| passing a parameter to a jdbc driver [message #833076] |
Fri, 30 March 2012 19:36  |
Eclipse User |
|
|
|
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][10120][10898][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:
<structure>
<property name="name">odaURL</property>
<property name="id">1247</property>
<expression name="value">"jdbc:db2://qa13:50006/aldonlm;allowNextOnExhaustedResultSet=1"</expression>
</structure>
I get:
SEVERE: Unable to open connection.
org.eclipse.birt.report.data.oda.jdbc.JDBCException: There is an error in get connection, [jcc][t4][2030][11211][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
<property name="allowNextOnExhaustedResultSet">1</property>
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?
Thanks,
Don
|
|
|
|
|
|
|
|
|
|
|
|
|
Powered by
FUDForum. Page generated in 0.05285 seconds
Home