1 2 Previous Next 15 Replies Latest reply on Dec 19, 2007 10:24 AM by Eduardo Crestani

    org.jboss.resource.JBossResourceException: Could not create

    Eduardo Crestani Newbie

      Hi fellas,

      I try to run a java routine on the oracle with jboss+datasource, but i get these errors message:


      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.<init>(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.<init>(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>
      
      


        1 2 Previous Next