4 Replies Latest reply on Mar 18, 2015 9:02 AM by Steven Hawkins

    Issue with Local JDBC Connection with Teiid

    Nitesh Pandey Newbie

      I am trying to make local JDBC connection as suggested in this site, but while running I am getting the below error.

       

      in SQLExceptionorg.teiid.jdbc.TeiidSQLException: Teiid Embedded mode Driver failed to load. You must only create this type of connection in the same VM as the Teiid Server. Use following driver fragment xml inside the JBoss AS configuration file<drivers><driver name="teiid-local" module="org.jboss.teiid"><driver-class>org.teiid.jdbc.TeiidDriver</driver-class><xa-datasource-class>org.teiid.jdbc.TeiidDataSource</xa-datasource-class></driver>   

       

      I have used the "teiid-client-8.7.0.Final.jar" file

      I have added the below statement in standalone-XXX.xml file too.

       

                      <datasource jndi-name="java:/teiidDS" pool-name="teiidDS" enabled="true">

                          <connection-url>jdbc:teiid:OpenWorksWitsmlModel</connection-url>

                          <driver>teiid-local</driver>

                          <pool>

                              <prefill>false</prefill>

                              <use-strict-min>false</use-strict-min>

                              <flush-strategy>FailingConnectionOnly</flush-strategy>

                          </pool>

                          <security>

                              <user-name>XXX</user-name>

                              <password>XXX</password>

                          </security>

                      </datasource>

       

      please suggest me how can I overcome this issue.