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 <ramram...@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@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@lists.jboss.org https://lists.jboss.org/mailman/listinfo/rules-users
