Many thanks for hepful responses.... my delay I reply is due to internet in
afica....
--------------------------------------------------
From: "Mark Eggers" <its_toas...@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 <yucca...@live.co.za> wrote:
From: Yucca Nel <yucca...@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" <jwi...@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-unsubscr...@tomcat.apache.org
For additional commands, e-mail: users-h...@tomcat.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org
For additional commands, e-mail: users-h...@tomcat.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org
For additional commands, e-mail: users-h...@tomcat.apache.org
