Bug 56046

Summary: org.apache.tomcat.jdbc.pool.XADataSource InitSQL property
Product: Tomcat Modules Reporter: ajsimon
Component: jdbc-poolAssignee: Tomcat Developers Mailing List <dev>
Status: NEW ---    
Severity: enhancement    
Priority: P2    
Version: unspecified   
Target Milestone: ---   
Hardware: All   
OS: All   

Description ajsimon 2014-01-21 12:45:12 UTC 
Hi.

I think that it would be helpful if the InitSQL property from a JDBC Connection Pool org.apache.tomcat.jdbc.pool take a List of querys to run when a connection is first created, better than a single statement. For example:

ALTER SESSION SET NLS_SORT=BINARY
ALTER SESSION SET NLS_COMP=LINGUISTIC

Thank you very much.

Regards.
Comment 1 Mark Thomas 2014-01-21 12:49:42 UTC 
Correct component