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]
