|
Re: passing a parameter to a jdbc driver [message #835704 is a reply to message #833076] |
Tue, 03 April 2012 15:14 ![Go to previous message Go to previous message](theme/Solstice/images/up.png) ![Go to next message Go to next message](theme/Solstice/images/down.png) |
|
Which version of the driver are you using?
Take a look at
https://bugs.eclipse.org/bugs/show_bug.cgi?id=186346
Jason
On 3/30/2012 7:37 PM, d h wrote:
> 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
>
>
>
>
>
|
|
|
|
Re: passing a parameter to a jdbc driver [message #835826 is a reply to message #835812] |
Tue, 03 April 2012 18:16 ![Go to previous message Go to previous message](theme/Solstice/images/up.png) ![Go to next message Go to next message](theme/Solstice/images/down.png) |
|
Don,
Can you open a bugzilla entry for this?
Jason
On 4/3/2012 1:56 PM, d h wrote:
> It's the db2 9.7 driver and I've tried both fixpack 5 JDBC 3.0 and JDBC
> 4.0. From the page:
> www-01.ibm.com/support/docview.wss?uid=swg21363866
> Thanks,
> Don
>
>
|
|
|
|
|
|
|
|
|
|
Powered by
FUDForum. Page generated in 0.04422 seconds