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
Connect AwareIM to CassandraDB
-
- Posts: 7526
- Joined: Sun Apr 24, 2005 12:36 am
- Contact:
Re: Connect AwareIM to CassandraDB
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.
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
Re: Connect AwareIM to CassandraDB
I changed CLASSPATH and now it works..!
Re: Connect AwareIM to CassandraDB
Would it be possible to use another JDBC-driver like
https://repo1.maven.org/maven2/com/data ... -4.1.0.jar
?
https://repo1.maven.org/maven2/com/data ... -4.1.0.jar
?