Apparently no has had any luck with this. All I can tell is that the jdbc connection url is not compatible with tomcat and storing sessions in a database. So for anyone else searching this list for answers, you have come to the wrong place. Perhaps try the JTDS mailing list.
Thanks, Randall -----Original Message----- From: Randall Svancara [mailto:[EMAIL PROTECTED] Sent: Wednesday, February 23, 2005 1:00 PM To: Tomcat Users List Subject: JDBCStore JTDS Anyone have any luck using the JTDS driver for Micro(Caugh..Caugh) SQL Server and persistent session management using JDCBStore. I am currently experiencing a problem connecting with jtds. Here is my configuration for my JDBCStore... <Manager className="org.apache.catalina.session.PersistentManager"> <Store className="org.apache.catalina.session.JDBCStore" connectionURL="jdbc:jtds:sqlserver://10.113.2.60/propsys;user=webuser;pa ssword=password" driverName="net.sourceforge.jtds.jdbc.Driver" sessionIdCol="session_id" sessionValidCol="valid_session" sessionMaxInactiveCol="max_inactive" sessionLastAccessedCol="last_access" sessionTable="tomcat_sessions" sessionAppCol="app_context" sessionDataCol="session_data" /> </Manager> I recieve this error when trying to use the driver/ConnectionURL to connect to the database. Feb 23, 2005 7:52:35 AM org.apache.catalina.session.JDBCStore getConnection SEVERE: A SQL exception occurred java.sql.SQLException: Single-Sign-On is only supported on Windows. Please specify a user name. Any help/advice/hints would be appreciated. Of course, my platform is Linux and single sign on is not what I want anyway. Randall --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]