Need help on Webservices : Service invocation threw an exception with message : null; Refer to the server log for more details

[April Medina]

I have an exception message while trying to invoke a webservice. the details is written below..

can anybody help me...

Thanks,

April

An exception occured while creating a query in EntityManager
java.lang.IllegalArgumentException: An exception occured while creating a query in EntityManager
  at oracle.toplink.essentials.internal.ejb.cmp3.EntityManagerImpl.createQuery(EntityManagerImpl.java:209)
  at com.sun.enterprise.util.EntityManagerWrapper.createQuery(EntityManagerWrapper.java:662)
  at Entity.OPWebService.GetOffices(OPWebService.java:38)
  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 com.sun.enterprise.webservice.InstanceResolverImpl$1.invoke(InstanceResolverImpl.java:112)
  at com.sun.xml.ws.server.InvokerTube$2.invoke(InvokerTube.java:146)
  at com.sun.xml.ws.server.sei.EndpointMethodHandler.invoke(EndpointMethodHandler.java:257)
  at com.sun.xml.ws.server.sei.SEIInvokerTube.processRequest(SEIInvokerTube.java:93)
  at com.sun.xml.ws.api.pipe.Fiber.__doRun(Fiber.java:595)
  at com.sun.xml.ws.api.pipe.Fiber._doRun(Fiber.java:554)
  at com.sun.xml.ws.api.pipe.Fiber.doRun(Fiber.java:539)
  at com.sun.xml.ws.api.pipe.Fiber.runSync(Fiber.java:436)
  at com.sun.xml.ws.api.pipe.helper.AbstractTubeImpl.process(AbstractTubeImpl.java:106)
  at com.sun.enterprise.webservice.MonitoringPipe.process(MonitoringPipe.java:147)
  at com.sun.xml.ws.api.pipe.helper.PipeAdapter.processRequest(PipeAdapter.java:115)
  at com.sun.xml.ws.api.pipe.Fiber.__doRun(Fiber.java:595)
  at com.sun.xml.ws.api.pipe.Fiber._doRun(Fiber.java:554)
  at com.sun.xml.ws.api.pipe.Fiber.doRun(Fiber.java:539)
  at com.sun.xml.ws.api.pipe.Fiber.runSync(Fiber.java:436)
  at com.sun.xml.ws.api.pipe.helper.AbstractTubeImpl.process(AbstractTubeImpl.java:106)
  at com.sun.enterprise.webservice.CommonServerSecurityPipe.processRequest(CommonServerSecurityPipe.java:218)
  at com.sun.enterprise.webservice.CommonServerSecurityPipe.process(CommonServerSecurityPipe.java:129)
  at com.sun.xml.ws.api.pipe.helper.PipeAdapter.processRequest(PipeAdapter.java:115)
  at com.sun.xml.ws.api.pipe.Fiber.__doRun(Fiber.java:595)
  at com.sun.xml.ws.api.pipe.Fiber._doRun(Fiber.java:554)
  at com.sun.xml.ws.api.pipe.Fiber.doRun(Fiber.java:539)
  at com.sun.xml.ws.api.pipe.Fiber.runSync(Fiber.java:436)
  at com.sun.xml.ws.server.WSEndpointImpl$2.process(WSEndpointImpl.java:243)
  at com.sun.xml.ws.transport.http.HttpAdapter$HttpToolkit.handle(HttpAdapter.java:444)
  at com.sun.xml.ws.transport.http.HttpAdapter.handle(HttpAdapter.java:244)
  at com.sun.xml.ws.transport.http.servlet.ServletAdapter.handle(ServletAdapter.java:135)
  at com.sun.enterprise.webservice.JAXWSServlet.doPost(JAXWSServlet.java:176)
  at javax.servlet.http.HttpServlet.service(HttpServlet.java:738)
  at javax.servlet.http.HttpServlet.service(HttpServlet.java:831)
  at org.apache.catalina.core.ApplicationFilterChain.servletService(ApplicationFilterChain.java:411)
  at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:317)
  at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:198)
  at org.netbeans.modules.web.monitor.server.MonitorFilter.doFilter(MonitorFilter.java:390)
  at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:230)
  at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:198)
  at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:288)
  at org.apache.catalina.core.StandardContextValve.invokeInternal(StandardContextValve.java:271)
  at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:202)
  at org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:632)
  at org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:577)
  at com.sun.enterprise.web.WebPipeline.invoke(WebPipeline.java:94)
  at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:206)
  at org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:632)
  at org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:577)
  at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:571)
  at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:1080)
  at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:150)
  at org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:632)
  at org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:577)
  at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:571)
  at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:1080)
  at org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:272)
  at com.sun.enterprise.web.connector.grizzly.DefaultProcessorTask.invokeAdapter(DefaultProcessorTask.java:637)
  at com.sun.enterprise.web.connector.grizzly.DefaultProcessorTask.doProcess(DefaultProcessorTask.java:568)
  at com.sun.enterprise.web.connector.grizzly.DefaultProcessorTask.process(DefaultProcessorTask.java:813)
  at com.sun.enterprise.web.connector.grizzly.DefaultReadTask.executeProcessorTask(DefaultReadTask.java:341)
  at com.sun.enterprise.web.connector.grizzly.DefaultReadTask.doTask(DefaultReadTask.java:263)
  at com.sun.enterprise.web.connector.grizzly.DefaultReadTask.doTask(DefaultReadTask.java:214)
  at com.sun.enterprise.web.portunif.PortUnificationPipeline$PUTask.doTask(PortUnificationPipeline.java:380)
  at com.sun.enterprise.web.connector.grizzly.TaskBase.run(TaskBase.java:265)
  at com.sun.enterprise.web.connector.grizzly.ssl.SSLWorkerThread.run(SSLWorkerThread.java:106)
