You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@openjpa.apache.org by zhourui <zh...@zoneland.net> on 2016/01/26 09:43:34 UTC

Boolean not incompatible with informix?

openjpa version: openjpa-all-2.4.1-SNAPSHOT.jar
(apache-openjpa-2.4.1-20160117.074355-22)
database: informix 12 FC5

the Boolean filed create in database as bit type;

but openjpa got incompatible warning:
Existing column "xmodified" on table "x.pp_c_task" is incompatible with the
same column in the given schema definition. 

it seems a bug?

29438  com.x.processplatform.core.entity.content.Task.s001  WARN  
[http-nio-20080-exec-5] openjpa.jdbc.Schema - Existing column "xmodified" on
table "x.pp_c_task" is incompatible with the same column in the given schema
definition. Existing column:
Full Name: pp_c_task.xmodified
Type: unknown(16)
Size: 5
Default: null
Not Null: false
Given column:
Full Name: pp_c_task.xmodified
Type: bit
Size: 0
Default: null
Not Null: false

filed definition:
@Column(name = "xmodified")
@Index(name = TABLE + "_modified")
private Boolean modified;

table ddl:
CREATE TABLE "x"."pp_c_task" (
		"xid" VARCHAR(64) NOT NULL,
		"xdistributefactor" INTEGER,
		"xactivity" VARCHAR(64),
		"xactivityname" VARCHAR(255),
		"xactivitytoken" VARCHAR(64),
		"xactivitytype" VARCHAR(16),
		"xallowrapid" BOOLEAN,
		"xapplication" VARCHAR(64),
		"xapplicationname" VARCHAR(255),
		"xcompany" VARCHAR(255),
		"xcreatetime" DATETIME YEAR TO FRACTION,
		"xcreatorcompany" VARCHAR(255),
		"xcreatordepartment" VARCHAR(255),
		"xcreatoridentity" VARCHAR(255),
		"xcreatorperson" VARCHAR(255),
		"xdepartment" VARCHAR(255),
		"xidentity" VARCHAR(255),
		"xjob" VARCHAR(64),
		"xlimittime" DATETIME YEAR TO FRACTION,
		"xmanualmode" INT8,
		"xmodified" BOOLEAN,
		"xopinion" VARCHAR(255),
		"xperson" VARCHAR(255),
		"xprocess" VARCHAR(64),
		"xprocessname" VARCHAR(255),
		"xroutename" VARCHAR(255),
		"xsequence" VARCHAR(128),
		"xserial" VARCHAR(128),
		"xstarttime" DATETIME YEAR TO FRACTION,
		"xstarttimemonth" VARCHAR(16),
		"xtitle" VARCHAR(255),
		"xupdatetime" DATETIME YEAR TO FRACTION,
		"xviewed" BOOLEAN,
		"xwork" VARCHAR(64)
	)
IN data8dbs1 EXTENT SIZE 32 NEXT SIZE 32 LOCK MODE ROW;

need help,thanks!



--
View this message in context: http://openjpa.208410.n2.nabble.com/Boolean-not-incompatible-with-informix-tp7588835.html
Sent from the OpenJPA Users mailing list archive at Nabble.com.