I have been trying to figure out how to set this
in jaspersoft studio
Can someone tell me how?
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:
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...