[jboss-jira] [JBoss JIRA] Assigned: (JBRULES-2488) Wrong type for NodeInstanceLog and ProcessInstanceLog feild "id"

[Mark Proctor (JIRA)]

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

Mark Proctor reassigned JBRULES-2488:
-------------------------------------

    Assignee: Kris Verlaenen  (was: Mark Proctor)


> Wrong type for NodeInstanceLog and ProcessInstanceLog feild "id"
> ----------------------------------------------------------------
>
>                 Key: JBRULES-2488
>                 URL: https://issues.jboss.org/browse/JBRULES-2488
>             Project: Drools
>          Issue Type: Bug
>      Security Level: Public(Everyone can see) 
>          Components: drools-core
>    Affects Versions: 5.1.0.M1
>         Environment: Drools history persistence on MySQL
>            Reporter: Sameeh Harfoush
>            Assignee: Kris Verlaenen
>            Priority: Blocker
>              Labels: NodeInstanceLog, ProcessInstanceLog, history_log
>
> i am using drools-bam to persist the history to MySQL DB with the below configuration
> <?xml version="1.0" encoding="utf-8"?>
> <!DOCTYPE hibernate-configuration PUBLIC
>           "-//Hibernate/Hibernate Configuration DTD 3.0//EN"
>           "http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd">
> <hibernate-configuration>
> 	<session-factory>
> 		<!-- Database connection settings -->
> 		<property name="connection.driver_class">com.mysql.jdbc.Driver</property>
> 		<property name="connection.url">jdbc:mysql://localhost:3306/drools</property>
> 		<property name="connection.username">root</property>
> 		<property name="connection.password">JAVA</property>
> 		<!-- JDBC connection pool (use the built-in) -->
> 		<property name="connection.pool_size">1</property>
> 		<!-- SQL dialect -->
> 		<property name="dialect">org.hibernate.dialect.MySQLInnoDBDialect</property>
> 		<!-- Enable Hibernate's automatic session context management -->
> 		<property name="current_session_context_class">thread</property>
> 		<!-- Disable the second-level cache  -->
> 		<property name="cache.provider_class">org.hibernate.cache.NoCacheProvider</property>
> 		<!-- Echo all executed SQL to stdout -->
> 		<property name="show_sql">true</property>
> 		<!-- Drop and re-create the database schema on startup -->
> 		<property name="hbm2ddl.auto">create</property>
> and with the following hibernate mapping file:
> <?xml version="1.0"?>
> <!DOCTYPE hibernate-mapping PUBLIC
>         "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
>         "http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
> <hibernate-mapping>
> 	<class name="org.drools.process.audit.ProcessInstanceLog" >
>         <id name="id" >
>             <generator class="native"/>
>         </id>
>         <property name="processInstanceId"/>
>         <property name="processId"/>
>         <property name="start" type="timestamp" column="START_DATE"/>
>         <property name="end" type="timestamp" column="END_DATE"/>
>     </class>
> 	<class name="org.drools.process.audit.NodeInstanceLog" >
>         <id name="id">
>             <generator class="native"/>
>         </id>
>         <property name="type"/>
>         <property name="nodeInstanceId"/>
>         <property name="nodeId"/>
>         <property name="processInstanceId"/>
>         <property name="processId"/>
>         <property name="date" type="timestamp" column="DATE"/>
>     </class>
> </hibernate-mapping>
> 		
> 		<mapping resource="DroolsAuditLog.hbm.xml" />
> 	</session-factory>
> </hibernate-configuration>
> when i run mu unit test i get the following logging 
> INFO: Running hbm2ddl schema export
> Apr 16, 2010 3:45:36 PM org.hibernate.tool.hbm2ddl.SchemaExport execute
> INFO: exporting generated schema to database
> Apr 16, 2010 3:45:37 PM org.hibernate.tool.hbm2ddl.SchemaExport create
> SEVERE: Unsuccessful: create table NodeInstanceLog (id varchar(255) not null auto_increment, type integer, nodeInstanceId varchar(255), nodeId varchar(255), processInstanceId bigint, processId varchar(255), DATE datetime, primary key (id))
> Apr 16, 2010 3:45:37 PM org.hibernate.tool.hbm2ddl.SchemaExport create
> SEVERE: Incorrect column specifier for column 'id'
> Apr 16, 2010 3:45:37 PM org.hibernate.tool.hbm2ddl.SchemaExport create
> SEVERE: Unsuccessful: create table ProcessInstanceLog (id varchar(255) not null auto_increment, processInstanceId bigint, processId varchar(255), START_DATE datetime, END_DATE datetime, primary key (id))
> Apr 16, 2010 3:45:37 PM org.hibernate.tool.hbm2ddl.SchemaExport create
> SEVERE: Incorrect column specifier for column 'id'
> Apr 16, 2010 3:45:37 PM org.hibernate.tool.hbm2ddl.SchemaExport execute
> INFO: schema export complete
> the id is set to varchar with auto increment...this doesn't work for MySQL
> and after changing the "id" column type in hibernate-mapping to 
>         <id name="id" type="integer">
>             <generator class="native"/>
>         </id>
> i get the following error
> SEVERE: expected type: java.lang.String, actual value: java.lang.Integer
> i checked org.drools.process.audit.ProcessInstanceLog and  org.drools.process.audit.NodeInstanceLog i realized that the id feils type is set to String which is causing a problem

--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira