8:27 a.m.
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#...
Reply to the post :
http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&a...