RE: Tomcat 4.1.18, DBCP, DataSources - What are people using?

[pqin]

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]