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

Tue Nov 2 22:02:01 EDT 2010

     [ https://jira.jboss.org/browse/JBRULES-2712?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Kris Verlaenen resolved JBRULES-2712.
-------------------------------------

    Fix Version/s: 5.2.0.M1
       Resolution: Done

The default name of the date columns have already been updated.

> 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: Kris Verlaenen
>             Fix For: 5.2.0.M1
>
>
> 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