How do i set my --defaultResultSetHoldable=True in Jasperstudio?

0

I have been trying to figure out how to set this

 

jdbc:firebirdsql:10.1.1.1:dbPath?defaultResultSetHoldable=True

 

in jaspersoft studio

 

Can someone tell me how?

 

-Colt

coltae's picture
12
Joined: Sep 15 2015 - 9:53am
Last seen: 3 years 8 months ago

1 Answer:

0

You can set that in the Connection Properties Tab (center tab) of the Data Adapter window (create or edit) see screenshot.

Regarding the question you sent me about this error: 

I get this error:
"net.sf.jasperreports.engine.JRException: net.sf.jasperreports.engine.JRException: Unable to get next record from result set."
and
"Caused by: org.firebirdsql.jdbc.FBSQLException: The result set is closed"

This exception looks like it indicates that the pool has been exhausted and a request for a connection has timed out by the driver. Seams like the FireBird driver is closing the connection to soon. By digging a bit this is caused when the Driver is in auto-commit mode. Based on this answer http://community.jaspersoft.com/questions/515727/subreport-closing-conne...
looks like you are on the right track with this question.
 
Best!
marianol's picture
4575
Joined: Sep 13 2011 - 8:04am
Last seen: 10 months 3 weeks ago
Feedback
randomness