Jasper integration with Cassandra getting NullPointerException

Hi All,

I have installed Apache cassandra on my MAC and following are the details:


[cqlsh 4.1.0 | Cassandra 2.0.4 | CQL spec 3.1.1 | Thrift protocol 19.39.0]

I am using Ireport Jasper design tool to designa report. In my report i am using a simple query " select * from emp".

I am seeing following error when I run this .

 

Error filling print... null
Testing as default connection
java.lang.NullPointerException
    at org.apache.cassandra.cql.jdbc.TypedColumn.<init>(TypedColumn.java:45)
    at org.apache.cassandra.cql.jdbc.CResultSet.createColumn(CResultSet.java:963)
    at org.apache.cassandra.cql.jdbc.CResultSet.next(CResultSet.java:942)
    at org.apache.cassandra.cql.jdbc.CResultSet.<init>(CResultSet.java:133)
    at org.apache.cassandra.cql.jdbc.CassandraStatement.doExecute(CassandraStatement.java:168)
    at org.apache.cassandra.cql.jdbc.CassandraStatement.executeQuery(CassandraStatement.java:228)
    at com.jaspersoft.cassandra.query.CassandraQueryExecuter.createDatasource(CassandraQueryExecuter.java:97)
    at net.sf.jasperreports.engine.fill.JRFillDataset.createQueryDatasource(JRFillDataset.java:1112)
    at net.sf.jasperreports.engine.fill.JRFillDataset.initDatasource(JRFillDataset.java:689)
    at net.sf.jasperreports.engine.fill.JRBaseFiller.setParameters(JRBaseFiller.java:1281)
    at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:900)
    at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:845)
    at net.sf.jasperreports.engine.fill.JRFiller.fill(JRFiller.java:87)
    at net.sf.jasperreports.engine.JasperFillManager.fill(JasperFillManager.java:446)
    at net.sf.jasperreports.engine.JasperFillManager.fill(JasperFillManager.java:276)
    at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:745)
    at com.jaspersoft.ireport.designer.compiler.IReportCompiler.run(IReportCompiler.java:891)
    at org.openide.util.RequestProcessor$Task.run(RequestProcessor.java:572)
    at org.openide.util.RequestProcessor$Processor.run(RequestProcessor.java:997)
net.sf.jasperreports.engine.JRException
    at com.jaspersoft.cassandra.query.CassandraQueryExecuter.createDatasource(CassandraQueryExecuter.java:100)
    at net.sf.jasperreports.engine.fill.JRFillDataset.createQueryDatasource(JRFillDataset.java:1112)
    at net.sf.jasperreports.engine.fill.JRFillDataset.initDatasource(JRFillDataset.java:689)
    at net.sf.jasperreports.engine.fill.JRBaseFiller.setParameters(JRBaseFiller.java:1281)
    at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:900)
    at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:845)
    at net.sf.jasperreports.engine.fill.JRFiller.fill(JRFiller.java:87)
    at net.sf.jasperreports.engine.JasperFillManager.fill(JasperFillManager.java:446)
    at net.sf.jasperreports.engine.JasperFillManager.fill(JasperFillManager.java:276)
    at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:745)
    at com.jaspersoft.ireport.designer.compiler.IReportCompiler.run(IReportCompiler.java:891)
    at org.openide.util.RequestProcessor$Task.run(RequestProcessor.java:572)
    at org.openide.util.RequestProcessor$Processor.run(RequestProcessor.java:997)

when i use cqlsh I get following outputr:

 

cqlsh:dev> select * from emp;

 empid | emp_dept | emp_first | emp_last
-------+----------+-----------+----------
     1 |      eng |      fred |    smith

 

Can some one help me to fix this.

saivamsilolla's picture
Joined: Jan 16 2014 - 8:49pm
Last seen: 9 years 4 months ago

0 Answers:

No answers yet
Feedback