Trying 'username' in db url instead of 'user' d.
Ujwal Oswal wrote: > Hi, > > Has anyone out there implemented Persistence Session using JDBC Based Store > in Tomcat. If yes can you please let us know of the procedure. I tried > modifing the Server.xml file but > I am getting SQLException. > > Here are the exception > > 2002-08-08 15:50:42 JDBCStore[/examples]: The database connection is null or > was found to be closed. Trying to re-open it. > 2002-08-08 15:50:42 JDBCStore[/examples]: A SQL exception occurred > java.sql.SQLException: invalid arguments in call > > > Heres part of my Server.xml (ONLY PERSISTENCE ELEMENT) > > <Manager className="org.apache.catalina.session.PersistentManager" > debug="0" > saveOnRestart="true" > maxActiveSessions="-1" > minIdleSwap="-1" > maxIdleSwap="0" > maxIdleBackup="0"> > <Store className="org.apache.catalina.session.JDBCStore" > debug="2" > > connectionURL="jdbc:oracle:thin:@hocleunx02:1521:reqpro?user=x25agent_dev;pa > ssword=x25agent_dev" > driverName="oracle.jdbc.driver.OracleDriver" > sessionDataCol="session_data" > sessionIdCol="session_id" > sessionLastAccessedCol="last_access" > sessionMaxInactiveCol="max_inactive" > sessionTable="tomcat_sessions" > sessionValidCol="valid_session"/> > </Manager> > > Thanks > Ujwal > > > -- David Mossakowski [EMAIL PROTECTED] Instinet Corporation 212.310.7275 ******************************************************************************* <<Disclaimer>> This message is intended only for the use of the Addressee and may contain information that is PRIVILEGED and/or CONFIDENTIAL or both. This email is intended only for the personal and confidential use of the recipient(s) named above. If the reader of this email is not an intended recipient, you have received this email in error and any review, dissemination, distribution or copying is strictly prohibited. If you have received this email in error, please notify the sender immediately by return mail and permanently deleting the copy you received. Thank you. ******************************************************************************* -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
