Werner, Thanks for the effort.
I understand itīs very difficult to solve a problem if you can not reproduce it, but as well itīs very difficult for me to send an environment that fails because I get exceptions at random times... I will need to spend some time and create a simple example that always fails so I can send it to you. Right now I donīt have time, when I find some time I will send it. Thanks a lot and best regards, Gonzalo Abollado. -----Original Message----- From: Werner Guttmann [mailto:[EMAIL PROTECTED] Sent: jueves, 15 de abril de 2004 11:43 To: [EMAIL PROTECTED] Subject: Re: [castor-dev] ObjectModifiedException using double in MySql with out size. Gonzalo, I have recreated your environment as similar as possible, but whatever I am doing, I am failing to see an exception. I've taken all your files (almost unchanged), and converted the main test class into a JUnit test case. It all runs fine ... I know that's not what you hoped to hear from me, but maybe you can get back to me and give me instructions so that I suffer from the OME as well. Werner On Tue, 13 Apr 2004 16:11:58 +0200, Gonzalo Abollado wrote: > >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 > ----------------------------------------------------------- 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