HI all,

I am stuck with the trying to setup MySql 4.0.13 to Tomcat 4.1.27 on RH Linux (both DB and TC are on the same box). I have read the doc's and looked thro' previous posting and cant see the problem. I have this working on TC 4.1.12 and MySql 3.23. The only other issue is the new box is inside a DMZ

I get the following error:

DBCP borrowObject failed: java.sql.SQLException: Server connection failure during transaction.
Attempted reconnect 3 times. Giving up.

I can use MySql client and connect to mysql using the user/passwd in server.xml


<<web.xml>>
<<server.xml>>
thanks

Thomas

*********************************************************************************************
This email and any attachments are confidential and intended for the sole use of the intended recipient(s).If you receive this email in error please notify emailadmin@(protected).
*********************************************************************************************

<?xml version="1.0" encoding="ISO-8859-1"?>
  <!DOCTYPE web-app PUBLIC
  "-//Sun Microsystems, Inc.//DTD Web Application 2.3//EN"
  "http://java.sun.com/dtd/web-app_2_3.dtd">
<web-app>
<description>Merchant Direct</description>
<resource-ref>
   <description>DB Connection</description>
   <res-ref-name>jdbc/mdirect</res-ref-name>
   <res-type>javax.sql.DataSource</res-type>
   <res-auth>Container</res-auth>
</resource-ref>
</web-app>

<?xml version='1.0' encoding='utf-8'?>
<Server className="org.apache.catalina.core.StandardServer" debug="0" port="8005" shutdown="SHUTDOWN">
<Listener className="org.apache.catalina.mbeans.ServerLifecycleListener" debug="0" jsr77Names="false"/>
<Listener className="org.apache.catalina.mbeans.GlobalResourcesLifecycleListener" debug="0"/>
<GlobalNamingResources>
  <Environment name="simpleValue" override="true" type="java.lang.Integer" value="30"/>
  <Resource auth="Container" description="User database that can be updated and saved" name="UserDatabase" scope="Shareable" type="org.apache.catalina.UserDatabase"/>

  <ResourceParams name="UserDatabase">
   <parameter>
    <name>factory</name>
    <value>org.apache.catalina.users.MemoryUserDatabaseFactory</value>
   </parameter>
   <parameter>
    <name>pathname</name>
    <value>conf/tomcat-users.xml</value>
   </parameter>
  </ResourceParams>
