|passing a parameter to a jdbc driver [message #833076]
||Fri, 30 March 2012 19:36
| d h
Registered: March 2012
I have a birt 3.7.1 engine called through a servlet connecting to a ibm db2 9.7 linux database.|
Everything seems ok except I get certain queries fail when they have empty result sets. The logs show that it's throwing a:
com.ibm.db2.jcc.am.SqlException: [jcc][t4][3.63.75] Invalid operation: result set is closed. ERRORCODE=-4470, SQLSTATE=null
According to IBM doc that's according to the JDBC standard when all rows have been retrieved:
There's a workaraound of setting a datasource property:
allowNextOnExhaustedResultSet to 1.
I've tried many different ways of trying to set this in the report design file.
If it try append to the odaurl:
SEVERE: Unable to open connection.
org.eclipse.birt.report.data.oda.jdbc.JDBCException: There is an error in get connection, [jcc][t4][3.63.75] A communication error occurred during operations on the connection's underlying socket, socket input stream,
or socket output stream. Error location: Reply.fill() - socketInputStream.read (-1). Message: Connection reset. ERRORCODE=-4499, SQLSTATE=08001.
That's with using a ';' or a '?' as a separator.
I've also tried setting a property in the report design file with
And many variations on that, all without any change in the ResultSet closed exception.
I tried 2 different versions of the DB2 driver and that also had no impact.
Has anyone had success with birt 3.7.1 engine connectng to a ibm db2 9.7 linux database?
Powered by FUDForum
. Page generated in 0.07041 seconds