cursor type/concurrency combination is not supported

Anonymous — Sat, 03 Mar 2012 16:32:31 GMT

"Talend Open Studio for Data Quality"
Version: 5.0.2
Build id: r78327-20120216-0341
-----------------------------------------
Connection to MS SQL 2008
-----------------------------------------
Table Anlaysis > Standard options.
-----------------------------------------
Sat Mar 03 16:23:48 GMT 2012
2012-03-03 16:23:48,228 ERROR org.talend.dq.indicators.ColumnSetIndicatorEvaluator - com.microsoft.sqlserver.jdbc.SQLServerException: The cursor type/concurrency combination is not supported.
com.microsoft.sqlserver.jdbc.SQLServerException: The cursor type/concurrency combination is not supported.
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(SQLServerException.java:170)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.<init>(SQLServerStatement.java:540)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.createStatement(SQLServerConnection.java:1854)
at org.talend.dq.indicators.ColumnSetIndicatorEvaluator.evaluateBySql(Unknown Source)
at org.talend.dq.indicators.ColumnSetIndicatorEvaluator.executeSqlQuery(Unknown Source)
at org.talend.dq.indicators.Evaluator.evaluateIndicators(Unknown Source)
at org.talend.dq.indicators.Evaluator.evaluateIndicators(Unknown Source)
at org.talend.dq.indicators.ColumnSetIndicatorEvaluator.evaluateIndicators(Unknown Source)
at org.talend.dq.analysis.ColumnSetAnalysisExecutor.runAnalysis(Unknown Source)
at org.talend.dq.analysis.AnalysisExecutor.execute(Unknown Source)
at org.talend.dq.analysis.AnalysisExecutorSelector.executeAnalysis(Unknown Source)
at org.talend.dataprofiler.core.ui.action.actions.AnalysisExecutorThread.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)
---------------------------------------

Any ideas anyone ???
Many Thanks

Re: cursor type/concurrency combination is not supported

Anonymous — Mon, 05 Mar 2012 03:36:30 GMT

Hi
Could you show me a screenshot of this Table Analysis? Any rule?
In fact, this exception is due to ResultSet.CONCUR_UPDATABLE and ResultSet.CONCUR_READ_ONLY in Java code.
I can't make sure whether it's a bug now.
One more thing. For all issues about TDQ, please create topic at section.
Regards,
Pedro

topic cursor type/concurrency combination is not supported in Data Quality

cursor type/concurrency combination is not supported

Re: cursor type/concurrency combination is not supported