You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@ode.apache.org by Rafal <ra...@gmail.com> on 2011/05/05 09:44:37 UTC
problem with ode under hibernate
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)
Re: problem with ode under hibernate
Posted by Rafal <ra...@gmail.com>.
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 <tv...@gmail.com> 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 <ra...@gmail.com> 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
>
Re: problem with ode under hibernate
Posted by Tammo van Lessen <tv...@gmail.com>.
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 <ra...@gmail.com> 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