B4J Question JRDC2 error

[Prosg]

Hello

I want to install jrdc2 in a VPS

i compile and when i do this :

java -jar jRDC.jar

i have this error

java.lang.UnsupportedClassVersionError: org/eclipse/jetty/server/HttpConfiguration$Customizer : Unsupported major.minor version 52.0
        at java.lang.ClassLoader.defineClass1(Native Method)
        at java.lang.ClassLoader.defineClass(ClassLoader.java:800)
        at java.security.SecureClassLoader.defineClass(SecureClassLoader.java:142)
        at java.net.URLClassLoader.defineClass(URLClassLoader.java:449)
        at java.net.URLClassLoader.access$100(URLClassLoader.java:71)
        at java.net.URLClassLoader$1.run(URLClassLoader.java:361)
        at java.net.URLClassLoader$1.run(URLClassLoader.java:355)
        at java.security.AccessController.doPrivileged(Native Method)
        at java.net.URLClassLoader.findClass(URLClassLoader.java:354)
        at java.lang.ClassLoader.loadClass(ClassLoader.java:425)
        at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:308)
        at java.lang.ClassLoader.loadClass(ClassLoader.java:358)
        at b4j.example.main._process_globals(main.java:113)
        at b4j.example.main.initializeProcessGlobals(main.java:104)
        at b4j.example.main.main(main.java:28)

Any idea ?

 

[Prosg]

if cassandra on my VPS is on port 9042 i must have

JdbcUrl=jdbc:cassandra://localhost:9042/test

nobody have a #DATABASE CONFIGURATION sample to cassandra... ?

 

[Prosg]

i have a new error :

AVERTISSEMENT: com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask@1a9cd997 -- Acquisition Attempt Failed!!! Clearing pending acq                                                                                             uires. While trying to acquire a needed new resource, we failed to succeed more than the maximum number of allowed acquisition attempts (30). La                                                                                             st acquisition attempt exception:
java.sql.SQLNonTransientConnectionException: org.apache.thrift.transport.TTransportException: Read a negative frame size (-2080374784)!
        at org.apache.cassandra.cql.jdbc.CassandraConnection.<init>(CassandraConnection.java:159)
        at org.apache.cassandra.cql.jdbc.CassandraDriver.connect(CassandraDriver.java:92)
        at com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:146)
        at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:195)
        at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:184)
        at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager.acquireResource(C3P0PooledConnectionPool.java:                                                                                             200)
        at com.mchange.v2.resourcepool.BasicResourcePool.doAcquire(BasicResourcePool.java:1086)
        at com.mchange.v2.resourcepool.BasicResourcePool.doAcquireAndDecrementPendingAcquiresWithinLockOnSuccess(BasicResourcePool.java:1073)
        at com.mchange.v2.resourcepool.BasicResourcePool.access$800(BasicResourcePool.java:44)
        at com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask.run(BasicResourcePool.java:1810)
        at com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:648)
Caused by: org.apache.thrift.transport.TTransportException: Read a negative frame size (-2080374784)!
        at org.apache.thrift.transport.TFramedTransport.readFrame(TFramedTransport.java:133)
        at org.apache.thrift.transport.TFramedTransport.read(TFramedTransport.java:101)
        at org.apache.thrift.transport.TTransport.readAll(TTransport.java:84)
        at org.apache.thrift.protocol.TBinaryProtocol.readAll(TBinaryProtocol.java:362)
        at org.apache.thrift.protocol.TBinaryProtocol.readI32(TBinaryProtocol.java:284)
        at org.apache.thrift.protocol.TBinaryProtocol.readMessageBegin(TBinaryProtocol.java:191)
        at org.apache.thrift.TServiceClient.receiveBase(TServiceClient.java:69)
        at org.apache.cassandra.thrift.Cassandra$Client.recv_describe_cluster_name(Cassandra.java:1197)
        at org.apache.cassandra.thrift.Cassandra$Client.describe_cluster_name(Cassandra.java:1185)
        at org.apache.cassandra.cql.jdbc.CassandraConnection.<init>(CassandraConnection.java:130)
        ... 10 more

mars 09, 2016 5:19:21 PM com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask run
AVERTISSEMENT: com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask@56085980 -- Acquisition Attempt Failed!!! Clearing pending acq                                                                                             uires. While trying to acquire a needed new resource, we failed to succeed more than the maximum number of allowed acquisition attempts (30). La                                                                                             st acquisition attempt exception:
java.sql.SQLNonTransientConnectionException: org.apache.thrift.transport.TTransportException: Read a negative frame size (-2080374784)!
        at org.apache.cassandra.cql.jdbc.CassandraConnection.<init>(CassandraConnection.java:159)
        at org.apache.cassandra.cql.jdbc.CassandraDriver.connect(CassandraDriver.java:92)
        at com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:146)
        at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:195)
        at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:184)
        at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager.acquireResource(C3P0PooledConnectionPool.java:                                                                                             200)
        at com.mchange.v2.resourcepool.BasicResourcePool.doAcquire(BasicResourcePool.java:1086)
        at com.mchange.v2.resourcepool.BasicResourcePool.doAcquireAndDecrementPendingAcquiresWithinLockOnSuccess(BasicResourcePool.java:1073)
        at com.mchange.v2.resourcepool.BasicResourcePool.access$800(BasicResourcePool.java:44)
        at com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask.run(BasicResourcePool.java:1810)
        at com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:648)
Caused by: org.apache.thrift.transport.TTransportException: Read a negative frame size (-2080374784)!
        at org.apache.thrift.transport.TFramedTransport.readFrame(TFramedTransport.java:133)
        at org.apache.thrift.transport.TFramedTransport.read(TFramedTransport.java:101)
        at org.apache.thrift.transport.TTransport.readAll(TTransport.java:84)
        at org.apache.thrift.protocol.TBinaryProtocol.readAll(TBinaryProtocol.java:362)
        at org.apache.thrift.protocol.TBinaryProtocol.readI32(TBinaryProtocol.java:284)
        at org.apache.thrift.protocol.TBinaryProtocol.readMessageBegin(TBinaryProtocol.java:191)
        at org.apache.thrift.TServiceClient.receiveBase(TServiceClient.java:69)
        at org.apache.cassandra.thrift.Cassandra$Client.recv_describe_cluster_name(Cassandra.java:1197)
        at org.apache.cassandra.thrift.Cassandra$Client.describe_cluster_name(Cassandra.java:1185)
        at org.apache.cassandra.cql.jdbc.CassandraConnection.<init>(CassandraConnection.java:130)
        ... 10 more

mars 09, 2016 5:19:21 PM com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask run
AVERTISSEMENT: com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask@5fa82a4d -- Acquisition Attempt Failed!!! Clearing pending acq                                                                                             uires. While trying to acquire a needed new resource, we failed to succeed more than the maximum number of allowed acquisition attempts (30). La                                                                                             st acquisition attempt exception:
java.sql.SQLNonTransientConnectionException: org.apache.thrift.transport.TTransportException: Read a negative frame size (-2080374784)!
        at org.apache.cassandra.cql.jdbc.CassandraConnection.<init>(CassandraConnection.java:159)
        at org.apache.cassandra.cql.jdbc.CassandraDriver.connect(CassandraDriver.java:92)
        at com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:146)
        at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:195)
        at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:184)
        at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager.acquireResource(C3P0PooledConnectionPool.java:                                                                                             200)
        at com.mchange.v2.resourcepool.BasicResourcePool.doAcquire(BasicResourcePool.java:1086)
        at com.mchange.v2.resourcepool.BasicResourcePool.doAcquireAndDecrementPendingAcquiresWithinLockOnSuccess(BasicResourcePool.java:1073)
        at com.mchange.v2.resourcepool.BasicResourcePool.access$800(BasicResourcePool.java:44)
        at com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask.run(BasicResourcePool.java:1810)
        at com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:648)
