Hi,I think "com.microsoft.jdbc.sqlserver.SQLServerDriver" is a jdbcpool driver. --- Chaitresh <[EMAIL PROTECTED]> 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:[EMAIL PROTECTED]> For additional commands: <mailto:[EMAIL PROTECTED]> Troubles with the list: <mailto:[EMAIL PROTECTED]>