I am using BoneCP connection Pooling and getting the Netezza status turned to "Tx-Idle" when am not closing the connection.
I have a situation where I need to use the same connection for the next query.
Do we have any solution so that we could prevent the Database session from turning to "Tx-Idle" with out closing the connection?
Thanks in adavnce
Why are you setting the autoCommit state of the connection to false? If you really need
multistatement transactions, commit them right when you're done. Otherwise, leave or
set the connection to autoCommit(true) mode and this problem will go away I think.