yes.. it's sounds like that..<div>do you know what's the column that causes the trouble?</div><div><br></div><div>(<span class="Apple-style-span" style="font-family: arial, sans-serif; font-size: 13px; border-collapse: collapse; ">ORA-01747: invalid user.table.column,</span></div>
<div><span class="Apple-style-span" style="font-family: arial, sans-serif; font-size: 13px; border-collapse: collapse; ">table.column, or column specification</span>)<br><br><div class="gmail_quote">On Tue, Nov 9, 2010 at 10:27 AM, ramram <span dir="ltr"><<a href="mailto:ramram858@gmail.com">ramram858@gmail.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;"><br>
Hi All,<br>
<br>
I have been trying to persist the Human TasK service to Oracle. And I got<br>
the below error. Please check my persistence.xml file and the error that I<br>
have recieved. It seems this is happening because of some oracle reserved<br>
words are used to name the columns.<br>
<br>
Any suggestions??? on this Topic?????<br>
<br>
persistence.xml<br>
============<br>
<persistence-unit name="org.drools.task"><br>
<class>org.drools.task.Attachment</class><br>
<class>org.drools.task.Content</class><br>
<class>org.drools.task.BooleanExpression</class><br>
<class>org.drools.task.Comment</class><br>
<class>org.drools.task.Deadline</class><br>
<class>org.drools.task.Comment</class><br>
<class>org.drools.task.Deadline</class><br>
<class>org.drools.task.Delegation</class><br>
<class>org.drools.task.Escalation</class><br>
<class>org.drools.task.Group</class><br>
<class>org.drools.task.I18NText</class><br>
<class>org.drools.task.Notification</class><br>
<class>org.drools.task.EmailNotification</class><br>
<class>org.drools.task.EmailNotificationHeader</class><br>
<class>org.drools.task.PeopleAssignments</class><br>
<class>org.drools.task.Reassignment</class><br>
<class>org.drools.task.Status</class><br>
<class>org.drools.task.Task</class><br>
<class>org.drools.task.TaskData</class><br>
<class>org.drools.task.SubTasksStrategy</class><br>
<class>org.drools.task.OnParentAbortAllSubTasksEndStrategy</class><br>
<class>org.drools.task.OnAllSubTasksEndParentEndStrategy</class><br>
<br>
<class>org.drools.task.User</class><br>
<br>
<properties><br>
<property name="hibernate.dialect"<br>
value="org.hibernate.dialect.Oracle10gDialect"/><br>
<property name="hibernate.connection.driver_class"<br>
value="oracle.jdbc.OracleDriver"/><br>
<property name="hibernate.connection.url"<br>
value="jdbc:oracle:thin:@DB_URL" /><br>
<property name="hibernate.connection.username" value="drools"/><br>
<property name="hibernate.connection.password" value="drools"/><br>
<br>
<property name="hibernate.connection.autocommit" value="false" /><br>
<property name="hibernate.max_fetch_depth" value="3"/><br>
<property name="hibernate.hbm2ddl.auto" value="create-drop" /><br>
<property name="hibernate.show_sql" value="true" /><br>
</properties><br>
</persistence-unit><br>
<br>
<br>
<br>
Error<br>
============<br>
Hibernate: select task0_.id as col_0_0_, deadline1_.id as col_1_0_,<br>
deadline1_.date as col_2_0_ from Task task0_, Deadline deadline1_ where<br>
(deadline1_.id in (select start<br>
deadl2_.id from Deadline startdeadl2_ where<br>
task0_.id=startdeadl2_.Deadlines_StartDeadLine_Id) or deadline1_.id in<br>
(select enddeadlin3_.id from Deadline enddeadlin3_ where<br>
task0_.id=enddeadlin3_.Deadlines_EndDeadLine_Id)) and<br>
deadline1_.escalated=0 order by deadline1_.date<br>
javax.persistence.PersistenceException:<br>
org.hibernate.exception.SQLGrammarException: could not execute query<br>
at<br>
org.hibernate.ejb.AbstractEntityManagerImpl.throwPersistenceException(AbstractEntityManagerImpl.java:629)<br>
at org.hibernate.ejb.QueryImpl.getResultList(QueryImpl.java:73)<br>
at org.drools.task.service.TaskService.<init>(TaskService.java:65)<br>
at org.drools.task.service.TaskService.<init>(TaskService.java:48)<br>
at com.fp.taskservice.RunTaskService.start(RunTaskService.java:45)<br>
at<br>
com.fp.taskservice.RunTaskService.contextInitialized(RunTaskService.java:28)<br>
at<br>
org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3843)<br>
at<br>
org.apache.catalina.core.StandardContext.start(StandardContext.java:4350)<br>
at<br>
org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:791)<br>
at<br>
org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:771)<br>
at<br>
org.apache.catalina.core.StandardHost.addChild(StandardHost.java:525)<br>
at<br>
org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.java:924)<br>
at<br>
org.apache.catalina.startup.HostConfig.deployDirectories(HostConfig.java:887)<br>
at<br>
org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:492)<br>
at<br>
org.apache.catalina.startup.HostConfig.start(HostConfig.java:1147)<br>
at<br>
org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:311)<br>
at<br>
org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:117)<br>
at<br>
org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1053)<br>
at<br>
org.apache.catalina.core.StandardHost.start(StandardHost.java:719)<br>
at<br>
org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045)<br>
at<br>
org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443)<br>
at<br>
org.apache.catalina.core.StandardService.start(StandardService.java:516)<br>
at<br>
org.apache.catalina.core.StandardServer.start(StandardServer.java:710)<br>
at org.apache.catalina.startup.Catalina.start(Catalina.java:578)<br>
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)<br>
at<br>
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)<br>
at<br>
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)<br>
at java.lang.reflect.Method.invoke(Method.java:597)<br>
at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:288)<br>
at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:413)<br>
Caused by: org.hibernate.exception.SQLGrammarException: could not execute<br>
query<br>
at<br>
org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:67)<br>
at<br>
org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)<br>
at org.hibernate.loader.Loader.doList(Loader.java:2223)<br>
at<br>
org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2104)<br>
at org.hibernate.loader.Loader.list(Loader.java:2099)<br>
at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:378)<br>
at<br>
org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:338)<br>
at<br>
org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:172)<br>
at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1121)<br>
at org.hibernate.impl.QueryImpl.list(QueryImpl.java:79)<br>
at org.hibernate.ejb.QueryImpl.getResultList(QueryImpl.java:64)<br>
... 28 more<br>
Caused by: java.sql.SQLException: ORA-01747: invalid user.table.column,<br>
table.column, or column specification<br>
<br>
at<br>
oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:125)<br>
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:316)<br>
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:282)<br>
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:639)<br>
at<br>
oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:185)<br>
at<br>
oracle.jdbc.driver.T4CPreparedStatement.execute_for_describe(T4CPreparedStatement.java:503)<br>
at<br>
oracle.jdbc.driver.OracleStatement.execute_maybe_describe(OracleStatement.java:965)<br>
at<br>
oracle.jdbc.driver.T4CPreparedStatement.execute_maybe_describe(T4CPreparedStatement.java:535)<br>
at<br>
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1051)<br>
at<br>
oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:2984)<br>
at<br>
oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3026)<br>
at<br>
org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:186)<br>
at org.hibernate.loader.Loader.getResultSet(Loader.java:1787)<br>
at org.hibernate.loader.Loader.doQuery(Loader.java:674)<br>
at<br>
org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:236)<br>
at org.hibernate.loader.Loader.doList(Loader.java:2220)<br>
... 36 more<br>
java.lang.Exception<br>
at com.fp.taskservice.RunTaskService.start(RunTaskService.java:50)<br>
at<br>
com.fp.taskservice.RunTaskService.contextInitialized(RunTaskService.java:28)<br>
at<br>
org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3843)<br>
at<br>
org.apache.catalina.core.StandardContext.start(StandardContext.java:4350)<br>
at<br>
org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:791)<br>
at<br>
org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:771)<br>
at<br>
org.apache.catalina.core.StandardHost.addChild(StandardHost.java:525)<br>
at<br>
org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.java:924)<br>
at<br>
org.apache.catalina.startup.HostConfig.deployDirectories(HostConfig.java:887)<br>
at<br>
org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:492)<br>
at<br>
org.apache.catalina.startup.HostConfig.start(HostConfig.java:1147)<br>
at<br>
org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:311)<br>
at<br>
org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:117)<br>
at<br>
org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1053)<br>
at<br>
org.apache.catalina.core.StandardHost.start(StandardHost.java:719)<br>
at<br>
org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045)<br>
at<br>
org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443)<br>
at<br>
org.apache.catalina.core.StandardService.start(StandardService.java:516)<br>
at<br>
org.apache.catalina.core.StandardServer.start(StandardServer.java:710)<br>
at org.apache.catalina.startup.Catalina.start(Catalina.java:578)<br>
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)<br>
at<br>
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)<br>
at<br>
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)<br>
at java.lang.reflect.Method.invoke(Method.java:597)<br>
at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:288)<br>
<br>
<br>
Regards,<br>
Ram<br>
<font color="#888888">--<br>
View this message in context: <a href="http://drools-java-rules-engine.46999.n3.nabble.com/Drools-Human-Task-Service-Persistence-tp1868778p1868778.html" target="_blank">http://drools-java-rules-engine.46999.n3.nabble.com/Drools-Human-Task-Service-Persistence-tp1868778p1868778.html</a><br>
Sent from the Drools - User mailing list archive at Nabble.com.<br>
_______________________________________________<br>
rules-users mailing list<br>
<a href="mailto:rules-users@lists.jboss.org">rules-users@lists.jboss.org</a><br>
<a href="https://lists.jboss.org/mailman/listinfo/rules-users" target="_blank">https://lists.jboss.org/mailman/listinfo/rules-users</a><br>
</font></blockquote></div><br><br clear="all"><br>-- <br> - CTO @ <a href="http://www.plugtree.com">http://www.plugtree.com</a> <br> - MyJourney @ <a href="http://salaboy.wordpress.com">http://salaboy.wordpress.com</a><br>
- Co-Founder @ <a href="http://www.jbug.com.ar">http://www.jbug.com.ar</a><br> <br> - Salatino "Salaboy" Mauricio -<br>
</div>