[ http://issues.apache.org/jira/browse/DBCP-175?page=all ]
Phil Steitz updated DBCP-175: ----------------------------- Bugzilla Id: (was: 37577) Fix Version: 1.3 > [dbcp] I'd like to run init SQL after JDBC Connection creation in Tomcat DBCP > ----------------------------------------------------------------------------- > > Key: DBCP-175 > URL: http://issues.apache.org/jira/browse/DBCP-175 > Project: Commons Dbcp > Type: Improvement > Versions: 1.2 Final > Environment: Operating System: other > Platform: Other > Reporter: Jiri Melichna > Priority: Minor > Fix For: 1.3 > Attachments: DBCP-175-1.txt, DBCP-175-2.txt, DBCP-175-2.txt, > dbcp_add_init_sql.zip > > 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 -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]