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: mailto:[EMAIL PROTECTED] For additional commands, e-mail: mailto:[EMAIL PROTECTED]
RE: ConnectionPool with Oracle - connection timeout
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:[EMAIL PROTECTED]] 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: 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]
RE: ConnectionPool with Oracle - connection timeout
This works though! ;-) I got this syntax off this list for configuring an Oracle JDBCRealm. -Original Message- From: Filip Hanik [mailto:[EMAIL PROTECTED]] Sent: Friday, January 17, 2003 9:42 AM To: Tomcat Users List Subject: RE: ConnectionPool with Oracle - connection timeout 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:[EMAIL PROTECTED]] 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: 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] -- To unsubscribe, e-mail: mailto:[EMAIL PROTECTED] For additional commands, e-mail: mailto:[EMAIL PROTECTED]