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.
Build: NetBeans IDE 6.0 (Build 200711261600) VM: Java HotSpot(TM) Client VM, 1.5.0_09-b03 OS: Windows XP, 5.1, x86 User comments: When dropping a database table from the services tab that contains a CLOB column Netbeans cannot work with the CLOB and returns an error. Netbeans also does not work when trying to load the clob data using the data provider. Is netbeans able at all to use CLOB data? STACKTRACE: (first 10 lines) java.lang.NullPointerException at com.sun.sql.rowset.RowSetMetaDataXImpl.getColumnClassName(RowSetMetaDataXImpl.java:108) at com.sun.data.provider.impl.CachedRowSetDataProvider.getType(CachedRowSetDataProvider.java:584) at com.sun.webui.jsf.component.table.TableRowGroupDesignState.resetTableColumns (TableRowGroupDesignState.java:365) at com.sun.webui.jsf.component.table.TableRowGroupDesignState.setDataProviderBean (TableRowGroupDesignState.java:210) at com.sun.webui.jsf.component.table.TableDesignState.setDataProviderBean(TableDesignState.java:262) at com.sun.webui.jsf.component.TableDesignInfo.linkBeans(TableDesignInfo.java:182) at org.netbeans.modules.visualweb.insync.models.FacesModel.linkBeans(FacesModel.java:1204) at org.netbeans.modules.visualweb.designer.jsf.JsfForm.linkDesignBeans(JsfForm.java:2872) at org.netbeans.modules.visualweb.designer.jsf.FacesDndSupport.processLinks(FacesDndSupport.java:1090) at org.netbeans.modules.visualweb.designer.jsf.FacesDndSupport.importBean(FacesDndSupport.java:650)
Which version of the Oracle driver are you using? The supported versions are on this page: http://wiki.netbeans.org/DatabasesAndDrivers#section-DatabasesAndDrivers-OracleDriverForTheOracle10.xDatabase
I'll need to see your sql script to create your table As mentioned in 132090 , this article shows CLOBs working with NetBeans: http://blogs.sun.com/dashboy/entry/using_clob_datatypes_with_netbeans
Is this error still occurring? Any more information you can provide (oracle driver version, schema ) As mentioned read/write of CLOBs do work with Dataproviders
User says the same error occurs as 132090 which has a workaround as stated in the comment "The work around is to add -Doracledatabasemetadata.get_lob_precision=false in the JVM options of the application server *** This issue has been marked as a duplicate of 132090 ***
Also see http://bugs.sun.com/bugdatabase/view_bug.do?bug_id=4625851