It turns out I had to RTFM. "Quick Start:
3. Place a copy of the JDBC driver you will be using inside the $CATALINA_HOME/lib directory. Note that only JAR files are recognized!" I only had it in my Web App lib folder On 6/14/07, Richard Sayre <[EMAIL PROTECTED]> wrote:
I just tried the exact same thing with the jTDS driver and I got the same error: <Realm className="org.apache.catalina.realm.JDBCRealm" debug="99" driverName="net.sourceforge.jtds.jdbc.Driver" connectionURL="jdbc:jtds:sqlserver://server-2006/v362;user=user;password=dbase" connectionName="user" connectionPassword="dbase" digest="SHA" userTable="PPMUser" userNameCol="UserName" userCredCol="UserPassword" userRoleTable="PPMUser" roleNameCol="RoleTomcat" /> 14-Jun-2007 10:49:02 AM org.apache.catalina.realm.JDBCRealm authenticate SEVERE: Exception performing authentication java.sql.SQLException: net.sourceforge.jtds.jdbc.Driver at org.apache.catalina.realm.JDBCRealm.open(JDBCRealm.java:691) at org.apache.catalina.realm.JDBCRealm.authenticate(JDBCRealm.java:346) at org.apache.catalina.authenticator.BasicAuthenticator.authenticate(BasicAuthenticator.java:181) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:491) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:104) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:261) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:581) at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447) at java.lang.Thread.run(Unknown Source) Did anything change in Tomcat 6 for setting up JDBC Realms? I am putting this in the server xml. On 6/13/07, Richard Sayre <[EMAIL PROTECTED]> wrote: > I have a web app that connects to my SQL Server 2005 Database with no > trouble using this code: > > Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver"); > con = > DriverManager.getConnection("jdbc:sqlserver://server-2006;databaseName=v362;user=user;password=dbase"); > > My application runs fine and I can see data from the database. > > Now when I try to set up a Realm to do Database authentication I get an error: > > <Realm className="org.apache.catalina.realm.JDBCRealm" debug="99" > driverName="com.microsoft.sqlserver.jdbc.SQLServerDriver" > connectionURL="jdbc:sqlserver://server-2006;databaseName=v362;userName=user;password=dbase" > connectionName="user" > connectionPassword="dbase" > digest="SHA" > userTable="PPMUser" userNameCol="UserName" > userCredCol="UserPassword" > userRoleTable="PPMUser" roleNameCol="RoleTomcat" /> > > Exception: > > 13-Jun-2007 3:56:00 PM org.apache.catalina.realm.JDBCRealm authenticate > SEVERE: Exception performing authentication > java.sql.SQLException: com.microsoft.sqlserver.jdbc.SQLServerDriver > at org.apache.catalina.realm.JDBCRealm.open(JDBCRealm.java:691) > at org.apache.catalina.realm.JDBCRealm.authenticate(JDBCRealm.java:346) > at org.apache.catalina.authenticator.BasicAuthenticator.authenticate(BasicAuthenticator.java:181) > at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:491) > at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128) > at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:104) > at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) > at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:261) > at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844) > at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:581) > at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447) > at java.lang.Thread.run(Unknown Source) > > The strange thing is, if I set up a DSN under Windows and use the Sun > ODBC driver the authentication realm works: > > <Realm className="org.apache.catalina.realm.JDBCRealm" debug="99" > driverName="sun.jdbc.odbc.JdbcOdbcDriver" > connectionURL="jdbc:odbc:v362" > connectionName="user" > connectionPassword="dbase" > digest="SHA" > userTable="User" userNameCol="UserName" userCredCol="UserPassword" > userRoleTable="User" roleNameCol="RoleTomcat" /> > > > Does any one have this type of authentication working with MS SQL > Server 2005 JDBC driver under Tomcat 6? > > Thank you, > > Rich >
--------------------------------------------------------------------- To start a new topic, e-mail: users@tomcat.apache.org To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]