Connect AwareIM to CassandraDB

If you think that something doesn't work in Aware IM post your message here
Post Reply
jannes
Posts: 100
Joined: Tue Jul 02, 2019 12:22 pm

Connect AwareIM to CassandraDB

Post by jannes »

I like to use AwareIM with Cassandra database (http://cassandra.apache.org)
It seems to be an ideal scenario to develop modern mainstream applications.
I didn't succeed yet to connect Cassandra via a JDBC-driver.

AwareIM and Cassandra are successfully installed on our server = Windows 2012 .

Java :
- java -version : 1.8
- JAVA_HOME=c:\Program Files\Java\jdk1.8.0_181

Cassandra
- keyspace : polderspace01


Step 1) Download and install JDBC-driver: https://www.cdata.com/drivers/cassandra/jdbc/

Step 2) Edit AwareIM/bin/setenv.bat
Add <path>/cdata.jdbc.cassandra.jar to CLASSPATH

Step 3) Copy the jar-file (cdata.jdbc.cassandra.jar) to D:\AwareIM\CustomJars

Step 4) Start AwareIM and add business objects
Each table in the external database has to be connected via the JDBC-driver.

In AwareIM we added a database-connection :
- Driver class name : cdata.jdbc.cassandra.CassandraDriver
- Connection URL : jdbc:cassandra:Database=polderspace01;Port=9042;Server=127.0.0.1;
- Runtime driver URL : empty
- Username/password : exmpty

Adding new business object :
Enter name of the Business Object: persoon
Persistence: Database existing external

Click Button [Discover attributes]
Error-message : "Unable to retrieve columns for table [persoon]"

What can be wrong ?

regards
= Jannes
aware_support
Posts: 7523
Joined: Sun Apr 24, 2005 12:36 am
Contact:

Re: Connect AwareIM to CassandraDB

Post by aware_support »

What's in the output of the Aware IM Server when you get this message? (Click on the View/Server in the Aware IM Control Panel)

By the way, you don't need to modify the CLASSPATH - you can just drop the driver into the AwareIM/CustomJars directory.
Aware IM Support Team
jannes
Posts: 100
Joined: Tue Jul 02, 2019 12:22 pm

Re: Connect AwareIM to CassandraDB

Post by jannes »

I changed CLASSPATH and now it works..!
jannes
Posts: 100
Joined: Tue Jul 02, 2019 12:22 pm

Re: Connect AwareIM to CassandraDB

Post by jannes »

Would it be possible to use another JDBC-driver like
https://repo1.maven.org/maven2/com/data ... -4.1.0.jar

?
Post Reply