[DBCP-175] [dbcp] I'd like to run init SQL after JDBC Connection creation in Tomcat DBCP

• Type: Improvement
• Status: Closed
• Priority: Minor
• Resolution: Fixed
• Affects Version/s: 1.2
• Fix Version/s: 1.3

Environment

Operating System: other
Platform: Other

• Bugzilla Id: 37577
• Assignee: Phil Steitz
• Reporter: Jiri Melichna
• Created: 21/Nov/05 15:15
• Updated: 15/Feb/10 04:12
• Resolved: 23/Feb/09 04:07

Description

Hi!

I'm porting some j2ee web based applications from BEA Web Logic to Tomcat 5.5.
In BEA Web Lobic connection pool it is possible to specify init SQL qurery
that server runs after connection is created (before first use). It's very
good for example of national settings in Oracle. For correct czech sorting i
have to run "setting query":

ALTER SESSION SET NLS_SORT = XCZECH

First time i tryed to write interceptor into my application. This interceptor
runs ALTER SESSION SET NLS_SORT = XCZECH before evey sorted query (SELECT ...
ORDER BY...), but i had some performance problems. So i starded to work with
DBCP. I was very wandered about DBCP packages in Tomcat 5.5 and i did not find
sources of naming-factory-dbcp.jar. So i refactored, enhanced and compiled
full DBCP (with pool and collections). Now i'm a little afraid of some library
conflicts (full DBCP, full Pool and full Collections refactored into tomcat
packages), but performance is OK and basic tests of my application seems good.

I added property connectionInitSql for int SQL into BasicDataSource. I had to
mofify BasicDataSourceFactory for correct setting of this property. Property
is used in method createConnection() of DriverConnectionFactory to init
Connection.

It would be very nice if you will add this init feature into Tomcat DBCP.

Best regards
Jiri Melichna

Issue Links

• incorporates: DBCP-179 [dbcp] initializationStatement and destructionStatement in PoolableConnectionFactory