Hi,
I am having problems setting up the JDBCRealm. The database is sqlserver. I have
downloaded the drivers and add them to the CLASSPATH. The configuration in the xml
file looks like this:
------------------------ server.xml clip BEGIN ---------------------------
<Realm className="org.apache.catalina.realm.JDBCRealm" debug="99"
driverName="com.microsoft.jdbc.sqlserver.SQLServerDriver"
connectionURL="jdbc:microsoft:sqlserver://dbmachine:9999;DatabaseName=SomeDataBase?username=uname;password=passwd"
userTable="user_table" userNameCol="user_name" userCredCol="pass"
userRoleTable="user_role" roleNameCol="role_name" />
------------------------ server.xml clip END ---------------------------
But I keep getting this error:
>>>>>>>>>>>>>>>>>>Error Message Begin<<<<<<<<<<<<<<<<<
Starting service Tomcat-Standalone
Apache Tomcat/4.0.1
Catalina.start: LifecycleException: Exception opening database connection:
java.sql.SQLException: com.microsoft.jdbc.sqlserver.SQLServerDriver
LifecycleException: Exception opening database connection: java.sql.SQLException:
com.microsoft.jdbc.sqlserver.SQLServerDriver
at org.apache.catalina.realm.JDBCRealm.start(JDBCRealm.java:615)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1108)
at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:307)
at org.apache.catalina.core.StandardService.start(StandardService.java:388)
at org.apache.catalina.core.StandardServer.start(StandardServer.java:505)
at org.apache.catalina.startup.Catalina.start(Catalina.java:776)
at org.apache.catalina.startup.Catalina.execute(Catalina.java:681)
at org.apache.catalina.startup.Catalina.process(Catalina.java:179)
at java.lang.reflect.Method.invoke(Native Method)
at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:243)
----- Root Cause -----
java.sql.SQLException: com.microsoft.jdbc.sqlserver.SQLServerDriver
at org.apache.catalina.realm.JDBCRealm.open(JDBCRealm.java:538)
at org.apache.catalina.realm.JDBCRealm.start(JDBCRealm.java:613)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1108)
at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:307)
at org.apache.catalina.core.StandardService.start(StandardService.java:388)
at org.apache.catalina.core.StandardServer.start(StandardServer.java:505)
at org.apache.catalina.startup.Catalina.start(Catalina.java:776)
at org.apache.catalina.startup.Catalina.execute(Catalina.java:681)
at org.apache.catalina.startup.Catalina.process(Catalina.java:179)
at java.lang.reflect.Method.invoke(Native Method)
at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:243)
>>>>>>>>>>>>>>>>>>Error Message End<<<<<<<<<<<<<<<<<
Any help is appreciated!
-Chaitresh
