M
mikeboz
Guest
Currently, validationQuery is not supported in JNDI resource for branded drivers. However, JNDI pool is controlled by app server. Without validateQuery, it is possible JNDI connection pool would return timeout connection. Is it possible that branded driver would allow some special query to return a resultset without unlocking? Of course this special query would need to be able to run in different databases. For examples, allowing the following queries to run without unlocking: DB2: SELECT COUNT(*) FROM SYSIBM.SYSTABLES ORACLE: SELECT 1 FROM DUAL SQLSERVER: SELECT 1 MYSQL: SELECT 1 POSTGRESQL: SELECT 1
Continue reading...
Continue reading...