kodo.util.UnsupportedOptionException: kodo.jdbc.SQL language queries cannot be executed in-memory. Either set the javax.jdo.option.IgnoreCache property to true, set the kodo.FlushBeforeQueries property to true, or execute the query before modifying objects within the transaction.

There are no available Samebug tips for this exception. Do you have an idea how to solve this issue? A short tip would help users who saw this issue last week.

  • using SQL in Query in 3.0.0
    via by 3004,
    • kodo.util.UnsupportedOptionException: kodo.jdbc.SQL language queries cannot be executed in-memory. Either set the javax.jdo.option.IgnoreCache property to true, set the kodo.FlushBeforeQueries property to true, or execute the query before modifying objects within the transaction. at kodo.jdbc.query.SQLQuery.newInMemoryQueryExecutor(SQLQuery.java:117) at kodo.query.AbstractQuery.internalCompile(AbstractQuery.java:545) at kodo.query.AbstractQuery.getAccessPathMetaDatas(AbstractQuery.java:938) at kodo.query.AbstractQuery.isAccessPathDirty(AbstractQuery.java:745) at kodo.query.AbstractQuery.executeWithMap(AbstractQuery.java:672) at kodo.query.AbstractQuery.executeWithArray(AbstractQuery.java:640) at au.com.aig.aiaa.billing.process.ejb.BillingProcessSubBean.findDirectEntryItems(BillingProcessSubBean.java:139) at au.com.aig.aiaa.billing.process.ejb.BillingProcessSubBean.findBillingDetails(BillingProcessSubBean.java:41) at au.com.aig.aiaa.billing.process.ejb.EJSLocalStatelessBillingProcessSub_81348520.findBillingDetails(EJSLocalStatelessBillingProcessSub_81348520.java:43) at au.com.aig.aiaa.billing.process.ejb.BillingProcessBean.processDirectEntrys(BillingProcessBean.java:42) at au.com.aig.aiaa.billing.process.ejb.EJSRemoteStatelessBillingProcess_b720060c.processDirectEntrys(EJSRemoteStatelessBillingProcess_b720060c.java:83) at au.com.aig.aiaa.billing.process.ejb._EJSRemoteStatelessBillingProcess_b720060c_Tie.processDirectEntrys(_EJSRemoteStatelessBillingProcess_b720060c_Tie.java:181) at au.com.aig.aiaa.billing.process.ejb._EJSRemoteStatelessBillingProcess_b720060c_Tie._invoke(_EJSRemoteStatelessBillingProcess_b720060c_Tie.java:100) at com.ibm.CORBA.iiop.ServerDelegate.dispatchInvokeHandler(ServerDelegate.java:582) at com.ibm.CORBA.iiop.ServerDelegate.dispatch(ServerDelegate.java:437) at com.ibm.rmi.iiop.ORB.process(ORB.java:320) at com.ibm.CORBA.iiop.ORB.process(ORB.java:1544) at com.ibm.rmi.iiop.Connection.doWork(Connection.java:2063) at com.ibm.rmi.iiop.WorkUnitImpl.doWork(WorkUnitImpl.java:63) at com.ibm.ejs.oa.pool.PooledThread.run(ThreadPool.java:95) at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:592)
    No Bugmate found.