DBCP & Tomcat 5.5.x

["Durfee, Bernard" <Be...@suny.edu>]

Hello,
Is this is proper way to create a pooled datasource in Tomcat 5.5.7
using DBCP?

<Resource
name="jdbc/myDS"
auth="Container"
type="javax.sql.DataSource"
factory="org.apache.commons.dbcp.BasicDataSourceFactory"

driverClassName="oracle.jdbc.OracleDriver"
url="jdbc:oracle:thin:@my.db.com:1521:me"
username="me"
password="it"
connectionProperties="SetBigStringTryClob=true"

initialSize="0"
maxActive="20"
maxIdle="10"
minIdle="0"
maxWait="60000"
/>

Bernie Durfee 


---------------------------------------------------------------------
To unsubscribe, e-mail: commons-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: commons-user-help@jakarta.apache.org

Re: DBCP & Tomcat 5.5.x

[Brian Cook <bc...@printtime.com>]

Well that is one of the steps.  You also need to define the resource in 
web.xml, and context.xml.  Then you can call it from your code.  There 
are examples in the Tomcat 5.5 docs.


Durfee, Bernard wrote:
> Hello,
> Is this is proper way to create a pooled datasource in Tomcat 5.5.7
> using DBCP?
> 
> <Resource
> name="jdbc/myDS"
> auth="Container"
> type="javax.sql.DataSource"
> factory="org.apache.commons.dbcp.BasicDataSourceFactory"
> 
> driverClassName="oracle.jdbc.OracleDriver"
> url="jdbc:oracle:thin:@my.db.com:1521:me"
> username="me"
> password="it"
> connectionProperties="SetBigStringTryClob=true"
> 
> initialSize="0"
> maxActive="20"
> maxIdle="10"
> minIdle="0"
> maxWait="60000"
> />
> 
> Bernie Durfee 
> 
> 
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: commons-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: commons-user-help@jakarta.apache.org
> 
> 


-- 
Brian Cook
Digital Services Analyst
Print Time Inc.
bcook@printtime.com
913.345.8900