7:27 a.m.
Hi All,
I have been trying to persist the Human TasK service to Oracle. And I got
the below error. Please check my persistence.xml file and the error that I
have recieved. It seems this is happening because of some oracle reserved
words are used to name the columns.
Any suggestions??? on this Topic?????
persistence.xml
============
<persistence-unit name="org.drools.task">
<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.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.Oracle10gDialect"/>
<property name="hibernate.connection.driver_class"
value="oracle.jdbc.OracleDriver"/>
<property name="hibernate.connection.url"
value="jdbc:oracle:thin:@DB_URL" />
<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>
Error
============
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 (select start
deadl2_.id from Deadline startdeadl2_ where
task0_.id=startdeadl2_.Deadlines_StartDeadLine_Id) or deadline1_.id in
(select enddeadlin3_.id from Deadline enddeadlin3_ where
task0_.id=enddeadlin3_.Deadlines_EndDeadLine_Id)) and
deadline1_.escalated=0 order by deadline1_.date
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 com.fp.taskservice.RunTaskService.start(RunTaskService.java:45)
at
com.fp.taskservice.RunTaskService.contextInitialized(RunTaskService.java:28)
at
org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3843)
at
org.apache.catalina.core.StandardContext.start(StandardContext.java:4350)
at
org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:791)
at
org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:771)
at
org.apache.catalina.core.StandardHost.addChild(StandardHost.java:525)
at
org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.java:924)
at
org.apache.catalina.startup.HostConfig.deployDirectories(HostConfig.java:887)
at
org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:492)
at
org.apache.catalina.startup.HostConfig.start(HostConfig.java:1147)
at
org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:311)
at
org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:117)
at
org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1053)
at
org.apache.catalina.core.StandardHost.start(StandardHost.java:719)
at
org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045)
at
org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443)
at
org.apache.catalina.core.StandardService.start(StandardService.java:516)
at
org.apache.catalina.core.StandardServer.start(StandardServer.java:710)
at org.apache.catalina.startup.Catalina.start(Catalina.java:578)
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.apache.catalina.startup.Bootstrap.start(Bootstrap.java:288)
at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:413)
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)
... 28 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)
... 36 more
java.lang.Exception
at com.fp.taskservice.RunTaskService.start(RunTaskService.java:50)
at
com.fp.taskservice.RunTaskService.contextInitialized(RunTaskService.java:28)
at
org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3843)
at
org.apache.catalina.core.StandardContext.start(StandardContext.java:4350)
at
org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:791)
at
org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:771)
at
org.apache.catalina.core.StandardHost.addChild(StandardHost.java:525)
at
org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.java:924)
at
org.apache.catalina.startup.HostConfig.deployDirectories(HostConfig.java:887)
at
org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:492)
at
org.apache.catalina.startup.HostConfig.start(HostConfig.java:1147)
at
org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:311)
at
org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:117)
at
org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1053)
at
org.apache.catalina.core.StandardHost.start(StandardHost.java:719)
at
org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045)
at
org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443)
at
org.apache.catalina.core.StandardService.start(StandardService.java:516)
at
org.apache.catalina.core.StandardServer.start(StandardServer.java:710)
at org.apache.catalina.startup.Catalina.start(Catalina.java:578)
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.apache.catalina.startup.Bootstrap.start(Bootstrap.java:288)
Regards,
Ram
--
View this message in context:
http://drools-java-rules-engine.46999.n3.nabble.com/Drools-Human-Task-Ser...
Sent from the Drools - User mailing list archive at Nabble.com.
8 a.m.
yes.. it's sounds like that..
do you know what's the column that causes the trouble?
(ORA-01747: invalid user.table.column,
table.column, or column specification)
On Tue, Nov 9, 2010 at 10:27 AM, ramram <ramram858(a)gmail.com> wrote:
Hi All,
I have been trying to persist the Human TasK service to Oracle. And I got
the below error. Please check my persistence.xml file and the error that I
have recieved. It seems this is happening because of some oracle reserved
words are used to name the columns.
Any suggestions??? on this Topic?????
persistence.xml
============
<persistence-unit name="org.drools.task">
<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.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.Oracle10gDialect"/>
<property name="hibernate.connection.driver_class"
value="oracle.jdbc.OracleDriver"/>
<property name="hibernate.connection.url"
value="jdbc:oracle:thin:@DB_URL" />
<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>
Error
============
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 (select start
deadl2_.id from Deadline startdeadl2_ where
task0_.id=startdeadl2_.Deadlines_StartDeadLine_Id) or deadline1_.id in
(select enddeadlin3_.id from Deadline enddeadlin3_ where
task0_.id=enddeadlin3_.Deadlines_EndDeadLine_Id)) and
deadline1_.escalated=0 order by deadline1_.date
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 com.fp.taskservice.RunTaskService.start(RunTaskService.java:45)
at
com.fp.taskservice.RunTaskService.contextInitialized(RunTaskService.java:28)
at
org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3843)
at
org.apache.catalina.core.StandardContext.start(StandardContext.java:4350)
at
org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:791)
at
org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:771)
at
org.apache.catalina.core.StandardHost.addChild(StandardHost.java:525)
at
org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.java:924)
at
org.apache.catalina.startup.HostConfig.deployDirectories(HostConfig.java:887)
at
org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:492)
at
org.apache.catalina.startup.HostConfig.start(HostConfig.java:1147)
at
org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:311)
at
org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:117)
at
org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1053)
at
org.apache.catalina.core.StandardHost.start(StandardHost.java:719)
at
org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045)
at
org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443)
at
org.apache.catalina.core.StandardService.start(StandardService.java:516)
at
org.apache.catalina.core.StandardServer.start(StandardServer.java:710)
at org.apache.catalina.startup.Catalina.start(Catalina.java:578)
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.apache.catalina.startup.Bootstrap.start(Bootstrap.java:288)
at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:413)
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)
... 28 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)
... 36 more
java.lang.Exception
at com.fp.taskservice.RunTaskService.start(RunTaskService.java:50)
at
com.fp.taskservice.RunTaskService.contextInitialized(RunTaskService.java:28)
at
org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3843)
at
org.apache.catalina.core.StandardContext.start(StandardContext.java:4350)
at
org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:791)
at
org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:771)
at
org.apache.catalina.core.StandardHost.addChild(StandardHost.java:525)
at
org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.java:924)
at
org.apache.catalina.startup.HostConfig.deployDirectories(HostConfig.java:887)
at
org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:492)
at
org.apache.catalina.startup.HostConfig.start(HostConfig.java:1147)
at
org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:311)
at
org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:117)
at
org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1053)
at
org.apache.catalina.core.StandardHost.start(StandardHost.java:719)
at
org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045)
at
org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443)
at
org.apache.catalina.core.StandardService.start(StandardService.java:516)
at
org.apache.catalina.core.StandardServer.start(StandardServer.java:710)
at org.apache.catalina.startup.Catalina.start(Catalina.java:578)
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.apache.catalina.startup.Bootstrap.start(Bootstrap.java:288)
Regards,
Ram
--
View this message in context:
http://drools-java-rules-engine.46999.n3.nabble.com/Drools-Human-Task-Ser...
Sent from the Drools - User mailing list archive at Nabble.com.
_______________________________________________
rules-users mailing list
rules-users(a)lists.jboss.org
https://lists.jboss.org/mailman/listinfo/rules-users
--
- CTO @ http://www.plugtree.com
- MyJourney @ http://salaboy.wordpress.com
- Co-Founder @ http://www.jbug.com.ar
- Salatino "Salaboy" Mauricio -
8:28 a.m.
Hello,
At first glance the "select start" keyword alone in the query (as shown in
the log, ...sk task0_, Deadline deadline1_ where (deadline1_.id in (select
start
deadl2_.id from Deadline startdeadl2_ where task0_.id=startdeadl2_....) will
probably not work in Oracle. Start is a reserved keyword in Oracle
(..besides the query does not look right with start), maybe this is causing
the error.
--
View this message in context:
http://drools-java-rules-engine.46999.n3.nabble.com/Drools-Human-Task-Ser...
Sent from the Drools - User mailing list archive at Nabble.com.
9:43 a.m.
Hi, Mauricio
Are the table name PeopleAssignments_BusinessAdministrators name and such
similar too long for Oracle to create?
Should this be refacted into some meaningful short ones?
On Tue, Nov 9, 2010 at 10:28 PM, melc <c_melas(a)yahoo.com> wrote:
Hello,
At first glance the "select start" keyword alone in the query (as shown in
the log, ...sk task0_, Deadline deadline1_ where (deadline1_.id in (select
start
deadl2_.id from Deadline startdeadl2_ where task0_.id=startdeadl2_....)
will
probably not work in Oracle. Start is a reserved keyword in Oracle
(..besides the query does not look right with start), maybe this is causing
the error.
--
View this message in context:
http://drools-java-rules-engine.46999.n3.nabble.com/Drools-Human-Task-Ser...
Sent from the Drools - User mailing list archive at Nabble.com.
_______________________________________________
rules-users mailing list
rules-users(a)lists.jboss.org
https://lists.jboss.org/mailman/listinfo/rules-users
--
唐睿
9:45 a.m.
Hi All,
Yes as you are stating the problem is from these keywords such as start
and date.
Salaboy,
Meanly the column name [date] is causing the problem, the question is how
to fix such issues. What do you recommend in such a case? is there any
Drools example working with Oracle persistance?
Thanks all for your support.
Regards,
Ram
--
View this message in context:
http://drools-java-rules-engine.46999.n3.nabble.com/Drools-Human-Task-Ser...
Sent from the Drools - User mailing list archive at Nabble.com.
10:06 a.m.
You can overrride the persistence annotations and names using XML mappings. That's the
solution, you should read the hibernate docs in order to find out how to do that. Would be
nice also to talk with Kris to know if we can change the attr name to make it compatible.
- CTO @ http://www.plugtree.com
- MyJourney @ http://salaboy.wordpress.com
- Co-Founder @ http://www.jbug.com.ar
- Mauricio "Salaboy" Salatino -
On 09/11/2010, at 12:45, ramram <ramram858(a)gmail.com> wrote:
Hi All,
Yes as you are stating the problem is from these keywords such as start
and date.
Salaboy,
Meanly the column name [date] is causing the problem, the question is how
to fix such issues. What do you recommend in such a case? is there any
Drools example working with Oracle persistance?
Thanks all for your support.
Regards,
Ram
--
View this message in context:
http://drools-java-rules-engine.46999.n3.nabble.com/Drools-Human-Task-Ser...
Sent from the Drools - User mailing list archive at Nabble.com.
_______________________________________________
rules-users mailing list
rules-users(a)lists.jboss.org
https://lists.jboss.org/mailman/listinfo/rules-users
2:38 a.m.
Hi Salaboy, Kris,
Please find below the list of the tables that are causing the problem in
the Oracle DB and the reason why the problems are appearing. If this could
be resolved in next releases it would be great. Meanwhile I will try to
override the anotations by using xml file. If any one have an example on how
to do this it would be great.
Table: Attachment -- column name [size] reserved word for oracle
Table: Comment -- table name [Comment] reserved word for oracle
Table: Deadline -- column name [date] reserved word for oracle
Table: Notification_BusinessAdministrators -- table name is too long for
oracle
Table: Notification_EmailNotificationHeader -- table name is too long for
oracle
Table: PeopleAssignments_BusinessAdministrators -- table name is too long
for oracle
Table: PeopleAssignments_ExcludedOwners -- table name is too long for
oracle
Table: PeopleAssign_PotentialOwners -- table name is too long for oracle
Table: PeopleAssign_TaskStakeholders -- table name is too long for oracle
Thanks for the help.
Regards,
Ram
--
View this message in context:
http://drools-java-rules-engine.46999.n3.nabble.com/Drools-Human-Task-Ser...
Sent from the Drools - User mailing list archive at Nabble.com.
12:47 p.m.
Kris, do you think that we need to change the names for all the mappings or
just create an xml file mapping for Oracle?
I remember a guy that was doing that mapping, probably we can distribute xml
mappings for different databases.
On Wed, Nov 10, 2010 at 5:38 AM, ramram <ramram858(a)gmail.com> wrote:
Hi Salaboy, Kris,
Please find below the list of the tables that are causing the problem in
the Oracle DB and the reason why the problems are appearing. If this could
be resolved in next releases it would be great. Meanwhile I will try to
override the anotations by using xml file. If any one have an example on
how
to do this it would be great.
Table: Attachment -- column name [size] reserved word for oracle
Table: Comment -- table name [Comment] reserved word for oracle
Table: Deadline -- column name [date] reserved word for oracle
Table: Notification_BusinessAdministrators -- table name is too long for
oracle
Table: Notification_EmailNotificationHeader -- table name is too long for
oracle
Table: PeopleAssignments_BusinessAdministrators -- table name is too long
for oracle
Table: PeopleAssignments_ExcludedOwners -- table name is too long for
oracle
Table: PeopleAssign_PotentialOwners -- table name is too long for oracle
Table: PeopleAssign_TaskStakeholders -- table name is too long for oracle
Thanks for the help.
Regards,
Ram
--
View this message in context:
http://drools-java-rules-engine.46999.n3.nabble.com/Drools-Human-Task-Ser...
Sent from the Drools - User mailing list archive at Nabble.com.
_______________________________________________
rules-users mailing list
rules-users(a)lists.jboss.org
https://lists.jboss.org/mailman/listinfo/rules-users
--
- CTO @ http://www.plugtree.com
- MyJourney @ http://salaboy.wordpress.com
- Co-Founder @ http://www.jbug.com.ar
- Salatino "Salaboy" Mauricio -
3:31 a.m.
Hi Salaboy, Kris
I managed to do the persistence to Oracle and that is not by creating an
xml file but by adding annotations to the org.drools.task file and I mean by
this:
for example org.drools.task.Deadline
- the column name [date] reserved word for oracle. So what I did is
the following: in the java file I added the following :
- @Column(name="dDate")
private Date date;
and For the classes that have long table name such as
org.drools.EmailNotificationHeader
@Entity
@Table(name="EmailNotifHead")
public class EmailNotificationHeader
can you add this in the next releases to the drools task??????
is the solution that I did a correct one??????
Regards,
Ram
--
View this message in context:
http://drools-java-rules-engine.46999.n3.nabble.com/Drools-Human-Task-Ser...
Sent from the Drools - User mailing list archive at Nabble.com.
4:16 a.m.
Hi, friends
I'd like to add xml config to fix this this problem. Because
sometimes, for different databases, we may need different mappings.
E.g. we may need varchar2 in Oracle other than varchar in others.
I've read some other one's note to say that it is better to define the
relationship of entities using annotation, but database mapping using
config files.
What's your opinion? Look forward.
2010/11/11, ramram <ramram858(a)gmail.com>:
Hi Salaboy, Kris
I managed to do the persistence to Oracle and that is not by creating an
xml file but by adding annotations to the org.drools.task file and I mean by
this:
for example org.drools.task.Deadline
- the column name [date] reserved word for oracle. So what I did is
the following: in the java file I added the following :
- @Column(name="dDate")
private Date date;
and For the classes that have long table name such as
org.drools.EmailNotificationHeader
@Entity
@Table(name="EmailNotifHead")
public class EmailNotificationHeader
can you add this in the next releases to the drools task??????
is the solution that I did a correct one??????
Regards,
Ram
--
View this message in context:
http://drools-java-rules-engine.46999.n3.nabble.com/Drools-Human-Task-Ser...
Sent from the Drools - User mailing list archive at Nabble.com.
_______________________________________________
rules-users mailing list
rules-users(a)lists.jboss.org
https://lists.jboss.org/mailman/listinfo/rules-users
--
从我的移动设备发送
唐睿
4:41 a.m.
yes I'm with Rui,
Changing the annotations in the code requires recompilation.. and that's not
good... because when you update your drools version (ramram) you will lose
that kind of changes.
I think that the best solution is to create xml mappings for different
vendors.. Rui if you can contribute with that.. will be awesome!
Greetings!
2010/11/11 Rui Tang <tangrui.cn(a)gmail.com>
Hi, friends
I'd like to add xml config to fix this this problem. Because
sometimes, for different databases, we may need different mappings.
E.g. we may need varchar2 in Oracle other than varchar in others.
I've read some other one's note to say that it is better to define the
relationship of entities using annotation, but database mapping using
config files.
What's your opinion? Look forward.
2010/11/11, ramram <ramram858(a)gmail.com>:
>
> Hi Salaboy, Kris
>
> I managed to do the persistence to Oracle and that is not by creating
an
> xml file but by adding annotations to the org.drools.task file and I mean
by
> this:
>
> for example org.drools.task.Deadline
> - the column name [date] reserved word for oracle. So what I did is
> the following: in the java file I added the following :
> - @Column(name="dDate")
> private Date date;
> and For the classes that have long table name such as
> org.drools.EmailNotificationHeader
> @Entity
> @Table(name="EmailNotifHead")
> public class EmailNotificationHeader
>
>
> can you add this in the next releases to the drools task??????
> is the solution that I did a correct one??????
>
> Regards,
> Ram
> --
> View this message in context:
>
http://drools-java-rules-engine.46999.n3.nabble.com/Drools-Human-Task-Ser...
> Sent from the Drools - User mailing list archive at Nabble.com.
> _______________________________________________
> rules-users mailing list
> rules-users(a)lists.jboss.org
> https://lists.jboss.org/mailman/listinfo/rules-users
>
--
从我的移动设备发送
唐睿
_______________________________________________
rules-users mailing list
rules-users(a)lists.jboss.org
https://lists.jboss.org/mailman/listinfo/rules-users
--
- CTO @ http://www.plugtree.com
- MyJourney @ http://salaboy.wordpress.com
- Co-Founder @ http://www.jbug.com.ar
- Salatino "Salaboy" Mauricio -
7:05 a.m.
Of course!
I'm just going to port MySQL database schema to Oracle in my project.
Give me some days only!
2010/11/15 Mauricio Salatino <salaboy(a)gmail.com>
yes I'm with Rui,
Changing the annotations in the code requires recompilation.. and that's
not good... because when you update your drools version (ramram) you will
lose that kind of changes.
I think that the best solution is to create xml mappings for different
vendors.. Rui if you can contribute with that.. will be awesome!
Greetings!
2010/11/11 Rui Tang <tangrui.cn(a)gmail.com>
Hi, friends
>
> I'd like to add xml config to fix this this problem. Because
> sometimes, for different databases, we may need different mappings.
> E.g. we may need varchar2 in Oracle other than varchar in others.
>
> I've read some other one's note to say that it is better to define the
> relationship of entities using annotation, but database mapping using
> config files.
>
> What's your opinion? Look forward.
>
> 2010/11/11, ramram <ramram858(a)gmail.com>:
> >
> > Hi Salaboy, Kris
> >
> > I managed to do the persistence to Oracle and that is not by creating
> an
> > xml file but by adding annotations to the org.drools.task file and I
> mean by
> > this:
> >
> > for example org.drools.task.Deadline
> > - the column name [date] reserved word for oracle. So what I did
> is
> > the following: in the java file I added the following :
> > - @Column(name="dDate")
> > private Date date;
> > and For the classes that have long table name such as
> > org.drools.EmailNotificationHeader
> > @Entity
> > @Table(name="EmailNotifHead")
> > public class EmailNotificationHeader
> >
> >
> > can you add this in the next releases to the drools task??????
> > is the solution that I did a correct one??????
> >
> > Regards,
> > Ram
> > --
> > View this message in context:
> >
>
http://drools-java-rules-engine.46999.n3.nabble.com/Drools-Human-Task-Ser...
> > Sent from the Drools - User mailing list archive at Nabble.com.
> > _______________________________________________
> > rules-users mailing list
> > rules-users(a)lists.jboss.org
> > https://lists.jboss.org/mailman/listinfo/rules-users
> >
>
> --
> 从我的移动设备发送
>
> 唐睿
>
> _______________________________________________
> rules-users mailing list
> rules-users(a)lists.jboss.org
> https://lists.jboss.org/mailman/listinfo/rules-users
>
--
- CTO @ http://www.plugtree.com
- MyJourney @ http://salaboy.wordpress.com
- Co-Founder @ http://www.jbug.com.ar
- Salatino "Salaboy" Mauricio -
_______________________________________________
rules-users mailing list
rules-users(a)lists.jboss.org
https://lists.jboss.org/mailman/listinfo/rules-users
--
唐睿
4:05 a.m.
Ok Great guys to have the xml mappings. Please can you reply on the mail once
the mapping is done through xml so that I can update my work.
Thanks and looking forward to it :D
--
View this message in context:
http://drools-java-rules-engine.46999.n3.nabble.com/Drools-Human-Task-Ser...
Sent from the Drools - User mailing list archive at Nabble.com.
11:31 a.m.
wait a minute, is it like no one ever tried persisting human task in oracle
before?
so far the support is only for H2 in memory db? i wonder how this made into
production system then?
honestly, its not criticism, just wanted to know how others are doing
without persistence of task, of course DB is not only oracle, they might
have used other DB as well.
But it doesn't ring me a bell how custom status be implemented and how the
named queries in org.drools.task be executed, lacking of proper docs and
examples ..creating lot of chaos :-(
So, you can't do persistence with oracle unless u have to override, if not
oracle, what is the best bet DB (please don't say H2 :-) )
-drooRam
--
View this message in context:
http://drools-java-rules-engine.46999.n3.nabble.com/Drools-Human-Task-Ser...
Sent from the Drools - User mailing list archive at Nabble.com.
6:43 a.m.
Hi list,
I've finished to port ORM annotations to xml mapping files. And the Oracle
is supported too. But all of these are not under full featured test, so this
is the only snapshot for you.
I've changed rule flow related, task related and BAM related annotations. I
can make sure that the creating table procedure is OK under MySQL 5.1 and
Oracle 10g, but not for others.
According to some hibernate problems, the mapping files have some
disadvantages:
1. When parsing the files, some warning logs will be printed. This is
because hibernate is trying to make sure that all of these mapping
attributes are public fields or methods. But some fields of the entities are
not, for example version, env and so on. But this seems no harm.
2. According to some hibernate processing bugs (I guess), some table or
field name cannot map correctly. One is in the class
org.drools.task.EmailNotification, the one-to-many relationship to
org.drools.task.EmailNotificationHeader cannot map correctly (There is a
field named emailHeaders_KEY in table DRL5_NOTIFICATION_EMAILHEADERS).
Another one is the
org.drools.persistence.processinstance.ProcessInstanceInfo's eventTypes
field (There is a table named ProcessInstanceInfo_eventTypes) . All of these
names are set in mapping files but not reflected in database. I don't know
how to resolve these, so leave it alone. But these should only impact the
names not the functions.
The naming convention is straight. All of the tables are starting with DRL5_
and all fields are with F_.
On Fri, Nov 19, 2010 at 1:31 AM, drooRam <rajeshram7(a)yahoo.com> wrote:
wait a minute, is it like no one ever tried persisting human task in oracle
before?
so far the support is only for H2 in memory db? i wonder how this made into
production system then?
honestly, its not criticism, just wanted to know how others are doing
without persistence of task, of course DB is not only oracle, they might
have used other DB as well.
But it doesn't ring me a bell how custom status be implemented and how the
named queries in org.drools.task be executed, lacking of proper docs and
examples ..creating lot of chaos :-(
So, you can't do persistence with oracle unless u have to override, if not
oracle, what is the best bet DB (please don't say H2 :-) )
-drooRam
--
View this message in context:
http://drools-java-rules-engine.46999.n3.nabble.com/Drools-Human-Task-Ser...
Sent from the Drools - User mailing list archive at Nabble.com.
_______________________________________________
rules-users mailing list
rules-users(a)lists.jboss.org
https://lists.jboss.org/mailman/listinfo/rules-users
--
唐睿
8:02 a.m.
Great Job!
@Kris: can we include this in drools-persistence-jpa? as an external bundle?
would be nice to have a place to store all the community contribution about
mappings for different databases.
2010/11/24 Rui Tang <tangrui.cn(a)gmail.com>
Hi list,
I've finished to port ORM annotations to xml mapping files. And the Oracle
is supported too. But all of these are not under full featured test, so this
is the only snapshot for you.
I've changed rule flow related, task related and BAM related annotations. I
can make sure that the creating table procedure is OK under MySQL 5.1 and
Oracle 10g, but not for others.
According to some hibernate problems, the mapping files have some
disadvantages:
1. When parsing the files, some warning logs will be printed. This is
because hibernate is trying to make sure that all of these mapping
attributes are public fields or methods. But some fields of the entities are
not, for example version, env and so on. But this seems no harm.
2. According to some hibernate processing bugs (I guess), some table or
field name cannot map correctly. One is in the class
org.drools.task.EmailNotification, the one-to-many relationship to
org.drools.task.EmailNotificationHeader cannot map correctly (There is a
field named emailHeaders_KEY in table DRL5_NOTIFICATION_EMAILHEADERS).
Another one is the
org.drools.persistence.processinstance.ProcessInstanceInfo's eventTypes
field (There is a table named ProcessInstanceInfo_eventTypes) . All of these
names are set in mapping files but not reflected in database. I don't know
how to resolve these, so leave it alone. But these should only impact the
names not the functions.
The naming convention is straight. All of the tables are starting with
DRL5_ and all fields are with F_.
On Fri, Nov 19, 2010 at 1:31 AM, drooRam <rajeshram7(a)yahoo.com> wrote:
>
> wait a minute, is it like no one ever tried persisting human task in
> oracle
> before?
>
> so far the support is only for H2 in memory db? i wonder how this made
> into
> production system then?
>
> honestly, its not criticism, just wanted to know how others are doing
> without persistence of task, of course DB is not only oracle, they might
> have used other DB as well.
>
> But it doesn't ring me a bell how custom status be implemented and how the
> named queries in org.drools.task be executed, lacking of proper docs and
> examples ..creating lot of chaos :-(
>
> So, you can't do persistence with oracle unless u have to override, if not
> oracle, what is the best bet DB (please don't say H2 :-) )
>
> -drooRam
>
> --
> View this message in context:
>
http://drools-java-rules-engine.46999.n3.nabble.com/Drools-Human-Task-Ser...
> Sent from the Drools - User mailing list archive at Nabble.com.
> _______________________________________________
> rules-users mailing list
> rules-users(a)lists.jboss.org
> https://lists.jboss.org/mailman/listinfo/rules-users
>
--
唐睿
_______________________________________________
rules-users mailing list
rules-users(a)lists.jboss.org
https://lists.jboss.org/mailman/listinfo/rules-users
--
- CTO @ http://www.plugtree.com
- MyJourney @ http://salaboy.wordpress.com
- Co-Founder @ http://www.jbug.com.ar
- Salatino "Salaboy" Mauricio -
2:18 a.m.
Hi Guys,
nice to hear that the xml mapping is done.
From where can i get this XML file to try it. Please can you provide the
URL for it.
Thanks in advance,
Ram
--
View this message in context:
http://drools-java-rules-engine.46999.n3.nabble.com/Drools-Human-Task-Ser...
Sent from the Drools - User mailing list archive at Nabble.com.
7:32 a.m.
@ramram is in the Rui Tang mail as an attach
On Thu, Nov 25, 2010 at 5:18 AM, ramram <ramram858(a)gmail.com> wrote:
Hi Guys,
nice to hear that the xml mapping is done.
From where can i get this XML file to try it. Please can you provide the
URL for it.
Thanks in advance,
Ram
--
View this message in context:
http://drools-java-rules-engine.46999.n3.nabble.com/Drools-Human-Task-Ser...
Sent from the Drools - User mailing list archive at Nabble.com.
_______________________________________________
rules-users mailing list
rules-users(a)lists.jboss.org
https://lists.jboss.org/mailman/listinfo/rules-users
--
- CTO @ http://www.plugtree.com
- MyJourney @ http://salaboy.wordpress.com
- Co-Founder @ http://www.jbug.com.ar
- Salatino "Salaboy" Mauricio -
11:01 a.m.
Hi all,
I have the following exception on the server intialization after applying
the orm.xml files
18:57:25,144 SEVERE [XMLHelper] Error parsing XML: XML InputStream(5)
cvc-complex-type.3.1: Value '2.0' of attribute 'version' of element
'entity-mappings' is not valid w
ith respect to the corresponding attribute use. Attribute 'version' has a
fixed value of '1.0'.
18:57:25,149 ERROR [STDERR] javax.persistence.PersistenceException:
[PersistenceUnit: org.drools.task] Error while reading JPA XML file:
META-INF/task/Attachment.orm.xml
18:57:25,150 ERROR [STDERR] at
org.hibernate.ejb.Ejb3Configuration.addClassesToSessionFactory(Ejb3Configuration.java:909)
18:57:25,150 ERROR [STDERR] at
org.hibernate.ejb.Ejb3Configuration.configure(Ejb3Configuration.java:758)
18:57:25,153 ERROR [STDERR] at
org.hibernate.ejb.Ejb3Configuration.configure(Ejb3Configuration.java:191)
18:57:25,156 ERROR [STDERR] at
org.hibernate.ejb.Ejb3Configuration.configure(Ejb3Configuration.java:253)
18:57:25,159 ERROR [STDERR] at
org.hibernate.ejb.HibernatePersistence.createEntityManagerFactory(HibernatePersistence.java:125)
18:57:25,163 ERROR [STDERR] at
javax.persistence.Persistence.createEntityManagerFactory(Persistence.java:52)
18:57:25,172 ERROR [STDERR] at
javax.persistence.Persistence.createEntityManagerFactory(Persistence.java:34)
18:57:25,176 ERROR [STDERR] at
com.fp.common.view.util.InitializeTaskService.start(InitializeTaskService.java:39)
18:57:25,178 ERROR [STDERR] at
com.fp.common.view.util.InitializeTaskService.startTaskService(InitializeTaskService.java:30)
18:57:25,186 ERROR [STDERR] at
com.fp.common.view.util.ServerInitialization.contextInitialized(ServerInitialization.java:22)
18:57:25,189 ERROR [STDERR] at
org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3910)
18:57:25,193 ERROR [STDERR] at
org.apache.catalina.core.StandardContext.start(StandardContext.java:4393)
18:57:25,195 ERROR [STDERR] at
org.jboss.web.tomcat.service.deployers.TomcatDeployment.performDeployInternal(TomcatDeployment.java:310)
18:57:25,204 ERROR [STDERR] at
org.jboss.web.tomcat.service.deployers.TomcatDeployment.performDeploy(TomcatDeployment.java:142)
18:57:25,207 ERROR [STDERR] at
org.jboss.web.deployers.AbstractWarDeployment.start(AbstractWarDeployment.java:461)
18:57:25,210 ERROR [STDERR] at
org.jboss.web.deployers.WebModule.startModule(WebModule.java:118)
18:57:25,213 ERROR [STDERR] at
org.jboss.web.deployers.WebModule.start(WebModule.java:97)
persistence.xml
<persistence-unit name="org.drools.task"
transaction-type="RESOURCE_LOCAL">
<provider>org.hibernate.ejb.HibernatePersistence</provider>
<jta-data-source>java:/comp/env/worDS</jta-data-source>
<mapping-file>META-INF/orm.xml</mapping-file>
<mapping-file>META-INF/task/Attachment.orm.xml</mapping-file> <!--
ATTACHMENT -->
<mapping-file>META-INF/task/BooleanExpression.orm.xml</mapping-file>
<mapping-file>META-INF/task/Comment.orm.xml</mapping-file>
<mapping-file>META-INF/task/Content.orm.xml</mapping-file>
<mapping-file>META-INF/task/Deadline.orm.xml</mapping-file>
<mapping-file>META-INF/task/Deadlines.orm.xml</mapping-file>
<mapping-file>META-INF/task/Delegation.orm.xml</mapping-file>
<mapping-file>META-INF/task/EmailNotification.orm.xml</mapping-file>
<mapping-file>META-INF/task/EmailNotificationHeader.orm.xml</mapping-file>
<mapping-file>META-INF/task/Escalation.orm.xml</mapping-file>
<mapping-file>META-INF/task/Group.orm.xml</mapping-file>
<mapping-file>META-INF/task/I18NText.orm.xml</mapping-file>
<mapping-file>META-INF/task/Notification.orm.xml</mapping-file>
<mapping-file>META-INF/task/OnAllSubTasksEndParentEndStrategy.orm.xml</mapping-file>
<mapping-file>META-INF/task/OnParentAbortAllSubTasksEndStrategy.orm.xml</mapping-file>
<mapping-file>META-INF/task/OrganizationalEntity.orm.xml</mapping-file>
<mapping-file>META-INF/task/PeopleAssignments.orm.xml</mapping-file>
<mapping-file>META-INF/task/Reassignment.orm.xml</mapping-file>
<mapping-file>META-INF/task/SubTasksStrategy.orm.xml</mapping-file>
<mapping-file>META-INF/task/Task.orm.xml</mapping-file> <!-- Task -->
<mapping-file>META-INF/task/TaskData.orm.xml</mapping-file> <!-- Task
Data
-->
<mapping-file>META-INF/task/User.orm.xml</mapping-file>
<properties>
<property name="hibernate.dialect"
value="org.hibernate.dialect.OracleDialect"/>
<property name="hibernate.connection.autocommit"
value="false" />
<property name="hibernate.hbm2ddl.auto"
value="create-drop" />
<property name="hibernate.max_fetch_depth" value="3"/>
<property name="hibernate.show_sql" value="true" />
<!-- TRANSACTION FOR JBOSS -->
<property name="hibernate.transaction.manager_lookup_class"
value="org.hibernate.transaction.JBossTransactionManagerLookup" />
<!-- TRANSACTION FOR TOMCAT>
<property name="hibernate.transaction.manager_lookup_class"
value="org.hibernate.transaction.BTMTransactionManagerLookup"/ -->
</properties>
</persistence-unit>
and I used the orm files provided
I tried it only for the Attachment and the table were created succesfully if
the version is 1.0 in orm file but then i got one-to-many error in the
Deadlines
any ideas
Regards,
Ram
--
View this message in context:
http://drools-java-rules-engine.46999.n3.nabble.com/Drools-Human-Task-Ser...
Sent from the Drools - User mailing list archive at Nabble.com.
8:15 p.m.
This is because I use some features that only ORM 2.0 supported. What
is the version of hibernate entitymanager you are using? I use the
latest 3.6.x and have got no errors. This seems that your hibernate
version expects a fix version of 1.0.
2010/11/26, ramram <ramram858(a)gmail.com>:
Hi all,
I have the following exception on the server intialization after applying
the orm.xml files
18:57:25,144 SEVERE [XMLHelper] Error parsing XML: XML InputStream(5)
cvc-complex-type.3.1: Value '2.0' of attribute 'version' of element
'entity-mappings' is not valid w
ith respect to the corresponding attribute use. Attribute 'version' has a
fixed value of '1.0'.
18:57:25,149 ERROR [STDERR] javax.persistence.PersistenceException:
[PersistenceUnit: org.drools.task] Error while reading JPA XML file:
META-INF/task/Attachment.orm.xml
18:57:25,150 ERROR [STDERR] at
org.hibernate.ejb.Ejb3Configuration.addClassesToSessionFactory(Ejb3Configuration.java:909)
18:57:25,150 ERROR [STDERR] at
org.hibernate.ejb.Ejb3Configuration.configure(Ejb3Configuration.java:758)
18:57:25,153 ERROR [STDERR] at
org.hibernate.ejb.Ejb3Configuration.configure(Ejb3Configuration.java:191)
18:57:25,156 ERROR [STDERR] at
org.hibernate.ejb.Ejb3Configuration.configure(Ejb3Configuration.java:253)
18:57:25,159 ERROR [STDERR] at
org.hibernate.ejb.HibernatePersistence.createEntityManagerFactory(HibernatePersistence.java:125)
18:57:25,163 ERROR [STDERR] at
javax.persistence.Persistence.createEntityManagerFactory(Persistence.java:52)
18:57:25,172 ERROR [STDERR] at
javax.persistence.Persistence.createEntityManagerFactory(Persistence.java:34)
18:57:25,176 ERROR [STDERR] at
com.fp.common.view.util.InitializeTaskService.start(InitializeTaskService.java:39)
18:57:25,178 ERROR [STDERR] at
com.fp.common.view.util.InitializeTaskService.startTaskService(InitializeTaskService.java:30)
18:57:25,186 ERROR [STDERR] at
com.fp.common.view.util.ServerInitialization.contextInitialized(ServerInitialization.java:22)
18:57:25,189 ERROR [STDERR] at
org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3910)
18:57:25,193 ERROR [STDERR] at
org.apache.catalina.core.StandardContext.start(StandardContext.java:4393)
18:57:25,195 ERROR [STDERR] at
org.jboss.web.tomcat.service.deployers.TomcatDeployment.performDeployInternal(TomcatDeployment.java:310)
18:57:25,204 ERROR [STDERR] at
org.jboss.web.tomcat.service.deployers.TomcatDeployment.performDeploy(TomcatDeployment.java:142)
18:57:25,207 ERROR [STDERR] at
org.jboss.web.deployers.AbstractWarDeployment.start(AbstractWarDeployment.java:461)
18:57:25,210 ERROR [STDERR] at
org.jboss.web.deployers.WebModule.startModule(WebModule.java:118)
18:57:25,213 ERROR [STDERR] at
org.jboss.web.deployers.WebModule.start(WebModule.java:97)
persistence.xml
<persistence-unit name="org.drools.task"
transaction-type="RESOURCE_LOCAL">
<provider>org.hibernate.ejb.HibernatePersistence</provider>
<jta-data-source>java:/comp/env/worDS</jta-data-source>
<mapping-file>META-INF/orm.xml</mapping-file>
<mapping-file>META-INF/task/Attachment.orm.xml</mapping-file> <!--
ATTACHMENT -->
<mapping-file>META-INF/task/BooleanExpression.orm.xml</mapping-file>
<mapping-file>META-INF/task/Comment.orm.xml</mapping-file>
<mapping-file>META-INF/task/Content.orm.xml</mapping-file>
<mapping-file>META-INF/task/Deadline.orm.xml</mapping-file>
<mapping-file>META-INF/task/Deadlines.orm.xml</mapping-file>
<mapping-file>META-INF/task/Delegation.orm.xml</mapping-file>
<mapping-file>META-INF/task/EmailNotification.orm.xml</mapping-file>
<mapping-file>META-INF/task/EmailNotificationHeader.orm.xml</mapping-file>
<mapping-file>META-INF/task/Escalation.orm.xml</mapping-file>
<mapping-file>META-INF/task/Group.orm.xml</mapping-file>
<mapping-file>META-INF/task/I18NText.orm.xml</mapping-file>
<mapping-file>META-INF/task/Notification.orm.xml</mapping-file>
<mapping-file>META-INF/task/OnAllSubTasksEndParentEndStrategy.orm.xml</mapping-file>
<mapping-file>META-INF/task/OnParentAbortAllSubTasksEndStrategy.orm.xml</mapping-file>
<mapping-file>META-INF/task/OrganizationalEntity.orm.xml</mapping-file>
<mapping-file>META-INF/task/PeopleAssignments.orm.xml</mapping-file>
<mapping-file>META-INF/task/Reassignment.orm.xml</mapping-file>
<mapping-file>META-INF/task/SubTasksStrategy.orm.xml</mapping-file>
<mapping-file>META-INF/task/Task.orm.xml</mapping-file> <!-- Task
-->
<mapping-file>META-INF/task/TaskData.orm.xml</mapping-file> <!-- Task
Data
-->
<mapping-file>META-INF/task/User.orm.xml</mapping-file>
<properties>
<property name="hibernate.dialect"
value="org.hibernate.dialect.OracleDialect"/>
<property name="hibernate.connection.autocommit"
value="false" />
<property name="hibernate.hbm2ddl.auto"
value="create-drop" />
<property name="hibernate.max_fetch_depth"
value="3"/>
<property name="hibernate.show_sql" value="true"
/>
<!-- TRANSACTION FOR JBOSS -->
<property name="hibernate.transaction.manager_lookup_class"
value="org.hibernate.transaction.JBossTransactionManagerLookup" />
<!-- TRANSACTION FOR TOMCAT>
<property name="hibernate.transaction.manager_lookup_class"
value="org.hibernate.transaction.BTMTransactionManagerLookup"/ -->
</properties>
</persistence-unit>
and I used the orm files provided
I tried it only for the Attachment and the table were created succesfully if
the version is 1.0 in orm file but then i got one-to-many error in the
Deadlines
any ideas
Regards,
Ram
--
View this message in context:
http://drools-java-rules-engine.46999.n3.nabble.com/Drools-Human-Task-Ser...
Sent from the Drools - User mailing list archive at Nabble.com.
_______________________________________________
rules-users mailing list
rules-users(a)lists.jboss.org
https://lists.jboss.org/mailman/listinfo/rules-users
--
从我的移动设备发送
唐睿
3:37 a.m.
Hi tangrui,
I was using the Hibernate 3.3 version once update to Hibernate 3.5.6 it
worked fine and the tables are created thnx 4 ur help.
Regards,
Ram
--
View this message in context:
http://drools-java-rules-engine.46999.n3.nabble.com/Drools-Human-Task-Ser...
Sent from the Drools - User mailing list archive at Nabble.com.
9:25 a.m.
Hi All,
After changing the hibernate from 3.3.0 to 3.5.6 the tables were created
successfully but there is a weired behavior the intialization of the
process:
INFO [STDOUT] [2010:11:330 17:11:605:debug] Message receieved on client :
GetContentResponse
INFO [STDOUT] [2010:11:330 17:11:608:debug] Arguments :
[org.drools.task.Content@cfa55191]
ERROR [STDERR] java.io.StreamCorruptedException: invalid stream header:
00540001
ERROR [STDERR] at
java.io.ObjectInputStream.readStreamHeader(ObjectInputStream.java:783)
ERROR [STDERR] at
java.io.ObjectInputStream.<init>(ObjectInputStream.java:280)
ERROR [STDERR] at
org.drools.process.workitem.wsht.CommandBasedWSHumanTaskHandler$GetResultContentResponseHandler.execute(CommandBasedWSHumanTaskHandler.
ERROR [STDERR] at
org.drools.task.service.TaskClientHandler.messageReceived(TaskClientHandler.java:152)
ERROR [STDERR] at
org.drools.task.service.mina.MinaTaskClientHandler.messageReceived(MinaTaskClientHandler.java:47)
ERROR [STDERR] at
org.apache.mina.core.filterchain.DefaultIoFilterChain$TailFilter.messageReceived(DefaultIoFilterChain.java:752)
ERROR [STDERR] at
org.apache.mina.core.filterchain.DefaultIoFilterChain.callNextMessageReceived(DefaultIoFilterChain.java:414)
ERROR [STDERR] at
org.apache.mina.core.filterchain.DefaultIoFilterChain.access$1200(DefaultIoFilterChain.java:49)
ERROR [STDERR] at
org.apache.mina.core.filterchain.DefaultIoFilterChain$EntryImpl$1.messageReceived(DefaultIoFilterChain.java:832)
ERROR [STDERR] at
org.apache.mina.filter.codec.ProtocolCodecFilter$ProtocolDecoderOutputImpl.flush(ProtocolCodecFilter.java:379)
ERROR [STDERR] at
org.apache.mina.filter.codec.ProtocolCodecFilter.messageReceived(ProtocolCodecFilter.java:173)
ERROR [STDERR] at
org.apache.mina.core.filterchain.DefaultIoFilterChain.callNextMessageReceived(DefaultIoFilterChain.java:414)
ERROR [STDERR] at
org.apache.mina.core.filterchain.DefaultIoFilterChain.access$1200(DefaultIoFilterChain.java:49)
ERROR [STDERR] at
org.apache.mina.core.filterchain.DefaultIoFilterChain$EntryImpl$1.messageReceived(DefaultIoFilterChain.java:832)
ERROR [STDERR] at
org.apache.mina.core.filterchain.DefaultIoFilterChain$HeadFilter.messageReceived(DefaultIoFilterChain.java:616)
ERROR [STDERR] at
org.apache.mina.core.filterchain.DefaultIoFilterChain.callNextMessageReceived(DefaultIoFilterChain.java:414)
ERROR [STDERR] at
org.apache.mina.core.filterchain.DefaultIoFilterChain.fireMessageReceived(DefaultIoFilterChain.java:408)
ERROR [STDERR] at
org.apache.mina.core.polling.AbstractPollingIoProcessor.read(AbstractPollingIoProcessor.java:578)
ERROR [STDERR] at
org.apache.mina.core.polling.AbstractPollingIoProcessor.process(AbstractPollingIoProcessor.java:540)
ERROR [STDERR] at
org.apache.mina.core.polling.AbstractPollingIoProcessor.process(AbstractPollingIoProcessor.java:532)
ERROR [STDERR] at
org.apache.mina.core.polling.AbstractPollingIoProcessor.access$400(AbstractPollingIoProcessor.java:58)
ERROR [STDERR] at
org.apache.mina.core.polling.AbstractPollingIoProcessor$Worker.run(AbstractPollingIoProcessor.java:857)
ERROR [STDERR] at
org.apache.mina.util.NamePreservingRunnable.run(NamePreservingRunnable.java:51)
ERROR [STDERR] at
java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:885)
ERROR [STDERR] at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:907)
ERROR [STDERR] at java.lang.Thread.run(Thread.java:619)
any ideas?
Regards,
Ram
--
View this message in context:
http://drools-java-rules-engine.46999.n3.nabble.com/Drools-Human-Task-Ser...
Sent from the Drools - User mailing list archive at Nabble.com.
6:35 a.m.
Hi tangrui,
i have applied the mapping provided by you and the process as well as the
task functioned well. I tried to change the name of the table provided and
everything worked fine except for the EVENTTYPES table which is still being
created under name of eventTypes what may be cause the problem of this and
how can we add a mapping to it to solve the issue.
Regards,
Ram
--
View this message in context:
http://drools-java-rules-engine.46999.n3.nabble.com/Drools-Human-Task-Ser...
Sent from the Drools - User mailing list archive at Nabble.com.
8:19 a.m.
Sorry for the delayed reply, I almost missed this email.
In the file ProcessInstanceInfo.orm.xml, there's a statement like
<element-collection name="eventTypes"
target-class="java.lang.String">
<column name="F_EVENT_TYPES" />
<collection-table name="DRL5_EVENT_TYPES">
<join-column name="F_PROCESS_INS_ID" />
</collection-table>
</element-collection>
I think you should notice this, but this really does not work, I don't know
why this happens, maybe some bugs of Hibernate.
On Wed, Dec 22, 2010 at 8:35 PM, ramram <ramram858(a)gmail.com> wrote:
Hi tangrui,
i have applied the mapping provided by you and the process as well as the
task functioned well. I tried to change the name of the table provided and
everything worked fine except for the EVENTTYPES table which is still being
created under name of eventTypes what may be cause the problem of this and
how can we add a mapping to it to solve the issue.
Regards,
Ram
--
View this message in context:
http://drools-java-rules-engine.46999.n3.nabble.com/Drools-Human-Task-Ser...
Sent from the Drools - User mailing list archive at Nabble.com.
_______________________________________________
rules-users mailing list
rules-users(a)lists.jboss.org
https://lists.jboss.org/mailman/listinfo/rules-users
--
唐睿
8:04 a.m.
Hi Man,
Thanks for the reply. I have noticed it and I think that it is like u r
stating some bug related to Hibernate. I will try other version of Hibernate
and check its result.
Thnx for the tip and for the help :D
--
View this message in context:
http://drools-java-rules-engine.46999.n3.nabble.com/Drools-Human-Task-Ser...
Sent from the Drools - User mailing list archive at Nabble.com.
8:56 a.m.
Hello,
I'm trying to persist my workflow into an oracle db, I want to use Jboss
transaction manager like you instead of bitronix. It doesn't work with
bitronix transaction manager !
Do you have the code that create your data source java:/comp/env/worDS and
the jndi.properties
With Bitronix I use
PoolingDataSource ds = new PoolingDataSource();
ds.setUniqueName("jdbc/DBD02");
ds.setClassName("oracle.jdbc.xa.client.OracleXADataSource");
ds.setMaxPoolSize(3);
ds.setAllowLocalTransactions(true);
ds.getDriverProperties().put("user", "XXX");
ds.getDriverProperties().put("password", "xxxx");
ds.getDriverProperties().put("URL",
"jdbc:oracle:thin:@gfxdevdb01.fr.world.xxx:1567:DBD02");
ds.init();
I did not find the code to create a jboss data source !
and in jndi.properties
java.naming.factory.initial=bitronix.tm.jndi.BitronixInitialContextFactory
Thank you very much for your help
--
View this message in context:
http://drools.46999.n3.nabble.com/Drools-Human-Task-Service-Persistence-t...
Sent from the Drools: User forum mailing list archive at Nabble.com.
9:49 a.m.
I'm not familiar with JBoss, but as I know, If you use JBoss as your tx
manager, you should not create data sources by code, just config it in the
JBoss way, and change your persistence.xml, just like what ram ram done.
<jta-data-source>java:/comp/env/worDS</jta-data-source>
<!-- TRANSACTION FOR JBOSS -->
<property name="hibernate.transaction.manager_lookup_class"
value="org.hibernate.transaction.JBossTransactionManagerLookup" />
Do you use the whole JBoss AS or only its transaction manager? If the latter
case, you can still use Bitronix datasource or others (like Apache Tomcat
JDBC Connection Pool)
if using Bitronix you can config it like this:
http://docs.codehaus.org/display/BTM/ResourceLoader2x
if using Apache Tomcat JDBC Connection Pool, you can config it like this:
http://people.apache.org/~fhanik/tomcat/jdbc-pool.html
All of these have no code, only config files.
On Thu, May 12, 2011 at 9:56 PM, loumimi <moundir.jamal-ext(a)sgcib.com>wrote:
Hello,
I'm trying to persist my workflow into an oracle db, I want to use Jboss
transaction manager like you instead of bitronix. It doesn't work with
bitronix transaction manager !
Do you have the code that create your data source java:/comp/env/worDS and
the jndi.properties
With Bitronix I use
PoolingDataSource ds = new PoolingDataSource();
ds.setUniqueName("jdbc/DBD02");
ds.setClassName("oracle.jdbc.xa.client.OracleXADataSource");
ds.setMaxPoolSize(3);
ds.setAllowLocalTransactions(true);
ds.getDriverProperties().put("user", "XXX");
ds.getDriverProperties().put("password", "xxxx");
ds.getDriverProperties().put("URL",
"jdbc:oracle:thin:@gfxdevdb01.fr.world.xxx:1567:DBD02");
ds.init();
I did not find the code to create a jboss data source !
and in jndi.properties
java.naming.factory.initial=bitronix.tm.jndi.BitronixInitialContextFactory
Thank you very much for your help
--
View this message in context:
http://drools.46999.n3.nabble.com/Drools-Human-Task-Service-Persistence-t...
Sent from the Drools: User forum mailing list archive at Nabble.com.
_______________________________________________
rules-users mailing list
rules-users(a)lists.jboss.org
https://lists.jboss.org/mailman/listinfo/rules-users
--
唐睿 研发部
深圳市中昱达信息技术有限责任公司
电话：0755-26966586-804
传真：0755-26966586-802
手机：86-18688827156
网址：www.zyeeda.com
地址：深圳市罗湖区金塘街48号蔡屋围丽晶大厦南座1206（518010）
本邮件（包括任何附件）含有专供明确的个人和目的使用的机密信息，并受法律保护。如果您并非指定收件人，请立即删除此邮件及其附件（如有），并勿使用、披露、复制或分发此邮件或据此采取任何行动。
Copyright (c) 2011 ZYEEDA CO., LTD. ALL RIGHTS RESERVED 中昱达公司 版权所有
10:01 a.m.
Thank your for your quick reply,
I'm using only the jboss transaction manager, it works fine for me now, I
can create the session but I have now another bug, it appear when I start
the workFlow
ksession.startProcess( "com.sample.ruleflow" );
Here is my stacktrace
java.lang.NullPointerException
at
org.drools.persistence.processinstance.JPAProcessInstanceManager.addProcessInstance(JPAProcessInstanceManager.java:33)
at
org.drools.common.AbstractWorkingMemory.startProcess(AbstractWorkingMemory.java:1620)
at
org.drools.process.command.StartProcessCommand.execute(StartProcessCommand.java:46)
at
org.drools.process.command.StartProcessCommand.execute(StartProcessCommand.java:10)
at
org.drools.persistence.session.SingleSessionCommandService.execute(SingleSessionCommandService.java:229)
at
org.drools.process.command.impl.CommandBasedStatefulKnowledgeSession.startProcess(CommandBasedStatefulKnowledgeSession.java:163)
at
org.drools.process.command.impl.CommandBasedStatefulKnowledgeSession.startProcess(CommandBasedStatefulKnowledgeSession.java:154)
at com.sample.ProcessTest.main(ProcessTest.java:64)
java.lang.RuntimeException: Could not rollback transaction
at
org.drools.persistence.session.SingleSessionCommandService.execute(SingleSessionCommandService.java:258)
at
org.drools.process.command.impl.CommandBasedStatefulKnowledgeSession.startProcess(CommandBasedStatefulKnowledgeSession.java:163)
at
org.drools.process.command.impl.CommandBasedStatefulKnowledgeSession.startProcess(CommandBasedStatefulKnowledgeSession.java:154)
at com.sample.ProcessTest.main(ProcessTest.java:64)
Caused by: java.lang.RuntimeException: Could not execute command
at
org.drools.persistence.session.SingleSessionCommandService.execute(SingleSessionCommandService.java:255)
... 3 more
Caused by: java.lang.NullPointerException
at
org.drools.persistence.processinstance.JPAProcessInstanceManager.addProcessInstance(JPAProcessInstanceManager.java:33)
at
org.drools.common.AbstractWorkingMemory.startProcess(AbstractWorkingMemory.java:1620)
at
org.drools.process.command.StartProcessCommand.execute(StartProcessCommand.java:46)
at
org.drools.process.command.StartProcessCommand.execute(StartProcessCommand.java:10)
at
org.drools.persistence.session.SingleSessionCommandService.execute(SingleSessionCommandService.java:229)
... 3 more
I think It happen because I did not define a transaction manager in my code
env.set(EnvironmentName.TRANSACTION_MANAGER, XXXX);
I don't know what can I put in instead EnvironmentName.TRANSACTION_MANAGER
of XXXX. Do you have any idea ?
EntityManagerFactory emf = Persistence.createEntityManagerFactory(
"org.drools.persistence.jpa" );
Environment env = KnowledgeBaseFactory.newEnvironment();
env.set( EnvironmentName.ENTITY_MANAGER_FACTORY, emf );
//env.set(EnvironmentName.TRANSACTION_MANAGER, XXXX);
StatefulKnowledgeSession ksession =
JPAKnowledgeService.newStatefulKnowledgeSession( kbase, null, env );
ksession.startProcess( "com.sample.ruleflow" );
ksession.fireAllRules();
ksession.dispose();
Thank you very much
Regards
--
View this message in context:
http://drools.46999.n3.nabble.com/Drools-Human-Task-Service-Persistence-t...
Sent from the Drools: User forum mailing list archive at Nabble.com.
10:16 a.m.
Hi loumimi,
What server are you using?
I have had it working on JBOSS server, the Datasource created was done
using Spring configuration. Please provide more info on your environment and
configuration.
Regards,
Ram
--
View this message in context:
http://drools.46999.n3.nabble.com/Drools-Human-Task-Service-Persistence-t...
Sent from the Drools: User forum mailing list archive at Nabble.com.
10:25 a.m.
Hello Ram,
I'm running a simple J2SE application (a hello world), I'm trying to persist
a simple drools workflow into Oracle DB.
Here's my configuration :
Oracle 10.2.0.4.0
drools-decisiontables-5.0.1.jar
hibernate-core-3.3.0.SP1.jar
...
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.persistence.jpa"
transaction-type="RESOURCE_LOCAL">
<provider>org.hibernate.ejb.HibernatePersistence</provider>
<class>org.drools.persistence.session.SessionInfo</class>
<class>org.drools.persistence.processinstance.ProcessInstanceInfo</class>
<class>org.drools.persistence.processinstance.ProcessInstanceEventInfo</class>
<class>org.drools.persistence.processinstance.WorkItemInfo</class>
<properties>
<property name="hibernate.dialect"
value="org.hibernate.dialect.Oracle10gDialect"/>
<property name="hibernate.connection.driver_class"
value="oracle.jdbc.OracleDriver"/>
<property name="hibernate.connection.url"
value="jdbc:oracle:thin:@gfxdevdb01.fr.world.xxxx:1567:CCOD02"/>
<property name="hibernate.connection.username"
value="xxxx"/>
<property name="hibernate.connection.password"
value="xxxx"/>
<property name="hibernate.connection.autocommit" value="true"
/>
<property name="hibernate.max_fetch_depth" value="3"/>
<property name="hibernate.hbm2ddl.auto" value="update" />
<property name="hibernate.show_sql" value="true" />
<property name="hibernate.transaction.manager_lookup_class"
value="org.hibernate.transaction.JBossTransactionManagerLookup" />
</properties>
</persistence-unit>
</persistence>
----
orm.xml :
<?xml version="1.0" encoding="UTF-8"?>
<entity-mappings xmlns="http://java.sun.com/xml/ns/persistence/orm"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://java.sun.com/xml/ns/persistence/orm orm_1_0.xsd"
version="1.0">
<named-query name="ProcessInstancesWaitingForEvent">
<query>
select
processInstanceInfo.processInstanceId
from
ProcessInstanceInfo processInstanceInfo
where
:type in elements(processInstanceInfo.eventTypes)
</query>
</named-query>
</entity-mappings>
---
the code :
public static final void main(String[] args) {
try {
KnowledgeBuilder kbuilder =
KnowledgeBuilderFactory.newKnowledgeBuilder();
kbuilder.add(ResourceFactory.newClassPathResource("ruleflow.rf"),
ResourceType.DRF);
KnowledgeBuilderErrors errors = kbuilder.getErrors();
if (errors.size() > 0) {
for (KnowledgeBuilderError error: errors) {
System.err.println(error);
}
throw new IllegalArgumentException("Could not parse
knowledge.");
}
KnowledgeBase kbase = KnowledgeBaseFactory.newKnowledgeBase();
kbase.addKnowledgePackages(kbuilder.getKnowledgePackages());
// create the entity manager factory and register it in the
environment
EntityManagerFactory emf = Persistence.createEntityManagerFactory(
"org.drools.persistence.jpa" );
Environment env = KnowledgeBaseFactory.newEnvironment();
env.set( EnvironmentName.ENTITY_MANAGER_FACTORY, emf );
// env.set( EnvironmentName.TRANSACTION_MANAGER, XXXXXXXXXXX );
// create a new knowledge session that uses JPA to store the runtime
state
StatefulKnowledgeSession ksession =
JPAKnowledgeService.newStatefulKnowledgeSession( kbase, null, env );
// invoke methods on your method here
ksession.startProcess( "com.sample.ruleflow" );
ksession.fireAllRules();
ksession.dispose();
} catch (Throwable t) {
t.printStackTrace();
}
}
I don't know If I miss something
--
View this message in context:
http://drools.46999.n3.nabble.com/Drools-Human-Task-Service-Persistence-t...
Sent from the Drools: User forum mailing list archive at Nabble.com.
8:57 p.m.
Drools Persistence JPA module must use JTA instead of local transaction.
<persistence-unit name="org.drools.persistence.jpa"
transaction-type="RESOURCE_LOCAL">
should change to
<persistence-unit name="default" transaction-type="JTA">
and
env.set( EnvironmentName.TRANSACTION_MANAGER, XXXXXXXXXXX );
your transaction manager should be get from JNDI like
UserTransaction utx = (UserTransaction)
ctx.lookup("java:comp/UserTransaction");
Your JBoss transaction manager component should register the UserTransaction
into that JNDO name. (In some JTA implementations the UserTransaction and
TransactionManager have the same interfaces). And to make Drools Persistence
JPA works, you should put 4 or 5 objects into env, they are:
env.set(EnvironmentName.ENTITY_MANAGER_FACTORY,
this.defaultPersistenceSvc.getSessionFactory());
env.set(EnvironmentName.APP_SCOPED_ENTITY_MANAGER,
this.defaultPersistenceSvc.getCurrentSession()); // If you don't handle the
EntityManager your self, you can omit this line.
env.set(EnvironmentName.TRANSACTION_MANAGER,
this.txSvc.getTransactionManager()); // java:comp/env/TransactionManager
env.set(EnvironmentName.TRANSACTION, this.txSvc.getTransaction()); //
java:comp/UserTransaction
env.set(EnvironmentName.TRANSACTION_SYNCHRONIZATION_REGISTRY,
this.txSvc.getTransactionSynchronizationRegistry()); //
java:comp/env/TransactionSynchronizationRegistry
all the methods called from txSvc fetch objects from according JNDI. In my
application all these JNDI objects are config-ed via Tomcat like this (in
META-INF/context.xml):
<Resource name="jdbc/defaultDS" auth="Container"
type="javax.sql.XADataSource"
factory="bitronix.tm.resource.ResourceObjectFactory"
uniqueName="jdbc/defaultDS" />
<Resource name="jdbc/droolsTaskDS" auth="Container"
type="javax.sql.XADataSource"
factory="bitronix.tm.resource.ResourceObjectFactory"
uniqueName="jdbc/droolsTaskDS" />
<Resource name="TransactionManager" auth="Container"
type="javax.transaction.TransactionManager"
factory="bitronix.tm.BitronixTransactionManagerObjectFactory" />
<Resource name="TransactionSynchronizationRegistry"
auth="Container"
type="javax.transaction.TransactionSynchronizationRegistry"
factory="bitronix.tm.BitronixTransactionSynchronizationRegistryObjectFactory"
/>
<Resource name="UserTransaction" auth="Container"
type="javax.transaction.UserTransaction" />
<Transaction factory="bitronix.tm.BitronixUserTransactionObjectFactory"
/>
On Thu, May 12, 2011 at 11:25 PM, loumimi <moundir.jamal-ext(a)sgcib.com>wrote:
Hello Ram,
I'm running a simple J2SE application (a hello world), I'm trying to
persist
a simple drools workflow into Oracle DB.
Here's my configuration :
Oracle 10.2.0.4.0
drools-decisiontables-5.0.1.jar
hibernate-core-3.3.0.SP1.jar
...
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.persistence.jpa"
transaction-type="RESOURCE_LOCAL">
<provider>org.hibernate.ejb.HibernatePersistence</provider>
<class>org.drools.persistence.session.SessionInfo</class>
<class>org.drools.persistence.processinstance.ProcessInstanceInfo</class>
<class>org.drools.persistence.processinstance.ProcessInstanceEventInfo</class>
<class>org.drools.persistence.processinstance.WorkItemInfo</class>
<properties>
<property name="hibernate.dialect"
value="org.hibernate.dialect.Oracle10gDialect"/>
<property name="hibernate.connection.driver_class"
value="oracle.jdbc.OracleDriver"/>
<property name="hibernate.connection.url"
value="jdbc:oracle:thin:@gfxdevdb01.fr.world.xxxx:1567:CCOD02"/>
<property name="hibernate.connection.username"
value="xxxx"/>
<property name="hibernate.connection.password"
value="xxxx"/>
<property name="hibernate.connection.autocommit" value="true"
/>
<property name="hibernate.max_fetch_depth" value="3"/>
<property name="hibernate.hbm2ddl.auto" value="update"
/>
<property name="hibernate.show_sql" value="true" />
<property name="hibernate.transaction.manager_lookup_class"
value="org.hibernate.transaction.JBossTransactionManagerLookup" />
</properties>
</persistence-unit>
</persistence>
----
orm.xml :
<?xml version="1.0" encoding="UTF-8"?>
<entity-mappings xmlns="http://java.sun.com/xml/ns/persistence/orm"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://java.sun.com/xml/ns/persistence/ormorm_1_...
version="1.0">
<named-query name="ProcessInstancesWaitingForEvent">
<query>
select
processInstanceInfo.processInstanceId
from
ProcessInstanceInfo processInstanceInfo
where
:type in elements(processInstanceInfo.eventTypes)
</query>
</named-query>
</entity-mappings>
---
the code :
public static final void main(String[] args) {
try {
KnowledgeBuilder kbuilder =
KnowledgeBuilderFactory.newKnowledgeBuilder();
kbuilder.add(ResourceFactory.newClassPathResource("ruleflow.rf"),
ResourceType.DRF);
KnowledgeBuilderErrors errors = kbuilder.getErrors();
if (errors.size() > 0) {
for (KnowledgeBuilderError error: errors) {
System.err.println(error);
}
throw new IllegalArgumentException("Could not parse
knowledge.");
}
KnowledgeBase kbase = KnowledgeBaseFactory.newKnowledgeBase();
kbase.addKnowledgePackages(kbuilder.getKnowledgePackages());
// create the entity manager factory and register it in the
environment
EntityManagerFactory emf =
Persistence.createEntityManagerFactory(
"org.drools.persistence.jpa" );
Environment env = KnowledgeBaseFactory.newEnvironment();
env.set( EnvironmentName.ENTITY_MANAGER_FACTORY, emf );
// env.set( EnvironmentName.TRANSACTION_MANAGER,
XXXXXXXXXXX );
// create a new knowledge session that uses JPA to store
the runtime
state
StatefulKnowledgeSession ksession =
JPAKnowledgeService.newStatefulKnowledgeSession( kbase, null, env );
// invoke methods on your method here
ksession.startProcess( "com.sample.ruleflow" );
ksession.fireAllRules();
ksession.dispose();
} catch (Throwable t) {
t.printStackTrace();
}
}
I don't know If I miss something
--
View this message in context:
http://drools.46999.n3.nabble.com/Drools-Human-Task-Service-Persistence-t...
Sent from the Drools: User forum mailing list archive at Nabble.com.
_______________________________________________
rules-users mailing list
rules-users(a)lists.jboss.org
https://lists.jboss.org/mailman/listinfo/rules-users
--
唐睿 研发部
深圳市中昱达信息技术有限责任公司
电话：0755-26966586-804
传真：0755-26966586-802
手机：86-18688827156
网址：www.zyeeda.com
地址：深圳市罗湖区金塘街48号蔡屋围丽晶大厦南座1206（518010）
本邮件（包括任何附件）含有专供明确的个人和目的使用的机密信息，并受法律保护。如果您并非指定收件人，请立即删除此邮件及其附件（如有），并勿使用、披露、复制或分发此邮件或据此采取任何行动。
Copyright (c) 2011 ZYEEDA CO., LTD. ALL RIGHTS RESERVED 中昱达公司 版权所有
8:47 a.m.
Hello,
I switch from drools 5.0.1 to drools 5.1.0, the problem is resolved, I used the bitronix
transaction manager, I kept transaction-type="RESOURCE_LOCAL". So every things
seem to be good, I have no exception.
But no data is persisted in my database. So I tried to change de transaction type to JTA
but I m getting the exception bellow :
SEVERE: an assertion failure occured (this may indicate a bug in Hibernate, but is more
likely due to unsafe use of the session)
org.hibernate.AssertionFailure: Transaction MARKED_FOR_JOINED after isOpen() call
at
org.hibernate.ejb.AbstractEntityManagerImpl.joinTransaction(AbstractEntityManagerImpl.java:465)
at
org.hibernate.ejb.AbstractEntityManagerImpl.postInit(AbstractEntityManagerImpl.java:82)
at org.hibernate.ejb.EntityManagerImpl.<init>(EntityManagerImpl.java:61)
at
org.hibernate.ejb.EntityManagerFactoryImpl.createEntityManager(EntityManagerFactoryImpl.java:39)
at
org.hibernate.ejb.EntityManagerFactoryImpl.createEntityManager(EntityManagerFactoryImpl.java:34)
at
org.drools.persistence.session.DefaultJpaManager.getApplicationScopedEntityManager(DefaultJpaManager.java:37)
at
org.drools.persistence.session.SingleSessionCommandService.<init>(SingleSessionCommandService.java:124)
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
at java.lang.reflect.Constructor.newInstance(Unknown Source)
at
org.drools.persistence.jpa.impl.KnowledgeStoreServiceImpl.buildCommanService(KnowledgeStoreServiceImpl.java:119)
at
org.drools.persistence.jpa.impl.KnowledgeStoreServiceImpl.newStatefulKnowledgeSession(KnowledgeStoreServiceImpl.java:57)
at
org.drools.persistence.jpa.JPAKnowledgeService.newStatefulKnowledgeSession(JPAKnowledgeService.java:109)
at com.sample.ProcessTest.main(ProcessTest.java:69)
java.lang.IllegalStateException: java.lang.reflect.InvocationTargetException
at
org.drools.persistence.jpa.impl.KnowledgeStoreServiceImpl.buildCommanService(KnowledgeStoreServiceImpl.java:133)
at
org.drools.persistence.jpa.impl.KnowledgeStoreServiceImpl.newStatefulKnowledgeSession(KnowledgeStoreServiceImpl.java:57)
at
org.drools.persistence.jpa.JPAKnowledgeService.newStatefulKnowledgeSession(JPAKnowledgeService.java:109)
at com.sample.ProcessTest.main(ProcessTest.java:69)
Caused by: java.lang.reflect.InvocationTargetException
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
at java.lang.reflect.Constructor.newInstance(Unknown Source)
at
org.drools.persistence.jpa.impl.KnowledgeStoreServiceImpl.buildCommanService(KnowledgeStoreServiceImpl.java:119)
... 3 more
Caused by: java.lang.RuntimeException: Could not commit session
at
org.drools.persistence.session.SingleSessionCommandService.<init>(SingleSessionCommandService.java:135)
... 8 more
Caused by: org.hibernate.AssertionFailure: Transaction MARKED_FOR_JOINED after isOpen()
call
at
org.hibernate.ejb.AbstractEntityManagerImpl.joinTransaction(AbstractEntityManagerImpl.java:465)
at
org.hibernate.ejb.AbstractEntityManagerImpl.postInit(AbstractEntityManagerImpl.java:82)
at org.hibernate.ejb.EntityManagerImpl.<init>(EntityManagerImpl.java:61)
at
org.hibernate.ejb.EntityManagerFactoryImpl.createEntityManager(EntityManagerFactoryImpl.java:39)
at
org.hibernate.ejb.EntityManagerFactoryImpl.createEntityManager(EntityManagerFactoryImpl.java:34)
at
org.drools.persistence.session.DefaultJpaManager.getApplicationScopedEntityManager(DefaultJpaManager.java:37)
at
org.drools.persistence.session.SingleSessionCommandService.<init>(SingleSessionCommandService.java:124)
... 8 more
I tried to add the objects you mentioned, I added only 3, I didn’t add
env.set(EnvironmentName.TRANSACTION_SYNCHRONIZATION_REGISTRY,
this.txSvc.getTransactionSynchronizationRegistry());
because
new InitialContext().lookup( "java:comp/env/TransactionSynchronizationRegistry"
);
Return null even I add
javax.transaction.TransactionSynchronizationRegistry =
bitronix.tm.BitronixTransactionSynchronizationRegistryObjectFactory
in my jndi.properties file
here is my code
UserTransaction ut = (UserTransaction) new InitialContext().lookup(
"java:comp/UserTransaction" );
// create the entity manager factory and register it in the environment
EntityManagerFactory emf = Persistence.createEntityManagerFactory(
"org.drools.persistence.jpa" );
Environment env = KnowledgeBaseFactory.newEnvironment();
env.set( EnvironmentName.ENTITY_MANAGER_FACTORY, emf );
env.set(EnvironmentName.TRANSACTION_MANAGER,
TransactionManagerServices.getTransactionManager());
env.set(EnvironmentName.GLOBALS, new MapGlobalResolver());
env.set(EnvironmentName.TRANSACTION, ut);
//TransactionSynchronizationRegistryHelper tsr =
(TransactionSynchronizationRegistryHelper) new InitialContext().lookup(
"java:comp/env/TransactionSynchronizationRegistry" );
// env.set(EnvironmentName.TRANSACTION_SYNCHRONIZATION_REGISTRY, tsr );
// create a new knowledge session that uses JPA to store the runtime
state
StatefulKnowledgeSession ksession =
JPAKnowledgeService.newStatefulKnowledgeSession( kbase, null, env );
// start the transaction
ut.begin();
// invoke methods on your method here
ProcessInstance process = ksession.startProcess(
"com.sample.ruleflow" );
ksession.signalEvent("Test", "Test",
process.getId());
ut.commit();
ut.begin();
ksession.fireAllRules();
// commit the transaction
ut.commit();
ksession.dispose();
any idea ?
Thanks
Regards,
From: rules-users-bounces(a)lists.jboss.org [mailto:rules-users-bounces@lists.jboss.org] On
Behalf Of Rui Tang
Sent: Friday,May 13,2011 3:58 AM
To: Rules Users List
Subject: Re: [rules-users] Drools Human Task Service Persistence
Drools Persistence JPA module must use JTA instead of local transaction.
<persistence-unit name="org.drools.persistence.jpa"
transaction-type="RESOURCE_LOCAL">
should change to
<persistence-unit name="default" transaction-type="JTA">
and
env.set( EnvironmentName.TRANSACTION_MANAGER, XXXXXXXXXXX );
your transaction manager should be get from JNDI like
UserTransaction utx = (UserTransaction)
ctx.lookup("java:comp/UserTransaction");
Your JBoss transaction manager component should register the UserTransaction into that
JNDO name. (In some JTA implementations the UserTransaction and TransactionManager have
the same interfaces). And to make Drools Persistence JPA works, you should put 4 or 5
objects into env, they are:
env.set(EnvironmentName.ENTITY_MANAGER_FACTORY,
this.defaultPersistenceSvc.getSessionFactory());
env.set(EnvironmentName.APP_SCOPED_ENTITY_MANAGER,
this.defaultPersistenceSvc.getCurrentSession()); // If you don't handle the
EntityManager your self, you can omit this line.
env.set(EnvironmentName.TRANSACTION_MANAGER, this.txSvc.getTransactionManager()); //
java:comp/env/TransactionManager
env.set(EnvironmentName.TRANSACTION, this.txSvc.getTransaction()); //
java:comp/UserTransaction
env.set(EnvironmentName.TRANSACTION_SYNCHRONIZATION_REGISTRY,
this.txSvc.getTransactionSynchronizationRegistry()); //
java:comp/env/TransactionSynchronizationRegistry
all the methods called from txSvc fetch objects from according JNDI. In my application all
these JNDI objects are config-ed via Tomcat like this (in META-INF/context.xml):
<Resource name="jdbc/defaultDS" auth="Container"
type="javax.sql.XADataSource"
factory="bitronix.tm.resource.ResourceObjectFactory"
uniqueName="jdbc/defaultDS" />
<Resource name="jdbc/droolsTaskDS" auth="Container"
type="javax.sql.XADataSource"
factory="bitronix.tm.resource.ResourceObjectFactory"
uniqueName="jdbc/droolsTaskDS" />
<Resource name="TransactionManager" auth="Container"
type="javax.transaction.TransactionManager"
factory="bitronix.tm.BitronixTransactionManagerObjectFactory" />
<Resource name="TransactionSynchronizationRegistry"
auth="Container"
type="javax.transaction.TransactionSynchronizationRegistry"
factory="bitronix.tm.BitronixTransactionSynchronizationRegistryObjectFactory"
/>
<Resource name="UserTransaction" auth="Container"
type="javax.transaction.UserTransaction" />
<Transaction factory="bitronix.tm.BitronixUserTransactionObjectFactory"
/>
On Thu, May 12, 2011 at 11:25 PM, loumimi
<moundir.jamal-ext@sgcib.com<mailto:moundir.jamal-ext@sgcib.com>> wrote:
Hello Ram,
I'm running a simple J2SE application (a hello world), I'm trying to persist
a simple drools workflow into Oracle DB.
Here's my configuration :
Oracle 10.2.0.4.0
drools-decisiontables-5.0.1.jar
hibernate-core-3.3.0.SP1.jar
...
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.persistence.jpa"
transaction-type="RESOURCE_LOCAL">
<provider>org.hibernate.ejb.HibernatePersistence</provider>
<class>org.drools.persistence.session.SessionInfo</class>
<class>org.drools.persistence.processinstance.ProcessInstanceInfo</class>
<class>org.drools.persistence.processinstance.ProcessInstanceEventInfo</class>
<class>org.drools.persistence.processinstance.WorkItemInfo</class>
<properties>
<property name="hibernate.dialect"
value="org.hibernate.dialect.Oracle10gDialect"/>
<property name="hibernate.connection.driver_class"
value="oracle.jdbc.OracleDriver"/>
<property name="hibernate.connection.url"
value="jdbc:oracle:thin:@gfxdevdb01.fr.world.xxxx:1567:CCOD02"/>
<property name="hibernate.connection.username"
value="xxxx"/>
<property name="hibernate.connection.password"
value="xxxx"/>
<property name="hibernate.connection.autocommit" value="true"
/>
<property name="hibernate.max_fetch_depth" value="3"/>
<property name="hibernate.hbm2ddl.auto" value="update" />
<property name="hibernate.show_sql" value="true" />
<property name="hibernate.transaction.manager_lookup_class"
value="org.hibernate.transaction.JBossTransactionManagerLookup" />
</properties>
</persistence-unit>
</persistence>
----
orm.xml :
<?xml version="1.0" encoding="UTF-8"?>
<entity-mappings xmlns="http://java.sun.com/xml/ns/persistence/orm"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://java.sun.com/xml/ns/persistence/orm orm_1_0.xsd"
version="1.0">
<named-query name="ProcessInstancesWaitingForEvent">
<query>
select
processInstanceInfo.processInstanceId
from
ProcessInstanceInfo processInstanceInfo
where
:type in elements(processInstanceInfo.eventTypes)
</query>
</named-query>
</entity-mappings>
---
the code :
public static final void main(String[] args) {
try {
KnowledgeBuilder kbuilder =
KnowledgeBuilderFactory.newKnowledgeBuilder();
kbuilder.add(ResourceFactory.newClassPathResource("ruleflow.rf"),
ResourceType.DRF);
KnowledgeBuilderErrors errors = kbuilder.getErrors();
if (errors.size() > 0) {
for (KnowledgeBuilderError error: errors) {
System.err.println(error);
}
throw new IllegalArgumentException("Could not parse
knowledge.");
}
KnowledgeBase kbase = KnowledgeBaseFactory.newKnowledgeBase();
kbase.addKnowledgePackages(kbuilder.getKnowledgePackages());
// create the entity manager factory and register it in the
environment
EntityManagerFactory emf = Persistence.createEntityManagerFactory(
"org.drools.persistence.jpa" );
Environment env = KnowledgeBaseFactory.newEnvironment();
env.set( EnvironmentName.ENTITY_MANAGER_FACTORY, emf );
// env.set( EnvironmentName.TRANSACTION_MANAGER, XXXXXXXXXXX );
// create a new knowledge session that uses JPA to store the runtime
state
StatefulKnowledgeSession ksession =
JPAKnowledgeService.newStatefulKnowledgeSession( kbase, null, env );
// invoke methods on your method here
ksession.startProcess( "com.sample.ruleflow" );
ksession.fireAllRules();
ksession.dispose();
} catch (Throwable t) {
t.printStackTrace();
}
}
I don't know If I miss something
--
View this message in context:
http://drools.46999.n3.nabble.com/Drools-Human-Task-Service-Persistence-t...
Sent from the Drools: User forum mailing list archive at Nabble.com.
_______________________________________________
rules-users mailing list
rules-users@lists.jboss.org<mailto:rules-users@lists.jboss.org>
https://lists.jboss.org/mailman/listinfo/rules-users
--
唐睿 研发部
深圳市中昱达信息技术有限责任公司
电话：0755-26966586-804
传真：0755-26966586-802
手机：86-18688827156
网址：www.zyeeda.com<http://www.zyeeda.com/>
地址：深圳市罗湖区金塘街48号蔡屋围丽晶大厦南座1206（518010）
本邮件（包括任何附件）含有专供明确的个人和目的使用的机密信息，并受法律保护。如果您并非指定收件人，请立即删除此邮件及其附件（如有），并勿使用、披露、复制或分发此邮件或据此采取任何行动。
Copyright © 2011 ZYEEDA CO., LTD. ALL RIGHTS RESERVED 中昱达公司 版权所有
*************************************************************************
This message and any attachments (the "message") are confidential, intended
solely for the addressee(s), and may contain legally privileged information.
Any unauthorised use or dissemination is prohibited. E-mails are susceptible to
alteration.
Neither SOCIETE GENERALE nor any of its subsidiaries or affiliates shall be liable for the
message if altered, changed or
falsified.
************
Ce message et toutes les pieces jointes (ci-apres le "message") sont
confidentiels et susceptibles de contenir des informations couvertes
par le secret professionnel.
Ce message est etabli a l'intention exclusive de ses destinataires. Toute utilisation
ou diffusion non autorisee est interdite.
Tout message electronique est susceptible d'alteration.
La SOCIETE GENERALE et ses filiales declinent toute responsabilite au titre de ce message
s'il a ete altere, deforme ou falsifie.
*************************************************************************
11:56 a.m.
Hello,
I switch from drools 5.0.1 to drools 5.1.0, the problem is resolved, I m
using the bitronix transaction manager, I kept transaction-type to
"RESOURCE_LOCAL". So every things seem to be good, I have no exception.
But no data is persisted in my database. So I tried to change the
transaction type to JTA but I m getting the exception bellow :
SEVERE: an assertion failure occured (this may indicate a bug in Hibernate,
but is more likely due to unsafe use of the session)
org.hibernate.AssertionFailure: Transaction MARKED_FOR_JOINED after isOpen()
call
at
org.hibernate.ejb.AbstractEntityManagerImpl.joinTransaction(AbstractEntityManagerImpl.java:465)
at
org.hibernate.ejb.AbstractEntityManagerImpl.postInit(AbstractEntityManagerImpl.java:82)
at
org.hibernate.ejb.EntityManagerImpl.<init>(EntityManagerImpl.java:61)
at
org.hibernate.ejb.EntityManagerFactoryImpl.createEntityManager(EntityManagerFactoryImpl.java:39)
at
org.hibernate.ejb.EntityManagerFactoryImpl.createEntityManager(EntityManagerFactoryImpl.java:34)
at
org.drools.persistence.session.DefaultJpaManager.getApplicationScopedEntityManager(DefaultJpaManager.java:37)
at
org.drools.persistence.session.SingleSessionCommandService.<init>(SingleSessionCommandService.java:124)
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native
Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown
Source)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown
Source)
at java.lang.reflect.Constructor.newInstance(Unknown Source)
at
org.drools.persistence.jpa.impl.KnowledgeStoreServiceImpl.buildCommanService(KnowledgeStoreServiceImpl.java:119)
at
org.drools.persistence.jpa.impl.KnowledgeStoreServiceImpl.newStatefulKnowledgeSession(KnowledgeStoreServiceImpl.java:57)
at
org.drools.persistence.jpa.JPAKnowledgeService.newStatefulKnowledgeSession(JPAKnowledgeService.java:109)
at com.sample.ProcessTest.main(ProcessTest.java:69)
java.lang.IllegalStateException: java.lang.reflect.InvocationTargetException
at
org.drools.persistence.jpa.impl.KnowledgeStoreServiceImpl.buildCommanService(KnowledgeStoreServiceImpl.java:133)
at
org.drools.persistence.jpa.impl.KnowledgeStoreServiceImpl.newStatefulKnowledgeSession(KnowledgeStoreServiceImpl.java:57)
at
org.drools.persistence.jpa.JPAKnowledgeService.newStatefulKnowledgeSession(JPAKnowledgeService.java:109)
at com.sample.ProcessTest.main(ProcessTest.java:69)
Caused by: java.lang.reflect.InvocationTargetException
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native
Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown
Source)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown
Source)
at java.lang.reflect.Constructor.newInstance(Unknown Source)
at
org.drools.persistence.jpa.impl.KnowledgeStoreServiceImpl.buildCommanService(KnowledgeStoreServiceImpl.java:119)
... 3 more
Caused by: java.lang.RuntimeException: Could not commit session
at
org.drools.persistence.session.SingleSessionCommandService.<init>(SingleSessionCommandService.java:135)
... 8 more
Caused by: org.hibernate.AssertionFailure: Transaction MARKED_FOR_JOINED
after isOpen() call
at
org.hibernate.ejb.AbstractEntityManagerImpl.joinTransaction(AbstractEntityManagerImpl.java:465)
at
org.hibernate.ejb.AbstractEntityManagerImpl.postInit(AbstractEntityManagerImpl.java:82)
at
org.hibernate.ejb.EntityManagerImpl.<init>(EntityManagerImpl.java:61)
at
org.hibernate.ejb.EntityManagerFactoryImpl.createEntityManager(EntityManagerFactoryImpl.java:39)
at
org.hibernate.ejb.EntityManagerFactoryImpl.createEntityManager(EntityManagerFactoryImpl.java:34)
at
org.drools.persistence.session.DefaultJpaManager.getApplicationScopedEntityManager(DefaultJpaManager.java:37)
at
org.drools.persistence.session.SingleSessionCommandService.<init>(SingleSessionCommandService.java:124)
... 8 more
I tried to add the objects you mentioned, I added only 3, I didn’t add
env.set(EnvironmentName.TRANSACTION_SYNCHRONIZATION_REGISTRY,
this.txSvc.getTransactionSynchronizationRegistry());
because
new InitialContext().lookup(
"java:comp/env/TransactionSynchronizationRegistry" );
Return null even I add
javax.transaction.TransactionSynchronizationRegistry =
bitronix.tm.BitronixTransactionSynchronizationRegistryObjectFactory
in my jndi.properties file
here is my code
UserTransaction ut = (UserTransaction) new InitialContext().lookup(
"java:comp/UserTransaction" );
// create the entity manager factory and register it in the
environment
EntityManagerFactory emf =
Persistence.createEntityManagerFactory( "org.drools.persistence.jpa" );
Environment env = KnowledgeBaseFactory.newEnvironment();
env.set( EnvironmentName.ENTITY_MANAGER_FACTORY, emf );
env.set(EnvironmentName.TRANSACTION_MANAGER,
TransactionManagerServices.getTransactionManager());
env.set(EnvironmentName.GLOBALS, new MapGlobalResolver());
env.set(EnvironmentName.TRANSACTION, ut);
//TransactionSynchronizationRegistryHelper tsr =
(TransactionSynchronizationRegistryHelper) new InitialContext().lookup(
"java:comp/env/TransactionSynchronizationRegistry" );
//
env.set(EnvironmentName.TRANSACTION_SYNCHRONIZATION_REGISTRY, tsr );
// create a new knowledge session that uses JPA to store the
runtime state
StatefulKnowledgeSession ksession =
JPAKnowledgeService.newStatefulKnowledgeSession( kbase, null, env );
// start the transaction
ut.begin();
// invoke methods on your method here
ProcessInstance process = ksession.startProcess(
"com.sample.ruleflow" );
ksession.signalEvent("Test", "Test",
process.getId());
ut.commit();
ut.begin();
ksession.fireAllRules();
// commit the transaction
ut.commit();
ksession.dispose();
any idea ?
Thanks
Regards,
From: rules-users-bounces(a)lists.jboss.org
[mailto:rules-users-bounces@lists.jboss.org] On Behalf Of Rui Tang
Sent: Friday,May 13,2011 3:58 AM
To: Rules Users List
Subject: Re: [rules-users] Drools Human Task Service Persistence
Drools Persistence JPA module must use JTA instead of local transaction.
<persistence-unit name="org.drools.persistence.jpa"
transaction-type="RESOURCE_LOCAL">
should change to
<persistence-unit name="default" transaction-type="JTA">
and
env.set( EnvironmentName.TRANSACTION_MANAGER, XXXXXXXXXXX );
your transaction manager should be get from JNDI like
UserTransaction utx = (UserTransaction)
ctx.lookup("java:comp/UserTransaction");
Your JBoss transaction manager component should register the UserTransaction
into that JNDO name. (In some JTA implementations the UserTransaction and
TransactionManager have the same interfaces). And to make Drools Persistence
JPA works, you should put 4 or 5 objects into env, they are:
env.set(EnvironmentName.ENTITY_MANAGER_FACTORY,
this.defaultPersistenceSvc.getSessionFactory());
env.set(EnvironmentName.APP_SCOPED_ENTITY_MANAGER,
this.defaultPersistenceSvc.getCurrentSession()); // If you don't handle the
EntityManager your self, you can omit this line.
env.set(EnvironmentName.TRANSACTION_MANAGER,
this.txSvc.getTransactionManager()); // java:comp/env/TransactionManager
env.set(EnvironmentName.TRANSACTION, this.txSvc.getTransaction()); //
java:comp/UserTransaction
env.set(EnvironmentName.TRANSACTION_SYNCHRONIZATION_REGISTRY,
this.txSvc.getTransactionSynchronizationRegistry()); //
java:comp/env/TransactionSynchronizationRegistry
all the methods called from txSvc fetch objects from according JNDI. In my
application all these JNDI objects are config-ed via Tomcat like this (in
META-INF/context.xml):
<Resource name="jdbc/defaultDS" auth="Container"
type="javax.sql.XADataSource"
factory="bitronix.tm.resource.ResourceObjectFactory"
uniqueName="jdbc/defaultDS" />
<Resource name="jdbc/droolsTaskDS" auth="Container"
type="javax.sql.XADataSource"
factory="bitronix.tm.resource.ResourceObjectFactory"
uniqueName="jdbc/droolsTaskDS" />
<Resource name="TransactionManager" auth="Container"
type="javax.transaction.TransactionManager"
factory="bitronix.tm.BitronixTransactionManagerObjectFactory" />
<Resource name="TransactionSynchronizationRegistry"
auth="Container"
type="javax.transaction.TransactionSynchronizationRegistry"
factory="bitronix.tm.BitronixTransactionSynchronizationRegistryObjectFactory"
/>
<Resource name="UserTransaction" auth="Container"
type="javax.transaction.UserTransaction" />
<Transaction factory="bitronix.tm.BitronixUserTransactionObjectFactory"
/>
--
View this message in context:
http://drools.46999.n3.nabble.com/Drools-Human-Task-Service-Persistence-t...
Sent from the Drools: User forum mailing list archive at Nabble.com.
1:31 a.m.
Please try to move ut.begin() before you newStatefulKnowledgeSession.
On Sat, May 14, 2011 at 12:56 AM, loumimi <moundir.jamal-ext(a)sgcib.com>wrote:
Hello,
I switch from drools 5.0.1 to drools 5.1.0, the problem is resolved, I m
using the bitronix transaction manager, I kept transaction-type to
"RESOURCE_LOCAL". So every things seem to be good, I have no exception.
But no data is persisted in my database. So I tried to change the
transaction type to JTA but I m getting the exception bellow :
SEVERE: an assertion failure occured (this may indicate a bug in Hibernate,
but is more likely due to unsafe use of the session)
org.hibernate.AssertionFailure: Transaction MARKED_FOR_JOINED after
isOpen()
call
at
org.hibernate.ejb.AbstractEntityManagerImpl.joinTransaction(AbstractEntityManagerImpl.java:465)
at
org.hibernate.ejb.AbstractEntityManagerImpl.postInit(AbstractEntityManagerImpl.java:82)
at
org.hibernate.ejb.EntityManagerImpl.<init>(EntityManagerImpl.java:61)
at
org.hibernate.ejb.EntityManagerFactoryImpl.createEntityManager(EntityManagerFactoryImpl.java:39)
at
org.hibernate.ejb.EntityManagerFactoryImpl.createEntityManager(EntityManagerFactoryImpl.java:34)
at
org.drools.persistence.session.DefaultJpaManager.getApplicationScopedEntityManager(DefaultJpaManager.java:37)
at
org.drools.persistence.session.SingleSessionCommandService.<init>(SingleSessionCommandService.java:124)
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native
Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown
Source)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown
Source)
at java.lang.reflect.Constructor.newInstance(Unknown Source)
at
org.drools.persistence.jpa.impl.KnowledgeStoreServiceImpl.buildCommanService(KnowledgeStoreServiceImpl.java:119)
at
org.drools.persistence.jpa.impl.KnowledgeStoreServiceImpl.newStatefulKnowledgeSession(KnowledgeStoreServiceImpl.java:57)
at
org.drools.persistence.jpa.JPAKnowledgeService.newStatefulKnowledgeSession(JPAKnowledgeService.java:109)
at com.sample.ProcessTest.main(ProcessTest.java:69)
java.lang.IllegalStateException:
java.lang.reflect.InvocationTargetException
at
org.drools.persistence.jpa.impl.KnowledgeStoreServiceImpl.buildCommanService(KnowledgeStoreServiceImpl.java:133)
at
org.drools.persistence.jpa.impl.KnowledgeStoreServiceImpl.newStatefulKnowledgeSession(KnowledgeStoreServiceImpl.java:57)
at
org.drools.persistence.jpa.JPAKnowledgeService.newStatefulKnowledgeSession(JPAKnowledgeService.java:109)
at com.sample.ProcessTest.main(ProcessTest.java:69)
Caused by: java.lang.reflect.InvocationTargetException
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native
Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown
Source)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown
Source)
at java.lang.reflect.Constructor.newInstance(Unknown Source)
at
org.drools.persistence.jpa.impl.KnowledgeStoreServiceImpl.buildCommanService(KnowledgeStoreServiceImpl.java:119)
... 3 more
Caused by: java.lang.RuntimeException: Could not commit session
at
org.drools.persistence.session.SingleSessionCommandService.<init>(SingleSessionCommandService.java:135)
... 8 more
Caused by: org.hibernate.AssertionFailure: Transaction MARKED_FOR_JOINED
after isOpen() call
at
org.hibernate.ejb.AbstractEntityManagerImpl.joinTransaction(AbstractEntityManagerImpl.java:465)
at
org.hibernate.ejb.AbstractEntityManagerImpl.postInit(AbstractEntityManagerImpl.java:82)
at
org.hibernate.ejb.EntityManagerImpl.<init>(EntityManagerImpl.java:61)
at
org.hibernate.ejb.EntityManagerFactoryImpl.createEntityManager(EntityManagerFactoryImpl.java:39)
at
org.hibernate.ejb.EntityManagerFactoryImpl.createEntityManager(EntityManagerFactoryImpl.java:34)
at
org.drools.persistence.session.DefaultJpaManager.getApplicationScopedEntityManager(DefaultJpaManager.java:37)
at
org.drools.persistence.session.SingleSessionCommandService.<init>(SingleSessionCommandService.java:124)
... 8 more
I tried to add the objects you mentioned, I added only 3, I didn't add
env.set(EnvironmentName.TRANSACTION_SYNCHRONIZATION_REGISTRY,
this.txSvc.getTransactionSynchronizationRegistry());
because
new InitialContext().lookup(
"java:comp/env/TransactionSynchronizationRegistry" );
Return null even I add
javax.transaction.TransactionSynchronizationRegistry =
bitronix.tm.BitronixTransactionSynchronizationRegistryObjectFactory
in my jndi.properties file
here is my code
UserTransaction ut = (UserTransaction) new InitialContext().lookup(
"java:comp/UserTransaction" );
// create the entity manager factory and register it in the
environment
EntityManagerFactory emf =
Persistence.createEntityManagerFactory( "org.drools.persistence.jpa" );
Environment env = KnowledgeBaseFactory.newEnvironment();
env.set( EnvironmentName.ENTITY_MANAGER_FACTORY, emf );
env.set(EnvironmentName.TRANSACTION_MANAGER,
TransactionManagerServices.getTransactionManager());
env.set(EnvironmentName.GLOBALS, new MapGlobalResolver());
env.set(EnvironmentName.TRANSACTION, ut);
//TransactionSynchronizationRegistryHelper tsr =
(TransactionSynchronizationRegistryHelper) new InitialContext().lookup(
"java:comp/env/TransactionSynchronizationRegistry" );
//
env.set(EnvironmentName.TRANSACTION_SYNCHRONIZATION_REGISTRY, tsr );
// create a new knowledge session that uses JPA to store the
runtime state
StatefulKnowledgeSession ksession =
JPAKnowledgeService.newStatefulKnowledgeSession( kbase, null, env );
// start the transaction
ut.begin();
// invoke methods on your method here
ProcessInstance process = ksession.startProcess(
"com.sample.ruleflow" );
ksession.signalEvent("Test", "Test",
process.getId());
ut.commit();
ut.begin();
ksession.fireAllRules();
// commit the transaction
ut.commit();
ksession.dispose();
any idea ?
Thanks
Regards,
From: rules-users-bounces(a)lists.jboss.org
[mailto:rules-users-bounces@lists.jboss.org] On Behalf Of Rui Tang
Sent: Friday,May 13,2011 3:58 AM
To: Rules Users List
Subject: Re: [rules-users] Drools Human Task Service Persistence
Drools Persistence JPA module must use JTA instead of local transaction.
<persistence-unit name="org.drools.persistence.jpa"
transaction-type="RESOURCE_LOCAL">
should change to
<persistence-unit name="default" transaction-type="JTA">
and
env.set( EnvironmentName.TRANSACTION_MANAGER, XXXXXXXXXXX );
your transaction manager should be get from JNDI like
UserTransaction utx = (UserTransaction)
ctx.lookup("java:comp/UserTransaction");
Your JBoss transaction manager component should register the
UserTransaction
into that JNDO name. (In some JTA implementations the UserTransaction and
TransactionManager have the same interfaces). And to make Drools
Persistence
JPA works, you should put 4 or 5 objects into env, they are:
env.set(EnvironmentName.ENTITY_MANAGER_FACTORY,
this.defaultPersistenceSvc.getSessionFactory());
env.set(EnvironmentName.APP_SCOPED_ENTITY_MANAGER,
this.defaultPersistenceSvc.getCurrentSession()); // If you don't handle the
EntityManager your self, you can omit this line.
env.set(EnvironmentName.TRANSACTION_MANAGER,
this.txSvc.getTransactionManager()); // java:comp/env/TransactionManager
env.set(EnvironmentName.TRANSACTION, this.txSvc.getTransaction()); //
java:comp/UserTransaction
env.set(EnvironmentName.TRANSACTION_SYNCHRONIZATION_REGISTRY,
this.txSvc.getTransactionSynchronizationRegistry()); //
java:comp/env/TransactionSynchronizationRegistry
all the methods called from txSvc fetch objects from according JNDI. In my
application all these JNDI objects are config-ed via Tomcat like this (in
META-INF/context.xml):
<Resource name="jdbc/defaultDS" auth="Container"
type="javax.sql.XADataSource"
factory="bitronix.tm.resource.ResourceObjectFactory"
uniqueName="jdbc/defaultDS" />
<Resource name="jdbc/droolsTaskDS" auth="Container"
type="javax.sql.XADataSource"
factory="bitronix.tm.resource.ResourceObjectFactory"
uniqueName="jdbc/droolsTaskDS" />
<Resource name="TransactionManager" auth="Container"
type="javax.transaction.TransactionManager"
factory="bitronix.tm.BitronixTransactionManagerObjectFactory" />
<Resource name="TransactionSynchronizationRegistry"
auth="Container"
type="javax.transaction.TransactionSynchronizationRegistry"
factory="bitronix.tm.BitronixTransactionSynchronizationRegistryObjectFactory"
/>
<Resource name="UserTransaction" auth="Container"
type="javax.transaction.UserTransaction" />
<Transaction factory="bitronix.tm.BitronixUserTransactionObjectFactory"
/>
--
View this message in context:
http://drools.46999.n3.nabble.com/Drools-Human-Task-Service-Persistence-t...
Sent from the Drools: User forum mailing list archive at Nabble.com.
_______________________________________________
rules-users mailing list
rules-users(a)lists.jboss.org
https://lists.jboss.org/mailman/listinfo/rules-users
--
唐睿 研发部
深圳市中昱达信息技术有限责任公司
电话：0755-26966586-804
传真：0755-26966586-802
手机：86-18688827156
网址：www.zyeeda.com
地址：深圳市罗湖区金塘街48号蔡屋围丽晶大厦南座1206（518010）
本邮件（包括任何附件）含有专供明确的个人和目的使用的机密信息，并受法律保护。如果您并非指定收件人，请立即删除此邮件及其附件（如有），并勿使用、披露、复制或分发此邮件或据此采取任何行动。
Copyright (c) 2011 ZYEEDA CO., LTD. ALL RIGHTS RESERVED 中昱达公司 版权所有
4:24 a.m.
thank you very much,
It works know for me, I changed my conf to use BTMTransactionManagerLookup
with JTA in transaction type,
I have an insert in my sessioninfo table, I have also one line persisted in
ProcessInstanceInfo but deleted just after
Hibernate: select processins0_.InstanceId as col_0_0_ from
ProcessInstanceInfo processins0_ where ? in (select eventtypes1_.element
from EventTypes eventtypes1_ where
processins0_.InstanceId=eventtypes1_.InstanceId)
Hibernate: insert into SessionInfo (lastModificationDate, rulesByteArray,
startDate, OPTLOCK, id) values (?, ?, ?, ?, ?)
Hibernate: update SessionInfo set lastModificationDate=?, rulesByteArray=?,
startDate=?, OPTLOCK=? where id=? and OPTLOCK=?
Hibernate: insert into ProcessInstanceInfo (externalVariables,
lastModificationDate, lastReadDate, processId, processInstanceByteArray,
startDate, state, OPTLOCK, InstanceId) values (?, ?, ?, ?, ?, ?, ?, ?, ?)
Hibernate: delete from ProcessInstanceInfo where InstanceId=? and OPTLOCK=?
Maybe that's normal,
in fact, on the toolbar of my eclipse drools I haven't the wait state, so,
I integrate them directly in the xml file, are they required to perform
backups of the Workflow ?
<milestone id="15" name="Wait for Diagnose" x="206"
y="324" width="124"
height="40" >
<constraint type="rule" dialect="mvel" >Diagnose(type ==
"test")</constraint>
</milestone>
thanks
--
View this message in context:
http://drools.46999.n3.nabble.com/Drools-Human-Task-Service-Persistence-t...
Sent from the Drools: User forum mailing list archive at Nabble.com.
4765
days inactive
4953
days old
34 comments
10 participants
participants (10)
-
drooRam -
JAMAL Moundir (EXT) -
loumimi
-
Mauricio Salatino -
melc -
ramram -
Rui Tang -
Rui Tang -
Salaboy
-
tangrui.cn＠gmail.com