[jboss-user] [JBossCache] - JDBCCacheLoader error: Io exception: The Network Adapter cou
gmeroz
do-not-reply at jboss.com
Tue Jan 30 05:27:31 EST 2007
if i use the following code with a JDBCCacheLoader, i get the following exception after a while (after putting about 250 items to the cache):
| for (int i=0 ; i<10000 ;i++){
| Person x = new Person();
| x.setName("x"+i);
| x.setAddress(address);
| cache.put("engine/x"+i,x);
| }
|
| 12:19:32,645 ERROR [JDBCCacheLoader] Failed to get connection for url=jdbc:oracle:thin:@dbms01:1521:besapp, user=GILEADHBVMC02_NEW2, password=GILEADHBVMC02_NEW2
| 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:525)
| at java.sql.DriverManager.getConnection(DriverManager.java:171)
| at org.jboss.cache.loader.JDBCCacheLoader$NonManagedConnectionFactory.getConnection(JDBCCacheLoader.java:1157)
| at org.jboss.cache.loader.JDBCCacheLoader.loadNode(JDBCCacheLoader.java:816)
| at org.jboss.cache.loader.JDBCCacheLoader.get(JDBCCacheLoader.java:202)
| at org.jboss.cache.interceptors.CacheLoaderInterceptor.loadData(CacheLoaderInterceptor.java:533)
| at org.jboss.cache.interceptors.CacheLoaderInterceptor.loadNode(CacheLoaderInterceptor.java:426)
| at org.jboss.cache.interceptors.CacheLoaderInterceptor.loadIfNeeded(CacheLoaderInterceptor.java:214)
| at org.jboss.cache.interceptors.CacheLoaderInterceptor.invoke(CacheLoaderInterceptor.java:185)
| at org.jboss.cache.interceptors.ActivationInterceptor.invoke(ActivationInterceptor.java:66)
| at org.jboss.cache.interceptors.Interceptor.invoke(Interceptor.java:75)
| at org.jboss.cache.interceptors.UnlockInterceptor.invoke(UnlockInterceptor.java:33)
| at org.jboss.cache.interceptors.Interceptor.invoke(Interceptor.java:75)
| at org.jboss.cache.interceptors.PassivationInterceptor.invoke(PassivationInterceptor.java:80)
| at org.jboss.cache.interceptors.Interceptor.invoke(Interceptor.java:75)
| at org.jboss.cache.interceptors.NotificationInterceptor.invoke(NotificationInterceptor.java:22)
| at org.jboss.cache.interceptors.Interceptor.invoke(Interceptor.java:75)
| at org.jboss.cache.interceptors.TxInterceptor.handleNonTxMethod(TxInterceptor.java:288)
| at org.jboss.cache.interceptors.TxInterceptor.invoke(TxInterceptor.java:126)
| at org.jboss.cache.interceptors.Interceptor.invoke(Interceptor.java:75)
| at org.jboss.cache.interceptors.CacheMgmtInterceptor.invoke(CacheMgmtInterceptor.java:126)
| at org.jboss.cache.interceptors.Interceptor.invoke(Interceptor.java:75)
| at org.jboss.cache.interceptors.InvocationContextInterceptor.invoke(InvocationContextInterceptor.java:66)
| at org.jboss.cache.CacheImpl.invokeMethod(CacheImpl.java:3750)
| at org.jboss.cache.CacheImpl.get(CacheImpl.java:1390)
| at org.jboss.cache.CacheImpl.get(CacheImpl.java:1365)
| at org.jboss.cache.pojo.impl.InternalHelper.get(InternalHelper.java:142)
| at org.jboss.cache.pojo.impl.InternalHelper.getAopInstance(InternalHelper.java:72)
| at org.jboss.cache.pojo.impl.InternalHelper.getPojo(InternalHelper.java:264)
| at org.jboss.cache.pojo.impl.PojoCacheDelegate.getObject(PojoCacheDelegate.java:88)
| at org.jboss.cache.pojo.impl.PojoCacheImpl.getObject(PojoCacheImpl.java:208)
| at org.jboss.cache.pojo.impl.PojoCacheImpl.org$jboss$cache$pojo$impl$PojoCacheImpl$find$aop(PojoCacheImpl.java:196)
| at org.jboss.cache.pojo.impl.PojoCacheImpl$PojoCacheImplAdvisor.find_N_7063709169143275953(PojoCacheImpl$PojoCacheImplAdvisor.java)
| at org.jboss.cache.pojo.impl.PojoCacheImpl.find(PojoCacheImpl.java)
| at org.jboss.cache.pojo.impl.PojoCacheImpl.org$jboss$cache$pojo$impl$PojoCacheImpl$detach$aop(PojoCacheImpl.java:160)
| at org.jboss.cache.pojo.impl.PojoCacheImpl$PojoCacheImplAdvisor.detach9209594694587929181(PojoCacheImpl$PojoCacheImplAdvisor.java)
| at org.jboss.cache.pojo.impl.PojoCacheImpl.detach(PojoCacheImpl.java)
| at org.jboss.cache.pojo.impl.PojoCacheDelegate.putObjectII(PojoCacheDelegate.java:150)
| at org.jboss.cache.pojo.impl.PojoCacheImpl.putObject(PojoCacheImpl.java:145)
| at org.jboss.cache.pojo.impl.PojoCacheImpl.org$jboss$cache$pojo$impl$PojoCacheImpl$attach$aop(PojoCacheImpl.java:122)
| at org.jboss.cache.pojo.impl.PojoCacheImpl$PojoCacheImplAdvisor.attach3085019539260813833(PojoCacheImpl$PojoCacheImplAdvisor.java)
| at org.jboss.cache.pojo.impl.PojoCacheImpl.attach(PojoCacheImpl.java)
| at org.jboss.cache.pojo.impl.PojoCacheImpl.attach(PojoCacheImpl.java:114)
| at com.bevents.infra.service.cache.JBossCacheImpl.put(JBossCacheImpl.java:41)
| at com.bevents.infra.service.cache.JBossCacheImplTest.testPutAndGet(JBossCacheImplTest.java:47)
| at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
| at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
| at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
| at java.lang.reflect.Method.invoke(Method.java:585)
| at junit.framework.TestCase.runTest(TestCase.java:154)
| at junit.framework.TestCase.runBare(TestCase.java:127)
| at junit.framework.TestResult$1.protect(TestResult.java:106)
| at junit.framework.TestResult.runProtected(TestResult.java:124)
| at junit.framework.TestResult.run(TestResult.java:109)
| at junit.framework.TestCase.run(TestCase.java:118)
| at junit.textui.TestRunner.doRun(TestRunner.java:116)
| at com.intellij.rt.execution.junit.IdeaTestRunner.doRun(IdeaTestRunner.java:69)
| at junit.textui.TestRunner.doRun(TestRunner.java:109)
| at com.intellij.rt.execution.junit.IdeaTestRunner.startRunnerWithArgs(IdeaTestRunner.java:24)
| at com.intellij.rt.execution.junit.JUnitStarter.prepareStreamsAndStart(JUnitStarter.java:118)
| 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 java.lang.reflect.Method.invoke(Method.java:585)
| at com.intellij.rt.execution.application.AppMain.main(AppMain.java:90)
| 12:19:32,723 INFO [TxInterceptor] There was a problem handling this request
|
The cache configuration::
| <mbean code="org.jboss.cache.TreeCache"
| name="jboss.cache:service=TreeCache">
|
| <depends>jboss:service=Naming</depends>
| <depends>jboss:service=TransactionManager</depends>
|
| <attribute name="TransactionManagerLookupClass">org.jboss.cache.DummyTransactionManagerLookup</attribute>
| <attribute name="IsolationLevel">READ_COMMITTED</attribute>
|
| <attribute name="CacheMode">LOCAL</attribute>
| <attribute name="CacheLoaderConfiguration">
| <config>
| <passivation>false</passivation>
| <preload>/</preload>
| <shared>true</shared>
|
| <cacheloader>
| <class>org.jboss.cache.loader.JDBCCacheLoader</class>
| <properties>
| cache.jdbc.table.name=jbosscache_test
| cache.jdbc.table.create=true
| cache.jdbc.table.drop=true
| cache.jdbc.table.primarykey=jbosscache_test_pk
| cache.jdbc.fqn.column=fqn
| cache.jdbc.fqn.type=varchar(255)
| cache.jdbc.node.column=node
| cache.jdbc.node.type=blob
| cache.jdbc.parent.column=parent
| cache.jdbc.driver=oracle.jdbc.driver.OracleDriver
| cache.jdbc.url=jdbc:oracle:thin:@dbms01:1521:besapp
| cache.jdbc.user=GILEADHBVMC02_NEW2
| cache.jdbc.password=GILEADHBVMC02_NEW2
| </properties>
|
| <!-- whether the cache loader writes are asynchronous -->
| <async>false</async>
| <!-- only one cache loader in the chain may set fetchPersistentState to true.-->
| <!--An exception is thrown if more than one cache loader sets this to true. -->
| <fetchPersistentState>false</fetchPersistentState>
| <!-- determines whether this cache loader ignores writes - defaults to false. -->
| <ignoreModifications>false</ignoreModifications>
| <!-- if set to true, purges the contents of this cache loader when the cache starts up.-->
| <!--Defaults to false. -->
| <purgeOnStartup>false</purgeOnStartup>
| </cacheloader>
| </config>
| </attribute>
| </mbean>
|
View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4008209#4008209
Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4008209
More information about the jboss-user
mailing list