tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Chaitresh" <chaitr...@hotmail.com>
Subject JDBCRealm problems - sqlserver
Date Thu, 03 Jan 2002 19:11:31 GMT
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

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message