Thanks, Gonzalo. I think it would definitely make sense to keep things simple to facilitate recreation.
Werner On Fri, 16 Apr 2004 01:28:42 +0200, Gonzalo Abollado wrote: > >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 > ----------------------------------------------------------- If you wish to unsubscribe from this mailing, send mail to [EMAIL PROTECTED] with a subject of: unsubscribe castor-dev
