ConnectionPool with Oracle - connection timeout

["Raible, Matt" <Ma...@cable.comcast.com>]

I am using Tomcat's JDBCRealm as well as a DBCP Connection pool.  I am
connecting to Oracle 9, and everything works fine - for about 24 hours.
I've experienced this with MySQL and adding autoReconnect=true to the
connectionURL fixed the problem.  However, adding this to Oracle's
connectionURL causes a "Cannot load JDBC driver class 'null'".

My connectionURL is:

jdbc:oracle:thin:username/password@host:1521:sid

Thanks,

Matt


--
To unsubscribe, e-mail:   <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>

RE: ConnectionPool with Oracle - connection timeout

[Filip Hanik <ma...@filip.net>]

jdbc:oracle:thin:username/password@host:1521:sid

is an invalid URL. password doesn't belong in the url
at least I don't think so :)
Filip



~
Namaste - I bow to the divine in you
~
Filip Hanik
Software Architect
www.filip.net 

>-----Original Message-----
>From: Raible, Matt [mailto:Matt_Raible@cable.comcast.com]
>Sent: Friday, January 17, 2003 8:31 AM
>To: 'Tomcat Users List'
>Subject: ConnectionPool with Oracle - connection timeout
>
>
>I am using Tomcat's JDBCRealm as well as a DBCP Connection pool.  I am
>connecting to Oracle 9, and everything works fine - for about 24 hours.
>I've experienced this with MySQL and adding autoReconnect=true to the
>connectionURL fixed the problem.  However, adding this to Oracle's
>connectionURL causes a "Cannot load JDBC driver class 'null'".
>
>My connectionURL is:
>
>jdbc:oracle:thin:username/password@host:1521:sid
>
>Thanks,
>
>Matt
>
>
>--
>To unsubscribe, e-mail:   
><ma...@jakarta.apache.org>
>For additional commands, e-mail: 
><ma...@jakarta.apache.org>
>
>

--
To unsubscribe, e-mail:   <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>