Hi Jeremi,

This is pretty much what the UDDI030 test does.. which work ok for me. Can you try running this test using your data? Also can you try to get the server side log of this error? Or is that what you attached below?

Cheers,

--Kurt

Jeremi Thebeau wrote:
Hi all,

on the Snapshot release of jUDDI (http://people.apache.org/repo/m2-snapshot-repository/org/apache/juddi/juddi-portal-bundle/3.0.0.SNAPSHOT/juddi-portal-bundle-3.0.0.20090723.201427-7.zip), I'm having trouble deleting businesses. I only insert an auth token and the business key (which does exist in the DB) in the DeleteBusiness object and get an "org.hibernate.exception.SQLGrammarException: could not initialize a collection" error:

[18:02:41,687] DEBUG [main] - Outbound Message:
HTTP Headers:

Soap Message:
<S:Envelope xmlns:S="http://schemas.xmlsoap.org/soap/envelope/";>
   <S:Body>
<delete_business xmlns="urn:uddi-org:api_v3" xmlns:ns10="urn:uddi-org:policy_v3_instanceParms" xmlns:ns2="urn:uddi-org:custody_v3" xmlns:ns3="urn:uddi-org:repl_v3" xmlns:ns4="http://www.w3.org/2000/09/xmldsig#"; xmlns:ns5="urn:uddi-org:sub_v3" xmlns:ns6="urn:uddi-org:subr_v3" xmlns:ns7="urn:uddi-org:vscache_v3" xmlns:ns8="urn:uddi-org:policy_v3" xmlns:ns9="urn:uddi-org:vs_v3">
           <authInfo>
               authtoken:de780cf9-d473-46dd-8952-423fd6dc9e4f
           </authInfo>
           <businessKey>
               uddi:juddi.apache.org:e03bb00e-4a88-4481-88da-e13d84f746c4
           </businessKey>
       </delete_business>
   </S:Body>
</S:Envelope>

Message Context Properties:
- com.sun.xml.internal.ws.api.message.HeaderList = []
- com.sun.xml.internal.ws.api.server.WSEndpoint = null
- com.sun.xml.internal.ws.client.ContentNegotiation = none
- com.sun.xml.internal.ws.client.handle = JAX-WS RI 2.1.6 in JDK 6: Stub for http://192.168.178.200:8080/juddi/services/publish - com.sun.xml.internal.ws.handler.config = com.sun.xml.internal.ws.client.handlerconfigurat...@52744
- com.sun.xml.internal.ws.server.OneWayOperation = true
- javax.xml.ws.handler.message.outbound = true
- javax.xml.ws.reference.parameters = []
- javax.xml.ws.service.endpoint.address = http://192.168.178.200:8080/juddi/services/publish
- javax.xml.ws.soap.http.soapaction.uri = delete_business
- javax.xml.ws.wsdl.interface = {urn:uddi-org:api_v3_portType}UDDI_Publication_PortType - javax.xml.ws.wsdl.port = {urn:uddi-org:api_v3_portType}UDDIPublishServicePort - javax.xml.ws.wsdl.service = {urn:uddi-org:api_v3_portType}UDDIPublishService

[18:02:41,697] DEBUG [main] - Inbound Message:
HTTP Headers:
- null = [HTTP/1.1 200 OK]
- Content-type = [text/xml;charset=UTF-8]
- Content-length = [395]
- Server = [Apache-Coyote/1.1]
- Date = [Mon, 10 Aug 2009 16:03:11 GMT]

Soap Message:
<soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/";>
   <soap:Header />
   <soap:Body>
       <soap:Fault>
           <faultcode>
               soap:Server
           </faultcode>
           <faultstring>
org.hibernate.exception.SQLGrammarException: could not initialize a collection: [org.apache.juddi.model.BusinessService.projectingBusinesses#uddi:juddi.apache.org:35b4b045-7fac-4edb-8082-937e9b9c9825]
           </faultstring>
       </soap:Fault>
   </soap:Body>
</soap:Envelope>

Message Context Properties:
- com.sun.xml.internal.ws.api.message.HeaderList = []
- com.sun.xml.internal.ws.api.server.WSEndpoint = null
- com.sun.xml.internal.ws.client.ContentNegotiation = none
- com.sun.xml.internal.ws.client.handle = null
- com.sun.xml.internal.ws.handler.config = com.sun.xml.internal.ws.client.handlerconfigurat...@52744
- com.sun.xml.internal.ws.server.OneWayOperation = null
- com.xceptance.xlt.ws.handler.requestData = com.xceptance.xlt.api.engine.requestd...@1ab6c1c
- javax.xml.ws.handler.message.outbound = false
- javax.xml.ws.http.response.code = 200
- javax.xml.ws.http.response.headers = {null=[HTTP/1.1 200 OK], Content-type=[text/xml;charset=UTF-8], Content-length=[395], Server=[Apache-Coyote/1.1], Date=[Mon, 10 Aug 2009 16:03:11 GMT]}
- javax.xml.ws.reference.parameters = []
- javax.xml.ws.service.endpoint.address = http://192.168.178.200:8080/juddi/services/publish
- javax.xml.ws.soap.http.soapaction.uri = null
- javax.xml.ws.wsdl.interface = {urn:uddi-org:api_v3_portType}UDDI_Publication_PortType - javax.xml.ws.wsdl.port = {urn:uddi-org:api_v3_portType}UDDIPublishServicePort - javax.xml.ws.wsdl.service = {urn:uddi-org:api_v3_portType}UDDIPublishService

[18:02:41,711] ERROR [main] - Execution step failed (user: 'TDeleteBusiness-0', output: '1249920157861'): javax.xml.ws.soap.SOAPFaultException: org.hibernate.exception.SQLGrammarException: could not initialize a collection: [org.apache.juddi.model.BusinessService.projectingBusinesses#uddi:juddi.apache.org:35b4b045-7fac-4edb-8082-937e9b9c9825] at com.sun.xml.internal.ws.fault.SOAP11Fault.getProtocolException(SOAP11Fault.java:178) at com.sun.xml.internal.ws.fault.SOAPFaultBuilder.createException(SOAPFaultBuilder.java:111) at com.sun.xml.internal.ws.client.sei.SyncMethodHandler.invoke(SyncMethodHandler.java:108) at com.sun.xml.internal.ws.client.sei.SyncMethodHandler.invoke(SyncMethodHandler.java:78)
   at com.sun.xml.internal.ws.client.sei.SEIStub.invoke(SEIStub.java:107)
   at $Proxy46.deleteBusiness(Unknown Source)
at org.apache.juddi.xlt.action.SOAP.UnregisterBusiness.execute(UnregisterBusiness.java:52) at com.xceptance.xlt.api.actions.AbstractAction.run(AbstractAction.java:315) at org.apache.juddi.xlt.test.TDeleteBusiness.deleteBusiness(TDeleteBusiness.java:59)
   at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
   at java.lang.reflect.Method.invoke(Method.java:597)
at org.junit.runners.model.FrameworkMethod$1.runReflectiveCall(FrameworkMethod.java:44) at org.junit.internal.runners.model.ReflectiveCallable.run(ReflectiveCallable.java:15) at org.junit.runners.model.FrameworkMethod.invokeExplosively(FrameworkMethod.java:41) at org.junit.internal.runners.statements.InvokeMethod.evaluate(InvokeMethod.java:20) at org.junit.internal.runners.statements.RunBefores.evaluate(RunBefores.java:28) at org.junit.internal.runners.statements.RunAfters.evaluate(RunAfters.java:31) at org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:73) at org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:46)
   at org.junit.runners.ParentRunner.runChildren(ParentRunner.java:180)
   at org.junit.runners.ParentRunner.access$000(ParentRunner.java:41)
   at org.junit.runners.ParentRunner$1.evaluate(ParentRunner.java:173)
at org.junit.internal.runners.statements.RunBefores.evaluate(RunBefores.java:28) at org.junit.internal.runners.statements.RunAfters.evaluate(RunAfters.java:31)
   at org.junit.runners.ParentRunner.run(ParentRunner.java:220)
at org.eclipse.jdt.internal.junit4.runner.JUnit4TestReference.run(JUnit4TestReference.java:45) at org.eclipse.jdt.internal.junit.runner.TestExecution.run(TestExecution.java:38) at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:460) at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:673) at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRunner.java:386) at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRunner.java:196)


If I pass it an invalid key I get a proper "key could not be found" error msg. Any ideas?

Thanks

Jeremi

Reply via email to