You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@tomcat.apache.org by Ujwal Oswal <Uj...@BristolWest.com> on 2002/08/09 15:09:17 UTC
Persistence in Tomact
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
Re: Persistence in Tomact
Posted by David Mossakowski <dm...@Instinet.Com>.
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 dmoss@instinet.com
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: <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>