Can't established connection of cassandraDB(cassandra version 3) on wildfly10.1.0
alohchab Apr 11, 2018 5:34 AMI am not able to import from teiid connection with cassandra3.x datasource and get the following error:
2018-04-10 05:58:59,139 WARN [org.teiid.RUNTIME] (Worker11_async-teiid-threads12) TEIID50036 VDB importVDB.1 model "importVDBSrcModel" metadata failed to load. Reason:TEIID31178 Could not obtain connection for schema importVDBSrcModel, but one is required for metadata load. : org.teiid.translator.TranslatorException: TEIID31178 Could not obtain connection for schema importVDBSrcModel, but one is required for metadata load.
at org.teiid.query.metadata.NativeMetadataRepository.getMetadata(NativeMetadataRepository.java:72)
at org.teiid.query.metadata.NativeMetadataRepository.loadMetadata(NativeMetadataRepository.java:58)
at org.teiid.query.metadata.ChainingMetadataRepository.loadMetadata(ChainingMetadataRepository.java:51)
at org.teiid.jboss.VDBService$6.run(VDBService.java:337)
at org.teiid.jboss.VDBService$7.run(VDBService.java:388)
at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:280)
at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:115)
at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:206)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1160)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:635)
at java.lang.Thread.run(Thread.java:811)
Caused by: java.lang.ClassCastException: org.teiid.resource.spi.WrappedConnectionFactory incompatible with javax.sql.DataSource
at org.teiid.translator.jdbc.JDBCExecutionFactory.getConnection(JDBCExecutionFactory.java:65)
at org.teiid.translator.ExecutionFactory.getConnection(ExecutionFactory.java:201)
at org.teiid.query.metadata.NativeMetadataRepository.getMetadata(NativeMetadataRepository.java:68)
... 10 more
i am able to add cassandra driver to wildfly using the following in standalone.xml file :-
<driver name="cassandra" module="org.apache.hadoop.cassandra">
<driver-class>org.apache.cassandra.cql.jdbc.CassandraDriver</driver-class>
<xa-datasource-class>org.apache.cassandra.cql.jdbc.CassandraDataSource</xa-datasource-class>
</driver>
cassandra module.xml looks like :-
<?xml version="1.0" encoding="UTF-8"?>
<module xmlns="urn:jboss:module:1.0" name="org.apache.hadoop.cassandra">
<resources>
<resource-root path="cassandra-driver-core-3.4.0.jar" />
<resource-root path="cassandra-jdbc-1.2.5.jar" />
<resource-root path="cassandra-all-3.11.1.jar" />
<resource-root path="slf4j-jdk14-1.7.24.jar" />
<resource-root path="cassandra-jdbc-wrapper-3.1.0.jar" />
</resources>
<dependencies>
<module name="javax.api"/>
<module name="javax.resource.api"/>
<module name="javax.transaction.api"/>
<module name="org.slf4j"/>
<module name="sun.jdk" export="true" >
<imports>
<include path="sun/misc/Unsafe" />
</imports>
</dependencies>
</module>