Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » BIRT » passing a parameter to a jdbc driver(problems with birt 3.7.1 engine connectng to a ibm db2 9.7 linux )
passing a parameter to a jdbc driver [message #833076] Fri, 30 March 2012 19:36 Go to next message
d h is currently offline d h
Messages: 10
Registered: March 2012
Junior Member
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 #835704 is a reply to message #833076] Tue, 03 April 2012 11:14 Go to previous messageGo to next message
Jason Weathersby is currently offline Jason Weathersby
Messages: 9167
Registered: July 2009
Senior Member

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 #835812 is a reply to message #835704] Tue, 03 April 2012 13:56 Go to previous messageGo to next message
d h is currently offline d h
Messages: 10
Registered: March 2012
Junior Member
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

Re: passing a parameter to a jdbc driver [message #835826 is a reply to message #835812] Tue, 03 April 2012 14:16 Go to previous messageGo to next message
Jason Weathersby is currently offline Jason Weathersby
Messages: 9167
Registered: July 2009
Senior Member

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
>
>
Re: passing a parameter to a jdbc driver [message #842995 is a reply to message #835812] Thu, 12 April 2012 14:53 Go to previous messageGo to next message
d h is currently offline d h
Messages: 10
Registered: March 2012
Junior Member
How do I do that?
Thanks,
Don
Re: passing a parameter to a jdbc driver [message #843026 is a reply to message #835812] Thu, 12 April 2012 14:53 Go to previous messageGo to next message
d h is currently offline d h
Messages: 10
Registered: March 2012
Junior Member
How do I do that?
Thanks,
Don
Re: passing a parameter to a jdbc driver [message #843028 is a reply to message #842995] Thu, 12 April 2012 14:56 Go to previous message
Jason Weathersby is currently offline Jason Weathersby
Messages: 9167
Registered: July 2009
Senior Member

Don,

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
>
Re: passing a parameter to a jdbc driver [message #843050 is a reply to message #835812] Thu, 12 April 2012 14:53 Go to previous message
d h is currently offline d h
Messages: 10
Registered: March 2012
Junior Member
How do I do that?
Thanks,
Don
Re: passing a parameter to a jdbc driver [message #843052 is a reply to message #842995] Thu, 12 April 2012 14:56 Go to previous message
Jason Weathersby is currently offline Jason Weathersby
Messages: 9167
Registered: July 2009
Senior Member

Don,

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
>
Re: passing a parameter to a jdbc driver [message #843083 is a reply to message #835812] Thu, 12 April 2012 14:53 Go to previous message
d h is currently offline d h
Messages: 10
Registered: March 2012
Junior Member
How do I do that?
Thanks,
Don
Re: passing a parameter to a jdbc driver [message #843085 is a reply to message #842995] Thu, 12 April 2012 14:56 Go to previous message
Jason Weathersby is currently offline Jason Weathersby
Messages: 9167
Registered: July 2009
Senior Member

Don,

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
>
Previous Topic:Reports are erroring out when run in parallel
Next Topic:ArrayLists in scripted data sets
Goto Forum:
  


Current Time: Fri Aug 29 22:32:47 EDT 2014

Powered by FUDForum. Page generated in 0.01985 seconds