[jboss-user] [JCA/JBoss] - org.jboss.resource.JBossResourceException: Could not create

[eduacsp2]

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