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.
Summary: | Cannot generate WSDL with SQL Module and Oracle DB | ||
---|---|---|---|
Product: | soa | Reporter: | jozwicki <jozwicki> |
Component: | SQL Project | Assignee: | Venkat Srinivasan <vsrinivasan> |
Status: | NEW --- | ||
Severity: | blocker | ||
Priority: | P3 | ||
Version: | 6.x | ||
Hardware: | All | ||
OS: | All | ||
Issue Type: | DEFECT | Exception Reporter: | |
Attachments: |
Fix for generating WSDL from SQL using Oracle JDBC driver
Fixed SQL Module jar |
Description
jozwicki
2008-06-18 23:21:26 UTC
Maybe for databases which don't support getting statement metadata before statement execution there should be some dialog box asking for standard parameters for binding. Here is WSDL generated for 'select sysdate as s1, sysdate+1 as s2 from dual' with applied patch: <?xml version="1.0" encoding="UTF-8"?> <definitions name="SQLApp1" targetNamespace="http://com.sun.jbi/sqlse/sqlseengine" xmlns="http://schemas.xmlsoap.org/wsdl/" xmlns:tns="http://com.sun.jbi/sqlse/sqlseengine" xmlns:slnk="http://schemas.xmlsoap.org/ws/2002/07/service-link/" xmlns:plink="http://docs.oasis-open.org/wsbpel/2.0/plnktype" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:soap="http://schemas.xmlsoap.org/wsdl/soap/"> <types> <xsd:schema xmlns:xsd="http://www.w3.org/2001/XMLSchema" elementFormDefault="qualified" targetNamespace="http://com.sun.jbi/sqlse/sqlseengine" xmlns="http://com.sun.jbi/sqlse/sqlseengine"> <xsd:element name="sysdateRequest"> <xsd:complexType> <xsd:sequence/> </xsd:complexType> </xsd:element> <xsd:element name="sysdateResponse"> <xsd:complexType> <xsd:sequence> <xsd:element maxOccurs="unbounded" ref="record"/> </xsd:sequence> </xsd:complexType> </xsd:element> <xsd:element name="record"> <xsd:complexType> <xsd:sequence> <xsd:element name="S1" type="xsd:string"/> <xsd:element name="S2" type="xsd:string"/> </xsd:sequence> </xsd:complexType> </xsd:element> </xsd:schema> </types> <message name="sysdateRequest"> <part name="sysdateRequestPart" element="tns:sysdateRequest"/> </message> <message name="sysdateResponse"> <part name="sysdateResponsePart" element="tns:sysdateResponse"/> </message> <portType name="SQLApp1_sqlsePortType"> <operation name="sysdate"> <input name="sysdateRequest" message="tns:sysdateRequest"/> <output name="sysdateResponse" message="tns:sysdateResponse"/> </operation> </portType> <binding name="SQLApp1Binding" type="tns:SQLApp1_sqlsePortType"> <operation name="sysdate"> <input name="sysdateRequest"> </input> <output name="sysdateResponse"> </output> </operation> </binding> <service name="SQLApp1_sqlseService"> <port name="SQLApp1_sqlsePort" binding="tns:SQLApp1Binding"> </port> </service> <plink:partnerLinkType xmlns:plink="http://docs.oasis-open.org/wsbpel/2.0/plnktype" name="SQLApp1_sqlsePartnerLinkType"> <plink:role name="SQLApp1_myrole" portType="tns:SQLApp1_sqlsePortType"/> </plink:partnerLinkType> </definitions> Result is not 100% correct, however better than nothing. also resultsetcolumn.setName(resultsetmetadata.getColumnName(j)); resultsetcolumn.setSqlType(getSQLTypeDescription(resultsetmetadata.getColumnType(j))); resultsetcolumn.setJavaType(getJavaFromSQLTypeDescription(resultsetcolumn.getSqlType())); try { resultsetcolumn.setOrdinalPosition(j); } catch (Exception e) {} try { resultsetcolumn.setNumericPrecision(resultsetmetadata.getPrecision(j)); } catch (Exception e) {} try { resultsetcolumn.setNumericScale(resultsetmetadata.getScale(j)); } catch (Exception e) {} would help. If I have free time I can try to install Mercurial, download source and deliver patch. Created attachment 63323 [details]
Fix for generating WSDL from SQL using Oracle JDBC driver
Created attachment 63324 [details]
Fixed SQL Module jar
Changed target milestone. http://systest.googlecode.com/files/org-netbeans-modules-sql-project.jar Here is SOA2 SQL module fixed for Oracle select, insert, update, delete and call operations. Class org.netbeans.modules.sql.project.dbmodel.DBMetaData was taken from soa-dev65. |