Uploaded image for project: 'Teiid'
  1. Teiid
  2. TEIID-2912

Teiid JDBC-ODBC bridge metada import fails from MS Access 2013

    XMLWordPrintable

Details

    • Bug
    • Resolution: Done
    • Major
    • 8.8, 8.7.1
    • 8.4
    • JDBC Connector
    • None

    Description

      Environment:

      • MS Access 2013
      • Windows 2012 Server

      VDB:

      <?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<vdb name="testVDB" version="1">
	<description>Importer VDB</description>
	<property name="UseConnectorMetadata" value="true" />
	<model name="testAccessModel" type="PHYSICAL" visible="true">
		<source name="testAccessModel" translator-name="jdbc-simple" connection-jndi-name="java:/AccessDS" />
	</model>
</vdb>

      Log exceprt (full log attached):

      ory] (teiid-async-threads - 4) Driver loaded and instance created:sun.jdbc.odbc.JdbcOdbcDriver@49dd4a28
08:32:23,935 DEBUG [org.teiid.CONNECTOR] (teiid-async-threads - 4) JDBCMetadataProcessor - Importing tables
08:32:23,952 DEBUG [org.teiid.CONNECTOR] (teiid-async-threads - 4) JDBCMetadataProcessor - Importing columns
08:32:23,985 DEBUG [org.teiid.CONNECTOR] (teiid-async-threads - 4) JDBCMetadataProcessor - Importing primary keys
08:32:23,985 DEBUG [org.jboss.jca.core.connectionmanager.pool.strategy.OnePool] (teiid-async-threads - 4) AccessDS: returnConnection(2677c1e5, false) [1/20]
08:32:23,985 WARN  [org.teiid.RUNTIME] (teiid-async-threads - 4) TEIID50036 VDB testVDB.1 model "testAccessModel" metadata failed to load. Reason:TEIID11010 java.sql.SQLException: [Microsoft][ODBC Driver Manager] Driver does not support this function

      Driver (standalone.xml attached):

        <datasource jndi-name="java:/AccessDS" pool-name="AccessDS" enabled="true">
                    <connection-url>jdbc:odbc:AccessDS</connection-url>
                    <driver>odbc</driver>
                    <transaction-isolation>TRANSACTION_NONE</transaction-isolation>
                    <pool>
                        <prefill>false</prefill>
                        <use-strict-min>false</use-strict-min>
                        <flush-strategy>FailingConnectionOnly</flush-strategy>
                    </pool>
                </datasource>
...
 <drivers>
    <driver name="odbc" module="sun.jdk">
                        <driver-class>sun.jdbc.odbc.JdbcOdbcDriver</driver-class>
                    </driver>
</drivers>

      Attachments

        1. test-vdb.xml
          0.4 kB
        2. standalone.xml
          28 kB
        3. server-importKeysFalse.log
          2.40 MB
        4. server.log
          2.34 MB

        Issue Links

          is related to

          Bug - A problem that impairs or prevents the functions of the product. TEIIDDES-2097 JDBC Importer fails when importing Access 2013 metadata via JDBC ODBC bridge

          • Major - To be worked after higher priority work items are addressed. When the severity is high and the effort to change it is low to moderate, this term is chosen. Issues in this category likely have an existing workaround but implementation or execution may be non-trivial.
          • Closed

          Activity

            People

              Unassigned Unassigned
              fnguyen_jira Filip Nguyen (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: