I can connect to the H2 Url in SQuirrel SQL just fine. Yet when using
it in a JDBCRealm, it doesn't work.
<Realm className="org.apache.catalina.realm.JDBCRealm"
driverName="org.h2.Driver"
debug="99"
connectionURL="jdbc:h2:file:/home/daniel/h2-db/
ms_Trailblaze;TRACE_LEVEL_FILE=4"
userTable="users"
userNameCol="user_name"
userCredCol="user_pass"
roleTable="user_roles"
roleNameCol="role_name"
connectionName="tomcat_realm_user"
connectionPassword="Z00mibl3s"
digest="SHA"/>
And the exceptions I get are:
Apr 2, 2009 11:05:58 PM org.apache.catalina.realm.JDBCRealm start
SEVERE: Exception opening database connection
java.sql.SQLException: org.h2.Driver
at org.apache.catalina.realm.JDBCRealm.open(JDBCRealm.java:
691)
at org.apache.catalina.realm.JDBCRealm.start(JDBCRealm.java:
769)
at org.apache.catalina.core.StandardContext.start
(StandardContext.java:4230)
at org.apache.catalina.core.ContainerBase.addChildInternal
(ContainerBase.java:791)
at org.apache.catalina.core.ContainerBase.addChild
(ContainerBase.java:771)
at org.apache.catalina.core.StandardHost.addChild
(StandardHost.java:525)
at org.apache.catalina.startup.HostConfig.deployDescriptor
(HostConfig.java:627)
at org.apache.catalina.startup.HostConfig.deployApps
(HostConfig.java:511)
at org.apache.catalina.startup.HostConfig.check
(HostConfig.java:1231)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke
(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke
(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.apache.tomcat.util.modeler.BaseModelMBean.invoke
(BaseModelMBean.java:297)
at com.sun.jmx.interceptor.DefaultMBeanServerInterceptor.invoke
(DefaultMBeanServerInterceptor.java:836)
at com.sun.jmx.mbeanserver.JmxMBeanServer.invoke
(JmxMBeanServer.java:761)
at org.apache.catalina.manager.ManagerServlet.check
(ManagerServlet.java:1471)
at org.apache.catalina.manager.ManagerServlet.deploy
(ManagerServlet.java:824)
at org.apache.catalina.manager.ManagerServlet.doGet
(ManagerServlet.java:350)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:
617)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:
717)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter
(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter
(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke
(StandardWrapperValve.java:233)
at org.apache.catalina.core.StandardContextValve.invoke
(StandardContextValve.java:191)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke
(AuthenticatorBase.java:525)
at org.apache.catalina.core.StandardHostValve.invoke
(StandardHostValve.java:128)
at org.apache.catalina.valves.ErrorReportValve.invoke
(ErrorReportValve.java:102)
at org.apache.catalina.core.StandardEngineValve.invoke
(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service
(CoyoteAdapter.java:286)
at org.apache.coyote.http11.Http11Processor.process
(Http11Processor.java:845)
at org.apache.coyote.http11.Http11Protocol
$Http11ConnectionHandler.process(Http11Protocol.java:583)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run
(JIoEndpoint.java:447)
at java.lang.Thread.run(Thread.java:619)
Also, tracing doesn't seem to work well either. I am having a heck of
time of finding the logger name in the docs so my log4j.xml can pick
it up.
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/h2-database?hl=en
-~----------~----~----~----~------~----~------~--~---