Caused by: Exception [TOPLINK-8034] (Oracle TopLink Essentials - 2.0.1 (Build b04-fcs (04/11/2008))): oracle.toplink.essentials.exceptions.EJBQLException
Exception Description: Error compiling the query [SELECT o.offname FROM office o]. Unknown abstract schema type [office].
  at oracle.toplink.essentials.exceptions.EJBQLException.unknownAbstractSchemaType(EJBQLException.java:494)
  at oracle.toplink.essentials.internal.parsing.ParseTreeContext.classForSchemaName(ParseTreeContext.java:163)
  at oracle.toplink.essentials.internal.parsing.VariableNode.resolveClass(VariableNode.java:280)
  at oracle.toplink.essentials.internal.parsing.DotNode.resolveMapping(DotNode.java:254)
  at oracle.toplink.essentials.internal.parsing.DotNode.endsWithDirectToField(DotNode.java:213)
  at oracle.toplink.essentials.internal.parsing.SelectNode.selectingDirectToField(SelectNode.java:440)
  at oracle.toplink.essentials.internal.parsing.SelectNode.hasOneToOneSelected(SelectNode.java:265)
  at oracle.toplink.essentials.internal.parsing.SelectNode.hasOneToOneSelected(SelectNode.java:222)
  at oracle.toplink.essentials.internal.parsing.SelectGenerationContext.computeUseParallelExpressions(SelectGenerationContext.java:105)
  at oracle.toplink.essentials.internal.parsing.SelectGenerationContext.<init>(SelectGenerationContext.java:88)
  at oracle.toplink.essentials.internal.parsing.ParseTree.buildContextForReadQuery(ParseTree.java:382)
  at oracle.toplink.essentials.internal.parsing.ParseTree.buildContext(ParseTree.java:370)
  at oracle.toplink.essentials.internal.parsing.EJBQLParseTree.buildContext(EJBQLParseTree.java:68)
  at oracle.toplink.essentials.internal.parsing.EJBQLParseTree.populateQuery(EJBQLParseTree.java:107)
  at oracle.toplink.essentials.internal.ejb.cmp3.base.EJBQueryImpl.buildEJBQLDatabaseQuery(EJBQueryImpl.java:219)
  at oracle.toplink.essentials.internal.ejb.cmp3.base.EJBQueryImpl.buildEJBQLDatabaseQuery(EJBQueryImpl.java:189)
  at oracle.toplink.essentials.internal.ejb.cmp3.base.EJBQueryImpl.buildEJBQLDatabaseQuery(EJBQueryImpl.java:153)
  at oracle.toplink.essentials.internal.ejb.cmp3.base.EJBQueryImpl.<init>(EJBQueryImpl.java:114)
  at oracle.toplink.essentials.internal.ejb.cmp3.base.EJBQueryImpl.<init>(EJBQueryImpl.java:99)
  at oracle.toplink.essentials.internal.ejb.cmp3.EJBQueryImpl.<init>(EJBQueryImpl.java:86)
  at oracle.toplink.essentials.internal.ejb.cmp3.EntityManagerImpl.createQuery(EntityManagerImpl.java:204)
  ... 68 more

