You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@tomcat.apache.org by Chaitresh <ch...@hotmail.com> on 2002/01/03 20:11:31 UTC
JDBCRealm problems - sqlserver
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
Re: JDBCRealm problems - sqlserver
Posted by tai liang <ta...@yahoo.com>.
Hi,I think
"com.microsoft.jdbc.sqlserver.SQLServerDriver"
is a jdbcpool driver.
--- Chaitresh <ch...@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: <ma...@jakarta.apache.org>
For additional commands: <ma...@jakarta.apache.org>
Troubles with the list: <ma...@jakarta.apache.org>