[MonetDB-users] JDBC float insert problem
I'm trying to insert floats into a MonetDB 5.0.0_beta1 db in table like this: create table P ( time timestamp not null, x numeric(5,2) not null, y numeric(5,2) not null ); using code like this: PreparedStatement ps = con.prepareStatement("insert into P (time,x,y) values (?,?,?)"); ps.setTimestamp(1, new Timestamp(time.getTime())); ps.setFloat(2, x); ps.setFloat(3, y); and get an error like this: java.sql.SQLException: MALException:(unknown):wrong argument for prepared statement (expected decimal instead of decimal) Is this a bug? Log detials: TX 1170950011791: sPREPARE insert into P (time,x,y) values (?,?,?); RD 1170950011791: final block: 189 bytes RD 1170950011805: read chunk: 189 bytes, left: 0 bytes RX 1170950011805: &5 2 3 3 3 % prepare, prepare, prepare # table_name % type, digits, scale # name % varchar, int, int # type % 0, 0, 0 # length [ "timestamp", 7, 0 ] [ "decimal", 5, 2 ] [ "decimal", 5, 2 ] RD 1170950011805: generating prompt TD 1170950011820: write final block: 57 bytes TX 1170950011820: sexec 2(timestamp '2003-01-30 18:03:35.0', 71.91, 71.98); RD 1170950011820: final block: 100 bytes RD 1170950011820: read chunk: 100 bytes, left: 0 bytes RX 1170950011820: !MALException:(unknown):wrong argument for prepared statement (expected decimal instead of decimal) Anders Blaagaard Nordea e-Markets Tel: +45 3333 6257 e-mail: anders.blaagaard@nordea.com This transmission is intended solely for the person or entity to whom it is addressed. It may contain privileged and confidential information. If you are not the intended recipient, please be notified that any dissemination, distribution or copying is strictly prohibited. If you have received this transmission by mistake, please let us know and then delete it from your system.
Hi, On 08-02-2007 16:59:49 +0100, anders.blaagaard@nordea.com wrote:
I'm trying to insert floats into a MonetDB 5.0.0_beta1 db in table like this:
[snip]
and get an error like this:
java.sql.SQLException: MALException:(unknown):wrong argument for prepared statement (expected decimal instead of decimal)
Is this a bug?
Your code and log look fine to me from the JDBC perspective. I definitely think this is a bug. Thanks for pointing out. Feel free to report it in our bugtracker.
participants (2)
-
anders.blaagaard@nordea.com
-
Fabian Groffen