tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From tai liang <tai_1...@yahoo.com>
Subject Re: JDBCRealm problems - sqlserver
Date Fri, 04 Jan 2002 04:41:27 GMT
  Hi,I think
"com.microsoft.jdbc.sqlserver.SQLServerDriver"
 is  a jdbcpool driver.
--- Chaitresh <chaitresh@hotmail.com> wrote:
> 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
> 


__________________________________________________
Do You Yahoo!?
Send your FREE holiday greetings online!
http://greetings.yahoo.com

--
To unsubscribe:   <mailto:tomcat-user-unsubscribe@jakarta.apache.org>
For additional commands: <mailto:tomcat-user-help@jakarta.apache.org>
Troubles with the list: <mailto:tomcat-user-owner@jakarta.apache.org>


Mime
View raw message