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 91632 - The JDBC Driver (oracle 9i) does not provide the capabilities required for the feature
Summary: The JDBC Driver (oracle 9i) does not provide the capabilities required for th...
Status: RESOLVED WONTFIX
Alias: None
Product: obsolete
Classification: Unclassified
Component: visualweb (show other bugs)
Version: 5.x
Hardware: All Windows XP
: P1 blocker (vote)
Assignee: _ jimdavidson
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2006-12-29 13:25 UTC by anolasco
Modified: 2007-01-26 20:35 UTC (History)
0 users

See Also:
Issue Type: ENHANCEMENT
Exception Reporter:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description anolasco 2006-12-29 13:25:45 UTC
Hi!

First we want to apologize for our english and to thank for your time.

We are developing an application in Netbeans 5.5, Visual Web Pack, JBoss 4.0.4 
GA and Oracle 9i Data Base. We are using jdbc conection with the oracle driver 
10.2.0.2. 

When we execute a sql query that we have done with the sql statement editor, 
using the "add query criteria" to add parameters, the NetBeans return us an 
error: "The JDBC Driver does not provide the capabilities required for the 
feature".

We had proved with others drivers(ojdbc.jar 9.2.0.8, 10.2.0.1 ) with the same 
results. And we had proved too with de derby driver that provide the Sun Java 
System Aplication Server 9 having a successfull result.

Waiting for an answer.

Cabildo de Gran Canaria
Comment 1 _ jimdavidson 2007-01-03 00:53:20 UTC
This is a known problem with the Oracle JDBC driver.  

That driver does not properly implement the  method getParameterMetaData(),
which is necessary to execute a parameterized query.  That's the meaning of the
error message.

Until Oracle fixes the drivers, there's not much that the Visual Editor can do
to support query execution.  I've changed this to an Enhancement, and set
resolution as REMIND, but it's unlikely that we will try to work around this.

Incidentally, drivers like Derby do implement the necessary methods, so queries
can be execute from within the editor.