tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From <yucca...@live.co.za>
Subject Re: problems at thejarbar.org
Date Tue, 01 Jun 2010 12:42:40 GMT
According to the stack trace I posted, is it possible that hibernate could 
also be a seperate casue of transient mysql exception or does this only need 
to be fixed in tomcat?
--------------------------------------------------
From: "Mark Eggers" <its_toasted@yahoo.com>
Sent: Monday, May 31, 2010 11:57 AM
To: "Tomcat Users List" <users@tomcat.apache.org>
Subject: Re: problems at thejarbar.org

> I think you are running into a MySQL database connection timeout. You can 
> use a MySQL admin interface (command line, PHPAdmin, MySQL Workbench, 
> etc.) to verify the idle connection timeout limit.
>
> There have been comments on the web concerning this. One such discussion 
> and a solution are here:
>
> http://lists.mysql.com/java/6578
>
> The explanation of the parameters given in the above link can be found 
> here:
>
> http://dev.mysql.com/doc/refman/5.0/en/connector-j-reference-configuration-properties.html
>
> Based on those two references, you'll need to modify your Realm database 
> URL:
>
> connectionURL="jdbc:mysql://localhost:3306/yucca123_thejarbar&autoReconnect=true&reconnectAtTxEnd=true"
>
> Note, I have not tried this, so test before production.
>
> The other solution mentioned is to use a DataSource Realm. This requires 
> you to configure a JNDI datasource describing your database connection as 
> well as the DataSource Realm.
>
> You can add all of this information in your web application's 
> META-INF/context.xml file if it's application-specific.
>
> If this is a host or service-based definition, then you'll have to define 
> the JNDI resources in a GlobalNamingResources element. See the following:
>
> http://tomcat.apache.org/tomcat-6.0-doc/config/globalresources.html
>
> Note the warning that this resource will not be available to an individual 
> web application unless you use a ResourceLink in your META-INF/context.xml 
> file.  See the globalresources link above for an example.
>
> Since you're using this connection for container managed authentication 
> and authorization, I'm not sure why your web application would need access 
> to this resource.
>
> However, it's 3 am, so I may have missed a few points that Chuck, Charles, 
> or Pid will be happy to correct.
>
> To summarize - it seems the easiest fix is to add the following properties 
> to your JDBC url:
>
> autoReconnect=true
> reconnectAtTxEnd=true
>
> Add them to the end of the URL, connected with ampersands.
>
> I hope this gets you up and running.
>
> . . . . . just my two cents
>
> /mde/
>
> --- On Sun, 5/30/10, Yucca Nel <yuccanel@live.co.za> wrote:
>
>> From: Yucca Nel <yuccanel@live.co.za>
>> Subject: Re: problems at thejarbar.org
>> To: "Tomcat Users List" <users@tomcat.apache.org>
>> Date: Sunday, May 30, 2010, 9:34 AM
>> Yes, but I am using JDBC and followed
>> the setup step by step from tomcat docs....
>>
>> <?xml version="1.0" encoding="UTF-8"?>
>> <Server
>>    port="9170">
>>  <Listener
>> className="org.apache.catalina.mbeans.GlobalResourcesLifecycleListener"/>
>>  <Listener
>> className="org.apache.catalina.core.JasperListener" />
>>  <Listener
>> className="org.apache.catalina.mbeans.ServerLifecycleListener"/>
>>  <GlobalNamingResources>
>>    <Resource
>>      auth="Container"
>>      description="User database"
>>      name="UserDatabase"
>>
>>    type="org.apache.catalina.UserDatabase"
>>      pathname="conf/tomcat-users.xml"
>>
>>    factory="org.apache.catalina.users.MemoryUserDatabaseFactory"/>
>>  </GlobalNamingResources>
>>  <Service
>>      name="Catalina">
>>    <Connector
>>        port="9670"
>>        minSpareThreads="1"
>>        address="127.0.0.1"
>>        maxThreads="50"
>>        maxSpareThreads="3"
>>        connectionTimeout="30000"
>>        protocol="AJP/1.3">
>>    </Connector>
>>    <Engine
>>
>>    defaultHost="thejarbar.org"
>>        name="Catalina">
>>      <Realm
>> className="org.apache.catalina.realm.UserDatabaseRealm"/><Realm
>> className="org.apache.catalina.realm.JDBCRealm"
>>
>> driverName="com.mysql.jdbc.Driver"
>>
>> connectionURL="jdbc:mysql://localhost:3306/yucca123_thejarbar"
>>   connectionName="yucca123_tom"
>>
>> connectionPassword="myPass"
>>       userTable="users"
>> userNameCol="user_name" userCredCol="user_pass"
>>   userRoleTable="user_roles"
>> roleNameCol="role_name"/><Host
>>
>>    appBase="/home/yucca123/public_html"
>>
>>    name="thejarbar.org">
>>
>>    <Alias>www.thejarbar.org</Alias>
>>        <Context
>>
>>    path="/the_jar_bar">
>>          <Listener
>> className="org.apache.catalina.startup.TldConfig"/>
>>        </Context>
>>        <Context
>>
>>    docBase="/usr/local/tomcat/users/yucca123/tomcat/webapps/manager"
>>
>>    path="/manager"
>>
>>    privileged="true"
>>
>>    reloadable="true">
>>          <Listener
>> className="org.apache.catalina.startup.TldConfig"/>
>>          <ResourceEnvRef
>>            name="users"
>>
>>    type="org.apache.catalina.UserDatabase"/>
>>        </Context>
>>        <Context
>>
>>    docBase="the_jar_bar"
>>            path=""
>>
>>    reloadable="true">
>>          <Listener
>> className="org.apache.catalina.startup.TldConfig"/>
>>        </Context>
>>      </Host>
>>    </Engine>
>>  </Service>
>> </Server>
>> May be missing something...
>>
>> http://tomcat.apache.org/tomcat-6.0-doc/jndi-resources-howto.html#JDBC%20Data%20Sources
>>
>> This error does not occur every time
>>
>>
>>
>>
>> --------------------------------------------------
>> From: "Jeff" <jwild1@cox.net>
>> Sent: Sunday, May 30, 2010 5:54 PM
>> To: "Tomcat Users List" <users@tomcat.apache.org>
>> Subject: Re: problems at thejarbar.org
>>
>> > would this help?
>> >
>> > http://tomcat.apache.org/tomcat-6.0-doc/jndi-datasource-examples-howto.html#Common%20Problems
>> >
>> >
>> > On 5/30/2010 10:08 AM, Yucca Nel wrote:
>> >> The following is becoming a common and serious
>> problem and I am unable to find a google solution for it...
>> >> I have never seen sych an error and it does not
>> appear to be common enough to get many google hits but when
>> it happens, no one is able to register at my site...
>> >>
>> >> Stck trace:
>> >>
>> >> Caused by:
>> com.mysql.jdbc.exceptions.jdbc4.CommunicationsException:
>> Communications link failure
>> >>
>> >> The last packet successfully received from the
>> server was 4,290,127 milliseconds ago.  The last packet
>> sent successfully to the server was 0 milliseconds ago.
>> >> at
>> sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native
>> Method)
>> >> at
>> sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
>> >> at
>> sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
>> >> at
>> java.lang.reflect.Constructor.newInstance(Constructor.java:513)
>> >> at
>> com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
>> >> at
>> com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1074)
>> >> at
>> com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:3052)
>> >> at
>> com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2938)
>> >> at
>> com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3481)
>> >> at
>> com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1959)
>> >> at
>> com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2109)
>> >> at
>> com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2648)
>> >> at
>> com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2077)
>> >> at
>> com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2228)
>> >> at
>> org.apache.catalina.realm.JDBCRealm.getPassword(JDBCRealm.java:550)
>> >> ... 15 more
>> >> Caused by: java.io.EOFException: Can not read
>> response from server. Expected to read 4 bytes, read 0 bytes
>> before connection was unexpectedly lost.
>> >> at
>> com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:2497)
>> >> at
>> com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2949)
>> >> ... 23 more
>> >> ERROR TP-Processor6
>> org.hibernate.util.JDBCExceptionReporter - Communications
>> link failure
>> >>
>> >> The last packet successfully received from the
>> server was 4,299,820 milliseconds ago.  The last packet
>> sent successfully to the server was 0 milliseconds ago.
>> >> ERROR TP-Processor6
>> org.hibernate.util.JDBCExceptionReporter - No operations
>> allowed after connection closed.Connection was implicitly
>> closed by the driver.
>> >> ERROR TP-Processor6
>> org.hibernate.util.JDBCExceptionReporter - No operations
>> allowed after connection closed.Connection was implicitly
>> closed by the driver.
>> >> ERROR TP-Processor6
>> org.hibernate.util.JDBCExceptionReporter - No operations
>> allowed after connection closed.Connection was implicitly
>> closed by the driver.
>> >> ERROR TP-Processor6
>> org.hibernate.util.JDBCExceptionReporter - No operations
>> allowed after connection closed.Connection was implicitly
>> closed by the driver.
>> >> ERROR TP-Processor6
>> org.hibernate.util.JDBCExceptionReporter - No operations
>> allowed after connection closed.Connection was implicitly
>> closed by the driver.
>> >> ERROR TP-Processor6
>> org.hibernate.util.JDBCExceptionReporter - No operations
>> allowed after connection closed.Connection was implicitly
>> closed by the driver.
>> >> ERROR TP-Processor6
>> org.hibernate.util.JDBCExceptionReporter - No operations
>> allowed after connection closed.Connection was implicitly
>> closed by the driver.
>> >> ERROR TP-Processor6
>> org.hibernate.util.JDBCExceptionReporter - No operations
>> allowed after connection closed.Connection was implicitly
>> closed by the driver.
>> >> ERROR TP-Processor6
>> org.apache.catalina.core.ContainerBase.[Catalina].[thejarbar.org].[/].[Faces
>> Servlet]The registration code that leads to error is as
>> follows: Form:<!--Created by IntelliJ IDEA.User:
>> ownerDate: 02.mai.2010Time: 14:07:31To change this template
>> use File | Settings | File Templates.--><%@page
>> contentType="text/html" language="java" %><%@page
>> pageEncoding="UTF-8"%><%@taglib uri="http://java.sun.com/jsf/core" 
>> prefix="f" %><%@
>> taglib prefix="h" uri="http://java.sun.com/jsf/html"
>> %><html><head>
>>    <meta http-equiv="Content-Type"
>> content="text/html; charset=UTF-8" />
>>    <title>The jar bar::
>> register</title></head><f:view>
>>    <body
>> style="background-color:#7b68ee;margin:auto">
>>    <div align="center"> <div
>> align="center" id="header"><jsp:include
>> page="/header.jsp"/></div> <div align="center"
>> id="centred-content"style="border-width:3px; border-style:
>> solid; border-color: #7fffd4;width:800px">
>>          <div id="h1"
>> align="center">
>>      <h:outputText
>> value="#{registerMsg.h1}" style="color:white;
>> font-family:fantasy;font-size:x-large;"/>
>>              <div
>> id="p1" align="center">
>>
>>    <h:outputText value="#{registerMsg.p1}"
>> style="font-size:large;margin-bottom:5em;color:white;"/>
>> <h:form>
>>          </h:form>
>>
>>    </div> <h:form>
>>
>>    <h:panelGrid columns="2">
>> <h:outputText value="*#{registerMsg.name}:"
>> style="color:yellow;"/> <h:inputText id="name"
>> value="#{user.entity.firstName}"
>> title="#{registerMsg.nameTitle}"required="true">
>> <f:validateLength minimum="3"maximum="30"/>
>> <h:message for="name"style="color:red;"/>
>> </h:inputText>
>>
>>    <h:outputText
>> value="#{registerMsg.surname}:" style="color:yellow;"/>
>> <h:inputText id="surname" value="#{user.entity.lastName}"
>> title="#{registerMsg.surnameTitle}" required="false">
>> <f:validateLength minimum="3"maximum="30"/>
>> <h:message for="surname" style="color:red;" />
>> </h:inputText>
>>
>>    <h:outputText
>> value="*#{registerMsg.email}:" style="color:yellow;"/>
>> <h:inputText id="email" value="#{user.entity.userEmail}"
>> title="#{registerMsg.emailTitle}"required="true">
>> <f:validator validatorId="emailEValidate"/>
>> <f:validator validatorId="emailPValidate"/>
>> <h:message for="email" style="color:red;"/>
>> </h:inputText>
>>
>>    <h:outputText
>> value="*#{registerMsg.userName}:" style="color:yellow;"/>
>> <h:inputText id="uName" value="#{user.entity.userName}"
>> title="#{registerMsg.userNameTitle}"required="true">
>> <f:validator validatorId="uNameEValidate"/>
>> <f:validateLength maximum="20" minimum="6"/>
>> <h:message for="uName"
>> style="color:red;"/></h:inputText> <h:outputText
>> value="*#{registerMsg.password}:" style="color:yellow;"/>
>> <h:inputSecret id="pass" value="#{user.entity.userPass}"
>> title="#{registerMsg.passwordTitle}*"required="true">
>> <f:validateLength minimum="6"maximum="20" />
>> <h:message for="pass" style="color:red;"/>
>> </h:inputSecret>
>>
>>    </h:panelGrid> <h:commandButton
>> action="#{user.create}"
>> value="#{registerMsg.register}"style="color:#20b2aa;" />
>> <br>
>>    </h:form>
>>      </div>
>>        <div id="footer"
>> align="center">
>>      <jsp:include
>> page="/Footer.jsp"/>
>>    </div>
>>    </div>
>>    </div>
>> </body></f:view></html>
>> Anyone have any thoughts as to why this is happening?
>> >>
>> >>
>> >>
>> >>
>> >> No virus found in this incoming message.
>> >> Checked by AVG - www.avg.com
>> >> Version: 9.0.819 / Virus Database: 271.1.1/2904 -
>> Release Date: 05/29/10 13:25:00
>> >>
>> >>
>> >
>>
>> ---------------------------------------------------------------------
>> To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
>> For additional commands, e-mail: users-help@tomcat.apache.org
>>
>>
>
>
>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
> For additional commands, e-mail: users-help@tomcat.apache.org
>
> 

---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
For additional commands, e-mail: users-help@tomcat.apache.org


Mime
View raw message