Caused by: org.apache.thrift.transport.TTransportException: Read a negative frame size (-2080374784)!
        at org.apache.thrift.transport.TFramedTransport.readFrame(TFramedTransport.java:133)
        at org.apache.thrift.transport.TFramedTransport.read(TFramedTransport.java:101)
        at org.apache.thrift.transport.TTransport.readAll(TTransport.java:84)
        at org.apache.thrift.protocol.TBinaryProtocol.readAll(TBinaryProtocol.java:362)
        at org.apache.thrift.protocol.TBinaryProtocol.readI32(TBinaryProtocol.java:284)
        at org.apache.thrift.protocol.TBinaryProtocol.readMessageBegin(TBinaryProtocol.java:191)
        at org.apache.thrift.TServiceClient.receiveBase(TServiceClient.java:69)
        at org.apache.cassandra.thrift.Cassandra$Client.recv_describe_cluster_name(Cassandra.java:1197)
        at org.apache.cassandra.thrift.Cassandra$Client.describe_cluster_name(Cassandra.java:1185)
        at org.apache.cassandra.cql.jdbc.CassandraConnection.<init>(CassandraConnection.java:130)
        ... 10 more

mars 09, 2016 5:19:21 PM com.mchange.v2.resourcepool.BasicResourcePool forceKillAcquires
AVERTISSEMENT: Having failed to acquire a resource, com.mchange.v2.resourcepool.BasicResourcePool@79166c9d is interrupting all Threads waiting o                                                                                             n a resource to check out. Will try again in response to new client requests.
mars 09, 2016 5:19:21 PM com.mchange.v2.resourcepool.BasicResourcePool forceKillAcquires
AVERTISSEMENT: Having failed to acquire a resource, com.mchange.v2.resourcepool.BasicResourcePool@79166c9d is interrupting all Threads waiting o                                                                                             n a resource to check out. Will try again in response to new client requests.
mars 09, 2016 5:19:21 PM com.mchange.v2.resourcepool.BasicResourcePool forceKillAcquires
AVERTISSEMENT: Having failed to acquire a resource, com.mchange.v2.resourcepool.BasicResourcePool@79166c9d is interrupting all Threads waiting o                                                                                             n a resource to check out. Will try again in response to new client requests.

 

[Erel]

Seems like a bug in Cassandra jdbc driver: https://code.google.com/archive/a/apache-extras.org/p/cassandra-jdbc/issues/95

 

[Prosg]

maybe it's a bug... but we have 2 jdbc driver for cassandra...

* http://www.dbschema.com/cassandra-jdbc-driver.html
* http://www.bigsql.org/se/cassandra/cassandra_jdbc.jsp

i'm really sure after a couple of hours trying to connect cassandra that i have no error in config.properties

like :

#DATABASE CONFIGURATION
DriverClass=org.apache.cassandra.cql.jdbc.CassandraDriver
JdbcUrl=jdbc:cassandra://localhost:9160/test
User=cassandra
Password=cassandra
#Java server port
ServerPort=17178

I have change in cassandra.yaml the authentificator and the authorizer to be working with login and password

and i have the keyspace "test"

And i have always connexion refused.... are u sure this jrdc2 is working with cassandra... ?

and the error you show me is from 2 YEARS old... maybe guys working and i'm sure this team haved resolved this bug

 

[Erel]

And i have always connexion refused.... are u sure this jrdc2 is working with cassandra... ?

jRDC2 works with any database that provides a JDBC driver. It handles all databases in the same way (it is the same way that all Java applications access databases).

 

[Prosg]

before said all of this do u have test with cassandra ? who have 2 jdbc drivers up

 

[Erel]

I didn't try it with cassandra.