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 100261 - Regression: JDBC WSDL Wizard Encountered NPE when connect using JDBC-ODBC Bridge data source
Summary: Regression: JDBC WSDL Wizard Encountered NPE when connect using JDBC-ODBC Bri...
Alias: None
Product: soa
Classification: Unclassified
Component: Binding Components (show other bugs)
Version: 6.x
Hardware: All All
: P2 blocker (vote)
Assignee: Narayana Pedapudi
Keywords: RELNOTE
Depends on:
Reported: 2007-04-06 22:01 UTC by rpoon
Modified: 2007-05-07 14:03 UTC (History)
1 user (show)

See Also:
Issue Type: DEFECT
Exception Reporter:

Unexpected_Exception JPEG (28.88 KB, image/jpeg)
2007-04-06 22:02 UTC, rpoon
NullPointerException JPEG (157.76 KB, image/jpeg)
2007-04-06 22:02 UTC, rpoon
Good_Connection_in_IDE_Runtime (115.77 KB, image/jpeg)
2007-04-06 22:03 UTC, rpoon
Message log (232.21 KB, text/plain)
2007-04-06 22:04 UTC, rpoon
NPE jpeg (2.60 MB, image/jpeg)
2007-05-02 18:07 UTC, rpoon
BuildInfo (50.58 KB, application/octet-stream)
2007-05-03 08:46 UTC, Narayana Pedapudi

Note You need to log in before you can comment on or make changes to this bug.
Description rpoon 2007-04-06 22:01:23 UTC


After created a new JDBC-ODBC Bidge - database connection (to SQL Server) under 
NetBeans IDE Runtime, and able to connect successfully (see attached JPEG) in 
JDBC WSDL wizard, using the same connection user is unable to proceed to create 
WSDL with the following NullPointerException once selected a table name:

	at org.openide.WizardDescriptor.setValueOpen(

To re-create the problem:

1) Create a Data source that connect to SQL Server from windwows 'Data Sources 
(ODBC)'.  Verify successful connection with this data source.

2) In NetBeans IDE/Runtime, create new Database Connection using 'JDBC-ODBC 
Bridge' type driver, and confirm successful connection to external database 
(Connect OK).

3) Now start the JDBC WSDL Wizard, and make connection using the same Database 
Source created in step 2 above. (Connect OK).

4) Now select a table and procceed to the next step.

The NPE occurs after clicking 'Next' on the 'Select DataSource and Table 
Objects' screen.

This is a regression problem.  This problem does not exist with Beta build.
Comment 1 rpoon 2007-04-06 22:02:08 UTC
Created attachment 40581 [details]
Unexpected_Exception JPEG
Comment 2 rpoon 2007-04-06 22:02:57 UTC
Created attachment 40582 [details]
NullPointerException JPEG
Comment 3 rpoon 2007-04-06 22:03:49 UTC
Created attachment 40583 [details]
Comment 4 rpoon 2007-04-06 22:04:19 UTC
Created attachment 40584 [details]
Message log
Comment 5 Narayana Pedapudi 2007-04-11 11:45:43 UTC
For JDBC-ODBC driver we need to select columns by order otherwise driver throws 
Invalid Descriptor Index exception. Because the driver is a native driver. This
is fixed and checked in the source. I wonder how this worked in beta.
Comment 6 rpoon 2007-05-02 18:05:50 UTC
With build:  NetBeans 6.0 Enterprise Pack – Milestone 9
     NetBeans IDE 6.0 Preview (M9) Full Installer.exe


Now encountered NullPointerException once selected table (with JDBC-ODBC 
connection) and click Next.

(please see attached jpeg for the NPE message)
Comment 7 rpoon 2007-05-02 18:07:16 UTC
Created attachment 42061 [details]
NPE jpeg
Comment 8 Annette Wegscheider 2007-05-02 21:52:41 UTC
Added to RNs as follows:
Issue #100261: JDBC Database Wizard cannot be used with JDBC-ODBC connections.
Description: If you are connecting to a database using JDBC-ODBC, you cannot use
the JDBC Database Wizard to generate a WSDL file.
Workaround: Use the New WSDL File Wizard to generate a WSDL skeleton. Then
modify the generated WSDL file using the WSDL Editor.

Comment 9 Narayana Pedapudi 2007-05-03 08:46:18 UTC
Created attachment 42080 [details]
Comment 10 Narayana Pedapudi 2007-05-03 08:51:50 UTC
I have Installed SQL Server on my machine and created the System DSN, could
generate the WSDL with System DSN using JDBC-ODBC drivers. Build used is
"NetBeans IDE 6.0 Preview (M9, build 070430)", If it doesn't work for you, can
you please provide the privileges to connect the SQL Server you are using.
Comment 11 rpoon 2007-05-03 22:12:30 UTC
I have retried and still am able to recreate the problem with latest m9 build:

From IDE Runtime, I was able to connect to SQL Server database using the 
JDBC:ODBC connection, however, it failed to proceed to build WSDL from the JDBC 
WSDL wizard (it does not able to continue once connecting to database via JDBC-
ODBC and after a table is selected).
Comment 12 Narayana Pedapudi 2007-05-07 14:03:07 UTC
When working odbc drivers result set must be scrolled sequentially otherwise it
will throw an exception "Invalid Descriptor Exception", this is fixed and
checked in. Please verify with the latest build after this check in.