Hello Nicolai !
I think I have the same problem that you had but i dont know what i
should do for solving it. I started JBoss yesterday and worked fine
with my EJBs but today morning I get the communication link
failure error I listed below. When I shutdown ans start jboss
everythings working fine.
Should I change something in my Minerva configuration for my
mySQL-Pool or something else ? Or do i have to configure
something in jaws.xml ?
Greetings
Anke
Here is my jaws.xml:
<?xml version="1.0" encoding="UTF-8"?>
<jaws>
<datasource>java:/mySQLDS</datasource>
<type-mapping>mySQL</type-mapping>
<enterprise-beans>
<entity>
<ejb-name>LockBean</ejb-name>
<table-name>locks</table-name>
<create-table>false</create-table>
<debug>true</debug>
<cmp-field>
<field-name>objId</field-name>
<column-name>obj_id</column-name>
</cmp-field>
<cmp-field>
<field-name>userId</field-name>
<column-name>user_id</column-name>
</cmp-field>
<cmp-field>
<field-name>orgId</field-name>
<column-name>org_id</column-name>
</cmp-field>
<cmp-field>
<field-name>counter</field-name>
<column-name>counter</column-name>
</cmp-field>
</entity>
</enterprise-beans>
</jaws>
Here is my configuration in jboss.jcml for mySQLPool:
<mbean code="org.jboss.jdbc.XADataSourceLoader"
name="DefaultDomain:service=XADataSource,name=mySQLDB">
<attribute
name="DataSourceClass">org.opentools.minerva.jdbc.xa.wrapper.X
ADataSourceImpl</attribute>
<attribute name="PoolName">mySQLDS</attribute>
<attribute
name="URL">jdbc:mysql://sun70/dbverteilung</attribute>
<attribute name="JDBCUser">root</attribute>
<attribute name="Password"/>
</mbean>
Here is the error messages from server log:
[mySQLDS] Resource
'org.opentools.minerva.jdbc.xa.wrapper.XAResourceImpl@578aab'
enlisted for
'org.opentools.minerva.jdbc.xa.wrapper.XAConnectionImpl@60a26f'.
[mySQLDS] Pool mySQLDS [1/1/Unlimited] gave out pooled
object:
org.opentools.minerva.jdbc.xa.wrapper.XAConnectionImpl@60a26f
[JAWS] java.sql.SQLException: Communication link failure:
java.net.SocketException
[JAWS] at
org.gjt.mm.mysql.MysqlIO.sendCommand(MysqlIO.java:478)
[JAWS] at
org.gjt.mm.mysql.MysqlIO.sqlQueryDirect(MysqlIO.java:550)
[JAWS] at
org.gjt.mm.mysql.Connection.execSQL(Connection.java:885)
[JAWS] at
org.gjt.mm.mysql.PreparedStatement.executeQuery(PreparedState
ment.java:288)
[JAWS] at
org.opentools.minerva.jdbc.PreparedStatementInPool.executeQuery
(PreparedStatementInPool.java:71)
[JAWS] at
org.jboss.ejb.plugins.jaws.jdbc.JDBCQueryCommand.executeState
mentAndHandleResult(JDBCQueryCommand.java:58)
[JAWS] at
org.jboss.ejb.plugins.jaws.jdbc.JDBCCommand.jdbcExecute(JDBCCommand.java:159)
[JAWS] at
org.jboss.ejb.plugins.jaws.jdbc.JDBCFinderCommand.execute(JDBCFinderCommand.java:60)
[JAWS] at
org.jboss.ejb.plugins.jaws.jdbc.JDBCFindEntitiesCommand.execute(JDBCFindEntitiesCommand.java:145)
[JAWS] at
org.jboss.ejb.plugins.jaws.JAWSPersistenceManager.findEntities(JAWSPersistenceManager.java:138)
[JAWS] at
org.jboss.ejb.plugins.CMPPersistenceManager.findEntities(CMPPersistenceManager.java:267)
[JAWS] at org.jboss.ejb.EntityContainer.find(EntityContainer.java:392)
[JAWS] at java.lang.reflect.Method.invoke(Native Method)
[JAWS] at
org.jboss.ejb.EntityContainer$ContainerInterceptor.invokeHome(EntityContainer.java:639)
[JAWS] at
org.jboss.ejb.plugins.EntitySynchronizationInterceptor.invokeHome(EntitySynchronizationInterceptor.java:160)
[JAWS] at
org.jboss.ejb.plugins.EntityInstanceInterceptor.invokeHome(EntityInstanceInterceptor.java:87)
[JAWS] at org.jboss.ejb.plugins.TxInterceptorCMT.invokeNext(TxInterceptorCMT.java:135)
[JAWS] at
org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.java:264)
[JAWS] at org.jboss.ejb.plugins.TxInterceptorCMT.invokeHome(TxInterceptorCMT.java:86)
[JAWS] at
org.jboss.ejb.plugins.SecurityInterceptor.invokeHome(SecurityInterceptor.java:119)
[JAWS] at org.jboss.ejb.plugins.LogInterceptor.invokeHome(LogInterceptor.java:106)
[JAWS] at org.jboss.ejb.EntityContainer.invokeHome(EntityContainer.java:316)
[JAWS] at
org.jboss.ejb.plugins.jrmp.server.JRMPContainerInvoker.invokeHome(JRMPContainerInvoker.java:421)
[JAWS] at org.jboss.ejb.plugins.jrmp.interfaces.HomeProxy.invoke(HomeProxy.java:198)
[JAWS] at $Proxy6.findAll(Unknown Source)
[JAWS] at de.werum.verteilung.ejb.LocksManagerBean.findAll(LocksManagerBean.java:197)
[JAWS] at java.lang.reflect.Method.invoke(Native Method)
[JAWS] at
org.jboss.ejb.StatelessSessionContainer$ContainerInterceptor.invoke(StatelessSessionContainer.java:472)
[JAWS] at
org.jboss.ejb.plugins.StatelessSessionInstanceInterceptor.invoke(StatelessSessionInstanceInterceptor.java:87)
[JAWS] at org.jboss.ejb.plugins.TxInterceptorCMT.invokeNext(TxInterceptorCMT.java:133)
[JAWS] at
org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.java:264)
[JAWS] at org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT.java:99)
[JAWS] at
org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterceptor.java:137)
[JAWS] at org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:195)
[JAWS] at
org.jboss.ejb.StatelessSessionContainer.invoke(StatelessSessionContainer.java:271)
[JAWS] at
org.jboss.ejb.plugins.jrmp.server.JRMPContainerInvoker.invoke(JRMPContainerInvoker.java:461)
[JAWS] at
org.jboss.ejb.plugins.jrmp.interfaces.StatelessSessionProxy.invoke(StatelessSessionProxy.java:152)
[JAWS] at $Proxy5.findAll(Unknown Source)
[JAWS] at
de.werum.verteilung.servlets.LocksServlet.getLocksTable(LocksServlet.java:393)
[JAWS] at de.werum.verteilung.servlets.LocksServlet.doGet(LocksServlet.java:133)
[JAWS] at de.werum.verteilung.servlets.LocksServlet.doPost(LocksServlet.java:77)
[JAWS] at javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
[JAWS] at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
[JAWS] at org.apache.tomcat.core.ServletWrapper.doService(ServletWrapper.java:404)
[JAWS] at org.apache.tomcat.core.Handler.service(Handler.java:286)
[JAWS] at org.apache.tomcat.core.ServletWrapper.service(ServletWrapper.java:372)
[JAWS] at
org.apache.tomcat.core.ContextManager.internalService(ContextManager.java:797)
[JAWS] at org.apache.tomcat.core.ContextManager.service(ContextManager.java:743)
[JAWS] at
org.apache.tomcat.service.connector.Ajp12ConnectionHandler.processConnection(Ajp12ConnectionHandler.java:166)
[JAWS] at org.apache.tomcat.service.TcpWorkerThread.runIt(PoolTcpEndpoint.java:416)
[JAWS] at org.apache.tomcat.util.ThreadPool$ControlRunnable.run(ThreadPool.java:498)
[JAWS] at java.lang.Thread.run(Thread.java:484)
[JAWS] java.sql.SQLException: Communication link failure: java.net.SocketException
[JAWS] at org.gjt.mm.mysql.MysqlIO.sendCommand(MysqlIO.java:478)
[JAWS] at org.gjt.mm.mysql.MysqlIO.sqlQueryDirect(MysqlIO.java:550)
[JAWS] at org.gjt.mm.mysql.Connection.execSQL(Connection.java:885)
[JAWS] at org.gjt.mm.mysql.PreparedStatement.executeQuery(PreparedStatement.java:288)
[JAWS] at
org.opentools.minerva.jdbc.PreparedStatementInPool.executeQuery(PreparedStatementInPool.java:71)
[JAWS] at
org.jboss.ejb.plugins.jaws.jdbc.JDBCQueryCommand.executeStatementAndHandleResult(JDBCQueryCommand.java:58)
[JAWS] at
org.jboss.ejb.plugins.jaws.jdbc.JDBCCommand.jdbcExecute(JDBCCommand.java:159)
[JAWS] at
org.jboss.ejb.plugins.jaws.jdbc.JDBCFinderCommand.execute(JDBCFinderCommand.java:60)
[JAWS] at
org.jboss.ejb.plugins.jaws.jdbc.JDBCFindEntitiesCommand.execute(JDBCFindEntitiesCommand.java:145)
[JAWS] at
org.jboss.ejb.plugins.jaws.JAWSPersistenceManager.findEntities(JAWSPersistenceManager.java:138)
[JAWS] at
org.jboss.ejb.plugins.CMPPersistenceManager.findEntities(CMPPersistenceManager.java:267)
[JAWS] at org.jboss.ejb.EntityContainer.find(EntityContainer.java:392)
[JAWS] at java.lang.reflect.Method.invoke(Native Method)
[JAWS] at
org.jboss.ejb.EntityContainer$ContainerInterceptor.invokeHome(EntityContainer.java:639)
[JAWS] at
org.jboss.ejb.plugins.EntitySynchronizationInterceptor.invokeHome(EntitySynchronizationInterceptor.java:160)
[JAWS] at
org.jboss.ejb.plugins.EntityInstanceInterceptor.invokeHome(EntityInstanceInterceptor.java:87)
[JAWS] at org.jboss.ejb.plugins.TxInterceptorCMT.invokeNext(TxInterceptorCMT.java:135)
[JAWS] at
org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.java:264)
[JAWS] at org.jboss.ejb.plugins.TxInterceptorCMT.invokeHome(TxInterceptorCMT.java:86)
[JAWS] at
org.jboss.ejb.plugins.SecurityInterceptor.invokeHome(SecurityInterceptor.java:119)
[JAWS] at org.jboss.ejb.plugins.LogInterceptor.invokeHome(LogInterceptor.java:106)
[JAWS] at org.jboss.ejb.EntityContainer.invokeHome(EntityContainer.java:316)
[JAWS] at
org.jboss.ejb.plugins.jrmp.server.JRMPContainerInvoker.invokeHome(JRMPContainerInvoker.java:421)
[JAWS] at org.jboss.ejb.plugins.jrmp.interfaces.HomeProxy.invoke(HomeProxy.java:198)
[JAWS] at $Proxy6.findAll(Unknown Source)
[JAWS] at de.werum.verteilung.ejb.LocksManagerBean.findAll(LocksManagerBean.java:197)
[JAWS] at java.lang.reflect.Method.invoke(Native Method)
[JAWS] at
org.jboss.ejb.StatelessSessionContainer$ContainerInterceptor.invoke(StatelessSessionContainer.java:472)
[JAWS] at
org.jboss.ejb.plugins.StatelessSessionInstanceInterceptor.invoke(StatelessSessionInstanceInterceptor.java:87)
[JAWS] at org.jboss.ejb.plugins.TxInterceptorCMT.invokeNext(TxInterceptorCMT.java:133)
[JAWS] at
org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.java:264)
[JAWS] at org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT.java:99)
[JAWS] at
org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterceptor.java:137)
[JAWS] at org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:195)
[JAWS] at
org.jboss.ejb.StatelessSessionContainer.invoke(StatelessSessionContainer.java:271)
[JAWS] at
org.jboss.ejb.plugins.jrmp.server.JRMPContainerInvoker.invoke(JRMPContainerInvoker.java:461)
[JAWS] at
org.jboss.ejb.plugins.jrmp.interfaces.StatelessSessionProxy.invoke(StatelessSessionProxy.java:152)
[JAWS] at $Proxy5.findAll(Unknown Source)
[JAWS] at
de.werum.verteilung.servlets.LocksServlet.getLocksTable(LocksServlet.java:393)
[JAWS] at de.werum.verteilung.servlets.LocksServlet.doGet(LocksServlet.java:133)
[JAWS] at de.werum.verteilung.servlets.LocksServlet.doPost(LocksServlet.java:77)
[JAWS] at javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
[JAWS] at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
[JAWS] at org.apache.tomcat.core.ServletWrapper.doService(ServletWrapper.java:404)
[JAWS] at org.apache.tomcat.core.Handler.service(Handler.java:286)
[JAWS] at org.apache.tomcat.core.ServletWrapper.service(ServletWrapper.java:372)
[JAWS] at
org.apache.tomcat.core.ContextManager.internalService(ContextManager.java:797)
[JAWS] at
org.apache.tomcat.core.ContextManager.service(ContextManager.j
ava:743)
[JAWS] at
org.apache.tomcat.service.connector.Ajp12ConnectionHandler.proc
essConnection(Ajp12ConnectionHandler.java:166)
[JAWS] at
org.apache.tomcat.service.TcpWorkerThread.runIt(PoolTcpEndpoint
.java:416)
[JAWS] at
org.apache.tomcat.util.ThreadPool$ControlRunnable.run(ThreadPool
.java:498)
[JAWS] at java.lang.Thread.run(Thread.java:484)
************************************
Anke Kimpel
Werum GmbH
Erbstorfer Landstraße 14
21337 Lüneburg
Tel. 04131/8900-707
mailto:[EMAIL PROTECTED]
http://www.werum.com
************************************
_______________________________________________
JBoss-user mailing list
[EMAIL PROTECTED]
http://lists.sourceforge.net/lists/listinfo/jboss-user
