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=37577>. 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=37577 Summary: I'd like to run init SQL after JDBC Connection creation in Tomcat DBCP Product: Commons Version: 1.2 Final Platform: Other OS/Version: other Status: NEW Severity: enhancement Priority: P2 Component: Dbcp AssignedTo: [email protected] ReportedBy: [EMAIL PROTECTED] 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 -- 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: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
