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

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