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

[coltae]

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

[marianol]

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-connection

looks like you are on the right track with this question.

 

Best!