使用cassandra-jdbc dreiver从列家族检索数据时出错

Question

当我使用Cssandra驱动程序从列家族检索数据时。我搞错了

Exception in thread "main" java.lang.NoSuchMethodError: org.apache.cassandra.thrift.Cassandra$Client.execute_cql3_query(Ljava/nio/ByteBuffer;Lorg/apache/cassandra/thrift/Compression;Lorg/apache/cassandra/thrift/ConsistencyLevel;)Lorg/apache/cassandra/thrift/CqlResult;

at org.apache.cassandra.cql.jdbc.CassandraConnection.execute(CassandraConnection.java:447)
at org.apache.cassandra.cql.jdbc.CassandraConnection.execute(CassandraConnection.java:472)
at org.apache.cassandra.cql.jdbc.CassandraStatement.doExecute(CassandraStatement.java:161)
at org.apache.cassandra.cql.jdbc.CassandraStatement.executeQuery(CassandraStatement.java:226)
at CassandraJDBCTest.main(CassandraJDBCTest.java:19)

代码是

public static void main (String args[]) throws SQLException{

    try {
        Class.forName("org.apache.cassandra.cql.jdbc.CassandraDriver");
    Connection con = DriverManager.getConnection("jdbc:cassandra://localhost:9160/TestExample");
        Statement stmt = con.createStatement();
    ResultSet rs = stmt.executeQuery("SELECT Name,Age FROM Users WHERE keyname='001';");

     rs.next();


        System.out.println(rs.getString("Name"));


       System.out.println(rs.getInt(2));
    } catch (ClassNotFoundException e) {
        // TODO Auto-generated catch block
        e.printStackTrace();
    }   
}

Answer 1

您缺少依赖关系：

线程"main“java.lang.NoSuchMethodError中的异常

我有一种感觉，类路径只是配置不正确(为什么是L的？)：

Ljava/nio/ByteBuffer;
Lorg/apache/cassandra/thrift/Compression;
Lorg/apache/cassandra/thrift/ConsistencyLevel;
...

如果您希望使用maven来保存依赖地狱，那么Datastax驱动程序就有一个maven中央回购，您只需要包含依赖项：

<dependency>
   <groupId>com.datastax.cassandra</groupId>
   <artifactId>cassandra-driver-core</artifactId>
   <version>1.0.2</version>
</dependency>

编辑对不起，我没有意识到你在使用。cassandra驱动程序也有有一个maven存储库

<dependency>
<groupId>org.apache-extras.cassandra-jdbc</groupId>
<artifactId>cassandra-jdbc</artifactId>
<version>1.2.5</version>
</dependency>