2 Replies Latest reply on Jul 9, 2009 10:59 AM by vl_sadovnikov

    starting JDBCCacheLoader and transactions

    vl_sadovnikov

      Hello,

      I've got a problem with JDBCCacheLoader and run out of ideas. Therefore any help will be appreciated.

      We are using JBoss Cache 3.0.0 and our application is EJB module, being deployed to WebSphere 6.1. Oracle is used as database, and data source is managed by the application server

      At initialization (processing of first request) we are getting exception from Oracle:

      Caused by: org.jboss.cache.CacheException: Unable to start cache loaders
       at org.jboss.cache.loader.CacheLoaderManager.startCacheLoader(CacheLoaderManager.java:467)
       ... 112 more
      Caused by: java.sql.SQLException: ORA-02089: COMMIT is not allowed in a subordinate session
      
       at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
       at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
       at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
       at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:743)
       at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:216)
       at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:955)
       at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1168)
       at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3285)
       at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3390)
       at com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement.pmiExecute(WSJdbcPreparedStatement.java:735)
       at com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement.execute(WSJdbcPreparedStatement.java:503)
       at org.jboss.cache.loader.AdjListJDBCCacheLoader.createDummyTableIfNeeded(AdjListJDBCCacheLoader.java:296)
       at org.jboss.cache.loader.AdjListJDBCCacheLoader.start(AdjListJDBCCacheLoader.java:269)
       at org.jboss.cache.loader.JDBCCacheLoader.start(JDBCCacheLoader.java:376)
       at org.jboss.cache.loader.CacheLoaderManager.startCacheLoader(CacheLoaderManager.java:461)
       ... 112 more
      


      The exception seems to be valid - transaction should not be committed here. However why does the loader try to createDummyTableIfNeeded ?

      Its configuration seems to prevent from creation of the tables (these tables are actually already in the database after running the same code outside application server)

       <loaders passivation="false" shared="true">
       <preload>
       <node fqn="/" />
       </preload>
       <loader class="org.jboss.cache.loader.JDBCCacheLoader" async="false"
       fetchPersistentState="false" ignoreModifications="false"
       purgeOnStartup="false">
       <properties>
       cache.jdbc.datasource=jdbc/DataLoad
       cache.jdbc.table.name=Cached_Events
       cache.jdbc.table.create=false
       cache.jdbc.table.drop=false
       cache.jdbc.table.primarykey=jbosscache_pk
       cache.jdbc.fqn.column=fqn
       cache.jdbc.fqn.type=varchar2(255)
       cache.jdbc.node.column=node
       cache.jdbc.node.type=blob
       cache.jdbc.parent.column=parent
       </properties>
       </loader>
       </loaders>
      


      Just in case, I'm posting below the last DEBUG message before exception trace (the last line is from our code):

      [2009-07-03 11:10:42,151] [efault : 3] DEBUG FileLookup - Unable to find configuration file D:\work\nextgen\workspace\build\storages\buildtest\config\jboss-cache.xml in classpath; searching for this file on the filesystem instead.
      [2009-07-03 11:10:42,323] [efault : 3] DEBUG ComponentRegistry - Looking in configuration for an instance of class org.jboss.cache.invocation.InvocationContextContainer that may have been injected from an external source.
      [2009-07-03 11:10:42,339] [efault : 3] DEBUG ComponentRegistry - Looking in configuration for an instance of interface org.jboss.cache.factories.context.ContextFactory that may have been injected from an external source.
      [2009-07-03 11:10:42,339] [efault : 3] DEBUG ComponentRegistry - Looking in configuration for an instance of class org.jboss.cache.interceptors.InterceptorChain that may have been injected from an external source.
      [2009-07-03 11:10:42,370] [efault : 3] DEBUG ComponentRegistry - Looking in configuration for an instance of class org.jboss.cache.transaction.TransactionTable that may have been injected from an external source.
      [2009-07-03 11:10:42,386] [efault : 3] DEBUG ComponentRegistry - Looking in configuration for an instance of interface javax.transaction.TransactionManager that may have been injected from an external source.
      [2009-07-03 11:10:42,386] [efault : 3] DEBUG GenericTransactionManagerLookup - Trying to lookup TransactionManager for JBoss, JRun4
      [2009-07-03 11:10:42,386] [efault : 3] DEBUG GenericTransactionManagerLookup - Failed to perform a lookup for [java:/TransactionManager (JBoss, JRun4)]
      [2009-07-03 11:10:42,386] [efault : 3] DEBUG GenericTransactionManagerLookup - Trying to lookup TransactionManager for Resin 3.x
      [2009-07-03 11:10:42,386] [efault : 3] DEBUG GenericTransactionManagerLookup - Failed to perform a lookup for [java:comp/TransactionManager (Resin 3.x)]
      [2009-07-03 11:10:42,386] [efault : 3] DEBUG GenericTransactionManagerLookup - Trying to lookup TransactionManager for Sun Glassfish
      [2009-07-03 11:10:42,386] [efault : 3] DEBUG GenericTransactionManagerLookup - Failed to perform a lookup for [java:appserver/TransactionManager (Sun Glassfish)]
      [2009-07-03 11:10:42,386] [efault : 3] DEBUG GenericTransactionManagerLookup - Trying to lookup TransactionManager for Borland, Sun
      [2009-07-03 11:10:42,386] [efault : 3] DEBUG GenericTransactionManagerLookup - Failed to perform a lookup for [java:pm/TransactionManager (Borland, Sun)]
      [2009-07-03 11:10:42,386] [efault : 3] DEBUG GenericTransactionManagerLookup - Trying to lookup TransactionManager for BEA WebLogic
      [2009-07-03 11:10:42,667] [efault : 3] DEBUG GenericTransactionManagerLookup - Failed to perform a lookup for [javax.transaction.TransactionManager (BEA WebLogic)]
      [2009-07-03 11:10:42,667] [efault : 3] DEBUG GenericTransactionManagerLookup - Trying to lookup TransactionManager for Resin, Orion, JOnAS (JOTM)
      [2009-07-03 11:10:42,667] [efault : 3] DEBUG GenericTransactionManagerLookup - Failed to perform a lookup for [java:comp/UserTransaction (Resin, Orion, JOnAS (JOTM))]
      [2009-07-03 11:10:42,667] [efault : 3] DEBUG GenericTransactionManagerLookup - Trying WebSphere 5.1: com.ibm.ws.Transaction.TransactionManagerFactory
      [2009-07-03 11:10:42,682] [efault : 3] DEBUG GenericTransactionManagerLookup - Found WebSphere 5.1: com.ibm.ws.Transaction.TransactionManagerFactory
      [2009-07-03 11:10:42,682] [efault : 3] DEBUG ComponentRegistry - Looking in configuration for an instance of interface org.jboss.cache.RPCManager that may have been injected from an external source.
      [2009-07-03 11:10:42,714] [efault : 3] DEBUG ComponentRegistry - Looking in configuration for an instance of class org.jboss.cache.remoting.jgroups.ChannelMessageListener that may have been injected from an external source.
      [2009-07-03 11:10:42,714] [efault : 3] DEBUG ComponentRegistry - Looking in configuration for an instance of interface org.jboss.cache.statetransfer.StateTransferManager that may have been injected from an external source.
      [2009-07-03 11:10:42,729] [efault : 3] DEBUG ComponentRegistry - Looking in configuration for an instance of interface org.jboss.cache.marshall.Marshaller that may have been injected from an external source.
      [2009-07-03 11:10:42,745] [efault : 3] DEBUG ComponentRegistry - Looking in configuration for an instance of interface org.jboss.cache.RegionManager that may have been injected from an external source.
      [2009-07-03 11:10:42,745] [efault : 3] DEBUG ComponentRegistry - Looking in configuration for an instance of interface org.jboss.cache.lock.LockManager that may have been injected from an external source.
      [2009-07-03 11:10:42,761] [efault : 3] DEBUG ComponentRegistry - Looking in configuration for an instance of interface org.jboss.cache.DataContainer that may have been injected from an external source.
      [2009-07-03 11:10:42,761] [efault : 3] DEBUG ComponentRegistry - Looking in configuration for an instance of interface org.jboss.cache.NodeFactory that may have been injected from an external source.
      [2009-07-03 11:10:42,776] [efault : 3] DEBUG ComponentRegistry - Looking in configuration for an instance of class org.jboss.cache.interceptors.InterceptorChain that may have been injected from an external source.
      [2009-07-03 11:10:42,792] [efault : 3] DEBUG ComponentRegistry - Looking in configuration for an instance of interface org.jboss.cache.notifications.Notifier that may have been injected from an external source.
      [2009-07-03 11:10:42,839] [efault : 3] DEBUG ComponentRegistry - Looking in configuration for an instance of interface org.jboss.cache.commands.CommandsFactory that may have been injected from an external source.
      [2009-07-03 11:10:42,839] [efault : 3] DEBUG ComponentRegistry - Looking in configuration for an instance of class org.jboss.cache.buddyreplication.BuddyManager that may have been injected from an external source.
      [2009-07-03 11:10:42,839] [efault : 3] DEBUG ComponentRegistry - Looking in configuration for an instance of class org.jboss.cache.buddyreplication.BuddyFqnTransformer that may have been injected from an external source.
      [2009-07-03 11:10:42,854] [efault : 3] DEBUG ComponentRegistry - Looking in configuration for an instance of class org.jboss.cache.loader.CacheLoaderManager that may have been injected from an external source.
      [2009-07-03 11:10:42,886] [efault : 3] DEBUG ComponentRegistry - Looking in configuration for an instance of class org.jboss.cache.mvcc.MVCCNodeHelper that may have been injected from an external source.
      [2009-07-03 11:10:42,901] [efault : 3] DEBUG ComponentRegistry - Looking in configuration for an instance of class org.jboss.cache.config.CacheLoaderConfig that may have been injected from an external source.
      [2009-07-03 11:10:42,901] [efault : 3] DEBUG ComponentRegistry - Looking in configuration for an instance of class org.jboss.cache.RegionRegistry that may have been injected from an external source.
      [2009-07-03 11:10:42,901] [efault : 3] DEBUG ComponentRegistry - Looking in configuration for an instance of interface org.jboss.cache.statetransfer.StateTransferIntegrator that may have been injected from an external source.
      [2009-07-03 11:10:42,901] [efault : 3] DEBUG ComponentRegistry - Looking in configuration for an instance of interface org.jboss.cache.statetransfer.StateTransferGenerator that may have been injected from an external source.
      [2009-07-03 11:10:42,917] [efault : 3] DEBUG ComponentRegistry - Looking in configuration for an instance of class org.jboss.cache.buddyreplication.BuddyManager that may have been injected from an external source.
      [2009-07-03 11:10:42,917] [efault : 3] DEBUG ComponentRegistry - Looking in configuration for an instance of class org.jboss.cache.batch.BatchContainer that may have been injected from an external source.
      [2009-07-03 11:10:42,917] [efault : 3] DEBUG CacheStatus - start() called while current state is INSTANTIATED -- call create() first
      [2009-07-03 11:10:42,917] [efault : 3] DEBUG ComponentRegistry - Looking in configuration for an instance of interface org.jboss.cache.NodeFactory that may have been injected from an external source.
      [2009-07-03 11:10:42,917] [efault : 3] DEBUG ComponentRegistry - Looking in configuration for an instance of class org.jboss.cache.interceptors.InterceptorChain that may have been injected from an external source.
      [2009-07-03 11:10:42,917] [efault : 3] DEBUG ComponentRegistry - Looking in configuration for an instance of interface javax.transaction.TransactionManager that may have been injected from an external source.
      [2009-07-03 11:10:42,917] [efault : 3] DEBUG ComponentRegistry - Looking in configuration for an instance of interface org.jboss.cache.RPCManager that may have been injected from an external source.
      [2009-07-03 11:10:42,917] [efault : 3] DEBUG ComponentRegistry - Looking in configuration for an instance of interface org.jboss.cache.marshall.Marshaller that may have been injected from an external source.
      [2009-07-03 11:10:42,917] [efault : 3] DEBUG ComponentRegistry - Looking in configuration for an instance of interface org.jboss.cache.RegionManager that may have been injected from an external source.
      [2009-07-03 11:10:42,917] [efault : 3] DEBUG ComponentRegistry - Looking in configuration for an instance of interface org.jboss.cache.lock.LockManager that may have been injected from an external source.
      [2009-07-03 11:10:42,917] [efault : 3] DEBUG ComponentRegistry - Looking in configuration for an instance of class org.jboss.cache.buddyreplication.BuddyFqnTransformer that may have been injected from an external source.
      [2009-07-03 11:10:42,917] [efault : 3] DEBUG ComponentRegistry - Looking in configuration for an instance of class org.jboss.cache.interceptors.InterceptorChain that may have been injected from an external source.
      [2009-07-03 11:10:42,917] [efault : 3] DEBUG ComponentRegistry - Looking in configuration for an instance of interface org.jboss.cache.factories.context.ContextFactory that may have been injected from an external source.
      [2009-07-03 11:10:42,917] [efault : 3] DEBUG ComponentRegistry - Looking in configuration for an instance of interface org.jboss.cache.commands.CommandsFactory that may have been injected from an external source.
      [2009-07-03 11:10:42,917] [efault : 3] DEBUG ComponentRegistry - Looking in configuration for an instance of class org.jboss.cache.buddyreplication.BuddyManager that may have been injected from an external source.
      [2009-07-03 11:10:42,917] [efault : 3] DEBUG ComponentRegistry - Looking in configuration for an instance of class org.jboss.cache.loader.CacheLoaderManager that may have been injected from an external source.
      [2009-07-03 11:10:42,917] [efault : 3] DEBUG ComponentRegistry - Looking in configuration for an instance of class org.jboss.cache.config.CacheLoaderConfig that may have been injected from an external source.
      [2009-07-03 11:10:42,932] [efault : 3] DEBUG DataContainerImpl - Setting rootInternal to NodeReference{delegate=UnversionedNode[ /]}
      [2009-07-03 11:10:42,932] [efault : 3] DEBUG ComponentRegistry - Looking in configuration for an instance of interface org.jboss.cache.statetransfer.StateTransferManager that may have been injected from an external source.
      [2009-07-03 11:10:42,948] [efault : 3] DEBUG ComponentRegistry - Looking in configuration for an instance of interface org.jboss.cache.statetransfer.StateTransferIntegrator that may have been injected from an external source.
      [2009-07-03 11:10:42,948] [efault : 3] DEBUG ComponentRegistry - Looking in configuration for an instance of interface org.jboss.cache.statetransfer.StateTransferGenerator that may have been injected from an external source.
      [2009-07-03 11:10:42,948] [efault : 3] DEBUG ComponentRegistry - Looking in configuration for an instance of class org.jboss.cache.buddyreplication.BuddyManager that may have been injected from an external source.
      [2009-07-03 11:10:42,948] [efault : 3] DEBUG ComponentRegistry - Looking in configuration for an instance of class org.jboss.cache.batch.BatchContainer that may have been injected from an external source.
      [2009-07-03 11:10:42,964] [efault : 3] DEBUG InterceptorChain - Interceptor chain is: InterceptorChain{
       >> org.jboss.cache.interceptors.CallInterceptor
       >> org.jboss.cache.interceptors.EvictionInterceptor
       >> org.jboss.cache.interceptors.CacheStoreInterceptor
       >> org.jboss.cache.interceptors.MVCCLockingInterceptor
       >> org.jboss.cache.interceptors.CacheLoaderInterceptor
       >> org.jboss.cache.interceptors.NotificationInterceptor
       >> org.jboss.cache.interceptors.TxInterceptor
       >> org.jboss.cache.interceptors.InvocationContextInterceptor
      }
      [2009-07-03 11:10:42,979] [efault : 3] DEBUG VersionAwareMarshaller - Started with version 3.0.0 and versionInt 30
      [2009-07-03 11:10:42,979] [efault : 3] DEBUG VersionAwareMarshaller - Using default marshaller class class org.jboss.cache.marshall.CacheMarshaller300
      [2009-07-03 11:10:43,104] [efault : 3] ERROR ErrorHandler - Error in invocation of public void com.fiserv.nextgen.detectionpipeline.DetectionPipelineBean.processEvent(com.fiserv.domain.eventmodel.api.IAcceptedEvent) with parameters [11400 {AtmFailedAuthentication,0,0,73}]
      


      Any suggestions?

        • 1. Re: starting JDBCCacheLoader and transactions
          mircea.markus
          • 2. Re: starting JDBCCacheLoader and transactions
            vl_sadovnikov

            The reported issue with COMMIT was due to a problem in our code: we've been creating multiple instances of PojoCacheFactory.createCache(config, true), giving the same configuration. Now only one PojoCacheFactory is created.

            However, when server commits its processing transaction, TxInterceptor logs an exception, but does not roll-back the transaction.

            Would you think something is wrong on our side?

            [2009-07-09 16:42:51,959] [Default : 18] ERROR JDBCCacheLoader - Failed to insert node :ORA-01461: can bind a LONG value only for insert into a LONG column
            
            [2009-07-09 16:42:51,959] [Default : 18] WARN TxInterceptor - Caught exception, will now set transaction to roll back
            java.lang.IllegalStateException: Failed to insert node: ORA-01461: can bind a LONG value only for insert into a LONG column
            
             at org.jboss.cache.loader.AdjListJDBCCacheLoader.insertNode(AdjListJDBCCacheLoader.java:514)
             at org.jboss.cache.loader.JDBCCacheLoader.addNewSubtree(JDBCCacheLoader.java:345)
             at org.jboss.cache.loader.JDBCCacheLoader.put(JDBCCacheLoader.java:147)
             at org.jboss.cache.loader.AbstractCacheLoader.put(AbstractCacheLoader.java:294)
             at org.jboss.cache.loader.AdjListJDBCCacheLoader.prepare(AdjListJDBCCacheLoader.java:211)
             at org.jboss.cache.interceptors.CacheStoreInterceptor.prepareCacheLoader(CacheStoreInterceptor.java:386)
             at org.jboss.cache.interceptors.CacheStoreInterceptor.handlePrepareCommand(CacheStoreInterceptor.java:214)
             at org.jboss.cache.interceptors.base.SkipCheckChainedInterceptor.visitPrepareCommand(SkipCheckChainedInterceptor.java:310)
             at org.jboss.cache.commands.tx.PrepareCommand.acceptVisitor(PrepareCommand.java:68)
             at org.jboss.cache.interceptors.base.CommandInterceptor.invokeNextInterceptor(CommandInterceptor.java:116)
             at org.jboss.cache.interceptors.MVCCLockingInterceptor.handlePrepareCommand(MVCCLockingInterceptor.java:320)
             at org.jboss.cache.interceptors.base.PrePostProcessingCommandInterceptor.visitPrepareCommand(PrePostProcessingCommandInterceptor.java:383)
             at org.jboss.cache.commands.tx.PrepareCommand.acceptVisitor(PrepareCommand.java:68)
             at org.jboss.cache.interceptors.base.CommandInterceptor.invokeNextInterceptor(CommandInterceptor.java:116)
             at org.jboss.cache.interceptors.base.CommandInterceptor.handleDefault(CommandInterceptor.java:131)
             at org.jboss.cache.commands.AbstractVisitor.visitPrepareCommand(AbstractVisitor.java:140)
             at org.jboss.cache.commands.tx.PrepareCommand.acceptVisitor(PrepareCommand.java:68)
             at org.jboss.cache.interceptors.base.CommandInterceptor.invokeNextInterceptor(CommandInterceptor.java:116)
             at org.jboss.cache.interceptors.NotificationInterceptor.visitPrepareCommand(NotificationInterceptor.java:50)
             at org.jboss.cache.commands.tx.PrepareCommand.acceptVisitor(PrepareCommand.java:68)
             at org.jboss.cache.interceptors.base.CommandInterceptor.invokeNextInterceptor(CommandInterceptor.java:116)
             at org.jboss.cache.interceptors.TxInterceptor.runPreparePhase(TxInterceptor.java:638)
             at org.jboss.cache.interceptors.TxInterceptor$LocalSynchronizationHandler.beforeCompletion(TxInterceptor.java:1041)
             at org.jboss.cache.interceptors.OrderedSynchronizationHandler.beforeCompletion(OrderedSynchronizationHandler.java:81)
             at com.ibm.ws.Transaction.JTA.RegisteredSyncs.distributeBefore(RegisteredSyncs.java:242)
             at com.ibm.ws.Transaction.JTA.TransactionImpl.prePrepare(TransactionImpl.java:2399)
             at com.ibm.ws.Transaction.JTA.TransactionImpl.stage1CommitProcessing(TransactionImpl.java:1632)
             at com.ibm.ws.Transaction.JTA.TransactionImpl.processCommit(TransactionImpl.java:1603)
             at com.ibm.ws.Transaction.JTA.TransactionImpl.commit(TransactionImpl.java:1538)
             at com.ibm.ws.Transaction.JTA.TranManagerImpl.commit(TranManagerImpl.java:239)
             at com.ibm.ws.Transaction.JTA.TranManagerSet.commit(TranManagerSet.java:163)
             at com.ibm.ejs.csi.TranStrategy.commit(TranStrategy.java:782)
             at com.ibm.ejs.csi.TranStrategy.postInvoke(TranStrategy.java:206)
             at com.ibm.ejs.csi.RequiresNew.postInvoke(RequiresNew.java:93)
             at com.ibm.ejs.csi.TransactionControlImpl.postInvoke(TransactionControlImpl.java:581)
             at com.ibm.ejs.container.EJSContainer.postInvoke(EJSContainer.java:4210)
             at com.fiserv.util.jee.beans.EJSLocal0SLDetectionPipelineBean_c78bfd96.processEvent(EJSLocal0SLDetectionPipelineBean_c78bfd96.java)
             at com.fiserv.nextgen.detectionpipeline.DetectionProcessingMDB.onMessage(DetectionProcessingMDB.java:72)
             at sun.reflect.GeneratedMethodAccessor165.invoke(Unknown Source)
             at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
             at java.lang.reflect.Method.invoke(Method.java:618)
             at com.ibm.ejs.container.interceptors.InvocationContextImpl.proceed(InvocationContextImpl.java:547)
             at com.fiserv.util.jee.interceptors.ErrorHandlerMDB.checkError(ErrorHandlerMDB.java:45)
             at sun.reflect.GeneratedMethodAccessor147.invoke(Unknown Source)
             at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
             at java.lang.reflect.Method.invoke(Method.java:618)
             at com.ibm.ejs.container.interceptors.InterceptorProxy.invokeInterceptor(InterceptorProxy.java:227)
             at com.ibm.ejs.container.interceptors.InvocationContextImpl.proceed(InvocationContextImpl.java:526)
             at com.ibm.ejs.container.interceptors.InvocationContextImpl.doAroundInvoke(InvocationContextImpl.java:184)
             at com.ibm.ejs.container.MessageEndpointHandler.invokeMdbMethod(MessageEndpointHandler.java:1073)
             at com.ibm.ejs.container.MessageEndpointHandler.invoke(MessageEndpointHandler.java:773)
             at $Proxy44.onMessage(Unknown Source)
             at com.ibm.ws.sib.api.jmsra.impl.JmsJcaEndpointInvokerImpl.invokeEndpoint(JmsJcaEndpointInvokerImpl.java:201)
             at com.ibm.ws.sib.ra.inbound.impl.SibRaDispatcher.dispatch(SibRaDispatcher.java:768)
             at com.ibm.ws.sib.ra.inbound.impl.SibRaSingleProcessListener$SibRaWork.run(SibRaSingleProcessListener.java:584)
             at com.ibm.ejs.j2c.work.WorkProxy.run(WorkProxy.java:419)
             at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1469)
            Caused by: java.sql.SQLException: ORA-01461: can bind a LONG value only for insert into a LONG column
            
             at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
             at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
             at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
             at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:743)
             at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:216)
             at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:955)
             at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1168)
             at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3285)
             at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3368)
             at com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement.pmiExecuteUpdate(WSJdbcPreparedStatement.java:948)
             at com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement.executeUpdate(WSJdbcPreparedStatement.java:615)
             at org.jboss.cache.loader.AdjListJDBCCacheLoader.insertNode(AdjListJDBCCacheLoader.java:501)
             ... 56 more