RE: JDBCStore JTDS

[Randall Svancara <rs...@adaweb.net>]

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:rsvancara@adaweb.net] 
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: tomcat-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: tomcat-user-help@jakarta.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: tomcat-user-help@jakarta.apache.org