Hi fellas, I try to run a java routine on the oracle with jboss+datasource, but i get these errors message:
anonymous wrote : | 12:20:35,125 WARN [JBossManagedConnectionPool] Throwable while attempting to get a new connection: null | org.jboss.resource.JBossResourceException: Could not create connection; - nested throwable: (java.sql.SQLException: Exceção de E/S: Connection refused(DESCRIPTION=(TMP=)(VSNNUM=153094144)(ERR=12505)(ERROR_STACK=(ERROR=(CODE=12505)(EMFI=4))))) | at org.jboss.resource.adapter.jdbc.local.LocalManagedConnectionFactory.createManagedConnection(LocalManagedConnectionFactory.java:164) | at org.jboss.resource.connectionmanager.InternalManagedConnectionPool.createConnectionEventListener(InternalManagedConnectionPool.java:519) | at org.jboss.resource.connectionmanager.InternalManagedConnectionPool.getConnection(InternalManagedConnectionPool.java:208) | at org.jboss.resource.connectionmanager.JBossManagedConnectionPool$BasePool.getConnection(JBossManagedConnectionPool.java:529) | at org.jboss.resource.connectionmanager.BaseConnectionManager2.getManagedConnection(BaseConnectionManager2.java:410) | at org.jboss.resource.connectionmanager.TxConnectionManager.getManagedConnection(TxConnectionManager.java:342) | at org.jboss.resource.connectionmanager.BaseConnectionManager2.allocateConnection(BaseConnectionManager2.java:462) | at org.jboss.resource.connectionmanager.BaseConnectionManager2$ConnectionManagerProxy.allocateConnection(BaseConnectionManager2.java:894) | at org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:73) | at com.xxxxxxxxxxx.xxxxxxxxx.carga.bd.GetConnectionTb54.getConnection(GetConnectionTb54.java:40) | at com.xxxxxxxxxxx.xxxxxxxxx.carga.dao.SelectsDAO.(SelectsDAO.java:50) | at com.xxxxxxxxxxx.xxxxxxxxx.carga.business.CarregandoAnuncios.upgrade(CarregandoAnuncios.java:43) | at com.xxxxxxxxxxx.xxxxxxxxx.carga.service.PrCargaIncService.perform(PrCargaIncService.java:103) | at org.jboss.varia.scheduler.Scheduler$Listener.handleNotification(Scheduler.java:1221) | at sun.reflect.GeneratedMethodAccessor3.invoke(Unknown Source) | at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) | at java.lang.reflect.Method.invoke(Method.java:585) | at org.jboss.mx.notification.NotificationListenerProxy.invoke(NotificationListenerProxy.java:138) | at $Proxy10.handleNotification(Unknown Source) | at javax.management.NotificationBroadcasterSupport.handleNotification(NotificationBroadcasterSupport.java:221) | at javax.management.NotificationBroadcasterSupport.sendNotification(NotificationBroadcasterSupport.java:184) | at javax.management.timer.Timer.sendNotification(Timer.java:1295) | at javax.management.timer.Timer.notifyAlarmClock(Timer.java:1264) | at javax.management.timer.TimerAlarmClock.run(Timer.java:1347) | at java.util.TimerThread.mainLoop(Timer.java:512) | at java.util.TimerThread.run(Timer.java:462) | Caused by: java.sql.SQLException: Exceção de E/S: Connection refused(DESCRIPTION=(TMP=)(VSNNUM=153094144)(ERR=12505)(ERROR_STACK=(ERROR=(CODE=12505)(EMFI=4)))) | at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134) | at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:179) | at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:334) | at oracle.jdbc.ttc7.TTC7Protocol.handleIOException(TTC7Protocol.java:3678) | at oracle.jdbc.ttc7.TTC7Protocol.logon(TTC7Protocol.java:352) | at oracle.jdbc.driver.OracleConnection.(OracleConnection.java:365) | at oracle.jdbc.driver.OracleDriver.getConnectionInstance(OracleDriver.java:547) | at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:347) | at org.jboss.resource.adapter.jdbc.local.LocalManagedConnectionFactory.createManagedConnection(LocalManagedConnectionFactory.java:154) | ... 25 more | | here is my DS.xml: | <?xml version="1.0" encoding="UTF-8"?> | <datasources> | <local-tx-datasource> | <jndi-name>OracleDSGD13</jndi-name> | <connection-url>jdbc:oracle:thin:@xx.x.x.xx:1521:Gd13</connection-url> | <driver-class>oracle.jdbc.driver.OracleDriver</driver-class> | <user-name>xxxxxxxx</user-name> | <password>xxxxxxxx</password> | <min-pool-size>1</min-pool-size> | <max-pool-size>50</max-pool-size> | <idle-timeout-minutes>5</idle-timeout-minutes> | <blocking-timeout-millis>30000</blocking-timeout-millis> | | <check-valid-connection-sql>select 1 from dual</check-valid-connection-sql> | | <isSameRM-override-value>false</isSameRM-override-value> | <track-connection-by-tx/> | <no-tx-separate-pools/> | | | </local-tx-datasource> | </datasources> | | View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4113794#4113794 Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4113794 _______________________________________________ jboss-user mailing list jboss-user@lists.jboss.org https://lists.jboss.org/mailman/listinfo/jboss-user
