You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@commons.apache.org by bu...@apache.org on 2005/11/21 07:18:12 UTC

DO NOT REPLY [Bug 37577] - I'd like to run init SQL after JDBC Connection creation in Tomcat DBCP

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





------- Additional Comments From jmelichna@gitus.cz  2005-11-21 07:18 -------
Created an attachment (id=17008)
 --> (http://issues.apache.org/bugzilla/attachment.cgi?id=17008&action=view)
My changes in BasicDataSource of Tomcat DBCP

Init SQL in resource specification in Tomcat Context setting:

<Resource name="jdbc/CzechSortDS" auth="Container"
	      type="javax.sql.DataSource" 
	      driverClassName="oracle.jdbc.driver.OracleDriver"
	      url="jdbc:oracle:thin:@server:1521:sid"
	      factory="org.apache.tomcat.dbcp.dbcp.BasicDataSourceFactory"
	      username="xxxx" 
	      password="xxxx" 
	      maxActive="40" 
	      maxIdle="10"
	      maxWait="5000"
	      connectionInitSql="ALTER SESSION SET NLS_SORT=XCZECH"/> 

-- 
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: commons-dev-unsubscribe@jakarta.apache.org
For additional commands, e-mail: commons-dev-help@jakarta.apache.org