I'm having a (related?) issue. When I hot-redeploy several times I end up
with no available connections on mysql and the ear cannot deploy. My app
only uses CMP, and even if I call no bean and only redeploy three or four
times I get the same error. I have to bounce the server back. No problem
since hot-redeploy is for development, but I don't think it's good.
I think it's already posted as a bug from some time ago.
[22:24:21,403,CanplasticaMySQLDS] Unable to create ManagedConnection:
javax.resource.ResourceException: Unable to create DB connection for url:
jdbc:mysql://localhost/can
plastica, user: , exception: java.sql.SQLException: Server configuration
denies access to data sourc
e
at
org.jboss.resource.adapter.jdbc.local.JDBCManagedConnectionFactory.createMan
agedConnectio
n(JDBCManagedConnectionFactory.java:392)
at
org.jboss.resource.connectionmanager.ManagedConnectionPoolFactory.createObje
ct(ManagedCon
nectionPoolFactory.java:77)
at org.jboss.pool.ObjectPool.createNewObject(ObjectPool.java:1007)
at org.jboss.pool.ObjectPool.getObject(ObjectPool.java:667)
at
org.jboss.resource.connectionmanager.SharedLocalConnectionManager.allocateCo
nnection(Shar
edLocalConnectionManager.java:124)
at
org.jboss.resource.adapter.jdbc.JDBCDataSource.getConnection(JDBCDataSource.
java:110)
at
org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.getConnection(JDBCStoreManag
er.java:303)
at
org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.createTable(JDBCStartCommand
.java:62)
at
org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.execute(JDBCStartCommand.jav
a:41)
at
org.jboss.ejb.plugins.cmp.CMPStoreManager.start(CMPStoreManager.java:142)
at
org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.start(JDBCStoreManager.java:
137)
at
org.jboss.ejb.plugins.CMPPersistenceManager.start(CMPPersistenceManager.java
:186)
at org.jboss.ejb.EntityContainer.start(EntityContainer.java:404)
at org.jboss.ejb.Application.start(Application.java:200)
at org.jboss.ejb.ContainerFactory.deploy(ContainerFactory.java:381)
at org.jboss.ejb.ContainerFactory.deploy(ContainerFactory.java:307)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:42
)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl
.java:28)
at java.lang.reflect.Method.invoke(Method.java:327)
at
com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1628)
at
com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1523)
at
org.jboss.deployment.J2eeDeployer.startModules(J2eeDeployer.java:467)
at
org.jboss.deployment.J2eeDeployer.startApplication(J2eeDeployer.java:444)
at org.jboss.deployment.J2eeDeployer.deploy(J2eeDeployer.java:215)
> -----Mensaje original-----
> De: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED]]En nombre de
> Ferguson, Doug
> Enviado el: martes, 20 de noviembre de 2001 21:37
> Para: jBoss Dev (E-mail)
> Asunto: RE: [JBoss-dev] ObjectPool - Invalidate On Error
>
>
> So it appears that the ConnectionInPool is getting removed from the pool
> but is inner connection is never getting closed.
>
> I am thinking that the best approach is to obtain the JDBC connection
> by calling getUnderlyingConnection. then call close() on that connection
>
> If I get the ok. I will do this and check it in.
>
> d./
>
> -----Original Message-----
> From: Ferguson, Doug [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, November 20, 2001 2:28 PM
> To: jBoss Dev (E-mail)
> Subject: [JBoss-dev] ObjectPool - Invalidate On Error
>
>
> We have just noticed that whenever our code throws a SQLException,
> the connection pool continues to grow. Apparently the connections
> that get "invalidated" aren't ever cleaned up. These grow until Oracle
> bails. I am looking at ObjectPool right now to see if I can figure it out.
>
> If anybody already knows about this, please let me know.
>
> Thanks,
> d.
>
> _______________________________________________
> Jboss-development mailing list
> [EMAIL PROTECTED]
> https://lists.sourceforge.net/lists/listinfo/jboss-development
>
> _______________________________________________
> Jboss-development mailing list
> [EMAIL PROTECTED]
> https://lists.sourceforge.net/lists/listinfo/jboss-development
>
>
_______________________________________________
Jboss-development mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-development
