[jboss-user] [JBossCache] - Re: JDBCCacheLoader problem in java application

[gmeroz]

Since we both agree that there shouldn't be a difference between pojo & core cache related to this issue, i decided to run more tests & managed to reproduce the problem.

i just changed the loop in your test to run up to 1000 & got the following error (only when using Oracle):


  | java.lang.IllegalStateException: Failed to load node for fqn /C/487
  | 	at org.jboss.cache.loader.AdjListJDBCCacheLoader.reportAndRethrowError(AdjListJDBCCacheLoader.java:652)
  | 	at org.jboss.cache.loader.AdjListJDBCCacheLoader.loadNode(AdjListJDBCCacheLoader.java:408)
  | 	at org.jboss.cache.loader.JDBCCacheLoader._put(JDBCCacheLoader.java:188)
  | 	at org.jboss.cache.loader.JDBCCacheLoader.put(JDBCCacheLoader.java:69)
  | 	at org.jboss.cache.interceptors.CacheStoreInterceptor.invoke(CacheStoreInterceptor.java:219)
  | 	at org.jboss.cache.interceptors.Interceptor.invoke(Interceptor.java:76)
  | 	at org.jboss.cache.interceptors.CacheLoaderInterceptor.invoke(CacheLoaderInterceptor.java:180)
  | 	at org.jboss.cache.interceptors.Interceptor.invoke(Interceptor.java:76)
  | 	at org.jboss.cache.interceptors.UnlockInterceptor.invoke(UnlockInterceptor.java:36)
  | 	at org.jboss.cache.interceptors.Interceptor.invoke(Interceptor.java:76)
  | 	at org.jboss.cache.interceptors.PessimisticLockInterceptor.invoke(PessimisticLockInterceptor.java:201)
  | 	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:299)
  | 	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:97)
  | 	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:4019)
  | 	at org.jboss.cache.CacheImpl.put(CacheImpl.java:1535)
  | 	at org.jboss.cache.loader.JDBCCacheLoaderConnectionTest.testConnectionRelease(JDBCCacheLoaderConnectionTest.java:55)
  | 	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  | 	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
  | 	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
  | 	at com.intellij.rt.execution.junit.JUnitStarter.main(JUnitStarter.java:40)
  | 	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  | 	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
  | 	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
  | 	at com.intellij.rt.execution.application.AppMain.main(AppMain.java:90)
  | Caused by: java.lang.IllegalStateException: Failed to get connection for url=jdbc:oracle:thin:@dbms01:1521:besapp, user=gggg, password=gggg
  | 	at org.jboss.cache.loader.NonManagedConnectionFactory.reportAndRethrowError(NonManagedConnectionFactory.java:236)
  | 	at org.jboss.cache.loader.NonManagedConnectionFactory.getConnection(NonManagedConnectionFactory.java:85)
  | 	at org.jboss.cache.loader.AdjListJDBCCacheLoader.loadNode(AdjListJDBCCacheLoader.java:373)
  | 	... 44 more
  | Caused by: 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(DatabaseError.java:162)
  | 	at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:274)
  | 	at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:328)
  | 	at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:348)
  | 	at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:151)
  | 	at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:32)
  | 	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)
  | 	... 45 more
  | 
  | 

Is there any workaround for hits?

View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4101478#4101478

Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4101478