in version 2.0.0GA When i use JDBCCacheLoader inside JBossAS it wokrs fine, but when i try to run the same code from a regular java Main class it fails with the following exception. i seems that some connections are not closed.
| .... | added 85 dummy node to Jboss cache. | added 86 dummy node to Jboss cache. | 18:15:52,164 ERROR [NonManagedConnectionFactory] Failed to get connection for url=jdbc:oracle:thin:@dbms01:1521:besapp, user=GGGG, password=gggg | java.sql.SQLException: Io exception: The Network Adapter could not establish the connection | at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:125) | at oracle.jdbc.driver.DatabaseError.throwSqlException | ... | ... | at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:563) | at java.sql.DriverManager.getConnection(DriverManager.java:582) | at java.sql.DriverManager.getConnection(DriverManager.java:185) | at org.jboss.cache.loader.NonManagedConnectionFactory.checkoutConnection(NonManagedConnectionFactory.java:99) | at org.jboss.cache.loader.NonManagedConnectionFactory.getConnection(NonManagedConnectionFactory.java:80) | at org.jboss.cache.loader.AdjListJDBCCacheLoader.loadNode(AdjListJDBCCacheLoader.java:373) | at org.jboss.cache.loader.AdjListJDBCCacheLoader.get(AdjListJDBCCacheLoader.java:97) | at org.jboss.cache.interceptors.CacheLoaderInterceptor.loadData(CacheLoaderInterceptor.java:530) | at org.jboss.cache.interceptors.CacheLoaderInterceptor.loadNode(CacheLoaderInterceptor.java:408) | at org.jboss.cache.interceptors.CacheLoaderInterceptor.loadIfNeeded(CacheLoaderInterceptor.java:210) | at org.jboss.cache.interceptors.CacheLoaderInterceptor.invoke(CacheLoaderInterceptor.java:157) | at org.jboss.cache.interceptors.Interceptor.invoke(Interceptor.java:76) | at org.jboss.cache.interceptors.UnlockInterceptor.invoke(UnlockInterceptor.java:37) | at org.jboss.cache.interceptors.Interceptor.invoke(Interceptor.java:76) | at org.jboss.cache.interceptors.PessimisticLockInterceptor.invoke(PessimisticLockInterceptor.java:203) | at org.jboss.cache.interceptors.Interceptor.invoke(Interceptor.java:76) | at org.jboss.cache.interceptors.NotificationInterceptor.invoke(NotificationInterceptor.java:32) | at org.jboss.cache.interceptors.Interceptor.invoke(Interceptor.java:76) | at org.jboss.cache.interceptors.TxInterceptor.handleNonTxMethod(TxInterceptor.java:298) | at org.jboss.cache.interceptors.TxInterceptor.invoke(TxInterceptor.java:131) | at org.jboss.cache.interceptors.Interceptor.invoke(Interceptor.java:76) | at org.jboss.cache.interceptors.CacheMgmtInterceptor.invoke(CacheMgmtInterceptor.java:81) | at org.jboss.cache.interceptors.Interceptor.invoke(Interceptor.java:76) | at org.jboss.cache.interceptors.InvocationContextInterceptor.invoke(InvocationContextInterceptor.java:62) | at org.jboss.cache.CacheImpl.invokeMethod(CacheImpl.java:3939) | at org.jboss.cache.CacheImpl.get(CacheImpl.java:1441) | at org.jboss.cache.CacheImpl.get(CacheImpl.java:1415) | at org.jboss.cache.pojo.impl.InternalHelper.get(InternalHelper.java:92) | at org.jboss.cache.pojo.impl.InternalHelper.getPojoInstance(InternalHelper.java:38) | at org.jboss.cache.pojo.impl.InternalHelper.getPojo(InternalHelper.java:198) | at org.jboss.cache.pojo.impl.PojoCacheDelegate.putObjectII(PojoCacheDelegate.java:131) | at org.jboss.cache.pojo.impl.PojoCacheImpl.putObject(PojoCacheImpl.java:136) | at org.jboss.cache.pojo.impl.PojoCacheImpl.org$jboss$cache$pojo$impl$PojoCacheImpl$attach$aop(PojoCacheImpl.java:101) | at org.jboss.cache.pojo.impl.PojoCacheImpl.attach(PojoCacheImpl.java) | at org.jboss.cache.pojo.impl.PojoCacheImpl.attach(PojoCacheImpl.java:93) | at JDBCCacheTest.main(JDBCCacheTest.java:10) | at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) | at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) | at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) | View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4100983#4100983 Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4100983 _______________________________________________ jboss-user mailing list [email protected] https://lists.jboss.org/mailman/listinfo/jboss-user
