Thanks so much. That fixed it!. I've been on a wild goose chase
all afternoon. By the way, where can I find 4.1.8 on the jakarta
web site
-----Original Message-----
From: Jacob Kjome [mailto:[EMAIL PROTECTED]]
Sent: 31 July 2002 17:30
To: Tomcat Users List
Subject: Re: 4.1.7 DataSource.getConnection()
Hello Damian,
You need to change "user" to "username" and add
<parameter>
<name>factory</name>
<value>org.apache.commons.dbcp.BasicDataSourceFactory</value>
</parameter>
BTW, Tomcat-4.1.8 added some fixes to DBCP. If tomcat-4.1.7 doesn't
work for you after making the mentioned changes, upgrade to
Tomcat-4.1.8. It is plenty stable for me.
Jake
Wednesday, July 31, 2002, 6:50:24 AM, you wrote:
OGD> Hi
OGD> hope someone can help. I've been using Tomcat 4.0-dev successfully for a
OGD> while but
OGD> have just moved to 4.1.7 beta.
OGD> I am getting Oracle connections using a javax.sql.DataSource.getConnection
OGD> but now get
OGD> the following error
OGD> java.sql.SQLException: invalid arguments in call on this line of code.
OGD> My jdbc libraries are in the same places as they were with 4.0
OGD> Are there any changes to server.xml that I need to make for 4.1.7?
OGD> My server.xml database entries in server.xml look like the following:
OGD> <Context path="/Omnibase" docBase="Omnibase" debug="0"
OGD> reloadable="false" crossContext="true" cookies="false">
OGD> <Resource name="jdbc/mi2DS" auth="Container"
OGD> type="javax.sql.DataSource"/>
OGD> <ResourceParams name="jdbc/mi2DS">
OGD> <parameter>
OGD> <name>user</name>
OGD> <value>mi</value>
OGD> </parameter>
OGD> <parameter>
OGD> <name>password</name>
OGD> <value>mi</value>
OGD> </parameter>
OGD> <parameter>
OGD> <name>driverClassName</name>
OGD> <value>oracle.jdbc.driver.OracleDriver</value>
OGD> </parameter>
OGD> <parameter>
OGD> <name>url</name>
OGD> <value>jdbc:oracle:thin:@ukpa-mcc:1521:mi2</value>
OGD> </parameter>
OGD> <parameter>
OGD> <name>maxActive</name>
OGD> <value>8</value>
OGD> </parameter>
OGD> <parameter>
OGD> <name>maxIdle</name>
OGD> <value>4</value>
OGD> </parameter>
OGD> </ResourceParams>
OGD> <Resource name="jdbc/reg2DS" auth="Container"
OGD> type="javax.sql.DataSource"/>
OGD> <ResourceParams name="jdbc/reg2DS">
OGD> <parameter>
OGD> <name>user</name>
OGD> <value>omni</value>
OGD> </parameter>
OGD> <parameter>
OGD> <name>password</name>
OGD> <value>omni</value>
OGD> </parameter>
OGD> <parameter>
OGD> <name>driverClassName</name>
OGD> <value>oracle.jdbc.driver.OracleDriver</value>
OGD> </parameter>
OGD> <parameter>
OGD> <name>url</name>
OGD> <value>jdbc:oracle:thin:@ukpa-mcc:1521:mi2</value>
OGD> </parameter>
OGD> <parameter>
OGD> <name>maxActive</name>
OGD> <value>8</value>
OGD> </parameter>
OGD> <parameter>
OGD> <name>maxIdle</name>
OGD> <value>4</value>
OGD> </parameter>
OGD> </ResourceParams>
OGD> </Context>
OGD> Thanks a lot if you can help
OGD> Cheers
OGD> Damian
--
Best regards,
Jacob mailto:[EMAIL PROTECTED]
--
To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]>
For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
-- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
