Ok, I am not sure if anyone knows this and the documentation for tomcat does
not indicate if you can use <parameter> </parameter> for configuring a
JDBCStore. Here is an example that I have seen in the tomcat documentation,
with the modification for jtds that does not work.
<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;password=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>
However, if it would support the same configuration style as dbcp, I would not
be having these problems. Partial example provided below.
<Manager className="org.apache.catalina.session.PersistentManager">
<Store>
<parameter>
<name>url</name>
<value>jdbc:jtds:sqlserver://10.113.2.60/propsys</value>
</parameter>
<parameter>
<name>user</name>
<value>someuser</value>
...........................................
________________________________
From: Randall Svancara [mailto:[EMAIL PROTECTED]
Sent: Tue 3/1/2005 2:22 PM
To: Tomcat Users List; Jason Bainbridge
Subject: RE: JDBCStore JTDS
Sorry to sound like more of an idiot, but can you provide an example of
passing the connectionName and Connection password as parameters.....
Thanks,
Randall
-----Original Message-----
From: Jason Bainbridge [mailto:[EMAIL PROTECTED]
Sent: Tuesday, March 01, 2005 1:36 PM
To: Tomcat Users List
Subject: Re: JDBCStore JTDS
Try passing connectionName and connectionPassword as parameters instead
of through the ConnectionURL. It isn't seeing them in the URL and trying
to sign you on with Windows Credentials that you don't have.
It is possibl;e if you change the semicolon after propsys to a ? then it
might also work.
On Wed, 23 Feb 2005 13:00:25 -0700, Randall Svancara
<[EMAIL PROTECTED]> wrote:
> 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]
>
>
--
Jason Bainbridge
http://kde.org - [EMAIL PROTECTED]
Personal Site - http://jasonbainbridge.com
---------------------------------------------------------------------
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]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
