-
1. Re: connect to cassandra
shawkins Dec 1, 2014 8:21 AM (in response to abedini)No community edition is yet compatible with wildfly. See Downloads · Teiid under the installation section for the relevant platform versions.
The current plan is to have Teiid 9 target wildfly 9.
-
2. Re: connect to cassandra
abedini Dec 6, 2014 12:26 AM (in response to shawkins)My server is jboss as 7.2.0 &teiid runtime 8.8.0
Questions:
1-For create Cassandra data source what use format:
a:<subsystem xmlns="urn:jboss:domain:datasources:1.0">
<datasources>
<datasourcejndi-name="java:jboss/datasources/CassandraDS" pool-name="CassandraDS" enabled="true"
use-java-context="true" use-ccm="false" jta="false">
<connection-url>jdbc:cassandra://localhost:9160/system?version=3.0.0</connection-url>
<driver>cassandra</driver>
</datasource>
<drivers>
<driver name="cassandra" module="org.apache-extras.cassandra-jdbc">
<datasource-class>org.apache.cassandra.cql.jdbc.CassandraDataSource</datasource-class>
</driver>
</drivers>
</datasources>
</subsystem>
b:<subsystem xmlns="urn:jboss:domain:resource-adapters:1.1">
<resource-adapters>
<resource-adapter id="cassandra">
<module slot="main" id="org.jboss.teiid.resource-adapter.cassandra"/>
<transaction-support>NoTransaction</transaction-support>
<connection-definitions>
<connection-definition class-name="org.teiid.resource.adapter.cassandra.CassandraManagedConnectionFactory"
jndi-name="java:/cassandraDS"
enabled="true"
use-java-context="true"
pool-name="teiid-cassandra-ds">
<!-- Cassandra host address -->
<config-property name="Address">some.host.com</config-property>
<!-- Cassandra keyspace -->
<config-property name="Keyspace">keyspace</config-property>
<!--
<config-property name="Username">user</config-property>
<config-property name="Password">password</config-property>
<config-property name="Port">7000</config-property>
-->
</connection-definition>
</connection-definitions>
</resource-adapter>
</resource-adapters>
</subsystem>
2-what jar file corrected for connected to Cassandra:
a-cassandra-driver-core-2.0.2.jar
b-cassandra-jdbc-1.2.5.jar
c-connector-cassandra-8.8.0.Final.jar
-
3. Re: connect to cassandra
rareddy Dec 6, 2014 10:10 AM (in response to abedini)Teiid works (b), it has been documented as such here Cassandra Data Sources - Teiid 8.10 (draft) - Project Documentation Editor and also in "jboss-eap-6.3/docs/teiid/datasources/cassandra" directory
-
4. Re: connect to cassandra
abedini Dec 9, 2014 12:21 AM (in response to rareddy)
hi2-what jar file corrected for connected to Cassandra:
a-cassandra-driver-core-2.0.2.jar
b-cassandra-jdbc-1.2.5.jar
c-connector-cassandra-8.8.0.Final.jar
-
5. Re: connect to cassandra
sa_jafarian Dec 9, 2014 6:01 AM (in response to rareddy)hi
my server jboss as 7.2.0 teiid 8.7.0 final
how connect to cassandra 2.0.7 from teiid designer
because when i use cassandra driver in teiid designer and insert address & keyspace dont add driver
-
6. Re: connect to cassandra
rareddy Dec 9, 2014 9:14 AM (in response to abedini)m: It is (a) and (c) in combination. Anyway is there any significance in your usecase how you are connecting?
Sadegh: In Designer, use "import -> Teiid Importer", then create a datasource and select "cassandra" as translator for working with Cassandra, Teiid is not designed to work with their JDBC driver.
-
7. Re: connect to cassandra
sa_jafarian Dec 9, 2014 10:38 AM (in response to rareddy)when i use Cassandra translator 3 properties :
address:?????????
keyspace:?????????
class-name:?????????????
what set this propertise:
for example :
address:localhost:9160
keyspace:testdb
classname:??????????
-
8. Re: connect to cassandra
rareddy Dec 9, 2014 11:55 AM (in response to sa_jafarian)Sadegh,
For "class-name" try "org.teiid.resource.adapter.cassandra.CassandraManagedConnectionFactory". This is typically not required by user to enter, however due to Teiid Designer bug you are seeing this. I entered an issue to solve this at [TEIIDDES-2405] Teiid Importer *MUST* not require class-name property working with Teiid Sources
Ramesh..
-
9. Re: connect to cassandra
sa_jafarian Dec 9, 2014 11:18 PM (in response to rareddy)when i use the cassandra and create data source dont add driver and display install driver this is bug or correct?
-
10. Re: connect to cassandra
rareddy Dec 10, 2014 10:59 AM (in response to sa_jafarian)when using the "Teiid Importer" in the Designer, you only need to add the driver, when the data source type is not found in the list of data types. This is typically only true for JDBC drivers, others you can upload a RAR file for your custom resource-adapter. All the resource-adapters that come OOB from Teiid already been installed in the system, so they do not need any more jar files.
-
11. Re: connect to cassandra
sa_jafarian Dec 10, 2014 11:20 PM (in response to rareddy)how access to data in cassandrta:
for example how select * from test(test is table in testdb)?
for address what is used?
a:adress:127.0.0.1
b:adress:localhost:9160
c:adress:localhost
d:adress:localhost:9160
-
12. Re: connect to cassandra
rareddy Dec 11, 2014 9:38 AM (in response to sa_jafarian)The address depends on where installed or where your instance of cassandra is running. If it is running on same box as your Teiid server, then address is "localhost" and port is "9160" or something else. They are represented in two separate properties.
-
13. Re: connect to cassandra
sa_jafarian Dec 14, 2014 2:12 AM (in response to rareddy)hi
i connect successfully to Cassandra from jboss as 7.2.0 and teiid 8.7.0 and address=127.0.0.1 in local host mode
question:
how connect to cassandra in remote mode for example cassandra in other system with ip adress 172.168.0.14 how config teiid to coonect cassandra to system with ip 172.168.0.14?????????
-
14. Re: connect to cassandra
rareddy Dec 14, 2014 4:39 PM (in response to sa_jafarian)Instead of using 127.0.0.1 use 172.168.0.14, and also make sure the whatever the port number you used is open in the firewall on the remote machine (if there is a firewall)