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.

Bug 132090 - java.lang.NumberFormatException: For input string: "4294967295"
Summary: java.lang.NumberFormatException: For input string: "4294967295"
Status: RESOLVED WONTFIX
Alias: None
Product: obsolete
Classification: Unclassified
Component: visualweb (show other bugs)
Version: 6.x
Hardware: PC Windows XP
: P1 blocker (vote)
Assignee: John Baker
URL: http://statistics.netbeans.org/except...
Keywords:
: 132081 (view as bug list)
Depends on:
Blocks:
 
Reported: 2008-04-04 16:10 UTC by tehe
Modified: 2008-05-14 00:53 UTC (History)
1 user (show)

See Also:
Issue Type: DEFECT
Exception Reporter: 10316

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description tehe 2008-04-04 16:10:33 UTC 
When dragging and dropping a database table from the services window to a table in the HTML desing the error occurs. 
This is always the cas when trying to read CLOBS. Could it be a driver or database problem?


Build: NetBeans IDE Dev (Build 20070919103038)
VM: Java HotSpot(TM) Client VM, 1.6.0_03-b05
OS: Windows XP, 5.1, x86
User comments: 
STACKTRACE: (first 10 lines)
java.lang.NumberFormatException: For input string: "4294967295"
        at java.lang.NumberFormatException.forInputString(NumberFormatException.java:48)
        at java.lang.Integer.parseInt(Integer.java:459)
        at java.lang.Integer.parseInt(Integer.java:497)
        at oracle.jdbc.driver.OracleResultSetMetaData.getPrecision(OracleResultSetMetaData.java:303)
        at com.sun.sql.rowset.CachedRowSetXImpl5.initMetaData(CachedRowSetXImpl5.java:748)
        at com.sun.sql.rowset.CachedRowSetXImpl5.getMetaData(CachedRowSetXImpl5.java:2254)
        at com.sun.data.provider.impl.CachedRowSetDataProvider.getMetaData(CachedRowSetDataProvider.java:1401)
        at com.sun.data.provider.impl.CachedRowSetDataProvider.getFieldKeys(CachedRowSetDataProvider.java:513)
        at com.sun.webui.jsf.component.TableDesignInfo.linkBeans(TableDesignInfo.java:176)
        at org.netbeans.modules.visualweb.insync.models.FacesModel.linkBeans(FacesModel.java:1181)
Comment 1 John Baker 2008-04-04 18:41:52 UTC 
Which version of the Oracle driver are you using?

The supported version is mentioned on this page:
http://wiki.netbeans.org/DatabasesAndDrivers#section-DatabasesAndDrivers-OracleDriverForTheOracle10.xDatabase
Comment 2 John Baker 2008-04-04 18:56:57 UTC 
btw, from the comment, it appears you're using a pre-fcs version of NetBeans 6.0

Also, I have written a basic application that uses CLOBs and it is working
http://blogs.sun.com/dashboy/entry/using_clob_datatypes_with_netbeans
Comment 3 John Baker 2008-04-04 18:59:38 UTC 
correction
> btw, from the comment, it appears you're using a pre-fcs version of NetBeans 6.0
please disregard, the version looks correct
Comment 4 John Baker 2008-04-04 19:01:02 UTC 
if you can share your sql script to create your table, I can try it out
Comment 5 dante 2008-04-14 11:21:17 UTC 
The JDBC jar was the ojdbc6.jar and the table below contain the clob.

DROP TABLE clob_table;

CREATE TABLE clob_table (
    id NUMBER PRIMARY KEY, 
    text VARCHAR(30),
    clob_col CLOB
);

INSERT INTO clob_Table VALUES (0, 'RECORD 0', 'COMMENT FOR RECORD 0');
INSERT INTO clob_Table VALUES (1, 'RECORD 1', 'COMMENT FOR RECORD 1');
INSERT INTO clob_Table VALUES (2, 'RECORD 2', 'COMMENT FOR RECORD 2');
INSERT INTO clob_Table VALUES (3, 'RECORD 3', 'COMMENT FOR RECORD 3');
Comment 6 John Baker 2008-05-13 17:10:34 UTC 
The work around is to add
-Doracledatabasemetadata.get_lob_precision=false

in the JVM options of the application server
Comment 7 John Baker 2008-05-14 00:53:14 UTC 
*** Issue 132081 has been marked as a duplicate of this issue. ***