Bugs item #2831994, was opened at 2009-08-04 15:16 Message generated for change (Comment added) made by stmane You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=482468&aid=2831994&group_id=56967
Please note that this message will contain a full copy of the comment thread, including the initial issue submission, for this request, not just the latest update. Category: SQL/JDBC Group: MonetDB5 "stable" Status: Open Resolution: None Priority: 5 Private: No Submitted By: Gleb Lanbin (glanbin) Assigned to: Fabian (mr-meltdown) Summary: Prepared statement problem Initial Comment: Hello, we have a strange problem with MonetDB JDBC driver, when we use standard statement to insert numeric data value all works. but with prepared statement we got the problem with value 0 (null) for decimal and numeric data type, so when we try to insert data with null in PreparedStatement we got SQL exception. I attached file with sample source code which generates such error. Thanks ---------------------------------------------------------------------- >Comment By: Stefan Manegold (stmane) Date: 2009-08-11 13:59 Message: The test (using mclient, not JDBC) seems to work fine: http://monetdb.cwi.nl/testing/projects/monetdb/Stable/sql/.mTests103/GNU.64.64.d.1-Fedora10/src_test_BugTracker-2009/prepare_decimal_bug.SF-2831994.out.00.html Could this one hence be closed? ---------------------------------------------------------------------- Comment By: Niels Nes (nielsnes) Date: 2009-08-04 19:35 Message: added test to BugTracker-2009/Tests/prepare_decimal_bug.SF-2831994.sql 0.0 got stripped to '.' having no digits. Asking for a decimal with length 0, automagically switches to maximum (19) digits length, which is larger as 5). So now we detect to low number of digits (<= 0) and set it to atleast 1. ---------------------------------------------------------------------- Comment By: Fabian (mr-meltdown) Date: 2009-08-04 15:20 Message: this is most probably a server-side exec problem ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=482468&aid=2831994&group_id=56967 ------------------------------------------------------------------------------ Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day trial. Simplify your report design, integration and deployment - and focus on what you do best, core application coding. Discover what's new with Crystal Reports now. http://p.sf.net/sfu/bobj-july _______________________________________________ Monetdb-bugs mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/monetdb-bugs
