Hi,
I found sequoia does not clean properly test statements.
On oracle we can see a lot of select * from dual statements in opened
statements.
(select user_name, a.sql_text, count(*) cpt
from v$session b,
v$open_cursor a
where a.sid = b.sid
GROUP BY user_name,a.sql_text ORDER BY cpt DESC)
On my version we corrected
- DatabaseBackend.isJDBCConnected()
- DatabaseBackend.isValidConnection()
- DriverCompliance.complianceTest()
- VariablePoolConnection.run()
- AbstractConnectionManager.run()
with correction like that :
Statement s = con.createStatement();
try {
s.execute(this.connectionTestStatement);
} finally {
try {
s.close();
} catch (SQLException e) {
logger.warn("Error on statement closure ",e);
}
}
Maybe this need a JIRA entry ?
Pierre
This e-mail is intended only for the above addressee. It may contain privileged
information.
If you are not the addressee you must not copy, distribute, disclose or use any
of the information in it.
If you have received it in error please delete it and immediately notify the
sender.
Security Notice: all e-mail, sent to or from this address, may be accessed by
someone other than the recipient, for system management and security reasons.
This access is controlled under Regulation of security reasons.
This access is controlled under Regulation of Investigatory Powers Act 2000,
Lawful Business Practises.
_______________________________________________
Sequoia mailing list
[email protected]
https://forge.continuent.org/mailman/listinfo/sequoia
