1 Reply Latest reply on Feb 19, 2008 10:26 AM by Vitaly Xaoc

    wrong sql-file for creating database - Data too long for col

    Vitaly Xaoc Newbie

      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)"