You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@tomcat.apache.org by "O'Gara, Damian" <Da...@sbs.siemens.co.uk> on 2002/07/31 13:50:24 UTC
4.1.7 DataSource.getConnection()
Hi
hope someone can help. I've been using Tomcat 4.0-dev successfully for a
while but
have just moved to 4.1.7 beta.
I am getting Oracle connections using a javax.sql.DataSource.getConnection
but now get
the following error
java.sql.SQLException: invalid arguments in call on this line of code.
My jdbc libraries are in the same places as they were with 4.0
Are there any changes to server.xml that I need to make for 4.1.7?
My server.xml database entries in server.xml look like the following:
<Context path="/Omnibase" docBase="Omnibase" debug="0"
reloadable="false" crossContext="true" cookies="false">
<Resource name="jdbc/mi2DS" auth="Container"
type="javax.sql.DataSource"/>
<ResourceParams name="jdbc/mi2DS">
<parameter>
<name>user</name>
<value>mi</value>
</parameter>
<parameter>
<name>password</name>
<value>mi</value>
</parameter>
<parameter>
<name>driverClassName</name>
<value>oracle.jdbc.driver.OracleDriver</value>
</parameter>
<parameter>
<name>url</name>
<value>jdbc:oracle:thin:@ukpa-mcc:1521:mi2</value>
</parameter>
<parameter>
<name>maxActive</name>
<value>8</value>
</parameter>
<parameter>
<name>maxIdle</name>
<value>4</value>
</parameter>
</ResourceParams>
<Resource name="jdbc/reg2DS" auth="Container"
type="javax.sql.DataSource"/>
<ResourceParams name="jdbc/reg2DS">
<parameter>
<name>user</name>
<value>omni</value>
</parameter>
<parameter>
<name>password</name>
<value>omni</value>
</parameter>
<parameter>
<name>driverClassName</name>
<value>oracle.jdbc.driver.OracleDriver</value>
</parameter>
<parameter>
<name>url</name>
<value>jdbc:oracle:thin:@ukpa-mcc:1521:mi2</value>
</parameter>
<parameter>
<name>maxActive</name>
<value>8</value>
</parameter>
<parameter>
<name>maxIdle</name>
<value>4</value>
</parameter>
</ResourceParams>
</Context>
Thanks a lot if you can help
Cheers
Damian
Re: 4.1.7 DataSource.getConnection()
Posted by Jacob Kjome <ho...@visi.com>.
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:hoju@visi.com
--
To unsubscribe, e-mail: <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>