DBCP & Tomcat 5.5.x

classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|

DBCP & Tomcat 5.5.x

Bernie Durfee
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: [hidden email]
For additional commands, e-mail: [hidden email]

Reply | Threaded
Open this post in threaded view
|

Re: DBCP & Tomcat 5.5.x

Brian Cook

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: [hidden email]
> For additional commands, e-mail: [hidden email]
>
>

--
Brian Cook
Digital Services Analyst
Print Time Inc.
[hidden email]
913.345.8900


---------------------------------------------------------------------
To unsubscribe, e-mail: [hidden email]
For additional commands, e-mail: [hidden email]