This Bugzilla instance is a read-only archive of historic NetBeans bug reports. To report a bug in NetBeans please follow the project's instructions for reporting issues.
This issue is related to issue #161048 though instead of problems with DECIMAL it has to do with VARCHAR. Suppose a VARCHAR column has content like the following stored: <svg xmlns:xlink="http://www.w3.org/1999/xlink" ...> ... </svg> I get the following back when using the 'Show SQL script for INSERT' function on one or more rows: INSERT INTO TESTDB."test" ("id", "value") VALUES (1, svg xmlns:xlink="http://www.w3.org/1999/xlink" ...> ... </svg); Instead of: INSERT INTO TESTDB."test" ("id", "value") VALUES (1, '<svg xmlns:xlink="http://www.w3.org/1999/xlink" ...> ... </svg>'); Note the lack of surrounding quotes, the leading '<' and trailing '>'. This results in an unusable (error generating) statement if you want to execute it because the string can not be converted to a suitable value. I'm using Netbeans 6.7.1 in combination with Apache Derby. Let me know if you need any more information.
http://hg.netbeans.org/core-main/rev/29f23c1172ab Fixed.
Integrated into 'main-golden', will be available in build *201204250400* on http://bits.netbeans.org/dev/nightly/ (upload may still be in progress) Changeset: http://hg.netbeans.org/main-golden/rev/29f23c1172ab User: Jaroslav Havlin <jhavlin@netbeans.org> Log: #172281 - 'Show SQL script for INSERT' returns invalid strings for varchar