Eclipse Community Forums - RDF feed
https://www.eclipse.org/forums/
Eclipse Community Forumspassing a parameter to a jdbc driver
https://www.eclipse.org/forums/index.php/mv/msg/319873/833076/#msg_833076
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
]]>d h2012-03-30T23:36:59-00:00Re: passing a parameter to a jdbc driver
https://www.eclipse.org/forums/index.php/mv/msg/319873/835704/#msg_835704
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
>
>
>
>
>]]>Jason Weathersby2012-04-03T15:14:10-00:00Re: passing a parameter to a jdbc driver
https://www.eclipse.org/forums/index.php/mv/msg/319873/835812/#msg_835812
From the page:
www-01.ibm.com/support/docview.wss?uid=swg21363866
Thanks,
Don
]]>d h2012-04-03T17:56:12-00:00Re: passing a parameter to a jdbc driver
https://www.eclipse.org/forums/index.php/mv/msg/319873/835826/#msg_835826
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
>
>]]>Jason Weathersby2012-04-03T18:16:11-00:00Re: passing a parameter to a jdbc driver
https://www.eclipse.org/forums/index.php/mv/msg/319873/843026/#msg_843026
Thanks,
Don]]>d h2012-04-12T18:53:51-00:00Re: passing a parameter to a jdbc driver
https://www.eclipse.org/forums/index.php/mv/msg/319873/843050/#msg_843050
Thanks,
Don]]>d h2012-04-12T18:53:51-00:00Re: passing a parameter to a jdbc driver
https://www.eclipse.org/forums/index.php/mv/msg/319873/843083/#msg_843083
Thanks,
Don]]>d h2012-04-12T18:53:51-00:00Re: passing a parameter to a jdbc driver
https://www.eclipse.org/forums/index.php/mv/msg/319873/842995/#msg_842995
Thanks,
Don
]]>d h2012-04-12T18:53:51-00:00Re: passing a parameter to a jdbc driver
https://www.eclipse.org/forums/index.php/mv/msg/319873/843028/#msg_843028
Look at the bugzilla section of this page: http://www.eclipse.org/birt/phoenix/community.php
Jason
On 4/12/2012 2:53 PM, d h wrote:
> How do I do that?
> Thanks,
> Don
>]]>Jason Weathersby2012-04-12T18:56:30-00:00Re: passing a parameter to a jdbc driver
https://www.eclipse.org/forums/index.php/mv/msg/319873/843052/#msg_843052
Look at the bugzilla section of this page: http://www.eclipse.org/birt/phoenix/community.php
Jason
On 4/12/2012 2:53 PM, d h wrote:
> How do I do that?
> Thanks,
> Don
>]]>Jason Weathersby2012-04-12T18:56:30-00:00Re: passing a parameter to a jdbc driver
https://www.eclipse.org/forums/index.php/mv/msg/319873/843085/#msg_843085
Look at the bugzilla section of this page: http://www.eclipse.org/birt/phoenix/community.php
Jason
On 4/12/2012 2:53 PM, d h wrote:
> How do I do that?
> Thanks,
> Don
>]]>Jason Weathersby2012-04-12T18:56:30-00:00