JBossDeveloper

Hi,

I am trying to connect to Cassandra data source which is running on different machine.

Made some changes in Cassandra.yaml file. rpc_address to 0.0.0.0, set the rpc_broadcast address and port on 9160

Now i am trying to create source from Teiid designer.

Import->Teiid Connection >>  Source model -> New - Selected cassandra [ filled host name,keyspace,username,password, class-name ]

Next page -> selected Cassandra from Translator dropdown

Next page -> Added Name

Next page - it is throwing error

When checked system logs it throwing -  TEIID50036 VDB importVDB3.1 model "importVDB3SrcModel" metadata failed to load. Reason:TEIID60000 javax.resource.ResourceException: IJ000453: Unable to get managed connection for java:/cassandraDS

Can someone help in solving this issue.

Thank you.

If there is any other means for testing make sure you can connect to Cassendra from the machine where Teiid server is installed. Then you same IP and PORT in the eclipse.

The server log should contain a better message about why the connection could not be obtained.  Have you checked there for a more complete message?

Hi Ramesh,

I tried connecting it using datastax where teiid is running, and i am successfully connected to Cassandra instance.

Using below code :

private Cluster cluster;

private Session session;

cluster = Cluster.builder().addContactPoint(<IP>).withPort(<Port>).build(); 

session = cluster.connect();

when i tried with same IP and Port through teiid designer it is throwing error.

server.log

10:37:50,175 INFO  [org.teiid.RUNTIME] (MSC service thread 1-5) TEIID50029 VDB importVDB4.1 model "importVDB4SrcModel" metadata is currently being loaded. Start Time: 1/6/16 10:37 AM

10:37:50,734 WARN  [org.teiid.RUNTIME] (teiid-async-threads - 3) TEIID50036 VDB importVDB4.1 model "importVDB4SrcModel" metadata failed to load. Reason:TEIID60000 javax.resource.ResourceException: IJ000453: Unable to get managed connection for java:/cassandraDS

This is my generated VDB:

<?xml version="1.0" encoding="UTF-8" standalone="yes"?>

<vdb name="importVDB4" version="1">

  <description>Importer VDB</description>

  <property name="UseConnectorMetadata" value="true" />

  <property name="deployment-name" value="importVDB4-vdb.xml" />

  <model name="importVDB4SrcModel" type="PHYSICAL" visible="true">

  <source name="importVDB4SrcModel" translator-name="cassandra" connection-jndi-name="java:/cassandraDS" />

  </model>

</vdb>

Thanks,

Raghuram

Hi Steven,

I have checked the logs, its throwing

10:37:50,175 INFO  [org.teiid.RUNTIME] (MSC service thread 1-5) TEIID50029 VDB importVDB4.1 model "importVDB4SrcModel" metadata is currently being loaded. Start Time: 1/6/16 10:37 AM

10:37:50,734 WARN  [org.teiid.RUNTIME] (teiid-async-threads - 3) TEIID50036 VDB importVDB4.1 model "importVDB4SrcModel" metadata failed to load. Reason:TEIID60000 javax.resource.ResourceException: IJ000453: Unable to get managed connection for java:/cassandraDS

You mean the logs of standalone server right?

EAP-6.4.0/standalone/log/server.log

Thanks,

Raghuram

What Teiid version are you on?  8.6 and later should include the underlying exception/stack with that WARN message - [TEIID-2875] Metadata failed to load. No column found - JBoss Issue Tracker