You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@tomcat.apache.org by Jacob Kjome <ho...@visi.com> on 2002/07/31 19:28:20 UTC
Re[2]: 4.1.7 DataSource.getConnection()
Hello Damian,
Just following the general directory structure of where Tomcat-4.1.7
is located:
http://jakarta.apache.org/builds/jakarta-tomcat-4.0/release/v4.1.7-beta/
Just move back a couple directories to jakarta-tomcat-4.0 and then
move into "test/v4.1.8"
http://jakarta.apache.org/builds/jakarta-tomcat-4.0/test/v4.1.8/
All Jakarta builds exist under
http://jakarta.apache.org/builds/
So, next time, if you can't find something, just start there.
Jake
Wednesday, July 31, 2002, 11:50:36 AM, you wrote:
OGD> Thanks so much. That fixed it!. I've been on a wild goose chase
OGD> all afternoon. By the way, where can I find 4.1.8 on the jakarta
OGD> web site
OGD> -----Original Message-----
OGD> From: Jacob Kjome [mailto:hoju@visi.com]
OGD> Sent: 31 July 2002 17:30
OGD> To: Tomcat Users List
OGD> Subject: Re: 4.1.7 DataSource.getConnection()
OGD> Hello Damian,
OGD> You need to change "user" to "username" and add
OGD> <parameter>
OGD> <name>factory</name>
OGD> <value>org.apache.commons.dbcp.BasicDataSourceFactory</value>
OGD> </parameter>
OGD> BTW, Tomcat-4.1.8 added some fixes to DBCP. If tomcat-4.1.7 doesn't
OGD> work for you after making the mentioned changes, upgrade to
OGD> Tomcat-4.1.8. It is plenty stable for me.
OGD> Jake
OGD> 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
OGD> a
OGD>> while but
OGD>> have just moved to 4.1.7 beta.
OGD>> I am getting Oracle connections using a
OGD> 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>>
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>>
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>