Skip to Content
0
Former Member
Dec 23, 2008 at 01:28 PM

Connection pool problem with CR XI and JRC

20 Views

Hello,

I have a problem with some reports developed using CRXI and which are exported from java into pdf (using JRC). I have introduced a connection pool in the application, and for this i did 2 things:

- i set the JNDI Name in all reports

- i commented out these lines of code which were used to generate the connection dinamycally at runtime:

// ConnectionInfo connInfo = SmartCommon.getJDBCCredentials(contextRealPath, SmartCommon.FILE_SEPARATOR);
//		ConnectionInfos connections = new ConnectionInfos();
//		connections.add(connInfo);
//
//		String userName = connInfo.getUserName();
//		String password = connInfo.getPassword();
//		String connectString = connInfo.getAttributes().getStringValue(SmartCommon.PropertyBagKeys.CONNECTION_URL);
//		String driverName = connInfo.getAttributes().getStringValue(SmartCommon.PropertyBagKeys.DATABASE_CLASS_NAME);
//		String serverName = connInfo.getAttributes().getStringValue(SmartCommon.PropertyBagKeys.SERVER_NAME);
//		String databaseName = connInfo.getAttributes().getStringValue(SmartCommon.PropertyBagKeys.DATABASE_NAME);
//		String JNDIName = null;
//
//		/* Switch all tables on the main report and sub reports */
//		JRCHelperSample.changeDataSource(reportClientDoc, reportName, null, userName, password, connectString, driverName, JNDIName, serverName, databaseName, null);
//		reportClientDoc.getDatabaseController().logon(userName, password);

All reports work fine, except for one (who has a stored procedure, but i don't think the error comes from this), which gives the following error :

23/12/2008 15:13:34 JRCCommunicationAdapter ERROR Failed to export report

com.crystaldecisions.reports.exportinterface.exceptions.ExportException: Some parameters are missing values

at com.crystaldecisions.reports.formatter.a.c.if(Unknown Source)

at com.crystaldecisions.reports.formatter.a.c.a(Unknown Source)

at com.businessobjects.reports.sdk.b.b.int(Unknown Source)

at com.businessobjects.reports.sdk.JRCCommunicationAdapter.request(Unknown Source)

at com.crystaldecisions.proxy.remoteagent.x.a(Unknown Source)

at com.crystaldecisions.proxy.remoteagent.q.a(Unknown Source)

at com.crystaldecisions.sdk.occa.report.application.dd.a(Unknown Source)

at com.crystaldecisions.sdk.occa.report.application.ReportSource.a(Unknown Source)

at com.crystaldecisions.sdk.occa.report.application.ReportSource.a(Unknown Source)

at com.crystaldecisions.sdk.occa.report.application.PrintOutputController.export(Unknown Source)

at com.crystaldecisions.sdk.occa.report.application.PrintOutputController.export(Unknown Source)

at com.crystaldecisions.reports.sdk.PrintOutputController.export(Unknown Source)

What do you think can be wrong?