Hi :
I am trying test Cassandra for DSS 3.1.0 following the guide
http://wso2.com/project/data-services/2.6.3/docs/cassandra.html ,
I set up cassandra-2.0.0 and following is the data in my Cassandra DB and
the content of my dbs file.
[default@keyspace1] get USER[user1];
=> (name=password, value=testpwd, timestamp=1385363606208000)
=> (name=username, value=test, timestamp=1385363597453000)
Returned 2 results.
Elapsed time: 9.78 msec(s).
<data name="Cassandra">
<config id="CassandraDS">
<property name="url">jdbc:cassandra://localhost:9160/keyspace1</property>
<property
name="driverClassName">org.apache.cassandra.cql.jdbc.CassandraDriver</property>
</config>
<query id="getUsers" useConfig="CassandraDS">
<sql>select 'key', 'username', 'password' from USER</sql>
<result element="Users" rowName="User">
<element column="key" name="key" xsdType="string"/>
<element column="username" name="username" xsdType="string"/>
<element column="password" name="password" xsdType="string"/>
</result>
</query>
<operation name="GetUserOp">
<call-query href="getUsers"/>
</operation>
</data>
Then I use tryit tool to test it ,but some errors occurs.
[2013-11-25 15:53:11,636] ERROR {org.wso2.carbon.dataservices.core.engine.DataSe
rvice} - DS Fault Message: Error in 'SQLQuery.processNormalQuery'
DS Code: DATABASE_ERROR
Source Data Service:-
Name: Cassandra
Location: \Cassandra.dbs
Description: N/A
Default Namespace: http://ws.wso2.org/dataservice
Current Request Name: GetUserOp
Current Params: {}
Nested Exception:-
DS Fault Message: Error in 'createProcessedPreparedStatement'
DS Code: UNKNOWN_ERROR
Nested Exception:-
java.sql.SQLSyntaxErrorException: InvalidRequestException(why:line 1:7 no viable
alternative at input 'key')
DS Fault Message: Error in 'SQLQuery.processNormalQuery'
DS Code: DATABASE_ERROR
Source Data Service:-
Name: Cassandra
Location: \Cassandra.dbs
Description: N/A
Default Namespace: http://ws.wso2.org/dataservice
Current Request Name: GetUserOp
Current Params: {}
Nested Exception:-
DS Fault Message: Error in 'createProcessedPreparedStatement'
DS Code: UNKNOWN_ERROR
Nested Exception:-
java.sql.SQLSyntaxErrorException: InvalidRequestException(why:line 1:7 no viable
alternative at input 'key')
at org.wso2.carbon.dataservices.core.description.query.SQLQuery.processN
ormalQuery(SQLQuery.java:860)
at org.wso2.carbon.dataservices.core.description.query.SQLQuery.runQuery
(SQLQuery.java:2183)
at org.wso2.carbon.dataservices.core.description.query.Query.execute(Que
ry.java:259)
at org.wso2.carbon.dataservices.core.engine.CallQuery.executeElement(Cal
lQuery.java:179)
at org.wso2.carbon.dataservices.core.engine.CallQueryGroup.executeElemen
t(CallQueryGroup.java:111)
at org.wso2.carbon.dataservices.core.engine.OutputElement.execute(Output
Element.java:89)
at org.wso2.carbon.dataservices.core.description.operation.Operation.exe
cute(Operation.java:71)
at org.wso2.carbon.dataservices.core.engine.DataService.invoke(DataServi
ce.java:548)
at org.wso2.carbon.dataservices.core.engine.DSOMDataSource.execute(DSOMD
ataSource.java:101)
at org.wso2.carbon.dataservices.core.engine.DSOMDataSource.serialize(DSO
MDataSource.java:112)
at org.apache.axiom.om.impl.llom.OMSourcedElementImpl.internalSerialize(
OMSourcedElementImpl.java:691)
at org.apache.axiom.om.impl.util.OMSerializerUtil.serializeChildren(OMSe
rializerUtil.java:562)
at org.apache.axiom.om.impl.llom.OMElementImpl.internalSerialize(OMEleme
ntImpl.java:875)
at org.apache.axiom.soap.impl.llom.SOAPEnvelopeImpl.serializeInternally(
SOAPEnvelopeImpl.java:283)
at org.apache.axiom.soap.impl.llom.SOAPEnvelopeImpl.internalSerialize(SO
APEnvelopeImpl.java:245)
at org.apache.axiom.om.impl.llom.OMSerializableImpl.serializeAndConsume(
OMSerializableImpl.java:193)
at org.apache.axis2.transport.http.SOAPMessageFormatter.writeTo(SOAPMess
ageFormatter.java:74)
at org.apache.axis2.transport.http.CommonsHTTPTransportSender.sendUsingO
utputStream(CommonsHTTPTransportSender.java:411)
at org.apache.axis2.transport.http.CommonsHTTPTransportSender.invoke(Com
monsHTTPTransportSender.java:288)
at org.apache.axis2.engine.AxisEngine.send(AxisEngine.java:442)
at org.apache.axis2.receivers.AbstractInOutSyncMessageReceiver.invokeBus
inessLogic(AbstractInOutSyncMessageReceiver.java:45)
at org.apache.axis2.receivers.AbstractMessageReceiver.receive(AbstractMe
ssageReceiver.java:110)
at org.apache.axis2.engine.AxisEngine.receive(AxisEngine.java:180)
at org.apache.axis2.transport.http.HTTPTransportUtils.processHTTPPostReq
uest(HTTPTransportUtils.java:172)
at org.apache.axis2.transport.http.AxisServlet.doPost(AxisServlet.java:1
46)
at org.wso2.carbon.core.transports.CarbonServlet.doPost(CarbonServlet.ja
va:231)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:755)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:848)
at org.eclipse.equinox.http.servlet.internal.ServletRegistration.service
(ServletRegistration.java:61)
at org.eclipse.equinox.http.servlet.internal.ProxyServlet.processAlias(P
roxyServlet.java:128)
at org.eclipse.equinox.http.servlet.internal.ProxyServlet.service(ProxyS
ervlet.java:68)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:848)
at org.wso2.carbon.tomcat.ext.servlet.DelegationServlet.service(Delegati
onServlet.java:68)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:305)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:210)
at org.wso2.carbon.tomcat.ext.filter.CharacterSetFilter.doFilter(Charact
erSetFilter.java:61)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:243)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:210)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperV
alve.java:222)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextV
alve.java:123)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(Authentica
torBase.java:472)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.j
ava:171)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.j
ava:99)
at org.wso2.carbon.tomcat.ext.valves.CompositeValve.continueInvocation(C
ompositeValve.java:178)
at org.wso2.carbon.tomcat.ext.valves.TomcatValveContainer.invokeValves(T
omcatValveContainer.java:49)
at org.wso2.carbon.tomcat.ext.valves.CompositeValve.invoke(CompositeValv
e.java:141)
at org.wso2.carbon.tomcat.ext.valves.CarbonStuckThreadDetectionValve.inv
oke(CarbonStuckThreadDetectionValve.java:156)
at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:
936)
at org.wso2.carbon.tomcat.ext.valves.CarbonContextCreatorValve.invoke(Ca
rbonContextCreatorValve.java:52)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineVal
ve.java:118)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.jav
a:407)
at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp
11Processor.java:1004)
at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(
AbstractProtocol.java:589)
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.run(NioEndpoin
t.java:1653)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.
java:1145)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor
.java:615)
at java.lang.Thread.run(Thread.java:722)
Caused by: DS Fault Message: Error in 'createProcessedPreparedStatement'
DS Code: UNKNOWN_ERROR
Nested Exception:-
java.sql.SQLSyntaxErrorException: InvalidRequestException(why:line 1:7 no viable
alternative at input 'key')
at org.wso2.carbon.dataservices.core.description.query.SQLQuery.createPr
ocessedPreparedStatement(SQLQuery.java:1540)
at org.wso2.carbon.dataservices.core.description.query.SQLQuery.processN
ormalQuery(SQLQuery.java:822)
... 56 more
Caused by: java.sql.SQLSyntaxErrorException: InvalidRequestException(why:line 1:
7 no viable alternative at input 'key')
at org.apache.cassandra.cql.jdbc.CassandraPreparedStatement.<init>(Cassa
ndraPreparedStatement.java:103)
at org.apache.cassandra.cql.jdbc.CassandraConnection.prepareStatement(Ca
ssandraConnection.java:388)
at org.apache.cassandra.cql.jdbc.CassandraConnection.prepareStatement(Ca
ssandraConnection.java:372)
at org.apache.cassandra.cql.jdbc.CassandraConnection.prepareStatement(Ca
ssandraConnection.java:50)
at sun.reflect.GeneratedMethodAccessor26.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
sorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:601)
at org.apache.tomcat.jdbc.pool.ProxyConnection.invoke(ProxyConnection.ja
va:126)
at org.apache.tomcat.jdbc.pool.JdbcInterceptor.invoke(JdbcInterceptor.ja
va:109)
at org.wso2.carbon.ndatasource.rdbms.ConnectionRollbackOnReturnIntercept
or.invoke(ConnectionRollbackOnReturnInterceptor.java:51)
at org.apache.tomcat.jdbc.pool.JdbcInterceptor.invoke(JdbcInterceptor.ja
va:109)
at org.apache.tomcat.jdbc.pool.interceptor.AbstractCreateStatementInterc
eptor.invoke(AbstractCreateStatementInterceptor.java:67)
at org.apache.tomcat.jdbc.pool.JdbcInterceptor.invoke(JdbcInterceptor.ja
va:109)
at org.apache.tomcat.jdbc.pool.interceptor.ConnectionState.invoke(Connec
tionState.java:153)
at org.apache.tomcat.jdbc.pool.JdbcInterceptor.invoke(JdbcInterceptor.ja
va:109)
at org.apache.tomcat.jdbc.pool.TrapException.invoke(TrapException.java:4
1)
at org.apache.tomcat.jdbc.pool.JdbcInterceptor.invoke(JdbcInterceptor.ja
va:109)
at org.apache.tomcat.jdbc.pool.DisposableConnectionFacade.invoke(Disposa
bleConnectionFacade.java:80)
at com.sun.proxy.$Proxy14.prepareStatement(Unknown Source)
at org.wso2.carbon.dataservices.core.description.query.SQLQuery.createPr
ocessedPreparedStatement(SQLQuery.java:1464)
... 57 more
Caused by: InvalidRequestException(why:line 1:7 no viable alternative at input '
key')
at org.apache.cassandra.thrift.Cassandra$prepare_cql3_query_result.read(
Cassandra.java:39567)
at org.apache.thrift.TServiceClient.receiveBase(TServiceClient.java:78)
at org.apache.cassandra.thrift.Cassandra$Client.recv_prepare_cql3_query(
Cassandra.java:1625)
at org.apache.cassandra.thrift.Cassandra$Client.prepare_cql3_query(Cassa
ndra.java:1611)
at org.apache.cassandra.cql.jdbc.CassandraConnection.prepare(CassandraCo
nnection.java:517)
at org.apache.cassandra.cql.jdbc.CassandraConnection.prepare(CassandraCo
nnection.java:532)
at org.apache.cassandra.cql.jdbc.CassandraPreparedStatement.<init>(Cassa
ndraPreparedStatement.java:96)
... 76 more
Does anyone know about the reason?
stevegyc_______________________________________________
Dev mailing list
[email protected]
http://wso2.org/cgi-bin/mailman/listinfo/dev
