You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@tomcat.apache.org by Rob King <ro...@zpin.com> on 2002/08/01 23:38:04 UTC
warp / jdbc problem

Hi,
I'm having problems connecting to mysql from tomcat when (only when) going
via the warp connector. (with roller in this example - I'm assuming it's not
app specific)
I point a browser to http://localhost:8080/roller/ and everything works - db
access no problem.
I point a browser to http://localhost/roller/ and I see the webapp html no
problem, but I get the exception below whenever it tries to hit mysql.
thanks in advance for any help on this (chunks of httpd.conf/server.xml &
versions at the bottom if they can aid diagnosis)
rob.

Catalina.start: LifecycleException:  Exception opening database connection:
java.sql.SQLException
LifecycleException:  Exception opening database connection:
java.sql.SQLException
        at org.apache.catalina.realm.JDBCRealm.start(JDBCRealm.java:681)
        at
org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1173)
        at
org.apache.catalina.core.StandardEngine.start(StandardEngine.java:347)
        at
org.apache.catalina.core.StandardService.start(StandardService.java:497)
        at
org.apache.catalina.core.StandardServer.start(StandardServer.java:2185)
        at org.apache.catalina.startup.Catalina.start(Catalina.java:510)
        at org.apache.catalina.startup.Catalina.execute(Catalina.java:400)
        at org.apache.catalina.startup.Catalina.process(Catalina.java:180)
        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:324)
        at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:203)
----- Root Cause -----
java.sql.SQLException
        at org.apache.catalina.realm.JDBCRealm.open(JDBCRealm.java:606)
        at org.apache.catalina.realm.JDBCRealm.start(JDBCRealm.java:679)
        at
org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1173)
        at
org.apache.catalina.core.StandardEngine.start(StandardEngine.java:347)
        at
org.apache.catalina.core.StandardService.start(StandardService.java:497)
        at
org.apache.catalina.core.StandardServer.start(StandardServer.java:2185)
        at org.apache.catalina.startup.Catalina.start(Catalina.java:510)
        at org.apache.catalina.startup.Catalina.execute(Catalina.java:400)
        at org.apache.catalina.startup.Catalina.process(Catalina.java:180)
        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:324)
        at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:203)
Stopping service Tomcat-Standalone
Stopping service Tomcat-Apache
Catalina.stop: LifecycleException:  Not started
LifecycleException:  Not started
        at org.apache.catalina.connector.warp.WarpConnector.stop(Unknown
Source)
        at
org.apache.catalina.core.StandardService.stop(StandardService.java:546)
        at
org.apache.catalina.core.StandardServer.stop(StandardServer.java:2220)
        at org.apache.catalina.startup.Catalina.start(Catalina.java:541)
        at org.apache.catalina.startup.Catalina.execute(Catalina.java:400)
        at org.apache.catalina.startup.Catalina.process(Catalina.java:180)
        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:324)
        at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:203)

HTTPD.CONF
----------------
<VirtualHost *>
ServerName www.whatever....
DocumentRoot /home/www/public_html
    WebAppConnection conn      warp  localhost:8008
    WebAppDeploy     roller  conn  /roller
    WebAppInfo /webapp-info
</VirtualHost>

SERVER.XML
----------------
  <Service name="Tomcat-Apache">

    <Connector className="org.apache.catalina.connector.warp.WarpConnector"
     port="8008" minProcessors="5" maxProcessors="75"
     enableLookups="true" appBase="webapps"
     acceptCount="10" debug="0"/>

    <Engine className="org.apache.catalina.connector.warp.WarpEngine"
     name="Apache" debug="0">

      <Logger className="org.apache.catalina.logger.FileLogger"
              prefix="apache_log." suffix=".txt"
              timestamp="true"/>

      <Realm className="org.apache.catalina.realm.MemoryRealm" />
    </Engine>

  </Service>


VERSIONS
--------------
tomcat 4.1.7 (also tried 4.0.4)
mysql-3.23.51
Apache/1.3.26
mm.mysql-2.0.14

--
To unsubscribe, e-mail:   <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>