[Edson Carlos Ericksson Richter]

Couple of tips come to my mind:

1) The class name is "office" or "Office" (the difference is the capital
"O")?
2) You must use put
"<exclude-unlisted-classes>false</exclude-unlisted-classes>" or add your
classes with full package name;
3) Check if you have all necessary libraries for TopLink
(toplink-essentials.jar and toplink-essentials-agent.jar)

Here is a sample persistence.xml that I know works (with Glassfish AS):

<?xml version="1.0" encoding="UTF-8"?>
<persistence version="1.0"
xmlns="http://java.sun.com/xml/ns/persistence"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://java.sun.com/xml/ns/persistence 
http://java.sun.com/xml/ns/persistence/persistence_1_0.xsd">
  <persistence-unit name="DynEducPU" transaction-type="JTA">
    <jta-data-source>jdbc/VIR_ApacheDerby</jta-data-source>
    <class>br.net.everest.persistence.State</class>
    <exclude-unlisted-classes>false</exclude-unlisted-classes>
    <properties/>
  </persistence-unit>
</persistence>


Note in the example above, that is unnecessary (but not forbidden) to
list the classes in the <class> because I've used the
<exclude-unlisted-classes>. I leave it there so you can see where to
list the class names.

Kind regards,

Edson


April Medina escreveu:

