Wanted: Working Example of Cassandra with Spring ORM

[Siegfried Heintze]

I'm going nuts trying to find a working example of using Cassandra with a java ORM like Spring.framework.data. I've tried over a half dozen examples and none work
This makes me wonder if there is something wrong with the Cassandra server I am using.

However, this example works in java and groovy. Here is the abbreviated groovy version:

@Grab(group='com.datastax.cassandra', module='cassandra-driver-core', version='3.1.0')
@Grab(group='org.slf4j', module='slf4j-api', version='1.7.21')
@Grab(group='org.slf4j', module='slf4j-log4j12', version='1.7.21')
import com.datastax.driver.core.Cluster;
import com.datastax.driver.core.Session;
import com.datastax.driver.core.ResultSet;


      //query = "DROP KEYSPACE tp;"
                    
      //creating Cluster object
      Cluster cluster = Cluster.builder().addContactPoint("127.0.0.1").build();
    
      //Creating Session object
      Session session = cluster.connect();
     
      //Executing the query
      session.execute("DROP KEYSPACE tp;");
      session.execute("CREATE KEYSPACE tp WITH replication = {'class':'SimpleStrategy', 'replication_factor':1};");
     
      //using the KeySpace
      session.execute("USE tp");
      println("Keyspace created");

      session.execute("CREATE TABLE emp(emp_id int PRIMARY KEY, emp_name text, emp_city text, emp_sal varint, emp_phone varint );");
      System.out.println("Table created");		 

      session.execute("INSERT INTO emp (emp_id, emp_name, emp_city, emp_phone,  emp_sal) VALUES(1,'ram', 'Hyderabad', 9848022338, 50000);");
      session.execute("INSERT INTO emp (emp_id, emp_name, emp_city, emp_phone, emp_sal) VALUES(2,'robin', 'Hyderabad', 9848022339, 40000);");
      session.execute("INSERT INTO emp (emp_id, emp_name, emp_city, emp_phone, emp_sal) VALUES(3,'rahman', 'Chennai', 9848022330, 45000);");

      //Getting the ResultSet
      ResultSet result = session.execute("SELECT * FROM emp");
    
	  println "--------------------------"
	  println result[0].getString(1);
	  println result[1].getString(1);
	  println "--------------------------"
      println(result.all());
	  println "--------------------------"
	  println "all done"

This makes me think that I have the v3.9 cassandra server working correctly.

So here is one of the many examples that I found from google searching that I cannot make work:
https://github.com/pivotal-cf/cf-cassandra-spring-example-app

I've tried this with Cassandra  (versions 3.7 and 3.9 and 2.0.8) and java 1.8 on Windows 10.

gradle cleanTest test
:cleanTest
:compileJava UP-TO-DATE
:processResources UP-TO-DATE
:classes UP-TO-DATE
:compileTestJava UP-TO-DATE
:processTestResources UP-TO-DATE
:testClasses UP-TO-DATE
:test

io.pivotal.samples.ApplicationTest > findSavedUserByUsername FAILED
    java.lang.IllegalStateException
        Caused by: org.springframework.beans.factory.UnsatisfiedDependencyException
            Caused by: org.springframework.beans.factory.BeanCreationException
                Caused by: org.springframework.beans.BeanInstantiationException
                    Caused by: org.springframework.beans.factory.BeanCreationException
                        Caused by: org.springframework.beans.factory.UnsatisfiedDependencyException
                            Caused by: org.springframework.beans.factory.BeanCreationException
                                Caused by: com.datastax.driver.core.exceptions.InvalidQueryException
                                    Caused by: com.datastax.driver.core.exceptions.InvalidQueryException

1 test completed, 1 failed
:test FAILED

FAILURE: Build failed with an exception.

* What went wrong:
Execution failed for task ':test'.
> There were failing tests. See the report at: file:///C:/Users/v-sihein/Dropbox/Siegfried%20Software%20Dev/Demos/cassandra-demo/cf-cassandra-spring-example-app/build/reports/tests/index.html

* Try:
Run with --stacktrace option to get the stack trace. Run with --info or --debug option to get more log output.

BUILD FAILED

Total time: 2 mins 0.299 secs

As far as I can tell, everytime I run cassandra 2.0.8, or 3.7 or 3.9, the server is listening on 127.0.0.1 and the default port 9042 and all my clients are also trying to connect to port 9042 (the default).

I've also tried these examples and cannot make them work either:

https://github.com/valchkou/SpringFrameworkCassandraSample

https://github.com/smartcat-labs/spring-cassandra-showcase-application

https://github.com/hellojeya/Demo-SpringBoot-Cassandra

https://github.com/boneill42/spring-data-jpa-cassandra.git

https://examples.javacodegeeks.com/enterprise-java/spring/spring-data-cassandra-example/

And some others I cannot remember where I downloaded them from.

Can someone help me fix
https://github.com/pivotal-cf/cf-cassandra-spring-example-app or find an example that works (preferable an example that uses JUnit to demonstrate that it works)?

Thanks
siegfried