I use Tomcat's JNDI database, not struts - my config is below. Make sure
that classes12.jar is in common/lib.
Matt
web.xml
<resource-ref>
<description>DB Connection</description>
<res-ref-name>jdbc/mydb</res-ref-name>
<res-type>javax.sql.DataSource</res-type>
<res-auth>Container</res-auth>
</resource-ref>
webapps/mycontext.xml
<Resource name="jdbc/mydb" auth="Container"
type="javax.sql.DataSource"/>
<ResourceParams name="jdbc/mydb">
<parameter>
<name>factory</name>
<value>org.apache.commons.dbcp.BasicDataSourceFactory</value>
</parameter>
<!-- Maximum number of dB connections in pool.
Set to 0 for no limit. -->
<parameter>
<name>maxActive</name>
<value>50</value>
</parameter>
<!-- Maximum number of idle dB connections to retain in pool.
Set to 0 for no limit. -->
<parameter>
<name>maxIdle</name>
<value>10</value>
</parameter>
<!-- Maximum time to wait for a dB connection to become available
in ms, in this example 10 seconds. An Exception is thrown if
this timeout is exceeded. Set to -1 to wait indefinitely. -->
<parameter>
<name>maxWait</name>
<value>10000</value>
</parameter>
<!-- Database username and password for connections -->
<parameter>
<name>username</name>
<value>username</value>
</parameter>
<parameter>
<name>password</name>
<value>password</value>
</parameter>
<!-- Class name for Oracle JDBC driver -->
<parameter>
<name>driverClassName</name>
<value>oracle.jdbc.pool.OracleConnectionPoolDataSource</value>
</parameter>
<!-- The JDBC connection url for connecting to your db. -->
<parameter>
<name>url</name>
<value>jdbc:oracle:thin:@hostname:1521:SID</value>
</parameter>
<parameter>
<name>removeAbandoned</name>
<value>true</value>
</parameter>
<parameter>
<name>removeAbandonedTimeout</name>
<value>60</value>
</parameter>
<parameter>
<name>logAbandoned</name>
<value>true</value>
</parameter>
<parameter>
<name>validationQuery</name>
<value>SELECT 1 FROM DUAL</value>
</parameter>
</ResourceParams>
> -----Original Message-----
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, February 26, 2003 3:15 PM
> To: [EMAIL PROTECTED]
> Subject: RE: Tomcat 4.1.18, DBCP, DataSources - What are people using?
>
>
> Make sure commons-dbcp and pooling are not in your common/lib, use
> tomcat's.
>
> Besides, I don't use struts datasource, I use Tomcat JNDI
> datasource and
> pooling.
>
> Regards,
>
>
> PQ
>
> "This Guy Thinks He Knows Everything"
> "This Guy Thinks He Knows What He Is Doing"
>
> -----Original Message-----
> From: David Haynes [mailto:[EMAIL PROTECTED]
> Sent: February 26, 2003 5:12 PM
> To: 'Struts Users Mailing List'
> Subject: RE: Tomcat 4.1.18, DBCP, DataSources - What are people using?
>
> I'm setting up named data sources with the following:
> <data-sources>
> <data-source key="eha"
> type="org.apache.commons.dbcp.BasicDataSource">
> <set-property property="autoCommit"
> value="false"/>
> <set-property property="description"
> value="EHA Definition"/>
> <set-property property="driverClass"
> value="oracle.jdbc.driver.OracleDriver"/>
> <set-property property="maxCount"
> value="4"/>
> <set-property property="minCount"
> value="2"/>
> <set-property property="url"
>
> value="jdbc:oracle:thin:@citation:1521/citation"/>
> <set-property property="user"
> value="david"/>
> <set-property property="password"
> value="secret"/>
> </data-source>
> </data-sources>
>
> In my Action, I reference this as:
> DataSource ds = getDataSource(req, "eha");
>
> Tomcat reports the following in catalina.out:
> SQLException: Cannot load JDBC driver class 'null'
>
> -david-
>
>
> -----Original Message-----
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
> Sent: February 26, 2003 4:55 PM
> To: [EMAIL PROTECTED]
> Subject: RE: Tomcat 4.1.18, DBCP, DataSources - What are people using?
>
> What is the bug that you discovered? Mine works just fine.
>
> Tomcat 4.1.18
> Struts 1.1-rc1
> Oracle 8i
>
> Regards,
>
>
> PQ
>
> "This Guy Thinks He Knows Everything"
> "This Guy Thinks He Knows What He Is Doing"
>
> -----Original Message-----
> From: David Haynes [mailto:[EMAIL PROTECTED]
> Sent: February 26, 2003 4:43 PM
> To: [EMAIL PROTECTED]
> Subject: Tomcat 4.1.18, DBCP, DataSources - What are people using?
>
> After working on this for most of the day, I have discovered
> that Tomcat
> 4.1.18 and DBCP do not play well together. There is a bug
> against Tomcat
> for this (I have *got* to remember to check the bugs databases sooner
> ;-) ), but no analysis or corrective action has been recorded to date.
>
> So, my question is this. "What are people using for their DataSource?"
>
> My environment is:
> Tomcat 4.1.18
> Struts 1.1rc1
> Oracle 9i
> JDBC
>
> Thanks!
> -david-
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
>
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
