Werner, here is the schema.
Regards.
# MySQL-Front Dump 2.5
#
# Host: localhost Database: costes
# --------------------------------------------------------
# Server version 4.0.13-nt
USE costes;
#
# Table structure for table 'facturas'
#
DROP TABLE IF EXISTS facturas;
CREATE TABLE facturas (
id int(11) NOT NULL auto_increment,
id_certificacion int(11) NOT NULL default '0',
referencia varchar(10) NOT NULL default '',
dato_contable1 varchar(10) default NULL,
dato_contable2 varchar(10) default NULL,
dato_contable3 varchar(10) default NULL,
importe double(10,2) default NULL,
PRIMARY KEY (id),
UNIQUE KEY id (id)
) TYPE=InnoDB;
#
# Dumping data for table 'facturas'
#
INSERT INTO facturas VALUES("483", "5", "FAC12A", "A1", "A1", "A1",
"12445755.34");
INSERT INTO facturas VALUES("484", "5", "ASD3", "", "", "",
"6677776.24");
INSERT INTO facturas VALUES("28", "5", "EDFR", "", "", "", "6666.00");
INSERT INTO facturas VALUES("29", "6", "FAC2", "", "", "",
"1231231231.00");
-----Original Message-----
From: Werner Guttmann [mailto:[EMAIL PROTECTED]
Sent: martes, 13 de abril de 2004 14:26
To: [EMAIL PROTECTED]
Subject: Re: [castor-dev] ObjectModifiedException using double in MySql
with out size.
Gonzalo,
can you please send me the SQL schema you use to generate the table for
Factura, and - if possible - some SQL to populate the table so that
below
test works.
Werner
On Tue, 13 Apr 2004 11:23:46 +0200, Gonzalo Abollado wrote:
>
>Sorry, I forgot to send you the mapping file....
>
><mapping>
> <class name="com.costes.base.Factura" identity="id"
>key-generator="IDENTITY">
> <map-to table="facturas"/>
> <field name="id" type="integer">
> <sql name="id" type="integer"/>
> </field>
> <field name="idCertificacion" type="integer">
> <sql name="id_certificacion"/>
> </field>
> <field name="referencia" type="string">
> <sql name="referencia" type="varchar"/>
> </field>
> <field name="datoContable1" type="string">
> <sql name="dato_Contable1" type="varchar"/>
> </field>
> <field name="datoContable2" type="string">
> <sql name="dato_Contable2" type="varchar"/>
> </field>
> <field name="datoContable3" type="string">
> <sql name="dato_Contable3" type="varchar"/>
> </field>
> <field name="importe" type="double">
> <sql name="importe"/>
> </field>
>
> </class>
></mapping>
>
>
>
>-----Original Message-----
>From: Werner Guttmann [mailto:[EMAIL PROTECTED]
>Sent: lunes, 12 de abril de 2004 20:30
>To: [EMAIL PROTECTED]
>Subject: Re: [castor-dev] ObjectModifiedException using double in MySql
>with out size.
>
>
>Gonzalo,
>
>can you please post a code fragment, a mapping file, et alias so that I
>can simulate your findings ? Parta from this, what version of mySQL are
>you using,
>and what's the release number of the JDBC driver for mySQL ?
>
>Regards
>Werner
>
>On Mon, 12 Apr 2004 17:15:51 +0200, Gonzalo Abollado wrote:
>
>>
>>Hello,
>>
>>I�m run into another ObjectModifiedException problem. In this case I
>was
>>using a double field in MySQL with out specifying the size of the
>field.
>>
>>In some situations, I can�t really tell when, but maybe it has to do
>>with values like: 123123,93 maybe a rounding problem, I�m not sure...
>>The thing is that using the same value that fails using double with
out
>>specifying the size, specifying a size of 10,2 in the double field it
>>works fine.
>>
>>Regards,
>>Gonzalo Abollado.
>>
>>-----------------------------------------------------------
>>If you wish to unsubscribe from this mailing, send mail to
>>[EMAIL PROTECTED] with a subject of:
>> unsubscribe castor-dev
>>
>
>-----------------------------------------------------------
>If you wish to unsubscribe from this mailing, send mail to
>[EMAIL PROTECTED] with a subject of:
> unsubscribe castor-dev
>
>-----------------------------------------------------------
>If you wish to unsubscribe from this mailing, send mail to
>[EMAIL PROTECTED] with a subject of:
> unsubscribe castor-dev
>
-----------------------------------------------------------
If you wish to unsubscribe from this mailing, send mail to
[EMAIL PROTECTED] with a subject of:
unsubscribe castor-dev
-----------------------------------------------------------
If you wish to unsubscribe from this mailing, send mail to
[EMAIL PROTECTED] with a subject of:
unsubscribe castor-dev