>
> I have an exception message while trying to invoke a webservice. the
> details is written below..
>
> can anybody help me...
>
> Thanks,
>
> April
>
> An exception occured while creating a query in EntityManager
> java.lang.IllegalArgumentException: An exception occured while
> creating a query in EntityManager
>   at
> oracle.toplink.essentials.internal.ejb.cmp3.EntityManagerImpl.createQuery(EntityManagerImpl.java:209)
>   at
> com.sun.enterprise.util.EntityManagerWrapper.createQuery(EntityManagerWrapper.java:662)
>   at Entity.OPWebService.GetOffices(OPWebService.java:38)
>   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
> com.sun.enterprise.webservice.InstanceResolverImpl$1.invoke(InstanceResolverImpl.java:112)
>   at com.sun.xml.ws.server.InvokerTube$2.invoke(InvokerTube.java:146)
>   at
> com.sun.xml.ws.server.sei.EndpointMethodHandler.invoke(EndpointMethodHandler.java:257)
>   at
> com.sun.xml.ws.server.sei.SEIInvokerTube.processRequest(SEIInvokerTube.java:93)
>   at com.sun.xml.ws.api.pipe.Fiber.__doRun(Fiber.java:595)
>   at com.sun.xml.ws.api.pipe.Fiber._doRun(Fiber.java:554)
>   at com.sun.xml.ws.api.pipe.Fiber.doRun(Fiber.java:539)
>   at com.sun.xml.ws.api.pipe.Fiber.runSync(Fiber.java:436)
>   at
> com.sun.xml.ws.api.pipe.helper.AbstractTubeImpl.process(AbstractTubeImpl.java:106)
>   at
> com.sun.enterprise.webservice.MonitoringPipe.process(MonitoringPipe.java:147)
>   at
> com.sun.xml.ws.api.pipe.helper.PipeAdapter.processRequest(PipeAdapter.java:115)
>   at com.sun.xml.ws.api.pipe.Fiber.__doRun(Fiber.java:595)
>   at com.sun.xml.ws.api.pipe.Fiber._doRun(Fiber.java:554)
>   at com.sun.xml.ws.api.pipe.Fiber.doRun(Fiber.java:539)
>   at com.sun.xml.ws.api.pipe.Fiber.runSync(Fiber.java:436)
>   at
> com.sun.xml.ws.api.pipe.helper.AbstractTubeImpl.process(AbstractTubeImpl.java:106)
>   at
> com.sun.enterprise.webservice.CommonServerSecurityPipe.processRequest(CommonServerSecurityPipe.java:218)
>   at
> com.sun.enterprise.webservice.CommonServerSecurityPipe.process(CommonServerSecurityPipe.java:129)
>   at
> com.sun.xml.ws.api.pipe.helper.PipeAdapter.processRequest(PipeAdapter.java:115)
>   at com.sun.xml.ws.api.pipe.Fiber.__doRun(Fiber.java:595)
>   at com.sun.xml.ws.api.pipe.Fiber._doRun(Fiber.java:554)
>   at com.sun.xml.ws.api.pipe.Fiber.doRun(Fiber.java:539)
>   at com.sun.xml.ws.api.pipe.Fiber.runSync(Fiber.java:436)
>   at
> com.sun.xml.ws.server.WSEndpointImpl$2.process(WSEndpointImpl.java:243)
>   at
> com.sun.xml.ws.transport.http.HttpAdapter$HttpToolkit.handle(HttpAdapter.java:444)
>   at
> com.sun.xml.ws.transport.http.HttpAdapter.handle(HttpAdapter.java:244)
>   at
> com.sun.xml.ws.transport.http.servlet.ServletAdapter.handle(ServletAdapter.java:135)
>   at
> com.sun.enterprise.webservice.JAXWSServlet.doPost(JAXWSServlet.java:176)
>   at javax.servlet.http.HttpServlet.service(HttpServlet.java:738)
>   at javax.servlet.http.HttpServlet.service(HttpServlet.java:831)
>   at
> org.apache.catalina.core.ApplicationFilterChain.servletService(ApplicationFilterChain.java:411)
>   at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:317)
>   at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:198)
>   at
> org.netbeans.modules.web.monitor.server.MonitorFilter.doFilter(MonitorFilter.java:390)
>   at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:230)
>   at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:198)
>   at
> org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:288)
>   at
> org.apache.catalina.core.StandardContextValve.invokeInternal(StandardContextValve.java:271)
>   at
> org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:202)
>   at
> org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:632)
>   at
> org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:577)
>   at com.sun.enterprise.web.WebPipeline.invoke(WebPipeline.java:94)
>   at
> org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:206)
>   at
> org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:632)
>   at
> org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:577)
>   at
> org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:571)
>   at
> org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:1080)
>   at
> org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:150)
>   at
> org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:632)
>   at
> org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:577)
>   at
> org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:571)
>   at
> org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:1080)
>   at
> org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:272)
>   at
> com.sun.enterprise.web.connector.grizzly.DefaultProcessorTask.invokeAdapter(DefaultProcessorTask.java:637)
>   at
> com.sun.enterprise.web.connector.grizzly.DefaultProcessorTask.doProcess(DefaultProcessorTask.java:568)
>   at
> com.sun.enterprise.web.connector.grizzly.DefaultProcessorTask.process(DefaultProcessorTask.java:813)
>   at
> com.sun.enterprise.web.connector.grizzly.DefaultReadTask.executeProcessorTask(DefaultReadTask.java:341)
>   at
> com.sun.enterprise.web.connector.grizzly.DefaultReadTask.doTask(DefaultReadTask.java:263)
>   at
> com.sun.enterprise.web.connector.grizzly.DefaultReadTask.doTask(DefaultReadTask.java:214)
>   at
> com.sun.enterprise.web.portunif.PortUnificationPipeline$PUTask.doTask(PortUnificationPipeline.java:380)
>   at
> com.sun.enterprise.web.connector.grizzly.TaskBase.run(TaskBase.java:265)
>   at
> com.sun.enterprise.web.connector.grizzly.ssl.SSLWorkerThread.run(SSLWorkerThread.java:106)
> Caused by: Exception [TOPLINK-8034] (Oracle TopLink Essentials - 2.0.1
> (Build b04-fcs (04/11/2008))):
> oracle.toplink.essentials.exceptions.EJBQLException
> Exception Description: Error compiling the query [SELECT o.offname
> FROM office o]. Unknown abstract schema type [office].
>   at
> oracle.toplink.essentials.exceptions.EJBQLException.unknownAbstractSchemaType(EJBQLException.java:494)
>   at
> oracle.toplink.essentials.internal.parsing.ParseTreeContext.classForSchemaName(ParseTreeContext.java:163)
>   at
> oracle.toplink.essentials.internal.parsing.VariableNode.resolveClass(VariableNode.java:280)
>   at
> oracle.toplink.essentials.internal.parsing.DotNode.resolveMapping(DotNode.java:254)
>   at
> oracle.toplink.essentials.internal.parsing.DotNode.endsWithDirectToField(DotNode.java:213)
>   at
> oracle.toplink.essentials.internal.parsing.SelectNode.selectingDirectToField(SelectNode.java:440)
>   at
> oracle.toplink.essentials.internal.parsing.SelectNode.hasOneToOneSelected(SelectNode.java:265)
>   at
> oracle.toplink.essentials.internal.parsing.SelectNode.hasOneToOneSelected(SelectNode.java:222)
>   at
> oracle.toplink.essentials.internal.parsing.SelectGenerationContext.computeUseParallelExpressions(SelectGenerationContext.java:105)
>   at
> oracle.toplink.essentials.internal.parsing.SelectGenerationContext.<init>(SelectGenerationContext.java:88)
>   at
> oracle.toplink.essentials.internal.parsing.ParseTree.buildContextForReadQuery(ParseTree.java:382)
>   at
> oracle.toplink.essentials.internal.parsing.ParseTree.buildContext(ParseTree.java:370)
>   at
> oracle.toplink.essentials.internal.parsing.EJBQLParseTree.buildContext(EJBQLParseTree.java:68)
>   at
> oracle.toplink.essentials.internal.parsing.EJBQLParseTree.populateQuery(EJBQLParseTree.java:107)
>   at
> oracle.toplink.essentials.internal.ejb.cmp3.base.EJBQueryImpl.buildEJBQLDatabaseQuery(EJBQueryImpl.java:219)
>   at
> oracle.toplink.essentials.internal.ejb.cmp3.base.EJBQueryImpl.buildEJBQLDatabaseQuery(EJBQueryImpl.java:189)
>   at
> oracle.toplink.essentials.internal.ejb.cmp3.base.EJBQueryImpl.buildEJBQLDatabaseQuery(EJBQueryImpl.java:153)
>   at
> oracle.toplink.essentials.internal.ejb.cmp3.base.EJBQueryImpl.<init>(EJBQueryImpl.java:114)
>   at
> oracle.toplink.essentials.internal.ejb.cmp3.base.EJBQueryImpl.<init>(EJBQueryImpl.java:99)
>   at
> oracle.toplink.essentials.internal.ejb.cmp3.EJBQueryImpl.<init>(EJBQueryImpl.java:86)
>   at
> oracle.toplink.essentials.internal.ejb.cmp3.EntityManagerImpl.createQuery(EntityManagerImpl.java:204)
>   ... 68 more
>
>

[April Medina]

Hi Edson!

It's working now!

I've modified persistence.xml on my project according to your example and I'm seeing the results for my web service...

Thanks a lot!

April