</GlobalNamingResources>
<Service className="org.apache.catalina.core.StandardService" debug="0" name="Tomcat-Standalone">
  <Connector className="org.apache.coyote.tomcat4.CoyoteConnector" acceptCount="100" bufferSize="2048" compression="off" connectionLinger="-1" connectionTimeout="20000" connectionUploadTimeout="300000" debug="0" disableUploadTimeout="true" enableLookups="true" maxKeepAliveRequests="100" maxProcessors="75" minProcessors="5" port="8080" protocolHandlerClassName="org.apache.coyote.http11.Http11Protocol" proxyPort="0" redirectPort="8443" scheme="http" secure="false" serverSocketTimeout="0" tcpNoDelay="true" useURIValidationHack="false">
   <Factory className="org.apache.catalina.net.DefaultServerSocketFactory"/>
  </Connector>
  <Connector className="org.apache.coyote.tomcat4.CoyoteConnector" acceptCount="10" bufferSize="2048" compression="off" connectionLinger="-1" connectionTimeout="0" connectionUploadTimeout="300000" debug="0" disableUploadTimeout="false" enableLookups="true" maxKeepAliveRequests="100" maxProcessors="75" minProcessors="5" port="8009" protocolHandlerClassName="org.apache.jk.server.JkCoyoteHandler" proxyPort="0" redirectPort="8443" scheme="http" secure="false" serverSocketTimeout="0" tcpNoDelay="true" useURIValidationHack="false">
   <Factory className="org.apache.catalina.net.DefaultServerSocketFactory"/>
  </Connector>
  <Engine className="org.apache.catalina.core.StandardEngine" debug="0" defaultHost="localhost" mapperClass="org.apache.catalina.core.StandardEngineMapper" name="Standalone">
   <Host className="org.apache.catalina.core.StandardHost" appBase="webapps" autoDeploy="true" configClass="org.apache.catalina.startup.ContextConfig" contextClass="org.apache.catalina.core.StandardContext" debug="0" deployXML="true" errorReportValveClass="org.apache.catalina.valves.ErrorReportValve" liveDeploy="true" mapperClass="org.apache.catalina.core.StandardHostMapper" name="localhost" unpackWARs="true">
    <Context className="org.apache.catalina.core.StandardContext" cachingAllowed="true" charsetMapperClass="org.apache.catalina.util.CharsetMapper" cookies="true" crossContext="false" debug="0" displayName="Tomcat Administration Application" docBase="../server/webapps/admin" mapperClass="org.apache.catalina.core.StandardContextMapper" path="/admin" privileged="true" reloadable="false" swallowOutput="false" useNaming="true" wrapperClass="org.apache.catalina.core.StandardWrapper">
      <Logger className="org.apache.catalina.logger.FileLogger" debug="0" directory="logs" prefix="localhost_admin_log." suffix=".txt" timestamp="true" verbosity="1"/>
    </Context>
    <Context className="org.apache.catalina.core.StandardContext" cachingAllowed="true" charsetMapperClass="org.apache.catalina.util.CharsetMapper" cookies="true" crossContext="false" debug="0" displayName="Webdav Content Management" docBase="/home/tomcat/jakarta-tomcat-4.1.27/webapps/webdav" mapperClass="org.apache.catalina.core.StandardContextMapper" path="/webdav" privileged="false" reloadable="false" swallowOutput="false" useNaming="true" wrapperClass="org.apache.catalina.core.StandardWrapper">
    </Context>
    <Context className="org.apache.catalina.core.StandardContext" cachingAllowed="true" charsetMapperClass="org.apache.catalina.util.CharsetMapper" cookies="true" crossContext="true" debug="0" displayName="Tomcat Examples" docBase="examples" mapperClass="org.apache.catalina.core.StandardContextMapper" path="/examples" privileged="false" reloadable="true" swallowOutput="false" useNaming="true" wrapperClass="org.apache.catalina.core.StandardWrapper">
      <Logger className="org.apache.catalina.logger.FileLogger" debug="0" directory="logs" prefix="localhost_examples_log." suffix=".txt" timestamp="true" verbosity="1"/>
      <Parameter name="context.param.name" override="false" value="context.param.value"/>
      <Ejb home="com.wombat.empl.EmployeeRecordHome" name="ejb/EmplRecord" remote="com.wombat.empl.EmployeeRecord" type="Entity"/>
      <Ejb description="Example EJB Reference" home="com.mycompany.mypackage.AccountHome" name="ejb/Account" remote="com.mycompany.mypackage.Account" type="Entity"/>
      <Environment name="foo/name4" override="true" type="java.lang.Integer" value="10"/>
      <Environment name="maxExemptions" override="true" type="java.lang.Integer" value="15"/>
      <Environment name="minExemptions" override="true" type="java.lang.Integer" value="1"/>
      <Environment name="foo/bar/name2" override="true" type="java.lang.Boolean" value="true"/>
      <Environment name="name3" override="true" type="java.lang.Integer" value="1"/>
      <Environment name="foo/name1" override="true" type="java.lang.String" value="value1"/>
      <LocalEjb description="Example Local EJB Reference" home="com.mycompany.mypackage.ProcessOrderHome" local="com.mycompany.mypackage.ProcessOrder" name="ejb/ProcessOrder" type="Session"/>
      <Resource auth="SERVLET" name="jdbc/EmployeeAppDb" scope="Shareable" type="javax.sql.DataSource"/>
      <Resource auth="Container" name="mail/Session" scope="Shareable" type="javax.mail.Session"/>
      <ResourceParams name="jdbc/EmployeeAppDb">
       <parameter>
        <name>url</name>
        <value>jdbc:HypersonicSQL:database</value>
       </parameter>
       <parameter>
        <name>password</name>
        <value></value>
       </parameter>
       <parameter>
        <name>driverClassName</name>
        <value>org.hsql.jdbcDriver</value>
       </parameter>
       <parameter>
        <name>username</name>
        <value>sa</value>
       </parameter>
      </ResourceParams>
      <ResourceParams name="mail/Session">
       <parameter>
        <name>mail.smtp.host</name>
        <value>localhost</value>
       </parameter>
      </ResourceParams>
      <ResourceLink global="simpleValue" name="linkToGlobalResource" type="java.lang.Integer"/>
    </Context>
    <Context className="org.apache.catalina.core.StandardContext" cachingAllowed="true" charsetMapperClass="org.apache.catalina.util.CharsetMapper" cookies="true" crossContext="false" debug="0" displayName="Tomcat Documentation" docBase="/home/tomcat/jakarta-tomcat-4.1.27/webapps/tomcat-docs" mapperClass="org.apache.catalina.core.StandardContextMapper" path="/tomcat-docs" privileged="false" reloadable="false" swallowOutput="false" useNaming="true" wrapperClass="org.apache.catalina.core.StandardWrapper">
    </Context>
    <Context className="org.apache.catalina.core.StandardContext" cachingAllowed="true" charsetMapperClass="org.apache.catalina.util.CharsetMapper" cookies="true" crossContext="false" debug="0" displayName="Welcome to Tomcat" docBase="/home/tomcat/jakarta-tomcat-4.1.27/webapps/ROOT" mapperClass="org.apache.catalina.core.StandardContextMapper" path="" privileged="false" reloadable="false" swallowOutput="false" useNaming="true" wrapperClass="org.apache.catalina.core.StandardWrapper">
    </Context>
    <Context className="org.apache.catalina.core.StandardContext" cachingAllowed="true" charsetMapperClass="org.apache.catalina.util.CharsetMapper" cookies="true" crossContext="false" debug="0" displayName="Tomcat Manager Application" docBase="../server/webapps/manager" mapperClass="org.apache.catalina.core.StandardContextMapper" path="/manager" privileged="true" reloadable="false" swallowOutput="false" useNaming="true" wrapperClass="org.apache.catalina.core.StandardWrapper">
      <ResourceLink global="UserDatabase" name="users" type="org.apache.catalina.UserDatabase"/>
    </Context>
    <Context className="org.apache.catalina.core.StandardContext" cachingAllowed="false" charsetMapperClass="org.apache.catalina.util.CharsetMapper" cookies="true" crossContext="true" debug="0" displayName="Merchant Direct" docBase="merdir" mapperClass="org.apache.catalina.core.StandardContextMapper" path="/merdir" privileged="false" reloadable="false" swallowOutput="false" useNaming="true" wrapperClass="org.apache.catalina.core.StandardWrapper">
    <Resource name="jdbc/mdirect" auth="Container" type="javax.sql.DataSource"/>
    <ResourceParams name="jdbc/mdirect">
     <parameter>
      <name>username</name>
      <value>mdapp</value>
     </parameter>
     <parameter>
      <name>password</name>
      <value>mdapp001</value>
     </parameter>
     <parameter>
      <name>url</name>
      <value>jdbc:mysql://svrark-mer01/mdirect?autoReconnect=true</value>
     </parameter>
     <parameter>
      <name>driverClassName</name>
      <value>com.mysql.jdbc.Driver</value>
     </parameter>
     <parameter>
      <name>maxWait</name>
      <value>5000</value>
     </parameter>
     <parameter>
      <name>maxActive</name>
      <value>200</value>
     </parameter>
     <parameter>
      <name>maxIdle</name>
      <value>10</value>
     </parameter>
    </ResourceParams>
  </Context>
    <Logger className="org.apache.catalina.logger.FileLogger" debug="0" directory="logs" prefix="localhost_log." suffix=".txt" timestamp="true" verbosity="1"/>
   </Host>
   <Logger className="org.apache.catalina.logger.FileLogger" debug="0" directory="logs" prefix="catalina_log." suffix=".txt" timestamp="true" verbosity="1"/>
   <Realm className="org.apache.catalina.realm.UserDatabaseRealm" debug="0" resourceName="UserDatabase" validate="true"/>
  </Engine>
</Service>
</Server>

---------------------------------------------------------------------
To unsubscribe, e-mail: tomcat-user-unsubscribe@(protected)
For additional commands, e-mail: tomcat-user-help@(protected)