commons-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Jerome Lacoste (JIRA)" <>
Subject [jira] Updated: (DBCP-175) [dbcp] I'd like to run init SQL after JDBC Connection creation in Tomcat DBCP
Date Sat, 17 Jun 2006 04:16:30 GMT
     [ ]

Jerome Lacoste updated DBCP-175:

    Attachment: DBCP-175-1.txt

DBCP-175-1.txt is a version of the change that is similar to the original request. It allows
one to add a single initialization SQL statement. We tested this patch on a test server yesterday.

DBCP-175-2.txt is a version of the change that would allow one to specify more than one initialization
statements. That's probably the most flexible solution. I haven't had time to test it yet.
I attach it as a sort of RFC and will complete it if you guys think it's the way to go (I

Both patches come with unit tests and documentation (hope I forgot nothing).

Patches made against trunk (1.2.2-SNAPSHOT).

> [dbcp] I'd like to run init SQL after JDBC Connection creation in Tomcat DBCP
> -----------------------------------------------------------------------------
>          Key: DBCP-175
>          URL:
>      Project: Commons Dbcp
>         Type: Improvement

>     Versions: 1.2 Final
>  Environment: Operating System: other
> Platform: Other
>     Reporter: Jiri Melichna
>     Priority: Minor
>  Attachments: DBCP-175-1.txt, DBCP-175-2.txt,
> 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":
> 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

This message is automatically generated by JIRA.
If you think it was sent incorrectly contact one of the administrators:
For more information on JIRA, see:

To unsubscribe, e-mail:
For additional commands, e-mail:

View raw message