Any news on Drools 5.1
by Chuck Irvine
I am planning on diving into a Drools based workflow related project pretty
soon and have kind of been waiting for 5.1 to come out (or maybe the next
milestone release). Any news on 5.1 availability? Thanks -Chuck
15 years, 10 months
drools expert: memory issues
by Miguel Machado
hi all,
I'm quite new to the drools rule engine and i've been using it for a project where i need to filter events and execute actions accordingly.
I'm currently running a DRL file and creating a stateful session from it, and then running 2/3 facts every time. Every X seconds I collect the available facts and call fireAllRules() + dispose(), always within the same session. The DRL file has circa 2160 rules declared (an external program is producing them), and i'm using the "no-loop", "lock-on-active", "activation-group" and "agenda-group" options on almost every one.
My main problem is that the software is consuming too much memory when it loads the rules to the knowledge base variable, it reaches +300Mb which is just not affordable in this project. Is there any way i can work around this? I've tried setting some configuration properties but to no avail. What techniques may i try in order to reduce memory load on drools startup? What would be the best approach for dealing with so many rules?
Anything would help, thanks in advance,
_ miguel
15 years, 10 months
Extending the "validation of rules" functionality in Guvnor
by Premkumar Stephen
Hello everyone,
Currently, the validate functionality ensures that rules have proper
syntax.
it is possible to extend this functionality so that business use cases might
also be validated? Is there an API/examples to do that.
For eg, in our domain, an object X can be evaluated for 3 criteria ( a, b,
c )
However, we would need to prevent rules written which combine criteria b and
c
Rules can have the combinations ( a,b,c, ab, ac ). Combinations ( bc and abc
) should not be allowed.
Regards,
Prem
15 years, 11 months
How to do Exception Handling???
by nanic23
I have a ruleflow that handles exceptions when they are raised by a "Fault"
node but I am not being able to accomplish the same if an exception is
thrown by a workItem or an action node instead.
I have a workItem node with a work item handler that throws a
RuntimeException. My exception handler in the composite node is not catching
this exception.
So, question
1) how can I handle runtime exceptions thrown by my workItemHandlers?
2) how can I get a hold of the exception to log the stack trace?
Any ideas or tips are very appreciated.
Nick.
--
View this message in context: http://n3.nabble.com/How-to-do-Exception-Handling-tp689387p689387.html
Sent from the Drools - User mailing list archive at Nabble.com.
15 years, 11 months
Issue with drools-flow/persistence
by Daniel Ilkovich
I'm stumped. I'm trying to implement persistence with Drools-flow, and I'd
like to grab the value of a property on a workitem / processinstance, but
everytime I try to get the workitem or process instance I end up with the
stack trace below.
I'm walking through the source and from what I can tell, this happens
anytime I try and grab a property that is annotated with @Lob in an entity
class.
My environment is hibernate/mysql/JPA persistence using BTM as a transaction
manager.
These are the relevant lines of code:
ksession =
JPAKnowledgeService.loadStatefulKnowledgeSession(ksession.getId(), m_kbase ,
null, m_environment);
m_pi = ksession.getProcessInstance(m_pi.getId());
What am I doing wrong?
<pre>
<code>
java.lang.NullPointerException
at java.io.ByteArrayInputStream.<init>(ByteArrayInputStream.java:89)
at
org.drools.persistence.processinstance.ProcessInstanceInfo.getProcessInstance(ProcessInstanceInfo.java:135)
at
org.drools.persistence.processinstance.JPAProcessInstanceManager.getProcessInstance(JPAProcessInstanceManager.java:62)
at
org.drools.common.AbstractWorkingMemory.getProcessInstance(AbstractWorkingMemory.java:1793)
at
org.drools.impl.StatefulKnowledgeSessionImpl.getProcessInstance(StatefulKnowledgeSessionImpl.java:261)Hibernate:
select at
org.drools.command.runtime.process.GetProcessInstanceCommand.execute(GetProcessInstanceCommand.java:29)
at
org.drools.command.runtime.process.GetProcessInstanceCommand.execute(GetProcessInstanceCommand.java:12)
at
org.drools.persistence.session.SingleSessionCommandService.execute(SingleSessionCommandService.java:254)
at
org.drools.command.impl.CommandBasedStatefulKnowledgeSession.getProcessInstance(CommandBasedStatefulKnowledgeSession.java:95)
at
com.thoughtvine.tracks.workflow.TracksFlow.getParameterFromWorkItem(TracksFlow.java:182)
at
com.thoughtvine.tracks.workflow.test.TestTracksFlow.testGetWorkItem(TestTracksFlow.java:118)
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:597)
at
org.junit.runners.model.FrameworkMethod$1.runReflectiveCall(FrameworkMethod.java:44)
at
org.junit.internal.runners.model.ReflectiveCallable.run(ReflectiveCallable.java:15)
at
org.junit.runners.model.FrameworkMethod.invokeExplosively(FrameworkMethod.java:41)
at
org.junit.internal.runners.statements.InvokeMethod.evaluate(InvokeMethod.java:20)
at
org.junit.internal.runners.statements.RunBefores.evaluate(RunBefores.java:28)
at
org.junit.internal.runners.statements.RunAfters.evaluate(RunAfters.java:31)
at
org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:73)
at
org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:46)
at org.junit.runners.ParentRunner.runChildren(ParentRunner.java:180)
at org.junit.runners.ParentRunner.access$000(ParentRunner.java:41)
at org.junit.runners.ParentRunner$1.evaluate(ParentRunner.java:173)
at
org.junit.internal.runners.statements.RunBefores.evaluate(RunBefores.java:28)
at
org.junit.internal.runners.statements.RunAfters.evaluate(RunAfters.java:31)
at org.junit.runners.ParentRunner.run(ParentRunner.java:220)
at
org.eclipse.jdt.internal.junit4.runner.JUnit4TestReference.run(JUnit4TestReference.java:46)
at
org.eclipse.jdt.internal.junit.runner.TestExecution.run(TestExecution.java:38)
at
org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:467)
at
org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:683)
at
org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRunner.java:390)
at
org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRunner.java:197)
</code>
</pre>
15 years, 11 months
Resuming the Flow: SESSION_ID, PROCESS_INSTANCE_ID, WORKITEM_ID
by tolitius
Hi Flow Crew,
This is about reloading the session and resuming the flow.
Let's say the flow reached one of its wait states, and was persisted.
Two days later an "assigned actor" does his/her duties, and the flow can
be resumed.
At this point, we need to call something, let's call it a
WorkflowService, that would have a resumeFlow( someBusinessId ) method that
will be called.
Here is where the question starts...
I understand there are three pieces in this puzzle: SESSION_ID,
PROCESS_INSTANCE_ID and WORKITEM_ID
I also understand that in order to resume the flow, I need to get a hold
of that certain work item that is ready to be completed, and let the flow
know it is completed.
But at the point, where I should resume the flow, I have no reference to
neither SESSION_ID, PROCESS_INSTANCE_ID or WORKFLOW_ID.
1. How are these three related to each other?
2. How do I find these three associated IDs?
2. Which one(s) do I need to resume the flow?
3. If I (somehow) get the reference to SESSION and PROCESS_INSTANCE
ids, how do I know which work item is ready to be completed?
Thank you,
/Anatoly
--
View this message in context: http://n3.nabble.com/Resuming-the-Flow-SESSION-ID-PROCESS-INSTANCE-ID-WOR...
Sent from the Drools - User mailing list archive at Nabble.com.
15 years, 11 months
Error When changing persistence from H2 to Oracle for TaskService
by ramram
Hi All,
I am trying to change the persistence of the HumanTaskService from the in
memory database to Oracle and I am having the below errors if some one can
help. I have posted my persistence,xml and the Error that I am having.
Persistence.xml
---------------
<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<persistence version="1.0"
xsi:schemaLocation="http://java.sun.com/xml/ns/persistence
http://java.sun.com/xml/ns/persistence/persistence_1_0.xsd
http://java.sun.com/xml/ns/persistence/orm
http://java.sun.com/xml/ns/persistence/orm_1_0.xsd"
xmlns:orm="http://java.sun.com/xml/ns/persistence/orm"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xmlns="http://java.sun.com/xml/ns/persistence">
<persistence-unit name="org.drools.task">
<provider>org.hibernate.ejb.HibernatePersistence</provider>
<class>org.drools.task.Attachment</class>
<class>org.drools.task.Content</class>
<class>org.drools.task.BooleanExpression</class>
<class>org.drools.task.Comment</class>
<class>org.drools.task.Deadline</class>
<class>org.drools.task.Delegation</class>
<class>org.drools.task.Escalation</class>
<class>org.drools.task.Group</class>
<class>org.drools.task.I18NText</class>
<class>org.drools.task.Notification</class>
<class>org.drools.task.EmailNotification</class>
<class>org.drools.task.EmailNotificationHeader</class>
<class>org.drools.task.PeopleAssignments</class>
<class>org.drools.task.Reassignment</class>
<class>org.drools.task.Status</class>
<class>org.drools.task.Task</class>
<class>org.drools.task.TaskData</class>
<class>org.drools.task.SubTasksStrategy</class>
<class>org.drools.task.OnParentAbortAllSubTasksEndStrategy</class>
<class>org.drools.task.OnAllSubTasksEndParentEndStrategy</class>
<class>org.drools.task.User</class>
<properties>
<property name="hibernate.dialect"
value="org.hibernate.dialect.OracleDialect"/>
<property name="hibernate.connection.driver_class"
value="oracle.jdbc.OracleDriver"/>
<property name="hibernate.connection.url" value="..... my databse
url is placed here..." />
<property name="hibernate.connection.username" value="drools"/>
<property name="hibernate.connection.password" value="drools"/>
<property name="hibernate.connection.autocommit" value="false" />
<property name="hibernate.max_fetch_depth" value="3"/>
<property name="hibernate.hbm2ddl.auto" value="create-drop" />
<property name="hibernate.show_sql" value="true" />
</properties>
</persistence-unit>
</persistence>
ERROR:
--------
SEVERE: Unsuccessful: create table Attachment (id number(19,0) not null,
name varchar2(255), accessType number(10,0), contentType varchar2(255),
attachedAt date, si
number(10,0) not null, attachmentContentId number(19,0) not null,
attachedBy_id varchar2(255), TaskData_Attachments_Id number(19,0), primary
key (id))
Mar 30, 2010 12:10:37 PM org.hibernate.tool.hbm2ddl.SchemaExport create
SEVERE: ORA-00904: : invalid identifier
Mar 30, 2010 12:10:37 PM org.hibernate.tool.hbm2ddl.SchemaExport create
SEVERE: Unsuccessful: create table Comment (id number(19,0) not null, text
clob, addedAt date, addedBy_id varchar2(255), TaskData_Comments_Id
number(19,0), primary
(id))
Mar 30, 2010 12:10:37 PM org.hibernate.tool.hbm2ddl.SchemaExport create
SEVERE: ORA-00903: invalid table name
Mar 30, 2010 12:10:38 PM org.hibernate.tool.hbm2ddl.SchemaExport create
SEVERE: Unsuccessful: create table Deadline (id number(19,0) not null, date
date, escalated number(1,0) not null, Deadlines_EndDeadLine_Id number(19,0),
Deadlines_S
tDeadLine_Id number(19,0), primary key (id))
Mar 30, 2010 12:10:38 PM org.hibernate.tool.hbm2ddl.SchemaExport create
SEVERE: ORA-00904: : invalid identifier
Mar 30, 2010 12:10:39 PM org.hibernate.tool.hbm2ddl.SchemaExport create
SEVERE: Unsuccessful: create table Notification_BusinessAdministrators
(task_id number(19,0) not null, entity_id varchar2(255) not null)
Mar 30, 2010 12:10:39 PM org.hibernate.tool.hbm2ddl.SchemaExport create
SEVERE: ORA-00972: identifier is too long
Mar 30, 2010 12:10:39 PM org.hibernate.tool.hbm2ddl.SchemaExport create
SEVERE: Unsuccessful: create table Notification_EmailNotificationHeader
(Notification_id number(19,0) not null, emailHeaders_id number(19,0) not
null, mapkey varcha
255), primary key (Notification_id, mapkey), unique (emailHeaders_id))
Mar 30, 2010 12:10:39 PM org.hibernate.tool.hbm2ddl.SchemaExport create
SEVERE: ORA-00972: identifier is too long
Mar 30, 2010 12:10:39 PM org.hibernate.tool.hbm2ddl.SchemaExport create
SEVERE: Unsuccessful: create table PeopleAssignments_BusinessAdministrators
(task_id number(19,0) not null, entity_id varchar2(255) not null)
Mar 30, 2010 12:10:39 PM org.hibernate.tool.hbm2ddl.SchemaExport create
SEVERE: ORA-00972: identifier is too long
Mar 30, 2010 12:10:39 PM org.hibernate.tool.hbm2ddl.SchemaExport create
SEVERE: Unsuccessful: create table PeopleAssignments_ExcludedOwners (task_id
number(19,0) not null, entity_id varchar2(255) not null)
Mar 30, 2010 12:10:39 PM org.hibernate.tool.hbm2ddl.SchemaExport create
SEVERE: ORA-00972: identifier is too long
Mar 30, 2010 12:10:39 PM org.hibernate.tool.hbm2ddl.SchemaExport create
SEVERE: Unsuccessful: create table PeopleAssignments_PotentialOwners
(task_id number(19,0) not null, entity_id varchar2(255) not null)
Mar 30, 2010 12:10:39 PM org.hibernate.tool.hbm2ddl.SchemaExport create
SEVERE: ORA-00972: identifier is too long
Mar 30, 2010 12:10:39 PM org.hibernate.tool.hbm2ddl.SchemaExport create
SEVERE: Unsuccessful: create table PeopleAssignments_TaskStakeholders
(task_id number(19,0) not null, entity_id varchar2(255) not null)
Mar 30, 2010 12:10:39 PM org.hibernate.tool.hbm2ddl.SchemaExport create
SEVERE: ORA-00972: identifier is too long
Mar 30, 2010 12:10:40 PM org.hibernate.tool.hbm2ddl.SchemaExport create
SEVERE: Unsuccessful: alter table Attachment add constraint
FK1C935432077E1A4 foreign key (attachedBy_id) references
OrganizationalEntity
Mar 30, 2010 12:10:40 PM org.hibernate.tool.hbm2ddl.SchemaExport create
SEVERE: ORA-00942: table or view does not exist
Mar 30, 2010 12:10:40 PM org.hibernate.tool.hbm2ddl.SchemaExport create
SEVERE: Unsuccessful: alter table Attachment add constraint
FK1C93543839A1819 foreign key (TaskData_Attachments_Id) references Task
Mar 30, 2010 12:10:40 PM org.hibernate.tool.hbm2ddl.SchemaExport create
SEVERE: ORA-00942: table or view does not exist
Mar 30, 2010 12:10:40 PM org.hibernate.tool.hbm2ddl.SchemaExport create
SEVERE: Unsuccessful: alter table Comment add constraint FK9BDE863F44E05A35
foreign key (TaskData_Comments_Id) references Task
Mar 30, 2010 12:10:40 PM org.hibernate.tool.hbm2ddl.SchemaExport create
SEVERE: ORA-00903: invalid table name
Mar 30, 2010 12:10:40 PM org.hibernate.tool.hbm2ddl.SchemaExport create
SEVERE: Unsuccessful: alter table Comment add constraint FK9BDE863FC17237C8
foreign key (addedBy_id) references OrganizationalEntity
Mar 30, 2010 12:10:40 PM org.hibernate.tool.hbm2ddl.SchemaExport create
SEVERE: ORA-00903: invalid table name
Mar 30, 2010 12:10:40 PM org.hibernate.tool.hbm2ddl.SchemaExport create
SEVERE: Unsuccessful: alter table Deadline add constraint FK21DF3E78F9CD9DE3
foreign key (Deadlines_StartDeadLine_Id) references Task
Mar 30, 2010 12:10:40 PM org.hibernate.tool.hbm2ddl.SchemaExport create
SEVERE: ORA-00942: table or view does not exist
Mar 30, 2010 12:10:40 PM org.hibernate.tool.hbm2ddl.SchemaExport create
SEVERE: Unsuccessful: alter table Deadline add constraint FK21DF3E78B92DDCCA
foreign key (Deadlines_EndDeadLine_Id) references Task
Mar 30, 2010 12:10:40 PM org.hibernate.tool.hbm2ddl.SchemaExport create
SEVERE: ORA-00942: table or view does not exist
Mar 30, 2010 12:10:41 PM org.hibernate.tool.hbm2ddl.SchemaExport create
SEVERE: Unsuccessful: alter table Escalation add constraint
FK67B2C6B5F8479DB0 foreign key (Deadline_Escalation_Id) references Deadline
Mar 30, 2010 12:10:41 PM org.hibernate.tool.hbm2ddl.SchemaExport create
SEVERE: ORA-00942: table or view does not exist
Mar 30, 2010 12:10:41 PM org.hibernate.tool.hbm2ddl.SchemaExport create
SEVERE: Unsuccessful: alter table I18NText add constraint FK2349686B63D84819
foreign key (Deadline_Documentation_Id) references Deadline
Mar 30, 2010 12:10:41 PM org.hibernate.tool.hbm2ddl.SchemaExport create
SEVERE: ORA-00942: table or view does not exist
Mar 30, 2010 12:10:41 PM org.hibernate.tool.hbm2ddl.SchemaExport create
SEVERE: Unsuccessful: alter table Notification_BusinessAdministrators add
constraint FK4DCCC4FAB009A012 foreign key (entity_id) references
OrganizationalEntity
Mar 30, 2010 12:10:41 PM org.hibernate.tool.hbm2ddl.SchemaExport create
SEVERE: ORA-00972: identifier is too long
Mar 30, 2010 12:10:41 PM org.hibernate.tool.hbm2ddl.SchemaExport create
SEVERE: Unsuccessful: alter table Notification_BusinessAdministrators add
constraint FK4DCCC4FA9A939BFA foreign key (task_id) references Notification
Mar 30, 2010 12:10:41 PM org.hibernate.tool.hbm2ddl.SchemaExport create
SEVERE: ORA-00972: identifier is too long
Mar 30, 2010 12:10:41 PM org.hibernate.tool.hbm2ddl.SchemaExport create
SEVERE: Unsuccessful: alter table Notification_EmailNotificationHeader add
constraint FK92169CC0379F97EA foreign key (emailHeaders_id) references
EmailNotificationH
er
Mar 30, 2010 12:10:41 PM org.hibernate.tool.hbm2ddl.SchemaExport create
SEVERE: ORA-00972: identifier is too long
Mar 30, 2010 12:10:41 PM org.hibernate.tool.hbm2ddl.SchemaExport create
SEVERE: Unsuccessful: alter table Notification_EmailNotificationHeader add
constraint FK92169CC01B1E66DC foreign key (Notification_id) references
Notification
Mar 30, 2010 12:10:41 PM org.hibernate.tool.hbm2ddl.SchemaExport create
SEVERE: ORA-00972: identifier is too long
Mar 30, 2010 12:10:41 PM org.hibernate.tool.hbm2ddl.SchemaExport create
SEVERE: Unsuccessful: alter table PeopleAssignments_BusinessAdministrators
add constraint FK3D56AB6EB009A012 foreign key (entity_id) references
OrganizationalEntity
Mar 30, 2010 12:10:41 PM org.hibernate.tool.hbm2ddl.SchemaExport create
SEVERE: ORA-00972: identifier is too long
Mar 30, 2010 12:10:41 PM org.hibernate.tool.hbm2ddl.SchemaExport create
SEVERE: Unsuccessful: alter table PeopleAssignments_BusinessAdministrators
add constraint FK3D56AB6EC834E294 foreign key (task_id) references Task
Mar 30, 2010 12:10:41 PM org.hibernate.tool.hbm2ddl.SchemaExport create
SEVERE: ORA-00972: identifier is too long
Mar 30, 2010 12:10:41 PM org.hibernate.tool.hbm2ddl.SchemaExport create
SEVERE: Unsuccessful: alter table PeopleAssignments_ExcludedOwners add
constraint FK19190ED2B009A012 foreign key (entity_id) references
OrganizationalEntity
Mar 30, 2010 12:10:41 PM org.hibernate.tool.hbm2ddl.SchemaExport create
SEVERE: ORA-00972: identifier is too long
Mar 30, 2010 12:10:41 PM org.hibernate.tool.hbm2ddl.SchemaExport create
SEVERE: Unsuccessful: alter table PeopleAssignments_ExcludedOwners add
constraint FK19190ED2C834E294 foreign key (task_id) references Task
Mar 30, 2010 12:10:41 PM org.hibernate.tool.hbm2ddl.SchemaExport create
SEVERE: ORA-00972: identifier is too long
Mar 30, 2010 12:10:41 PM org.hibernate.tool.hbm2ddl.SchemaExport create
SEVERE: Unsuccessful: alter table PeopleAssignments_PotentialOwners add
constraint FK9C9C2A96B009A012 foreign key (entity_id) references
OrganizationalEntity
Mar 30, 2010 12:10:41 PM org.hibernate.tool.hbm2ddl.SchemaExport create
SEVERE: ORA-00972: identifier is too long
Mar 30, 2010 12:10:41 PM org.hibernate.tool.hbm2ddl.SchemaExport create
SEVERE: Unsuccessful: alter table PeopleAssignments_PotentialOwners add
constraint FK9C9C2A96C834E294 foreign key (task_id) references Task
Mar 30, 2010 12:10:41 PM org.hibernate.tool.hbm2ddl.SchemaExport create
SEVERE: ORA-00972: identifier is too long
Mar 30, 2010 12:10:41 PM org.hibernate.tool.hbm2ddl.SchemaExport create
SEVERE: Unsuccessful: alter table PeopleAssignments_TaskStakeholders add
constraint FKE6997FFAB009A012 foreign key (entity_id) references
OrganizationalEntity
Mar 30, 2010 12:10:41 PM org.hibernate.tool.hbm2ddl.SchemaExport create
SEVERE: ORA-00972: identifier is too long
Mar 30, 2010 12:10:41 PM org.hibernate.tool.hbm2ddl.SchemaExport create
SEVERE: Unsuccessful: alter table PeopleAssignments_TaskStakeholders add
constraint FKE6997FFAC834E294 foreign key (task_id) references Task
Mar 30, 2010 12:10:41 PM org.hibernate.tool.hbm2ddl.SchemaExport create
SEVERE: ORA-00972: identifier is too long
Mar 30, 2010 12:10:42 PM org.hibernate.tool.hbm2ddl.SchemaExport execute
INFO: schema export complete
Hibernate: select task0_.id as col_0_0_, deadline1_.id as col_1_0_,
deadline1_.date as col_2_0_ from Task task0_, Deadline deadline1_ where
(deadline1_.id in (selec
tartdeadl2_.id from Deadline startdeadl2_ where
task0_.id=startdeadl2_.Deadlines_StartDeadLine_Id) or deadline1_.id in
(select enddeadlin3_.id from Deadline enddead
3_ where task0_.id=enddeadlin3_.Deadlines_EndDeadLine_Id)) and
deadline1_.escalated=0 order by deadline1_.date
Mar 30, 2010 12:10:43 PM org.hibernate.util.JDBCExceptionReporter
logExceptions
WARNING: SQL Error: 1747, SQLState: 42000
Mar 30, 2010 12:10:43 PM org.hibernate.util.JDBCExceptionReporter
logExceptions
SEVERE: ORA-01747: invalid user.table.column, table.column, or column
specification
javax.persistence.PersistenceException:
org.hibernate.exception.SQLGrammarException: could not execute query
at
org.hibernate.ejb.AbstractEntityManagerImpl.throwPersistenceException(AbstractEntityManagerImpl.java:629)
at org.hibernate.ejb.QueryImpl.getResultList(QueryImpl.java:73)
at org.drools.task.service.TaskService.<init>(TaskService.java:65)
at org.drools.task.service.TaskService.<init>(TaskService.java:48)
at RunTaskService.start(RunTaskService.java:48)
at RunTaskService.main(RunTaskService.java:31)
Caused by: org.hibernate.exception.SQLGrammarException: could not execute
query
at
org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:67)
at
org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
at org.hibernate.loader.Loader.doList(Loader.java:2223)
at
org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2104)
at org.hibernate.loader.Loader.list(Loader.java:2099)
at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:378)
at
org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:338)
at
org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:172)
at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1121)
at org.hibernate.impl.QueryImpl.list(QueryImpl.java:79)
at org.hibernate.ejb.QueryImpl.getResultList(QueryImpl.java:64)
... 4 more
Caused by: java.sql.SQLException: ORA-01747: invalid user.table.column,
table.column, or column specification
at
oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:125)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:316)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:282)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:639)
at
oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:185)
at
oracle.jdbc.driver.T4CPreparedStatement.execute_for_describe(T4CPreparedStatement.java:503)
at
oracle.jdbc.driver.OracleStatement.execute_maybe_describe(OracleStatement.java:965)
at
oracle.jdbc.driver.T4CPreparedStatement.execute_maybe_describe(T4CPreparedStatement.java:535)
at
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1051)
at
oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:2984)
at
oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3026)
at
org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:186)
at org.hibernate.loader.Loader.getResultSet(Loader.java:1787)
at org.hibernate.loader.Loader.doQuery(Loader.java:674)
at
org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:236)
at org.hibernate.loader.Loader.doList(Loader.java:2220)
... 12 more
Exception in thread "main" java.lang.Exception
at RunTaskService.start(RunTaskService.java:53)
at RunTaskService.main(RunTaskService.java:31)
--
View this message in context: http://n3.nabble.com/Error-When-changing-persistence-from-H2-to-Oracle-fo...
Sent from the Drools - User mailing list archive at Nabble.com.
15 years, 11 months
Drools Flow: looking for a Fault Node / Handler example
by Nol de Wit
Hi all,
In the documentation and other articles I reed about the Fault Node,
and how it acts as a bit of an End Node in Flow.
I've been searching on the net in general, and the mail-list archive
in particular for an example on how to use this, but without much
success.
In mostly interessted in the 'Exception Handlers' that apperently can
be used for this. What is the format of such handler, and how to
register it...
Thanks,
Nol
15 years, 11 months
Oryx exported BPMN not properly opened in Eclipse Drools.
by Robert
Hi,
my exported BPMN-File from the Oryx-Editor does not open properly in the
Eclipse-Drools IDE.
I set the BPMN-Skin and the Editor is actually open up, but the only
symbol displayed is the start-node (but there are actually many more)
What did I do ?
I followed the demo at
http://people.redhat.com/kverlaen/BPMN2-OryxEditor.swf
for creating a BPMN 2.0 model.
But somehow the recent version of Oryx seems different.
First there are some more options of creating a new modell:
- BPMN 2.0 Process
- BPMN 2.0 Conversations
- BPMN 2.0 Choreographies
- ...
I choose the first (BPMN 2.0 Process).
At exporting it, it looks also somehow different:
- ...
- Show BPMN 2.0 DI XML
- Download BPMN 2.0 DI XML
- ...
There are others, but nothing looking close to the one used in the demo
(there you used "Show BPMN 2.0 XML", so the "DI" is different).
I guees the format changed somehow.
Can you give me some feedback on this, if you also encountered problems or
give me a hint what I did wrong ?
Thanks.
Cheers, Rob.
--
Erstellt mit Operas revolutionärem E-Mail-Modul: http://www.opera.com/mail/
15 years, 11 months
