Connection pool problem with CR XI and JRC

[Former Member]

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?

[Former Member]

Where do i change the table location? Which table?

And which parameters must be changed?

[ted_ueda]

> Where do i change the table location? Which table?

> And which parameters must be changed?

That would depend entirely on your report, so I'm assuming your questions are rhetorical.

Fundamentally, you're trying to run a report without setting parameters.

Go into your report. Find the parameter. Set the parameter using ReportClientDocument.getDataDefController().getParameterFieldController().setCurrentValue(report, parameter_name, value_object).

Sincerely,

Ted Ueda

[former_member11696]

Change your Cursor to IN OUT and then it should work. CR requires it to be of this type.

Thank you

Don

[Former Member]

Yes, the procedure does have parameters (only of type "IN")

[ted_ueda]

When you change the table location for a parametrized stored procedure, it deletes the old parameter and replaces it with a new one.

Are you setting the new one after the change?

Sincerely,

Ted Ueda

[ted_ueda]

Is it a parametrized stored proc?

Sincerely,

Ted Ueda