Mailing-List: contact jetspeed-dev-help@jakarta.apache.org; run by ezmlm
Precedence: bulk
Reply-To: "Jetspeed Developers List" <jetspeed-dev@jakarta.apache.org>
Message-ID: <40EA57D6.5090309@alienor.com>
Date: Tue, 06 Jul 2004 09:42:14 +0200
From: Arnaudin Xavier <xa@alienor.com>
Reply-To: x.arnaudin@alienor.fr
User-Agent: Mozilla Thunderbird 0.6 (Windows/20040502)
MIME-Version: 1.0
To: jetspeed-dev@jakarta.apache.org
Subject: Problem with Mysql and connector/J
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 8bit

Hi all.

Sorry for my english.

I have problem with jetspeed 1.5 using with mysql 4.0.20.
I'm using connector/j 3.0.14 production or 3.1-nightly-20040702 there is 
same error.

The portal have timeout error when user attempt to click after one minute.

If i'm surfing on web portal there is no problem. If i wait 60 seconds, 
when i re-clicked on my pane the message appairs


  There has been an Error!

Reason:

      org.apache.jetspeed.om.profile.ProfileException: org.apache.jetspeed.services.security.RoleException: Failed to retrieve role 'responsable': Communications link failure due to underlying exception: 

** BEGIN NESTED EXCEPTION ** 

java.io.EOFException

STACKTRACE:

java.io.EOFException
	at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:1858)
	at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2270)
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2693)
	at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1532)
	at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1622)
	at com.mysql.jdbc.Connection.execSQL(Connection.java:2273)
	at com.mysql.jdbc.Connection.setAutoCommit(Connection.java:493)
	at org.apache.commons.dbcp.cpdsadapter.ConnectionImpl.setAutoCommit(ConnectionImpl.java:415)
	at org.apache.torque.pool.TorqueClassicDataSource.getConnection(TorqueClassicDataSource.java:489)
	at org.apache.torque.pool.TorqueClassicDataSource.getConnection(TorqueClassicDataSource.java:458)
	at org.apache.torque.TorqueInstance.getConnection(TorqueInstance.java:743)
	at org.apache.torque.Torque.getConnection(Torque.java:306)
	at org.apache.torque.util.Transaction.beginOptional(Transaction.java:118)
	at org.apache.torque.util.BasePeer.doSelect(BasePeer.java:1365)
	at org.apache.jetspeed.om.security.turbine.BaseTurbineRolePeer.doSelectVillageRecords(BaseTurbineRolePeer.java:366)
	at org.apache.jetspeed.om.security.turbine.BaseTurbineRolePeer.doSelectVillageRecords(BaseTurbineRolePeer.java:334)
	at org.apache.jetspeed.om.security.turbine.BaseTurbineRolePeer.doSelect(BaseTurbineRolePeer.java:303)
	at org.apache.jetspeed.services.security.turbine.TurbineRoleManagement.getRole(TurbineRoleManagement.java:522)
	at org.apache.jetspeed.services.security.JetspeedRoleManagement.getRole(JetspeedRoleManagement.java:212)
	at org.apache.jetspeed.services.JetspeedSecurity.getRole(JetspeedSecurity.java:397)
	at org.apache.jetspeed.services.profiler.JetspeedProfilerService.fallbackProfile(JetspeedProfilerService.java:436)
	at org.apache.jetspeed.services.profiler.JetspeedProfilerService.getProfile(JetspeedProfilerService.java:245)
	at org.apache.jetspeed.services.profiler.JetspeedProfilerService.getProfile(JetspeedProfilerService.java:528)
	at org.apache.jetspeed.services.Profiler.getProfile(Profiler.java:87)
	at org.apache.jetspeed.modules.actions.JetspeedAccessController.doPerform(JetspeedAccessController.java:74)
	at org.apache.turbine.modules.Action.perform(Action.java:87)
	at org.apache.turbine.modules.ActionLoader.exec(ActionLoader.java:122)
	at org.apache.turbine.Turbine.doGet(Turbine.java:529)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:697)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:237)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:214)
	at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
	at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
	at org.apache.catalina.core.StandardContextValve.invokeInternal(StandardContextValve.java:198)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:152)
	at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
	at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:137)
	at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)
	at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102)
	at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
	at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
	at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
	at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:929)
	at org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:160)
	at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:793)
	at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:702)
	at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:571)
	at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:644)
	at java.lang.Thread.run(Thread.java:534)


** END NESTED EXCEPTION **


I have found that mysql connexion closed and jetspeed tried to use it first open another connexion.
Could you help me or any idea ?


-- 

________________________
Xavier Arnaudin
Analyste-D�veloppeur Alienor 
Tel +33 (0)5 57 19 65 00
Fax +33 (0)5 57 19 65 01


---------------------------------------------------------------------
To unsubscribe, e-mail: jetspeed-dev-unsubscribe@jakarta.apache.org
For additional commands, e-mail: jetspeed-dev-help@jakarta.apache.org