Hi, I followed the instructions. I attached my database schema. I didn't find database schema for SQL Server. I changed a little bit mySql database schema to fit SqlServer schema specification.
Thanks, Rafal On Thu, May 26, 2011 at 6:15 PM, Tammo van Lessen <[email protected]> wrote: > Hi, > > what database schema did you use? Did you follow the instructions at > http://ode.apache.org/ode-schema.html ? > > Thanks, > Tammo > > On Thu, May 5, 2011 at 09:44, Rafal <[email protected]> wrote: >> I set up ode 1.3.5 under hibernate with SQL Server 2008. >> >> My ode-axis2.properties: >> ode-axis2.dao.factory=org.apache.ode.daohib.bpel.BpelDAOConnectionFactoryImpl >> ode-axis2.db.mode=INTERNAL >> ode-axis2.db.int.mcf=org.tranql.connector.sqlserver.XAMCF >> ode-axis2.db.int.mcf.databaseName=ODE >> ode-axis2.db.int.mcf.userName=test >> ode-axis2.db.int.mcf.password=***** >> ode-axis2.db.int.mcf.portNumber=1444 >> ode-axis2.db.int.mcf.serverName=10.0.101.44 >> >> Everything works fine, but always when I undeploy (e.g. copy and >> delete HelloWorld2) any process I get errors bellow. It works fine >> with default derby database. Any ideas? >> >> 09:07:41,908 ERROR [BpelEngineImpl] Scheduled job failed; >> jobDetail=JobDetails( instanceId: null mexId: null processId: null >> type: null channel: null correlatorId: null correlationKeySet: null >> retryCount: null inMem: null detailsExt: >> {runnable=org.apache.ode.bpel.engine.ProcessCleanUpRunnable@b2bde5, >> pid=1}) >> java.lang.IllegalArgumentException: id to load is required for loading >> at org.hibernate.event.LoadEvent.<init>(LoadEvent.java:51) >> at org.hibernate.event.LoadEvent.<init>(LoadEvent.java:33) >> at org.hibernate.impl.SessionImpl.get(SessionImpl.java:812) >> at org.hibernate.impl.SessionImpl.get(SessionImpl.java:808) >> at >> org.apache.ode.daohib.bpel.BpelDAOConnectionImpl._getInstance(BpelDAOConnectionImpl.java:201) >> at >> org.apache.ode.daohib.bpel.BpelDAOConnectionImpl.getInstance(BpelDAOConnectionImpl.java:145) >> at >> org.apache.ode.bpel.engine.BpelEngineImpl.onScheduledJob(BpelEngineImpl.java:416) >> at >> org.apache.ode.bpel.engine.BpelServerImpl.onScheduledJob(BpelServerImpl.java:450) >> at >> org.apache.ode.scheduler.simple.SimpleScheduler$RunJob$1.call(SimpleScheduler.java:518) >> at >> org.apache.ode.scheduler.simple.SimpleScheduler$RunJob$1.call(SimpleScheduler.java:513) >> at >> org.apache.ode.scheduler.simple.SimpleScheduler.execTransaction(SimpleScheduler.java:284) >> at >> org.apache.ode.scheduler.simple.SimpleScheduler.execTransaction(SimpleScheduler.java:239) >> at >> org.apache.ode.scheduler.simple.SimpleScheduler$RunJob.call(SimpleScheduler.java:512) >> at >> org.apache.ode.scheduler.simple.SimpleScheduler$RunJob.call(SimpleScheduler.java:496) >> at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source) >> at java.util.concurrent.FutureTask.run(Unknown Source) >> at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown >> Source) >> at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) >> at java.lang.Thread.run(Unknown Source) >> 09:07:41,910 ERROR [SimpleScheduler] Error while processing a >> persisted job: Job hqejbhcnphr6945qcvl95v time: 2011-05-05 09:07:38 >> CEST transacted: true persisted: true details: JobDetails( instanceId: >> null mexId: null processId: null type: null channel: null >> correlatorId: null correlationKeySet: null retryCount: null inMem: >> null detailsExt: >> {runnable=org.apache.ode.bpel.engine.ProcessCleanUpRunnable@b2bde5, >> pid=1}) >> org.apache.ode.bpel.iapi.Scheduler$JobProcessorException: >> java.lang.IllegalArgumentException: id to load is required for loading >> at >> org.apache.ode.bpel.engine.BpelEngineImpl.onScheduledJob(BpelEngineImpl.java:478) >> at >> org.apache.ode.bpel.engine.BpelServerImpl.onScheduledJob(BpelServerImpl.java:450) >> at >> org.apache.ode.scheduler.simple.SimpleScheduler$RunJob$1.call(SimpleScheduler.java:518) >> at >> org.apache.ode.scheduler.simple.SimpleScheduler$RunJob$1.call(SimpleScheduler.java:513) >> at >> org.apache.ode.scheduler.simple.SimpleScheduler.execTransaction(SimpleScheduler.java:284) >> at >> org.apache.ode.scheduler.simple.SimpleScheduler.execTransaction(SimpleScheduler.java:239) >> at >> org.apache.ode.scheduler.simple.SimpleScheduler$RunJob.call(SimpleScheduler.java:512) >> at >> org.apache.ode.scheduler.simple.SimpleScheduler$RunJob.call(SimpleScheduler.java:496) >> at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source) >> at java.util.concurrent.FutureTask.run(Unknown Source) >> at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown >> Source) >> at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) >> at java.lang.Thread.run(Unknown Source) >> Caused by: java.lang.IllegalArgumentException: id to load is required >> for loading >> at org.hibernate.event.LoadEvent.<init>(LoadEvent.java:51) >> at org.hibernate.event.LoadEvent.<init>(LoadEvent.java:33) >> at org.hibernate.impl.SessionImpl.get(SessionImpl.java:812) >> at org.hibernate.impl.SessionImpl.get(SessionImpl.java:808) >> at >> org.apache.ode.daohib.bpel.BpelDAOConnectionImpl._getInstance(BpelDAOConnectionImpl.java:201) >> at >> org.apache.ode.daohib.bpel.BpelDAOConnectionImpl.getInstance(BpelDAOConnectionImpl.java:145) >> at >> org.apache.ode.bpel.engine.BpelEngineImpl.onScheduledJob(BpelEngineImpl.java:416) >> ... 12 more >> 09:07:41,944 ERROR [SimpleScheduler] Error while processing job, retrying in >> 5s >> 09:07:51,507 ERROR [SimpleScheduler] Error loading immediate jobs from >> database. >> java.lang.ClassCastException: java.lang.Long cannot be cast to >> java.lang.String >> at >> org.apache.ode.scheduler.simple.JdbcDelegate.dequeueImmediate(JdbcDelegate.java:321) >> at >> org.apache.ode.scheduler.simple.SimpleScheduler$6.call(SimpleScheduler.java:699) >> at >> org.apache.ode.scheduler.simple.SimpleScheduler$6.call(SimpleScheduler.java:698) >> at >> org.apache.ode.scheduler.simple.SimpleScheduler.execTransaction(SimpleScheduler.java:284) >> at >> org.apache.ode.scheduler.simple.SimpleScheduler.execTransaction(SimpleScheduler.java:239) >> at >> org.apache.ode.scheduler.simple.SimpleScheduler.doLoadImmediate(SimpleScheduler.java:697) >> at >> org.apache.ode.scheduler.simple.SimpleScheduler$LoadImmediateTask.run(SimpleScheduler.java:842) >> at >> org.apache.ode.scheduler.simple.SimpleScheduler$5.call(SimpleScheduler.java:658) >> at >> org.apache.ode.scheduler.simple.SimpleScheduler$5.call(SimpleScheduler.java:656) >> at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source) >> at java.util.concurrent.FutureTask.run(Unknown Source) >> at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown >> Source) >> at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) >> at java.lang.Thread.run(Unknown Source) >> > > > > -- > Tammo van Lessen - http://www.taval.de >
