tomcat-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From bugzi...@apache.org
Subject DO NOT REPLY [Bug 37485] New: - I'd like to run init SQL after JDBC Connection creation in DBCP
Date Mon, 14 Nov 2005 08:37:23 GMT
DO NOT REPLY TO THIS EMAIL, BUT PLEASE POST YOUR BUG·
RELATED COMMENTS THROUGH THE WEB INTERFACE AVAILABLE AT
<http://issues.apache.org/bugzilla/show_bug.cgi?id=37485>.
ANY REPLY MADE TO THIS MESSAGE WILL NOT BE COLLECTED AND·
INSERTED IN THE BUG DATABASE.

http://issues.apache.org/bugzilla/show_bug.cgi?id=37485

           Summary: I'd like to run init SQL after JDBC Connection creation
                    in DBCP
           Product: Tomcat 5
           Version: 5.5.9
          Platform: All
        OS/Version: All
            Status: NEW
          Severity: enhancement
          Priority: P2
         Component: Unknown
        AssignedTo: tomcat-dev@jakarta.apache.org
        ReportedBy: jmelichna@gitus.cz


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 ini 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 
set 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 had to refactor, change and compile 
full DBCP and now i'm afraid of some library conflicts (full DBCP, full Pool 
and full Collections refactored into tomcat packages), but performance is OK 
and 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

-- 
Configure bugmail: http://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug, or are watching the assignee.

---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@tomcat.apache.org
For additional commands, e-mail: dev-help@tomcat.apache.org


Mime
View raw message