cayenne-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Borut BolĨina <borut.bolc...@gmail.com>
Subject Modeler fails migrating from BIGINT to DECIMAL
Date Mon, 11 Oct 2010 08:16:41 GMT
Hi,

the 3.0.1 win modeler refuses to migrate some (not all!) changes made in
mysql database. If I rename column name it works just fine. I changed the
type from BIGINT to DECIMAL(17,11) and the modeler is showing no operations
to be performed.

The database table looks like:

CREATE TABLE `town` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `mid` int(10) unsigned NOT NULL,
  `name` varchar(60) NOT NULL,
  `label_y` decimal(17,11) unsigned NOT NULL,
  `label_x` decimal(17,11) unsigned NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `mid_UNIQUE` (`mid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8

The curent mapping:

    <db-entity name="town" schema="maps" catalog="maps">
        <db-attribute name="id" type="BIGINT" isPrimaryKey="true"
isGenerated="true" isMandatory="true" length="10"/>
        <db-attribute name="label_x" type="BIGINT" isMandatory="true"
length="10"/>
        <db-attribute name="label_y" type="BIGINT" isMandatory="true"
length="10"/>
        <db-attribute name="mid" type="BIGINT" isMandatory="true"
length="10"/>
        <db-attribute name="name" type="VARCHAR" isMandatory="true"
length="60"/>
    </db-entity>

    <obj-entity name="Town" className="com.acme.maps.model.Town"
dbEntityName="town">
        <obj-attribute name="labelX" type="java.lang.Long"
db-attribute-path="label_x"/>
        <obj-attribute name="labelY" type="java.lang.Long"
db-attribute-path="label_y"/>
        <obj-attribute name="name" type="java.lang.String"
db-attribute-path="name"/>
    </obj-entity>

I looked for the modeler log file, but it is empty. Is there any other
location for the modeler log file than user home/.cayenne/modeler.log?

I am using mysql connector 5.1.10 on windows 7 and win modeler 3.0.1.

Should I file a JIRA report for this?

Regards,
Borut

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message