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 94522 - Unsupported feature on run query with tables having non-standard data types
Summary: Unsupported feature on run query with tables having non-standard data types
Status: RESOLVED INCOMPLETE
Alias: None
Product: obsolete
Classification: Unclassified
Component: visualweb (show other bugs)
Version: 5.x
Hardware: All Windows XP
: P3 blocker (vote)
Assignee: John Baker
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2007-02-05 21:25 UTC by Chary Kanaparthi
Modified: 2008-02-06 14:38 UTC (History)
1 user (show)

See Also:
Issue Type: DEFECT
Exception Reporter:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Chary Kanaparthi 2007-02-05 21:25:10 UTC
shortfin RC3

+ add Oracle driver
+ add database connection jdbc:oracle:thin:@xxxx
+ drop ONLINE_MEDIA onto page
+ open query editor and Run Query
+ It says "Unsupported feature"
*********** Exception occurred ************ at 11:33 AM on Oct 19, 2006
java.lang.RuntimeException: java.lang.ClassNotFoundException: oracle.sql.STRUCT
        at
com.sun.data.provider.impl.CachedRowSetDataProvider.getType(CachedRowSetDataProvider.java:528)
        at
com.sun.rave.propertyeditors.binding.nodes.DataProviderTargetNodeFactory$DataProviderTargetNode$SelectItemsNode.initCustomPanel(DataProviderTargetNodeFactory.java:244)
        at
com.sun.rave.propertyeditors.binding.nodes.DataProviderTargetNodeFactory$DataProviderTargetNode$SelectItemsNode.<init>(DataProviderTargetNodeFactory.java:160)
        at
com.sun.rave.propertyeditors.binding.nodes.DataProviderTargetNodeFactory$DataProviderTargetNode$OptionsNode.<init>(DataProviderTargetNodeFactory.java:143)
        at
com.sun.rave.propertyeditors.binding.nodes.DataProviderTargetNodeFactory$DataProviderTargetNode$1$1.run(DataProviderTargetNodeFactory.java:62)
        at java.awt.event.InvocationEvent.dispatch(InvocationEvent.java:209)
        at java.awt.EventQueue.dispatchEvent(EventQueue.java:597)
[catch] at
java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:273)
        at
java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:183)
        at
java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:177)
        at java.awt.Dialog$1.run(Dialog.java:1039)
        at java.awt.Dialog$3.run(Dialog.java:1091)
        at java.security.AccessController.doPrivileged(Native Method)
        at java.awt.Dialog.show(Dialog.java:1089)
        at
org.netbeans.core.windows.services.NbPresenter.superShow(NbPresenter.java:816)
        at
org.netbeans.core.windows.services.NbPresenter.doShow(NbPresenter.java:859)
        at org.netbeans.core.windows.services.NbPresenter.run(NbPresenter.java:847)
        at org.openide.util.Mutex.doEventAccess(Mutex.java:1178)
        at org.openide.util.Mutex.readAccess(Mutex.java:215)
        at org.netbeans.core.windows.services.NbPresenter.show(NbPresenter.java:832)
        at
com.sun.rave.insync.CustomizerDisplayer.show(CustomizerDisplayer.java:128)
        at com.sun.rave.insync.ResultHandler.handleResult(ResultHandler.java:165)
        at
com.sun.rave.insync.action.AbstractDisplayActionAction.invokeDisplayAction(AbstractDisplayActionAction.java:107)
        at
com.sun.rave.insync.action.AbstractDisplayActionAction.access$200(AbstractDisplayActionAction.java:58)
        at
com.sun.rave.insync.action.AbstractDisplayActionAction$SingleDisplayActionAction.actionPerformed(AbstractDisplayActionAction.java:234)
        at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1995)
        at
javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2318)
        at
javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:387)
        at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:242)
        at javax.swing.AbstractButton.doClick(AbstractButton.java:357)
        at javax.swing.plaf.basic.BasicMenuItemUI.doClick(BasicMenuItemUI.java:1170)
        at
javax.swing.plaf.basic.BasicMenuItemUI$Handler.mouseReleased(BasicMenuItemUI.java:1211)
        at java.awt.Component.processMouseEvent(Component.java:6038)
        at javax.swing.JComponent.processMouseEvent(JComponent.java:3260)
        at java.awt.Component.processEvent(Component.java:5803)
        at java.awt.Container.processEvent(Container.java:2058)
        at java.awt.Component.dispatchEventImpl(Component.java:4410)
        at java.awt.Container.dispatchEventImpl(Container.java:2116)
        at java.awt.Component.dispatchEvent(Component.java:4240)
        at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4322)
        at java.awt.LightweightDispatcher.processMouseEvent(Container.java:3986)
        at java.awt.LightweightDispatcher.dispatchEvent(Container.java:3916)
        at java.awt.Container.dispatchEventImpl(Container.java:2102)
        at java.awt.Window.dispatchEventImpl(Window.java:2429)
        at java.awt.Component.dispatchEvent(Component.java:4240)
        at java.awt.EventQueue.dispatchEvent(EventQueue.java:599)
        at
java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:273)
        at
java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:183)
        at
java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:173)
        at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:168)
        at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:160)
        at java.awt.EventDispatchThread.run(EventDispatchThread.java:121)
Caused by: java.lang.ClassNotFoundException: oracle.sql.STRUCT
        at java.net.URLClassLoader$1.run(URLClassLoader.java:200)
        at java.security.AccessController.doPrivileged(Native Method)
        at java.net.URLClassLoader.findClass(URLClassLoader.java:188)
        at java.lang.ClassLoader.loadClass(ClassLoader.java:306)
        at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:276)
        at java.lang.ClassLoader.loadClass(ClassLoader.java:251)
        at org.netbeans.ProxyClassLoader.loadInOrder(ProxyClassLoader.java:582)
        at org.netbeans.ProxyClassLoader.smartLoadClass(ProxyClassLoader.java:531)
        at org.netbeans.ProxyClassLoader.loadClass(ProxyClassLoader.java:163)
        at java.lang.ClassLoader.loadClass(ClassLoader.java:251)
        at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:319)
        at java.lang.Class.forName0(Native Method)
        at java.lang.Class.forName(Class.java:169)
        at
com.sun.data.provider.impl.CachedRowSetDataProvider.getType(CachedRowSetDataProvider.java:523)
        ... 51 more
[rave.queryeditor] Error occurred when trying to retrieve table information:
java.sql.SQLException: Unsupported feature
[rave.queryeditor] Error occurred when trying to retrieve table information:
java.sql.SQLException: Unsupported feature

-----------
I could run the same query via Execute command in DB Explorer and view the rows
This is not a regression, It is reproducible in leopard but with the
SQLException message that comes from the driver
*** (#1 of 1): 2006-10-19 11:52:16 PDT sakthivel
Comment 1 Jiri Prox 2007-09-17 21:39:32 UTC
Obsolete milestone, please reevaluate
Comment 2 John Baker 2007-10-17 01:31:46 UTC
Chary please provide the JDBC URL
The schema for the one I have does not contain ONLINE_MEDIA