[jboss-jira] [JBoss JIRA] Created: (JBRULES-2712) NodeInstanceLog error with Oracle Persistance

Tue Sep 28 04:41:28 EDT 2010

NodeInstanceLog error with Oracle Persistance
---------------------------------------------

                 Key: JBRULES-2712
                 URL: https://jira.jboss.org/browse/JBRULES-2712
             Project: Drools
          Issue Type: Bug
      Security Level: Public (Everyone can see)
          Components: drools-core (flow)
    Affects Versions: 5.1.1.FINAL
         Environment: OS : Windows XP
            Reporter: Shridhar Kamat
            Assignee: Mark Proctor

I am using Drools Flow 5.1 and have configured the BAM module with Oracle persistance. I am getting the following error since "DATE" is a reserved word in Oracle due to which its not able to create the NodeInstanceLog table

Sep 28, 2010 11:05:43 AM org.hibernate.tool.hbm2ddl.SchemaExport execute
INFO: exporting generated schema to database
Sep 28, 2010 11:05:47 AM org.hibernate.tool.hbm2ddl.SchemaExport create
SEVERE: Unsuccessful: create table NodeInstanceLog (id number(19,0) not null, type number(10,0), nodeInstanceId varchar2(255 char), nodeId varchar2(255 char), processInstanceId number(19,0), processId varchar2(255 char), DATE timestamp, primary key (id))
Sep 28, 2010 11:05:47 AM org.hibernate.tool.hbm2ddl.SchemaExport create
SEVERE: ORA-00904: : invalid identifier

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: https://jira.jboss.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira