Unable to generate a WSDL for a SQL Service Engine project

[Brynjar Glesnes]

Hi!

I'm unable to generate a WSDL for a SQL Service Engine project using the latest Open-esb build. How do I resolve this?

I'm using the openesb-installer-windows-20080505.exe build of open-esb / netbeans and I'm trying to create a service unit based on the SQL Service Engine. I've created a SQL Module project in Netbeans. In this project I've created a SQL file with a select statement (select * from DOCUMENT_TYPE where ID = ?;). In Netbeans I've also connected to the database specified in the connectivityInfo.xml file.

When I try to generate a WSDL for the service I get a warning however, pointing me to the Netbeans log. The generated WSDL have an empty record for the response message, in effect making it useless.

In the Netbeans log I find the following stacktrace for the sample Derby base:

java.sql.SQLException: Syntax error: Encountered ";" at line 1, column 41.
        at org.apache.derby.client.am.SQLExceptionFactory.getSQLException(Unknown Source)
        at org.apache.derby.client.am.SqlException.getSQLException(Unknown Source)
        at org.apache.derby.client.am.Connection.prepareStatement(Unknown Source)
        at org.netbeans.modules.sql.project.dbmodel.DBMetaData.getPrepStmtMetaData(DBMetaData.java:695)
        at org.netbeans.modules.sql.project.dbmodel.DBMetaData.getPrepStmtMetaData(DBMetaData.java:737)
        at org.netbeans.modules.sql.project.wsdl.WSDLGenerator.generateSelectSchemaElements(WSDLGenerator.java:935)
        at org.netbeans.modules.sql.project.wsdl.WSDLGenerator.modifyMessageTypes(WSDLGenerator.java:412)
        at org.netbeans.modules.sql.project.wsdl.WSDLGenerator.modifyWSDL(WSDLGenerator.java:353)
        at org.netbeans.modules.sql.project.wsdl.WSDLGenerator.generateWSDL(WSDLGenerator.java:321)
        at org.netbeans.modules.sql.project.wsdl.GenFiles.execute(GenFiles.java:266)
        at org.netbeans.modules.sql.project.wsdl.GenFiles.actionPerformed(GenFiles.java:151)
        at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1849)
        at javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2169)
        at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:420)
        at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:258)
        at javax.swing.AbstractButton.doClick(AbstractButton.java:302)
        at javax.swing.plaf.basic.BasicMenuItemUI.doClick(BasicMenuItemUI.java:1051)
        at javax.swing.plaf.basic.BasicMenuItemUI$Handler.mouseReleased(BasicMenuItemUI.java:1092)
        at java.awt.Component.processMouseEvent(Component.java:5517)
        at javax.swing.JComponent.processMouseEvent(JComponent.java:3135)
        at java.awt.Component.processEvent(Component.java:5282)
        at java.awt.Container.processEvent(Container.java:1966)
        at java.awt.Component.dispatchEventImpl(Component.java:3984)
        at java.awt.Container.dispatchEventImpl(Container.java:2024)
        at java.awt.Component.dispatchEvent(Component.java:3819)
        at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4212)
        at java.awt.LightweightDispatcher.processMouseEvent(Container.java:3892)
        at java.awt.LightweightDispatcher.dispatchEvent(Container.java:3822)
        at java.awt.Container.dispatchEventImpl(Container.java:2010)
        at java.awt.Window.dispatchEventImpl(Window.java:1791)
        at java.awt.Component.dispatchEvent(Component.java:3819)
        at java.awt.EventQueue.dispatchEvent(EventQueue.java:463)
        at org.netbeans.core.TimableEventQueue.dispatchEvent(TimableEventQueue.java:104)
        at java.awt.EventDispatchThread.pumpOneEventForHierarchy(EventDispatchThread.java:242)
        at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:163)
        at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:157)
        at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:149)
        at java.awt.EventDispatchThread.run(EventDispatchThread.java:110)
Caused by: org.apache.derby.client.am.SqlException: Syntax error: Encountered ";" at line 1, column 41.
        at org.apache.derby.client.am.Statement.completeSqlca(Unknown Source)
        at org.apache.derby.client.net.NetStatementReply.parsePrepareError(Unknown Source)
        at org.apache.derby.client.net.NetStatementReply.parsePRPSQLSTTreply(Unknown Source)
        at org.apache.derby.client.net.NetStatementReply.readPrepareDescribeOutput(Unknown Source)
        at org.apache.derby.client.net.StatementReply.readPrepareDescribeOutput(Unknown Source)
        at org.apache.derby.client.net.NetStatement.readPrepareDescribeOutput_(Unknown Source)
        at org.apache.derby.client.am.Statement.readPrepareDescribeOutput(Unknown Source)
        at org.apache.derby.client.am.PreparedStatement.readPrepareDescribeInputOutput(Unknown Source)
        at org.apache.derby.client.am.PreparedStatement.flowPrepareDescribeInputOutput(Unknown Source)
        at org.apache.derby.client.am.PreparedStatement.prepare(Unknown Source)
        at org.apache.derby.client.am.Connection.prepareStatementX(Unknown Source)
        ... 36 more

For a Oracle base using the ojdbc14.jar driver I find:

java.sql.SQLException: Ikke støttet funksjon
        at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
        at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:146)
        at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:208)
        at oracle.jdbc.driver.DatabaseError.throwUnsupportedFeatureSqlException(DatabaseError.java:499)
        at oracle.jdbc.driver.OracleParameterMetaData.getParameterType(OracleParameterMetaData.java:157)
        at org.netbeans.modules.sql.project.dbmodel.DBMetaData.getPrepStmtParameters(DBMetaData.java:1760)
        at org.netbeans.modules.sql.project.dbmodel.DBMetaData.getPrepStmtMetaData(DBMetaData.java:700)
        at org.netbeans.modules.sql.project.dbmodel.DBMetaData.getPrepStmtMetaData(DBMetaData.java:737)
        at org.netbeans.modules.sql.project.wsdl.WSDLGenerator.generateSelectSchemaElements(WSDLGenerator.java:935)
        at org.netbeans.modules.sql.project.wsdl.WSDLGenerator.modifyMessageTypes(WSDLGenerator.java:412)
        at org.netbeans.modules.sql.project.wsdl.WSDLGenerator.modifyWSDL(WSDLGenerator.java:353)
        at org.netbeans.modules.sql.project.wsdl.WSDLGenerator.generateWSDL(WSDLGenerator.java:321)
        at org.netbeans.modules.sql.project.wsdl.GenFiles.execute(GenFiles.java:266)
        at org.netbeans.modules.sql.project.wsdl.GenFiles.actionPerformed(GenFiles.java:151)
        at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1849)
        at javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2169)
        at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:420)
        at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:258)
        at javax.swing.AbstractButton.doClick(AbstractButton.java:302)
        at javax.swing.plaf.basic.BasicMenuItemUI.doClick(BasicMenuItemUI.java:1051)
        at javax.swing.plaf.basic.BasicMenuItemUI$Handler.mouseReleased(BasicMenuItemUI.java:1092)
        at java.awt.Component.processMouseEvent(Component.java:5517)
        at javax.swing.JComponent.processMouseEvent(JComponent.java:3135)
        at java.awt.Component.processEvent(Component.java:5282)
        at java.awt.Container.processEvent(Container.java:1966)
        at java.awt.Component.dispatchEventImpl(Component.java:3984)
        at java.awt.Container.dispatchEventImpl(Container.java:2024)
        at java.awt.Component.dispatchEvent(Component.java:3819)
        at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4212)
        at java.awt.LightweightDispatcher.processMouseEvent(Container.java:3892)
        at java.awt.LightweightDispatcher.dispatchEvent(Container.java:3822)
        at java.awt.Container.dispatchEventImpl(Container.java:2010)
        at java.awt.Window.dispatchEventImpl(Window.java:1791)
        at java.awt.Component.dispatchEvent(Component.java:3819)
        at java.awt.EventQueue.dispatchEvent(EventQueue.java:463)
        at org.netbeans.core.TimableEventQueue.dispatchEvent(TimableEventQueue.java:104)
        at java.awt.EventDispatchThread.pumpOneEventForHierarchy(EventDispatchThread.java:242)
        at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:163)
        at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:157)
        at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:149)
        at java.awt.EventDispatchThread.run(EventDispatchThread.java:110)
java.sql.SQLException: Ikke støttet funksjon
        at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
        at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:146)
        at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:208)
        at oracle.jdbc.driver.DatabaseError.throwUnsupportedFeatureSqlException(DatabaseError.java:499)
        at oracle.jdbc.driver.OracleParameterMetaData.getPrecision(OracleParameterMetaData.java:122)
        at org.netbeans.modules.sql.project.dbmodel.DBMetaData.getPrepStmtParameters(DBMetaData.java:1781)
        at org.netbeans.modules.sql.project.dbmodel.DBMetaData.getPrepStmtMetaData(DBMetaData.java:700)
        at org.netbeans.modules.sql.project.dbmodel.DBMetaData.getPrepStmtMetaData(DBMetaData.java:737)
        at org.netbeans.modules.sql.project.wsdl.WSDLGenerator.generateSelectSchemaElements(WSDLGenerator.java:935)
        at org.netbeans.modules.sql.project.wsdl.WSDLGenerator.modifyMessageTypes(WSDLGenerator.java:412)
        at org.netbeans.modules.sql.project.wsdl.WSDLGenerator.modifyWSDL(WSDLGenerator.java:353)
        at org.netbeans.modules.sql.project.wsdl.WSDLGenerator.generateWSDL(WSDLGenerator.java:321)
        at org.netbeans.modules.sql.project.wsdl.GenFiles.execute(GenFiles.java:266)
        at org.netbeans.modules.sql.project.wsdl.GenFiles.actionPerformed(GenFiles.java:151)
        at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1849)
        at javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2169)
        at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:420)
        at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:258)
        at javax.swing.AbstractButton.doClick(AbstractButton.java:302)
        at javax.swing.plaf.basic.BasicMenuItemUI.doClick(BasicMenuItemUI.java:1051)
        at javax.swing.plaf.basic.BasicMenuItemUI$Handler.mouseReleased(BasicMenuItemUI.java:1092)
        at java.awt.Component.processMouseEvent(Component.java:5517)
        at javax.swing.JComponent.processMouseEvent(JComponent.java:3135)
        at java.awt.Component.processEvent(Component.java:5282)
        at java.awt.Container.processEvent(Container.java:1966)
        at java.awt.Component.dispatchEventImpl(Component.java:3984)
        at java.awt.Container.dispatchEventImpl(Container.java:2024)
        at java.awt.Component.dispatchEvent(Component.java:3819)
        at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4212)
        at java.awt.LightweightDispatcher.processMouseEvent(Container.java:3892)
        at java.awt.LightweightDispatcher.dispatchEvent(Container.java:3822)
        at java.awt.Container.dispatchEventImpl(Container.java:2010)
        at java.awt.Window.dispatchEventImpl(Window.java:1791)
        at java.awt.Component.dispatchEvent(Component.java:3819)
        at java.awt.EventQueue.dispatchEvent(EventQueue.java:463)
        at org.netbeans.core.TimableEventQueue.dispatchEvent(TimableEventQueue.java:104)
        at java.awt.EventDispatchThread.pumpOneEventForHierarchy(EventDispatchThread.java:242)
        at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:163)
        at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:157)
        at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:149)
        at java.awt.EventDispatchThread.run(EventDispatchThread.java:110)
java.sql.SQLException: Ikke støttet funksjon
        at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
        at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:146)
        at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:208)
        at oracle.jdbc.driver.DatabaseError.throwUnsupportedFeatureSqlException(DatabaseError.java:499)
        at oracle.jdbc.driver.OracleParameterMetaData.getScale(OracleParameterMetaData.java:139)
        at org.netbeans.modules.sql.project.dbmodel.DBMetaData.getPrepStmtParameters(DBMetaData.java:1792)
        at org.netbeans.modules.sql.project.dbmodel.DBMetaData.getPrepStmtMetaData(DBMetaData.java:700)
        at org.netbeans.modules.sql.project.dbmodel.DBMetaData.getPrepStmtMetaData(DBMetaData.java:737)
        at org.netbeans.modules.sql.project.wsdl.WSDLGenerator.generateSelectSchemaElements(WSDLGenerator.java:935)
        at org.netbeans.modules.sql.project.wsdl.WSDLGenerator.modifyMessageTypes(WSDLGenerator.java:412)
        at org.netbeans.modules.sql.project.wsdl.WSDLGenerator.modifyWSDL(WSDLGenerator.java:353)
        at org.netbeans.modules.sql.project.wsdl.WSDLGenerator.generateWSDL(WSDLGenerator.java:321)
        at org.netbeans.modules.sql.project.wsdl.GenFiles.execute(GenFiles.java:266)
        at org.netbeans.modules.sql.project.wsdl.GenFiles.actionPerformed(GenFiles.java:151)
        at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1849)
        at javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2169)
        at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:420)
        at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:258)
        at javax.swing.AbstractButton.doClick(AbstractButton.java:302)
        at javax.swing.plaf.basic.BasicMenuItemUI.doClick(BasicMenuItemUI.java:1051)
        at javax.swing.plaf.basic.BasicMenuItemUI$Handler.mouseReleased(BasicMenuItemUI.java:1092)
        at java.awt.Component.processMouseEvent(Component.java:5517)
        at javax.swing.JComponent.processMouseEvent(JComponent.java:3135)
        at java.awt.Component.processEvent(Component.java:5282)
        at java.awt.Container.processEvent(Container.java:1966)
        at java.awt.Component.dispatchEventImpl(Component.java:3984)
        at java.awt.Container.dispatchEventImpl(Container.java:2024)
        at java.awt.Component.dispatchEvent(Component.java:3819)
        at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4212)
        at java.awt.LightweightDispatcher.processMouseEvent(Container.java:3892)
        at java.awt.LightweightDispatcher.dispatchEvent(Container.java:3822)
        at java.awt.Container.dispatchEventImpl(Container.java:2010)
        at java.awt.Window.dispatchEventImpl(Window.java:1791)
        at java.awt.Component.dispatchEvent(Component.java:3819)
        at java.awt.EventQueue.dispatchEvent(EventQueue.java:463)
        at org.netbeans.core.TimableEventQueue.dispatchEvent(TimableEventQueue.java:104)
        at java.awt.EventDispatchThread.pumpOneEventForHierarchy(EventDispatchThread.java:242)
        at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:163)
        at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:157)
        at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:149)
        at java.awt.EventDispatchThread.run(EventDispatchThread.java:110)
java.sql.SQLException: Ikke støttet funksjon
        at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
        at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:146)
        at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:208)
        at oracle.jdbc.driver.DatabaseError.throwUnsupportedFeatureSqlException(DatabaseError.java:499)
        at oracle.jdbc.driver.OracleParameterMetaData.isNullable(OracleParameterMetaData.java:64)
        at org.netbeans.modules.sql.project.dbmodel.DBMetaData.getPrepStmtParameters(DBMetaData.java:1817)
        at org.netbeans.modules.sql.project.dbmodel.DBMetaData.getPrepStmtMetaData(DBMetaData.java:700)
        at org.netbeans.modules.sql.project.dbmodel.DBMetaData.getPrepStmtMetaData(DBMetaData.java:737)
        at org.netbeans.modules.sql.project.wsdl.WSDLGenerator.generateSelectSchemaElements(WSDLGenerator.java:935)
        at org.netbeans.modules.sql.project.wsdl.WSDLGenerator.modifyMessageTypes(WSDLGenerator.java:412)
        at org.netbeans.modules.sql.project.wsdl.WSDLGenerator.modifyWSDL(WSDLGenerator.java:353)
        at org.netbeans.modules.sql.project.wsdl.WSDLGenerator.generateWSDL(WSDLGenerator.java:321)
        at org.netbeans.modules.sql.project.wsdl.GenFiles.execute(GenFiles.java:266)
        at org.netbeans.modules.sql.project.wsdl.GenFiles.actionPerformed(GenFiles.java:151)
        at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1849)
        at javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2169)
        at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:420)
        at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:258)
        at javax.swing.AbstractButton.doClick(AbstractButton.java:302)
        at javax.swing.plaf.basic.BasicMenuItemUI.doClick(BasicMenuItemUI.java:1051)
        at javax.swing.plaf.basic.BasicMenuItemUI$Handler.mouseReleased(BasicMenuItemUI.java:1092)
        at java.awt.Component.processMouseEvent(Component.java:5517)
        at javax.swing.JComponent.processMouseEvent(JComponent.java:3135)
        at java.awt.Component.processEvent(Component.java:5282)
        at java.awt.Container.processEvent(Container.java:1966)
        at java.awt.Component.dispatchEventImpl(Component.java:3984)
        at java.awt.Container.dispatchEventImpl(Container.java:2024)
        at java.awt.Component.dispatchEvent(Component.java:3819)
        at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4212)
        at java.awt.LightweightDispatcher.processMouseEvent(Container.java:3892)
        at java.awt.LightweightDispatcher.dispatchEvent(Container.java:3822)
        at java.awt.Container.dispatchEventImpl(Container.java:2010)
        at java.awt.Window.dispatchEventImpl(Window.java:1791)
        at java.awt.Component.dispatchEvent(Component.java:3819)
        at java.awt.EventQueue.dispatchEvent(EventQueue.java:463)
        at org.netbeans.core.TimableEventQueue.dispatchEvent(TimableEventQueue.java:104)
        at java.awt.EventDispatchThread.pumpOneEventForHierarchy(EventDispatchThread.java:242)
        at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:163)
        at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:157)
        at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:149)
        at java.awt.EventDispatchThread.run(EventDispatchThread.java:110)
java.sql.SQLException: setningsreferanse ikke utført: getMetaData
        at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
        at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:146)
        at oracle.jdbc.driver.OracleResultSetImpl.getMetaData(OracleResultSetImpl.java:135)
        at oracle.jdbc.driver.OraclePreparedStatement.getMetaData(OraclePreparedStatement.java:4080)
        at org.netbeans.modules.sql.project.dbmodel.DBMetaData.getPrepStmtResultSetColumns(DBMetaData.java:1858)
        at org.netbeans.modules.sql.project.dbmodel.DBMetaData.getPrepStmtMetaData(DBMetaData.java:711)
        at org.netbeans.modules.sql.project.dbmodel.DBMetaData.getPrepStmtMetaData(DBMetaData.java:737)
        at org.netbeans.modules.sql.project.wsdl.WSDLGenerator.generateSelectSchemaElements(WSDLGenerator.java:935)
        at org.netbeans.modules.sql.project.wsdl.WSDLGenerator.modifyMessageTypes(WSDLGenerator.java:412)
        at org.netbeans.modules.sql.project.wsdl.WSDLGenerator.modifyWSDL(WSDLGenerator.java:353)
        at org.netbeans.modules.sql.project.wsdl.WSDLGenerator.generateWSDL(WSDLGenerator.java:321)
        at org.netbeans.modules.sql.project.wsdl.GenFiles.execute(GenFiles.java:266)
        at org.netbeans.modules.sql.project.wsdl.GenFiles.actionPerformed(GenFiles.java:151)
        at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1849)
        at javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2169)
        at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:420)
        at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:258)
        at javax.swing.AbstractButton.doClick(AbstractButton.java:302)
        at javax.swing.plaf.basic.BasicMenuItemUI.doClick(BasicMenuItemUI.java:1051)
        at javax.swing.plaf.basic.BasicMenuItemUI$Handler.mouseReleased(BasicMenuItemUI.java:1092)
        at java.awt.Component.processMouseEvent(Component.java:5517)
        at javax.swing.JComponent.processMouseEvent(JComponent.java:3135)
        at java.awt.Component.processEvent(Component.java:5282)
        at java.awt.Container.processEvent(Container.java:1966)
        at java.awt.Component.dispatchEventImpl(Component.java:3984)
        at java.awt.Container.dispatchEventImpl(Container.java:2024)
        at java.awt.Component.dispatchEvent(Component.java:3819)
        at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4212)
        at java.awt.LightweightDispatcher.processMouseEvent(Container.java:3892)
        at java.awt.LightweightDispatcher.dispatchEvent(Container.java:3822)
        at java.awt.Container.dispatchEventImpl(Container.java:2010)
        at java.awt.Window.dispatchEventImpl(Window.java:1791)
        at java.awt.Component.dispatchEvent(Component.java:3819)
        at java.awt.EventQueue.dispatchEvent(EventQueue.java:463)
        at org.netbeans.core.TimableEventQueue.dispatchEvent(TimableEventQueue.java:104)
        at java.awt.EventDispatchThread.pumpOneEventForHierarchy(EventDispatchThread.java:242)
        at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:163)
        at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:157)
        at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:149)
        at java.awt.EventDispatchThread.run(EventDispatchThread.java:110)
