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 135975 - "WSDL from Database" wizard handles exceptions badly
Summary: "WSDL from Database" wizard handles exceptions badly
Status: NEW
Alias: None
Product: soa
Classification: Unclassified
Component: SQL Project (show other bugs)
Version: 6.x
Hardware: PC Windows XP
: P3 blocker (vote)
Assignee: Venkat Srinivasan
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2008-05-28 10:52 UTC by ats37
Modified: 2008-05-28 10:52 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 ats37 2008-05-28 10:52:23 UTC
I'm using Netbeans 6.1 under Sun's JDK 1.6.0_02 on Windows XP.

I configured a database driver (in the Services window) for Oracle using the v9.2.0 JDBC driver (ojdbc14.jar &
nsl_charset12.jar).  I successfully connected to one of our databases Using this, and can see various tables & stored
procedures when I expand the node.

I created a new empty SQL Module project, and ran the New -> WSDL From Database... wizard.  However, at the third step
after selecting my database connection from the dropdown list, no tables are shown in the Available Tables list.  Other
database connections (e.g. the default derby ones and another Sybase connection I had previously configured) show plenty
of entries, and like I said I can see a number of tables in the Oracle database in the Services window's node.

After a bit of investigation, I came across an exception in the messages.log:

java.sql.SQLException: Unsupported feature
	at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
	at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:179)
	at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:269)
	at oracle.jdbc.dbaccess.DBError.throwUnsupportedFeatureSqlException(DBError.java:689)
	at oracle.jdbc.OracleDatabaseMetaData.getDatabaseMajorVersion(OracleDatabaseMetaData.java:4442)
	at org.netbeans.modules.jdbcwizard.builder.DBMetaData.getDatabaseMajorVersion(DBMetaData.java:444)
[catch] at org.netbeans.modules.jdbcwizard.wizards.JDBCWizardSelectionPanel.persistModel(JDBCWizardSelectionPanel.java:321)
	at org.netbeans.modules.jdbcwizard.wizards.JDBCWizardSelectionPanel.updateSourceSchema(JDBCWizardSelectionPanel.java:285)
	at
org.netbeans.modules.jdbcwizard.wizards.JDBCWizardSelectionPanel.dbschemaComboBoxActionPerformed(JDBCWizardSelectionPanel.java:270)
	at org.netbeans.modules.jdbcwizard.wizards.JDBCWizardSelectionPanel.access$000(JDBCWizardSelectionPanel.java:72)
	at
org.netbeans.modules.jdbcwizard.wizards.JDBCWizardSelectionPanel$AddJDBCDataSourceActionListener.actionPerformed(JDBCWizardSelectionPanel.java:118)

Upgrading to the Oracle 11g drivers (ojdbc6.jar & orai18n.jar) and changing the connection settings accordingly fixed
this; half a dozen tables were listed and I could generate the WSDL & XSD.  I'd have figured it out quicker if the
exception were handled better, though.  IMO the wizard should at least display an "error retrieving tables list"
message, rather than just simply leaving the select list empty.

Trying it all again later, I noticed a flashing "exception indicator" icon in the bottom right corner of the window when
I selected the v9 connection from the dropdown, but it's not particularly obvious (I missed it completely first time
round) and since the wizard is modal anyway clicking on it has no effect.