[JCA/JBoss] - WHY pingDatabase failed status=-1?
by xpdz
Hello,
our customer encoutered this issue while they do some normal operations on web application. The exception is:
08:30:45,435 WARN [LocalManagedConnectionFactory] Destroying connection that is not valid, due to the following exception: oracle.jdbc.driver.T4CConnection@1545e24
java.sql.SQLException: pingDatabase failed status=-1
at org.jboss.resource.adapter.jdbc.vendor.OracleValidConnectionChecker.isValidConnection(OracleValidConnectionChecker.java:72)
at org.jboss.resource.adapter.jdbc.BaseWrapperManagedConnectionFactory.isValidConnection(BaseWrapperManagedConnectionFactory.java:435)
at org.jboss.resource.adapter.jdbc.BaseWrapperManagedConnection.checkValid(BaseWrapperManagedConnection.java:231)
at org.jboss.resource.adapter.jdbc.local.LocalManagedConnectionFactory.matchManagedConnections(LocalManagedConnectionFactory.java:200)
at org.jboss.resource.connectionmanager.InternalManagedConnectionPool.getConnection(InternalManagedConnectionPool.java:209)
at org.jboss.resource.connectionmanager.JBossManagedConnectionPool$BasePool.getConnection(JBossManagedConnectionPool.java:529)
at org.jboss.resource.connectionmanager.BaseConnectionManager2.getManagedConnection(BaseConnectionManager2.java:341)
at org.jboss.resource.connectionmanager.TxConnectionManager.getManagedConnection(TxConnectionManager.java:301)
at org.jboss.resource.connectionmanager.BaseConnectionManager2.allocateConnection(BaseConnectionManager2.java:396)
at org.jboss.resource.connectionmanager.BaseConnectionManager2$ConnectionManagerProxy.allocateConnection(BaseConnectionManager2.java:842)
at org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:88)
...........................................................................................................
08:30:45,440 WARN [TxConnectionManager] Connection error occured: org.jboss.resource.connectionmanager.TxConnectionManager$TxConnectionEventListener@13115ab[state=NORMAL mc=org.jboss.resource.adapter.jdbc.local.LocalManagedConnection@1f0bf67 handles=0 lastUse=1229578757037 permit=false trackByTx=false mcp=org.jboss.resource.connectionmanager.JBossManagedConnectionPool$OnePool@a63987 context=org.jboss.resource.connectionmanager.InternalManagedConnectionPool@10aed2c xaResource=org.jboss.resource.connectionmanager.TxConnectionManager$LocalXAResource@59071d txSync=null]
java.sql.SQLException: pingDatabase failed status=-1
at org.jboss.resource.adapter.jdbc.vendor.OracleValidConnectionChecker.isValidConnection(OracleValidConnectionChecker.java:72)
at org.jboss.resource.adapter.jdbc.BaseWrapperManagedConnectionFactory.isValidConnection(BaseWrapperManagedConnectionFactory.java:435)
at org.jboss.resource.adapter.jdbc.BaseWrapperManagedConnection.checkValid(BaseWrapperManagedConnection.java:231)
at org.jboss.resource.adapter.jdbc.local.LocalManagedConnectionFactory.matchManagedConnections(LocalManagedConnectionFactory.java:200)
at org.jboss.resource.connectionmanager.InternalManagedConnectionPool.getConnection(InternalManagedConnectionPool.java:209)
at org.jboss.resource.connectionmanager.JBossManagedConnectionPool$BasePool.getConnection(JBossManagedConnectionPool.java:529)
at org.jboss.resource.connectionmanager.BaseConnectionManager2.getManagedConnection(BaseConnectionManager2.java:341)
at org.jboss.resource.connectionmanager.TxConnectionManager.getManagedConnection(TxConnectionManager.java:301)
at org.jboss.resource.connectionmanager.BaseConnectionManager2.allocateConnection(BaseConnectionManager2.java:396)
at org.jboss.resource.connectionmanager.BaseConnectionManager2$ConnectionManagerProxy.allocateConnection(BaseConnectionManager2.java:842)
at org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:88)
...........................................................................................................
08:30:45,443 WARN [JBossManagedConnectionPool] Destroying connection that could not be successfully matched: org.jboss.resource.connectionmanager.TxConnectionManager$TxConnectionEventListener@13115ab[state=DESTROYED mc=org.jboss.resource.adapter.jdbc.local.LocalManagedConnection@1f0bf67 handles=0 lastUse=1229578757037 permit=false trackByTx=false mcp=org.jboss.resource.connectionmanager.JBossManagedConnectionPool$OnePool@a63987 context=org.jboss.resource.connectionmanager.InternalManagedConnectionPool@10aed2c xaResource=org.jboss.resource.connectionmanager.TxConnectionManager$LocalXAResource@59071d txSync=null]
my *-ds.xml is:
<?xml version="1.0" encoding="UTF-8" ?>
-
- <local-tx-datasource>
<jndi-name>jdbc/mvpdm</jndi-name>
<connection-url>jdbc:oracle:thin:@stddsdb1:3302:DDS</connection-url>
<driver-class>oracle.jdbc.driver.OracleDriver</driver-class>
<user-name>mcf</user-name>
mcf01
- <!-- This checks the connections are good before handing them out
-->
<valid-connection-checker-class-name>org.jboss.resource.adapter.jdbc.vendor.OracleValidConnectionChecker</valid-connection-checker-class-name>
<exception-sorter-class-name>org.jboss.resource.adapter.jdbc.vendor.OracleExceptionSorter</exception-sorter-class-name>
<min-pool-size>1</min-pool-size>
<max-pool-size>10</max-pool-size>
-
<type-mapping>Oracle9i</type-mapping>
</local-tx-datasource>
any ideas?
TIA!
View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4200961#4200961
Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4200961
17 years, 6 months
[JBossWS] - Class Cast Exception under Endpoint.publish()
by adinn
I am using JBossAS 5.0.0.GA with JBossWS 3.0.4 and I am trying to publish an endpoint using
| Endpoint publish(String address, Object implementor)
|
I supply the call with an instance of my endpoint class which is annotated with the appropriate WebService, SOAPBinding, WebMethod, etc annotations.
During deployment of the endpoint I get a Class Cast Exception as follows
| 11:40:51,731 ERROR [AbstractKernelController] Error installing to PostClassLoader: name=/xtsservicetests1 state=ClassLoader mode=Manual requiredState=PostClassLoader
| org.jboss.deployers.spi.DeploymentException: Error during deploy: /xtsservicetests1
| at org.jboss.deployers.spi.DeploymentException.rethrowAsDeploymentException(DeploymentException.java:49)
| at org.jboss.deployers.plugins.deployers.DeployerWrapper.deploy(DeployerWrapper.java:177)
| at org.jboss.deployers.plugins.deployers.DeployersImpl.doDeploy(DeployersImpl.java:1439)
| at org.jboss.deployers.plugins.deployers.DeployersImpl.doInstallParentFirst(DeployersImpl.java:1157)
| at org.jboss.deployers.plugins.deployers.DeployersImpl.install(DeployersImpl.java:1098)
| at org.jboss.dependency.plugins.AbstractControllerContext.install(AbstractControllerContext.java:348)
| at org.jboss.dependency.plugins.AbstractController.install(AbstractController.java:1598)
| at org.jboss.dependency.plugins.AbstractController.incrementState(AbstractController.java:934)
| at org.jboss.dependency.plugins.AbstractController.resolveContexts(AbstractController.java:1062)
| at org.jboss.dependency.plugins.AbstractController.resolveContexts(AbstractController.java:984)
| at org.jboss.dependency.plugins.AbstractController.change(AbstractController.java:822)
| at org.jboss.dependency.plugins.AbstractController.change(AbstractController.java:553)
| at org.jboss.deployers.plugins.deployers.DeployersImpl.process(DeployersImpl.java:781)
| at org.jboss.deployers.plugins.main.MainDeployerImpl.deploy(MainDeployerImpl.java:418)
| at org.jboss.wsf.container.jboss50.transport.EndpointAPIHttpTransportManager.deploy(EndpointAPIHttpTransportManager.java:169)
| at org.jboss.wsf.container.jboss50.transport.EndpointAPIHttpTransportManager.createListener(EndpointAPIHttpTransportManager.java:85)
| at org.jboss.wsf.framework.deployment.HttpTransportDeploymentAspect.create(HttpTransportDeploymentAspect.java:76)
| at org.jboss.wsf.framework.deployment.DeploymentAspectManagerImpl.create(DeploymentAspectManagerImpl.java:121)
| at org.jboss.wsf.container.jboss50.BareWSFRuntime.create(BareWSFRuntime.java:61)
| at org.jboss.wsf.container.jboss50.transport.WSFRuntimeDelegateHttpServer.publish(WSFRuntimeDelegateHttpServer.java:96)
| at org.jboss.ws.core.jaxws.spi.EndpointImpl.publish(EndpointImpl.java:172)
| at org.jboss.ws.core.jaxws.spi.EndpointImpl.publish(EndpointImpl.java:129)
| at org.jboss.ws.core.jaxws.spi.ProviderImpl.createAndPublishEndpoint(ProviderImpl.java:83)
| at javax.xml.ws.Endpoint.publish(Endpoint.java:184)
| at org.jboss.jbossts.xts.servicetests.service.XTSServiceTestServiceManager.publish(XTSServiceTestServiceManager.java:19)
| at org.jboss.jbossts.xts.servicetests.test.XTSPublishAndInvokeTest.run(XTSPublishAndInvokeTest.java:20)
| at org.jboss.jbossts.xts.servicetests.bean.XTSServiceTestRunnerBean$1.run(XTSServiceTestRunnerBean.java:74)
| Caused by: java.lang.ClassCastException: org.jboss.deployers.structure.spi.helpers.AbstractDeploymentUnit
| at org.jboss.deployment.security.AbstractSecurityDeployer.deploy(AbstractSecurityDeployer.java:148)
| at org.jboss.deployers.plugins.deployers.DeployerWrapper.deploy(DeployerWrapper.java:171)
| ... 25 more
|
The problem is that AbstractSecurityDeployer.deploy is invoked with an AbstractDeploymentUnit as argument. However, at line 148 it tries to cast its argument to a VFSDeploymentUnit.
Any ideas why this is happening?
Has anyone successfully managed to use Endpoint.publish previously? If so what did you do to avoid running up against this exception?
View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4200960#4200960
Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4200960
17 years, 6 months
[Persistence, JBoss/CMP, Hibernate, Database] - Re: JBoss Datasource reads an old connection-url
by mfps1810
1. C:\jboss-4.2.2.GA\server\default\deploy\my-ds.xml
<?xml version="1.0"?>
<local-tx-datasource>
<jndi-name>imceDS</jndi-name>
<connection- url>jdbc:mysql://10.90.31.14:3306/testB</connection-url>
<driver-class>org.gjt.mm.mysql.Driver</driver-class>
<user-name>root</user-name>
xxx
<exception-sorter-class-name>org.jboss.resource.adapter.jdbc.vendor.MySQLExceptionSorter</exception-sorter-class-name>
<max-pool-size>20</max-pool-size>
<idle-timeout-minutes>5</idle-timeout-minutes>
<type-mapping>mySQL</type-mapping>
</local-tx-datasource>
2. C:\jboss-4.2.2.GA\bin\run.bat
12:23:57,703 INFO [Server] JBoss (MX MicroKernel) [4.2.2.GA (build: SVNTag=JBoss_4_2_2_GA date=200710221139)] Started in 1m:56s:859ms...
3. Edit server.log
<config-property name='ConnectionURL' type='java.lang.String'>jdbc:mysql://10.90.31.14:3306/testB</config-property>
<config-property name='DriverClass' type='java.lang.String'>org.gjt.mm.mysql.Driver</config-property>
<config-property name='UserName' type='java.lang.String'>root</config-property>
<config-property name='Password' type='java.lang.String'>imce</config-property>
<config-property name='ExceptionSorterClassName' type='java.lang.String'>org.jboss.resource.adapter.jdbc.vendor.MySQLExceptionSorter</config-property>
<config-property name='ValidateOnMatch' type='boolean'>true</config-property>
4. Run my web app
http://localhost:8080/mywebapp/
The database called test has been loaded, not the database testB !!!!!
That's all!
Thanks,
Manuel.
View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4200954#4200954
Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4200954
17 years, 6 months