java.sql.SQLException: setningsreferanse ikke utført: getMetaData
        at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
        at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:146)
        at oracle.jdbc.driver.OracleResultSetImpl.getMetaData(OracleResultSetImpl.java:135)
        at oracle.jdbc.driver.OraclePreparedStatement.getMetaData(OraclePreparedStatement.java:4080)
        at org.netbeans.modules.sql.project.dbmodel.DBMetaData.getPrepStmtResultSetColumns(DBMetaData.java:1858)
        at org.netbeans.modules.sql.project.dbmodel.DBMetaData.getPrepStmtMetaData(DBMetaData.java:711)
        at org.netbeans.modules.sql.project.dbmodel.DBMetaData.getPrepStmtMetaData(DBMetaData.java:737)
        at org.netbeans.modules.sql.project.wsdl.WSDLGenerator.generateSelectSchemaElements(WSDLGenerator.java:935)
        at org.netbeans.modules.sql.project.wsdl.WSDLGenerator.modifyMessageTypes(WSDLGenerator.java:412)
        at org.netbeans.modules.sql.project.wsdl.WSDLGenerator.modifyWSDL(WSDLGenerator.java:353)
        at org.netbeans.modules.sql.project.wsdl.WSDLGenerator.generateWSDL(WSDLGenerator.java:321)
        at org.netbeans.modules.sql.project.wsdl.GenFiles.execute(GenFiles.java:266)
        at org.netbeans.modules.sql.project.wsdl.GenFiles.actionPerformed(GenFiles.java:151)
        at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1849)
        at javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2169)
        at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:420)
        at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:258)
        at javax.swing.AbstractButton.doClick(AbstractButton.java:302)
        at javax.swing.plaf.basic.BasicMenuItemUI.doClick(BasicMenuItemUI.java:1051)
        at javax.swing.plaf.basic.BasicMenuItemUI$Handler.mouseReleased(BasicMenuItemUI.java:1092)
        at java.awt.Component.processMouseEvent(Component.java:5517)
        at javax.swing.JComponent.processMouseEvent(JComponent.java:3135)
        at java.awt.Component.processEvent(Component.java:5282)
        at java.awt.Container.processEvent(Container.java:1966)
        at java.awt.Component.dispatchEventImpl(Component.java:3984)
        at java.awt.Container.dispatchEventImpl(Container.java:2024)
        at java.awt.Component.dispatchEvent(Component.java:3819)
        at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4212)
        at java.awt.LightweightDispatcher.processMouseEvent(Container.java:3892)
        at java.awt.LightweightDispatcher.dispatchEvent(Container.java:3822)
        at java.awt.Container.dispatchEventImpl(Container.java:2010)
        at java.awt.Window.dispatchEventImpl(Window.java:1791)
        at java.awt.Component.dispatchEvent(Component.java:3819)
        at java.awt.EventQueue.dispatchEvent(EventQueue.java:463)
        at org.netbeans.core.TimableEventQueue.dispatchEvent(TimableEventQueue.java:104)
        at java.awt.EventDispatchThread.pumpOneEventForHierarchy(EventDispatchThread.java:242)
        at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:163)
        at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:157)
        at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:149)
        at java.awt.EventDispatchThread.run(EventDispatchThread.java:110)

[Brynjar Glesnes]

I've been toying with the SQL Module project at bit more. As a workaround I find that I may manually add an element for the parameter in my select statement to the element in the WSDL representing the request and elements for each of the selected columns to the element in the WSDl called record that represents the response. Hence the SQL Service Engine seems to be working and it's only the WSDL generation in Netbeans that is broken.

Brynjar Glesnes wrote:

Hi!

I'm unable to generate a WSDL for a SQL Service Engine project using the latest Open-esb build. How do I resolve this?

I'm using the openesb-installer-windows-20080505.exe build of open-esb / netbeans and I'm trying to create a service unit based on the SQL Service Engine. I've created a SQL Module project in Netbeans. In this project I've created a SQL file with a select statement (select * from DOCUMENT_TYPE where ID = ?;). In Netbeans I've also connected to the database specified in the connectivityInfo.xml file.

When I try to generate a WSDL for the service I get a warning however, pointing me to the Netbeans log. The generated WSDL have an empty record for the response message, in effect making it useless.