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.
Create SQL project Create a SQL file called CreateTable. open the synchronousSample projct. Add the SQL JBI Module to the composite app(SynchronousSampleApplication). when deploying the CA, get the following err: pre-init: init-private: init-userdir: init-user: init-project: do-init: post-init: init-check: init: init-deploy: deps-jar: pre-init: init-private: init-userdir: init-user: init-project: do-init: post-init: init-check: init-taskdefs: init: pre-dist: dist_se: Expanding: C:\Documents and Settings\Administrator\My Documents\NetBeansProjects\SQLApp1\build\SEDeployment.jar into C:\Documents and Settings\Administrator\My Documents\NetBeansProjects\SynchronousSample1\SynchronousSample1Application\src\jbiServiceUnits\SQLApp1 DEPRECATED - The copyfile task is deprecated. Use copy instead. C:\Documents and Settings\Administrator\My Documents\NetBeansProjects\SynchronousSample1\SynchronousSample1Application\nbproject\build-impl.xml:131: src C:\Documents and Settings\Administrator\My Documents\NetBeansProjects\SynchronousSample1\SynchronousSample1Application\src\jbiServiceUnits\SQLApp1\META-INF\jbi.xml does not exist. BUILD FAILED (total time: 0 seconds)
Created attachment 41577 [details] the sql and sample project zip file
Please look into this.
A menu item "Generate WSDL.." is added to generate the WSDL before building the project.Please try generating the WSDL and then building the project. Added a pop-up to remind the user to generate the WSDL if the jbi.xml is not generated. Steps: 1.Create a SQL Project. 2.Edit the connectivityinfo.xml as required. 2.Right-click on the folder SQLApp1 project and select Other 3.Select Service Oriented Architecture from Categories. 4.Select SQL File from File Types. Click Next. 5.Input CreateTable for the File Name 6.Click the Browse button and select src. Click Finish. 7.Copy and past the following to the CreateCustomerTable.sql source editor CREATE TABLE SynchronousCallLog ( ID INT NOT NULL GENERATED ALWAYS AS IDENTITY PRIMARY KEY, INSERT_TIMESTAMP TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, MESSAGE VARCHAR(200) ); NOTE : AS YOU ARE CREATING THE TABLE PLEASE DO NOT EXECUTE THE COMMAND BECAUSE IF YOU EXECUTE THE COMMAND.THE TABLE WILL BE CREATED AND IF YOU DEPLOY THE PROJECT YOU WILL GET ERROR SAYING "TABLE ALREADY EXISTS". 9. Right Click on the SQL Project and Generate the WSDL using "Generate WSDL.." Item. 10. Add the bindings(file or soap etc)and address. 11. Build the Project. After that create a Composite Application, add the JBI Module and build and deploy the project. Please let me know if you have any queries.
I followed your steps. It does not create any table.
works fine . CREATE TABLE SynchronousCallLog ( ID INT NOT NULL GENERATED ALWAYS AS IDENTITY PRIMARY KEY, INSERT_TIMESTAMP TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, MESSAGE VARCHAR(200) ) dont use ";" at the end . build details :- --------------- NetBeans IDE 6.0 Preview (M9, build 070502) 1.6.0_01; Java HotSpot(TM) Client VM 1.6.0_01-b06 Windows XP version 5.1 running on x86 en_US (nb); Cp1252