Creating a WSDL from a Database

[jsexton0]

I'd like to try out the various methods of database access/update from a BPEL.  To start I used the admin console to create a connection pool, which I can ping, and then a JNDI name.  That seems to work fine.  

Now in a BPEL project, I select "new" and "WSDL from Database".  The pool I created does not appear on the drop down list of available database sources.

Did I miss a step?

Thanks

[jsexton0]

My problem here is that I did not define the database connection in Netbeans.  I should have thought of that...  Now I have created a simple service assembly including a step that inserts a record in a table.  There are no errors in building anything, but in deploying the SA, I get an exception.

JBIFW2459: Unexpected exception java.lang.NoClassDefFoundError occurred on init for Service Unit CMS_AddCardHolderSA-sun-jdbc-binding. Exception message text is: org/apache/xmlbeans/XmlException.
java.lang.NoClassDefFoundError: org/apache/xmlbeans/XmlException
        at com.sun.wsdl4j.ext.impl.WSDLFactoryEx.newWSDLReaderEx(WSDLFactoryEx.java:55)
        at com.sun.jbi.jdbcbc.JDBCBindingDeployer$DeployHelper.readWsdl(JDBCBindingDeployer.java:474)
        at com.sun.jbi.jdbcbc.JDBCBindingDeployer$DeployHelper.readAllDefinitions(JDBCBindingDeployer.java:1107)
        at com.sun.jbi.jdbcbc.JDBCBindingDeployer$DeployHelper.deploy(JDBCBindingDeployer.java:752)
        at com.sun.jbi.jdbcbc.JDBCBindingDeployer$DeployHelper.access$100(JDBCBindingDeployer.java:437)
        at com.sun.jbi.jdbcbc.JDBCBindingDeployer.processDeployment(JDBCBindingDeployer.java:226)
        at com.sun.jbi.jdbcbc.JDBCBindingDeployer.init(JDBCBindingDeployer.java:192)
        at com.sun.jbi.framework.ServiceUnitOperation.process(ServiceUnitOperation.java:181)
        at com.sun.jbi.framework.Operation.run(Operation.java:104)
        at java.lang.Thread.run(Thread.java:619)

What class is missing?  My first thought would be the jdbc driver class, but this class is available (it has to be because I was able to create the connection pool in the server).

Thanks

jsexton0 wrote:

I'd like to try out the various methods of database access/update from a BPEL.  To start I used the admin console to create a connection pool, which I can ping, and then a JNDI name.  That seems to work fine.  

Now in a BPEL project, I select "new" and "WSDL from Database".  The pool I created does not appear on the drop down list of available database sources.

Did I miss a step?

Thanks

[jqian]

Cross-posting...

jsexton0 wrote:

> My problem here is that I did not define the database connection in Netbeans.
> I should have thought of that...  Now I have created a simple service
> assembly including a step that inserts a record in a table.  There are no
> errors in building anything, but in deploying the SA, I get an exception.
>
> JBIFW2459: Unexpected exception java.lang.NoClassDefFoundError occurred on
> init for Service Unit CMS_AddCardHolderSA-sun-jdbc-binding. Exception
> message text is: org/apache/xmlbeans/XmlException.
> java.lang.NoClassDefFoundError: org/apache/xmlbeans/XmlException
>         at
> com.sun.wsdl4j.ext.impl.WSDLFactoryEx.newWSDLReaderEx(WSDLFactoryEx.java:55)
>         at
> com.sun.jbi.jdbcbc.JDBCBindingDeployer$DeployHelper.readWsdl(JDBCBindingDeployer.java:474)
>         at
> com.sun.jbi.jdbcbc.JDBCBindingDeployer$DeployHelper.readAllDefinitions(JDBCBindingDeployer.java:1107)
>         at
> com.sun.jbi.jdbcbc.JDBCBindingDeployer$DeployHelper.deploy(JDBCBindingDeployer.java:752)
>         at
> com.sun.jbi.jdbcbc.JDBCBindingDeployer$DeployHelper.access$100(JDBCBindingDeployer.java:437)
>         at
> com.sun.jbi.jdbcbc.JDBCBindingDeployer.processDeployment(JDBCBindingDeployer.java:226)
>         at
> com.sun.jbi.jdbcbc.JDBCBindingDeployer.init(JDBCBindingDeployer.java:192)
>         at
> com.sun.jbi.framework.ServiceUnitOperation.process(ServiceUnitOperation.java:181)
>         at com.sun.jbi.framework.Operation.run(Operation.java:104)
>         at java.lang.Thread.run(Thread.java:619)
>
> What class is missing?  My first thought would be the jdbc driver class, but
> this class is available (it has to be because I was able to create the
> connection pool in the server).
>
> Thanks
>
>
> jsexton0 wrote:
>  
>> I'd like to try out the various methods of database access/update from a
>> BPEL.  To start I used the admin console to create a connection pool,
>> which I can ping, and then a JNDI name.  That seems to work fine.  
>>
>> Now in a BPEL project, I select "new" and "WSDL from Database".  The pool
>> I created does not appear on the drop down list of available database
>> sources.
>>
>> Did I miss a step?
>>
>> Thanks
>>
>>    
>
>  

[jsexton0]

Hello -

I have a little more information about this.

When I include any WSDL made from the database in a service assembly, and deploy from Netbeans, the deploy fails with java.lang.NoClassDefFoundError: org/apache/xmlbeans/XmlException.

When I deploy the same application from the Glassfish administration web application, it deploys fine, and runs normally just as I'd like.

The software versions here are quite new.  I downloaded the package just a few days ago, and have patches it with available updates.