[rules-users] Drools Human Task Service Persistence
Mauricio Salatino
salaboy at gmail.com
Tue Nov 9 09:00:20 EST 2010
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 at 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-Service-Persistence-tp1868778p1868778.html
> Sent from the Drools - User mailing list archive at Nabble.com.
> _______________________________________________
> rules-users mailing list
> rules-users at 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 -
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.jboss.org/pipermail/rules-users/attachments/20101109/ec459386/attachment.html
More information about the rules-users
mailing list