[jboss-dev-forums] [Design of JBoss jBPM] - wrong sql-file for creating database - Data too long for col

[inxaoc]

Hello!
The following exception was thrown when I've tried to use Mysql DB. 
Caused by: com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data too long for column 'ISTERMINATIONIMPLICIT_' at row 1.

I've used the special file for creating mysql database. The sql-file provided by developers (in starter kit) is wrong, and I've token correct file from other source (jbpm wiki article). But this file was no good fully. It contains error. Ypu should replacde all inclusion like this - "ISTERMINATIONIMPLICIT_ bit" (bit is wrong type for mysql it is the same as UNKNOWN, but this should be boolean!) with for example such "ISTERMINATIONIMPLICIT_ tinyint(1)"

View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4130432#4130432

Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4130432