Dear all;
I try to use a ResultSet as datasource in Crystal Reports,But an Exception Happend;
First i execute the SQL Statment to get ResultSet Object called rs then try the following code:
String tableAlias = reportClientDocument.getDatabaseController().getDatabase().getTables().getTable(0).getAlias();
reportClientDocument.getDatabaseController().setDataSource(rs,tableAlias,"resultsetTable");
This is the Exception;
com.crystaldecisions.sdk.occa.report.lib.ReportSDKException: Unexpected database connector error---- Error code:-2147467259 Error code name:failed
at com.businessobjects.reports.sdk.JRCCommunicationAdapter.a(Unknown Source)
at com.businessobjects.reports.sdk.JRCCommunicationAdapter.a(Unknown Source)
at com.businessobjects.reports.sdk.JRCCommunicationAdapter.if(Unknown Source)
at com.businessobjects.reports.sdk.JRCCommunicationAdapter.a(Unknown Source)
at com.businessobjects.reports.sdk.JRCCommunicationAdapter$2.a(Unknown Source)
at com.businessobjects.reports.sdk.JRCCommunicationAdapter$2.call(Unknown Source)
at com.crystaldecisions.reports.common.ThreadGuard.syncExecute(Unknown Source)
.
.
.
Please help me to solve this exception