If you think that something doesn't work in Aware IM post your message here
#51177 by jannes
Sat Jul 06, 2019 9:46 am
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
#51178 by aware_support
Sat Jul 06, 2019 10:34 am
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.

Who is online

Users browsing this forum: No registered users and 10 guests