I don't know much about mySql, but have you tried using Numeric or other number type where you can specify the precission?
>From what this email sounds like, its a problem with the table type. Can you give more information, like the schema affected, and how you're mapping it? --- Ender_Hikmet_KILI�OGLU <[EMAIL PROTECTED]> wrote: > Hi > This is my second mail about this error. > Problem is appair when you try to update double field with 7 or more > digit > on a mysql table. Reason is SQL query created with exponention format > like > "2.802344E7" so it cause exception on the mm.mysql's executeupdate > function. > I couldnt find solution > Thanks for reply > > org.exolab.castor.jdo.PersistenceException: Nested error: > java.sql.SQLException: Syntax error or access violation: You have an > error > in your SQL syntax near '2.8031808E7)' at line 1 > java.sql.SQLException: Syntax error or access violation: You have an > error > in your SQL syntax near '2.8031808E7)' at line 1 > at > org.gjt.mm.mysql.PreparedStatement.executeUpdate(PreparedStatement.java:428) > at org.exolab.castor.jdo.engine.SQLEngine.create(SQLEngine.java:616) > at org.exolab.castor.persist.ClassMolder.create(ClassMolder.java:891) > > > Ender KILICOGLu > > ----------------------------------------------------------- > If you wish to unsubscribe from this mailing, send mail to > [EMAIL PROTECTED] with a subject of: > unsubscribe castor-dev > ===== Virtually, | "Must you shout too?" Ned Wolpert | -Dante [EMAIL PROTECTED] | _________________/ "Who watches the watchmen?" 4e75 -Juvenal, 120 AD -- Place your commercial here -- fnord __________________________________________________ Do You Yahoo!? Send FREE video emails in Yahoo! Mail! http://promo.yahoo.com/videomail/ ----------------------------------------------------------- If you wish to unsubscribe from this mailing, send mail to [EMAIL PROTECTED] with a subject of: unsubscribe castor-dev
