Hi, Can you please try with the following sample select query. (Column names should be without quotes)
SELECT column1, column2, column3 FROM keyspace.column_family Thanks On Mon, Nov 25, 2013 at 1:39 PM, stevegyc <[email protected]> wrote: > 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 > > -- Best Regards.. Chanika Geeganage Software Engineer WSO2, Inc.; http://wso2.com
_______________________________________________ Dev mailing list [email protected] http://wso2.org/cgi-bin/mailman/listinfo/dev
