Well this is getting stranger, for me with this simple table definition,
select key,gender from users
is also failing with a null pointer exception
Andy
On 29 Jan 2013, at 13:50, Andy Cobley <acob...@computing.dundee.ac.uk> wrote:
> When connecting to Cassandra 1.2.0 from CQLSH the table was created with:
>
> CREATE KEYSPACE test WITH replication = {'class': 'SimpleStrategy',
> 'replication_factor' : 1};
> cqlsh> use test;
> cqlsh:test> create columnfamily users (KEY varchar Primary key, password
> varchar, gender varchar) ;
> cqlsh:test> INSERT INTO users (KEY, password) VALUES ('jsmith', 'ch@ngem3a');
> cqlsh:test> INSERT INTO users (KEY, gender) VALUES ('jbrown', 'male');
>
> stack trace (generated et.printStackTrace()) is:
>
> Can not execute statement java.lang.NullPointerException
> at org.apache.cassandra.cql.jdbc.TypedColumn.<init>(TypedColumn.java:45)
> at
> org.apache.cassandra.cql.jdbc.CassandraResultSet.createColumn(CassandraResultSet.java:972)
> at
> org.apache.cassandra.cql.jdbc.CassandraResultSet.populateColumns(CassandraResultSet.java:156)
> at
> org.apache.cassandra.cql.jdbc.CassandraResultSet.<init>(CassandraResultSet.java:130)
> at
> org.apache.cassandra.cql.jdbc.CassandraStatement.doExecute(CassandraStatement.java:167)
> at
> org.apache.cassandra.cql.jdbc.CassandraStatement.executeQuery(CassandraStatement.java:227)
> at uk.ac.dundee.computing.aec.test.test.doGet(test.java:51)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:621)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:728)
> at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)
> at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
> at
> org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:222)
> at
> org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:123)
> at
> org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:472)
> at
> org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:171)
> at
> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:99)
> at
> org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:936)
> at
> org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
> at
> org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:407)
> at
> org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1004)
> at
> org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:589)
> at
> org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:310)
> at
> java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
> at
> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
> at java.lang.Thread.run(Thread.java:680)
>
> Hope that helps !
>
> Andy
>
>
> On 29 Jan 2013, at 07:17, aaron morton <aa...@thelastpickle.com> wrote:
>
>> What is your table spec ?
>> Do you have the full stack trace from the exception ?
>>
>> Cheers
>>
>> -----------------
>> Aaron Morton
>> Freelance Cassandra Developer
>> New Zealand
>>
>> @aaronmorton
>> http://www.thelastpickle.com
>>
>> On 29/01/2013, at 8:15 AM, Andy Cobley <acob...@computing.dundee.ac.uk>
>> wrote:
>>
>>> I have the following code in my app using the JDBC
>>> (cassandra-jdbc-1.1.2.jar) drivers to CQL:
>>>
>>> try {
>>> rs= stmt.executeQuery("SELECT * FROM users");
>>> }catch(Exception et){
>>> System.out.println("Can not execute statement "+et);
>>> }
>>>
>>> When connecting to a CQL2 server (cassandra 1.1.5) the code works as
>>> expected returning a result set . When connecting to CQL3 (Cassandra 1.2)
>>> I catch the following exception:
>>>
>>> Can not execute statement java.lang.NullPointerException
>>>
>>> The Select statement (Select * from users) does work from CQLSH as
>>> expected. Is there a problem with my code or something else ?
>>>
>>> Andy C
>>> School of Computing
>>> University of Dundee.
>>>
>>>
>>>
>>> The University of Dundee is a Scottish Registered Charity, No. SC015096.
>>
>
> The University of Dundee is a Scottish Registered Charity, No. SC015096.
The University of Dundee is a Scottish Registered Charity, No. SC015096.
