[jboss-jira] [JBoss JIRA] Created: (JBRULES-2325) Drools Flow BAM Module(5.1.0.M1) - Primary Key of String type creating problem
Drools Flow BAM Module(5.1.0.M1) - Primary Key of String type creating problem
------------------------------------------------------------------------------
Key: JBRULES-2325
URL: https://jira.jboss.org/jira/browse/JBRULES-2325
Project: Drools
Issue Type: Bug
Security Level: Public (Everyone can see)
Components: drools-process
Affects Versions: 5.1.0.M1
Environment: Java 5, Drools 5.1.0.M1, MySQL 5.1
Reporter: vijpan
Assignee: Mark Proctor
I am planning to use Drools Flow BAM (5.1.0.M1) module to store the processes instances
for audit purpose. I generated the DDL with the help of Hibernate Tools against the MYSQL
5.1(INNODB)
DDL for the 2 tables are given below -- the interesting part is the "id" column
as "varchar" ---- this gives error when we try to execute the DDL against the
mysql.
create table AUDIT_NODE_INSTANCE_LOG (
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)
) ENGINE=InnoDB;
create table AUDIT_PROCESS_INSTANCE_LOG (
id varchar(255) not null auto_increment,
processInstanceId bigint,
processId varchar(255),
START_DATE datetime,
END_DATE datetime,
primary key (id)
) ENGINE=InnoDB;
The error we get is
Error: Incorrect column specifier for column 'id'
SQLState: 42000
ErrorCode: 1063
Just to test with different column name such as "primaryid" - we still the same
error.
If i change the column type to "bigint" - the tables get created fine.
I think with the "native" strategy - the column type should be changed from
'String' to 'long'
Thanks
Vijay
p.s. I used a naming strategy for the hibernate that's why the above table names.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
https://jira.jboss.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira