Hi, I am trying to populate a table using jdbc and CloverETL, but I get the following message : Caused by: java.sql.SQLException: SQLException:sql.prepare:wrong argument for prepared statement (expected decimal instead of decimal) So, Monetdb is expecting decimal, but gets ... decimal :-) What can be the problem ? Thanks, Franck
Hi, I ahve changed the type of the field from NUMERIC(12,6) to DOUBLE, and now the error is gone. NUMERIC type in Monetdb seems to be limited to 18 digits and a maximum scale of 8. According to the doc, double is bound to the underlying os implementation. So, I'll go on... Franck Le lundi 06 juillet 2009 à 19:57 +0200, Franck Routier a écrit :
Hi,
I am trying to populate a table using jdbc and CloverETL, but I get the following message :
Caused by: java.sql.SQLException: SQLException:sql.prepare:wrong argument for prepared statement (expected decimal instead of decimal)
So, Monetdb is expecting decimal, but gets ... decimal :-)
What can be the problem ?
Thanks,
Franck
------------------------------------------------------------------------------ _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users
Hi Franck, On 07-07-2009 09:56:29 +0200, Franck Routier wrote:
I ahve changed the type of the field from NUMERIC(12,6) to DOUBLE, and now the error is gone.
NUMERIC type in Monetdb seems to be limited to 18 digits and a maximum scale of 8.
Could you file these two issues as bugs against MonetDB/SQL in our bugtracker on SourceForge please? Thanks!
Hi Fabian, I have field bug #2818176 regarding the NUMERIC data type, hope this makes sense. Franck Le mardi 07 juillet 2009 à 19:14 +0200, Fabian Groffen a écrit :
Hi Franck,
On 07-07-2009 09:56:29 +0200, Franck Routier wrote:
I ahve changed the type of the field from NUMERIC(12,6) to DOUBLE, and now the error is gone.
NUMERIC type in Monetdb seems to be limited to 18 digits and a maximum scale of 8.
Could you file these two issues as bugs against MonetDB/SQL in our bugtracker on SourceForge please?
Thanks!
------------------------------------------------------------------------------ Enter the BlackBerry Developer Challenge This is your chance to win up to $100,000 in prizes! For a limited time, vendors submitting new applications to BlackBerry App World(TM) will have the opportunity to enter the BlackBerry Developer Challenge. See full prize details at: http://p.sf.net/sfu/blackberry _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users
participants (2)
-
Fabian Groffen -
Franck Routier