After connecting to Oracle, it is found that each time a session is disconnected and reconnected, there will be one more session in the connection pool. In an hour, there will be more than 300 connections. Debug the disconnection process and find that the disconnection fails. The error 25000 is returned: invalid transaction state. there was a transaction in process on the connection specified by the argument connectionhandle. the transaction remains active. however, I did not execute any statements.
The final result is that after connecting to the Oracle database, sqlprepare is used to prepare the statement. Even if nothing is executed during the process, the transaction is started. In disconnect, although there is no processing, you still need to end the transaction with sqlendtran.
I lamented my lack of experience.
Start building with 50+ products and up to 12 months usage for Elastic Compute Service
1 on 1 presale consultation
24/7 Technical Support 6 Free Tickets per Quarter Faster Response
Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.
A comprehensive suite of global cloud computing services to power your business
Payment Methods We Support
