1 2 Previous Next 20 Replies Latest reply on Jun 1, 2016 8:44 AM by shawkins

    connect to cassandra

    abedini

      Hi

      In community edition what runtime teiid-8.?.0. Final-jboss-dist.zip version compatible with wildfly-8.0.0.Final

      For example runtime teiid-8.3.0.Final-jboss-dist compatible with jboss-7.1.1.Final application server

      thanks

        • 1. Re: connect to cassandra
          shawkins

          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

            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

              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


                hi

                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

                • 5. Re: connect to cassandra
                  sa_jafarian

                  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

                    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

                      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

                        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

                          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

                            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

                              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

                                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

                                  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

                                    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)

                                    1 2 Previous Next