-
1. Re: Incorrect syntax near '.'
rareddy Jul 31, 2012 4:20 PM (in response to mananpat)Can you provide whole stack?
-
2. Re: Incorrect syntax near '.'
mananpat Jul 31, 2012 4:45 PM (in response to rareddy)============================================================================
16:22:39,228 INFO [STDOUT] [/BooksWebServiceVDB/Books, {http://teiid.org}Books,
[MessageInfo INPUT: {http://teiid.org}Books_getBooksByISBN_ISBN], {content-type
=[text/xml;charset=UTF-8], connection=[Keep-Alive], host=[localhost:8080], Conte
nt-Length=[253], SOAPAction=[""], user-agent=[Apache-HttpClient/4.1.1 (java 1.5)
], accept-encoding=[gzip,deflate], Content-Type=[text/xml;charset=UTF-8]}, {http
://teiid.org}Books, org.apache.catalina.connector.RequestFacade@64712baa, org.ap
ache.catalina.core.StandardWrapperFacade@41e9d96a, null, null, [], /BooksWebServ
iceVDBhttp://localhost:8080/BooksWebServiceVDB/Books, /BooksWebServiceVDBnull, {
http://teiid.org}BooksWebServiceVDB, POST, [org.apache.cxf.transport.https.CertC
onstraintsInterceptor@5fc0dff4], UTF-8, null, org.jboss.wsf.stack.cxf.HttpServle
tResponseExt@7ea90d2e, org.apache.cxf.transport.http.AbstractHTTPDestination$1@c
a087f9, true, {http://teiid.org}getBooksByISBN, false, org.apache.cxf.transport.
servlet.ServletDestination@b930359, {}, http://localhost:8080/BooksWebServiceVDB
/Books?wsdl, text/xml;charset=UTF-8, org.apache.catalina.core.ApplicationContext
Facade@60c0cdfe]
16:22:39,671 SEVERE [soap] Exception in executeDataservice: {0}
java.lang.Throwable: java.sql.SQLException: Incorrect syntax near '.'.
at org.teiid.soap.provider.TeiidWSProvider.execute(TeiidWSProvider.java:
194)
at org.teiid.soap.provider.TeiidWSProvider.invoke(TeiidWSProvider.java:3
16)
at org.teiid.soap.provider.Books.invoke(Books.java:22)
at org.teiid.soap.provider.Books.invoke(Books.java:15)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.
java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
sorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.apache.cxf.service.invoker.AbstractInvoker.performInvocation(Abst
ractInvoker.java:173)
at org.apache.cxf.service.invoker.AbstractInvoker.invoke(AbstractInvoker
.java:89)
at org.apache.cxf.jaxws.JAXWSMethodInvoker.invoke(JAXWSMethodInvoker.jav
a:60)
at org.apache.cxf.service.invoker.AbstractInvoker.invoke(AbstractInvoker
.java:75)
at org.apache.cxf.interceptor.ServiceInvokerInterceptor$1.run(ServiceInv
okerInterceptor.java:58)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:44
1)
at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)
at java.util.concurrent.FutureTask.run(FutureTask.java:138)
at org.apache.cxf.workqueue.SynchronousExecutor.execute(SynchronousExecu
tor.java:37)
at org.apache.cxf.interceptor.ServiceInvokerInterceptor.handleMessage(Se
rviceInvokerInterceptor.java:106)
at org.apache.cxf.phase.PhaseInterceptorChain.doIntercept(PhaseIntercept
orChain.java:236)
at org.apache.cxf.transport.ChainInitiationObserver.onMessage(ChainIniti
ationObserver.java:109)
at org.apache.cxf.transport.servlet.ServletDestination.invoke(ServletDes
tination.java:98)
at org.apache.cxf.transport.servlet.ServletController.invokeDestination(
ServletController.java:394)
at org.jboss.wsf.stack.cxf.ServletControllerExt.invoke(ServletController
Ext.java:175)
at org.jboss.wsf.stack.cxf.RequestHandlerImpl.handleHttpRequest(RequestH
andlerImpl.java:61)
at org.jboss.wsf.stack.cxf.CXFServletExt.invoke(CXFServletExt.java:194)
at org.apache.cxf.transport.servlet.AbstractHTTPServlet.handleRequest(Ab
stractHTTPServlet.java:179)
at org.apache.cxf.transport.servlet.AbstractHTTPServlet.doPost(AbstractH
TTPServlet.java:103)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
at org.apache.cxf.transport.servlet.AbstractHTTPServlet.service(Abstract
HTTPServlet.java:159)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:206)
at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFi
lter.java:96)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperV
alve.java:235)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextV
alve.java:191)
at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(Securit
yAssociationValve.java:190)
at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValv
e.java:92)
at org.jboss.web.tomcat.security.SecurityContextEstablishmentValve.proce
ss(SecurityContextEstablishmentValve.java:126)
at org.jboss.web.tomcat.security.SecurityContextEstablishmentValve.invok
e(SecurityContextEstablishmentValve.java:70)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.j
ava:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.j
ava:102)
at org.jboss.web.tomcat.service.jca.CachedConnectionValve.invoke(CachedC
onnectionValve.java:158)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineVal
ve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.jav
a:330)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java
:829)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.proce
ss(Http11Protocol.java:598)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:44
7)
at java.lang.Thread.run(Thread.java:662)
Caused by: java.sql.SQLException: Incorrect syntax near '.'.
at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.j
ava:368)
at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2820)
at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2258)
at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:632)
at net.sourceforge.jtds.jdbc.JtdsStatement.processResults(JtdsStatement.
java:584)
at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQL(JtdsStatement.java
:546)
at net.sourceforge.jtds.jdbc.JtdsPreparedStatement.execute(JtdsPreparedS
tatement.java:558)
at org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.execute(Wrap
pedPreparedStatement.java:299)
at org.teiid.soap.provider.TeiidWSProvider.execute(TeiidWSProvider.java:
124)
... 48 more
16:22:39,719 WARNING [PhaseInterceptorChain] Application has thrown exception, u
nwinding now
org.apache.cxf.binding.soap.SoapFault: Incorrect syntax near '.'.
at org.apache.cxf.jaxws.AbstractJAXWSMethodInvoker.createFault(AbstractJ
AXWSMethodInvoker.java:75)
at org.apache.cxf.service.invoker.AbstractInvoker.invoke(AbstractInvoker
.java:121)
at org.apache.cxf.jaxws.JAXWSMethodInvoker.invoke(JAXWSMethodInvoker.jav
a:60)
at org.apache.cxf.service.invoker.AbstractInvoker.invoke(AbstractInvoker
.java:75)
at org.apache.cxf.interceptor.ServiceInvokerInterceptor$1.run(ServiceInv
okerInterceptor.java:58)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:44
1)
at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)
at java.util.concurrent.FutureTask.run(FutureTask.java:138)
at org.apache.cxf.workqueue.SynchronousExecutor.execute(SynchronousExecu
tor.java:37)
at org.apache.cxf.interceptor.ServiceInvokerInterceptor.handleMessage(Se
rviceInvokerInterceptor.java:106)
at org.apache.cxf.phase.PhaseInterceptorChain.doIntercept(PhaseIntercept
orChain.java:236)
at org.apache.cxf.transport.ChainInitiationObserver.onMessage(ChainIniti
ationObserver.java:109)
at org.apache.cxf.transport.servlet.ServletDestination.invoke(ServletDes
tination.java:98)
at org.apache.cxf.transport.servlet.ServletController.invokeDestination(
ServletController.java:394)
at org.jboss.wsf.stack.cxf.ServletControllerExt.invoke(ServletController
Ext.java:175)
at org.jboss.wsf.stack.cxf.RequestHandlerImpl.handleHttpRequest(RequestH
andlerImpl.java:61)
at org.jboss.wsf.stack.cxf.CXFServletExt.invoke(CXFServletExt.java:194)
at org.apache.cxf.transport.servlet.AbstractHTTPServlet.handleRequest(Ab
stractHTTPServlet.java:179)
at org.apache.cxf.transport.servlet.AbstractHTTPServlet.doPost(AbstractH
TTPServlet.java:103)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
at org.apache.cxf.transport.servlet.AbstractHTTPServlet.service(Abstract
HTTPServlet.java:159)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:206)
at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFi
lter.java:96)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperV
alve.java:235)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextV
alve.java:191)
at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(Securit
yAssociationValve.java:190)
at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValv
e.java:92)
at org.jboss.web.tomcat.security.SecurityContextEstablishmentValve.proce
ss(SecurityContextEstablishmentValve.java:126)
at org.jboss.web.tomcat.security.SecurityContextEstablishmentValve.invok
e(SecurityContextEstablishmentValve.java:70)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.j
ava:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.j
ava:102)
at org.jboss.web.tomcat.service.jca.CachedConnectionValve.invoke(CachedC
onnectionValve.java:158)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineVal
ve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.jav
a:330)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java
:829)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.proce
ss(Http11Protocol.java:598)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:44
7)
at java.lang.Thread.run(Thread.java:662)
Caused by: java.lang.RuntimeException: javax.xml.ws.soap.SOAPFaultException: Inc
orrect syntax near '.'.
at org.teiid.soap.provider.TeiidWSProvider.invoke(TeiidWSProvider.java:3
18)
at org.teiid.soap.provider.Books.invoke(Books.java:22)
at org.teiid.soap.provider.Books.invoke(Books.java:15)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.
java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
sorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.apache.cxf.service.invoker.AbstractInvoker.performInvocation(Abst
ractInvoker.java:173)
at org.apache.cxf.service.invoker.AbstractInvoker.invoke(AbstractInvoker
.java:89)
... 39 more
Caused by: javax.xml.ws.soap.SOAPFaultException: Incorrect syntax near '.'.
at org.teiid.soap.provider.TeiidWSProvider.createSOAPFaultMessage(TeiidW
SProvider.java:248)
at org.teiid.soap.provider.TeiidWSProvider.execute(TeiidWSProvider.java:
201)
at org.teiid.soap.provider.TeiidWSProvider.invoke(TeiidWSProvider.java:3
16)
... 47 more
-
BooksWebServiceVDB-ds.xml 1.8 KB
-
-
3. Re: Incorrect syntax near '.'
rareddy Jul 31, 2012 4:29 PM (in response to mananpat)Are there any exceptions on the Server log? you may need to put server in DEBUG mode to see whole stack in case of an error.
-
4. Re: Incorrect syntax near '.'
tejones Jul 31, 2012 4:34 PM (in response to mananpat)Manan,
Can you please attach the *-ds.xml file that defines the JNDI name of BooksWebServiceVDB?
Thanks,
Ted
-
-
6. Re: Incorrect syntax near '.'
tejones Jul 31, 2012 4:50 PM (in response to mananpat)Manan,
The issue is you are connecting the the underlying data source, not the VDB. You need to creata a -ds.xml for your VDB and then use that JNDI name in the WAR generation.
Thanks,
Ted
-
7. Re: Incorrect syntax near '.'
mananpat Jul 31, 2012 5:00 PM (in response to tejones)Thanks Ted.
Any specific help or pointer on this. I have been following example and instruction where it says:
1) deploy the VDB.
2) from Teiid view, right click to create Data Source.
3) I entered some name "BooksWebServiceVDBDataSource"
4) Then I select to package war and I enter "BooksWebServiceVDBDataSource" in the JNDI entry.
Any thing wrong with above?
thx
-
8. Re: Incorrect syntax near '.'
mananpat Jul 31, 2012 5:06 PM (in response to mananpat)Above 3) is the Create Data Source window in the Teiid Designer -
Here, in the Connection Source section - i have 2 options
I select 2nd option - Use Connection Profile Info: I have choice of the physical source connection only -
although, I can create new but new connection to where?
So I kept selecting the existing conenction to which is also used for my Relation model.
Regards,
-
9. Re: Incorrect syntax near '.'
tejones Jul 31, 2012 5:11 PM (in response to mananpat)Manan,
In the Teiid view, right click on your deployed VDB (under the VDB section) and select "Create Data Source". Create a new Connection Profile of type "Teiid". This will allow you to define your VDB connection properties and create the -ds.xml file.
Thanks,
Ted
-
10. Re: Incorrect syntax near '.'
mananpat Jul 31, 2012 5:19 PM (in response to tejones)Now I tried to create new connection source first in the Data Source Explorer - > Web Service Data Source - with my WSDL url, and used that data source profile while generating war.
i get below error.
<soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/">
<soap:Body>
<soap:Fault>
<faultcode>soap:Server</faultcode>
<faultstring>org.teiid.resource.spi.WrappedConnectionFactory cannot be cast to javax.sql.DataSource</faultstring>
</soap:Fault>
</soap:Body>
</soap:Envelope>
-
11. Re: Incorrect syntax near '.'
tejones Jul 31, 2012 5:34 PM (in response to mananpat)Yeah.. that won't work. The JNDI connection has to be for the deployed VDB. Then use that JNDI name for the generated WAR. The war is not connecting *to* a web service, it is connecting to the VDB with the web service models in it *from* a web service. Make sense?
-
12. Re: Incorrect syntax near '.'
mananpat Jul 31, 2012 5:48 PM (in response to tejones)yes.. I got the webservice connection working now. The trick is to select VDB connection as Teiid connection type in the datasource connection window.
Now, I got different set of problems (if you could shed some light on it).
I followed an example where -
1. I have Relational Model - (connecting to the database)
2. View Model - to join 2 tables together
3. xml docs to define input parameter and output of the webservice
4. webservice interface/operation
now, I am calling an operation with parameter - and it seems like the parameter is ignored. instead of returning selective data, it returns matching data so many times.
for example - it returns matching book element about 50 times.
My Operation Procedure looks like this:
CREATE VIRTUAL PROCEDURE
BEGIN
DECLARE string VARIABLES.IN_ISBNInput = xpathvalue(BooksWebSvc.Books.getBooksByISBN.ISBNInput, '/*:ISBNInput');
SELECT DISTINCT * FROM BooksDoc.BooksResultDocument WHERE BooksDoc.BooksResultDocument.BooksResult.Books.ISBN = VARIABLES.IN_ISBNInput;
END
-
13. Re: Incorrect syntax near '.'
mananpat Jul 31, 2012 5:50 PM (in response to mananpat)One of operations which does not have any paramters (for getAllBooks), ends up with following errors as it does not have any parameters.
<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/">
<soapenv:Header/>
<soapenv:Body/>
</soapenv:Envelope>
<soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/">
<soap:Body>
<soap:Fault>
<faultcode>soap:Client</faultcode>
<faultstring>Remote org.teiid.api.exception.query.QueryParserException: Parsing error: Encountered "(" at line 1, column 6.
Was expecting:
<ID> ...</faultstring>
</soap:Fault>
</soap:Body>
</soap:Envelope>
-
14. Re: Incorrect syntax near '.'
tejones Jul 31, 2012 7:02 PM (in response to mananpat)Manan,
Not sure what is going on there. If you would like to attach your model project set (File->Export->Teiid Designer->Model Project Set) I will take a look.
Thanks,
Ted