[ http://issues.apache.org/jira/browse/DBCP-175?page=all ]
Jerome Lacoste updated DBCP-175:
--------------------------------
Attachment: DBCP-175-1.txt
DBCP-175-2.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 do).
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: 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
> Attachments: DBCP-175-1.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]
