[
https://issues.jboss.org/browse/TEIID-2912?page=com.atlassian.jira.plugin...
]
Filip Nguyen commented on TEIID-2912:
-------------------------------------
Added importKeys to false [1]. Some other issue comes up (attaching
server-importKeysFalse.log). Tail of the log file [2]
[1]
{code:xml}
<vdb name="testVDB" version="1">
<description>Importer VDB</description>
<property name="UseConnectorMetadata" value="true" />
<model name="testAccessModel" type="PHYSICAL"
visible="true">
<property name="importer.importKeys" value="false"/>
<source name="testAccessModel" translator-name="jdbc-simple"
connection-jndi-name="java:/AccessDS" />
</model>
</vdb>
{code}
[2]
{noformat}
d "test-vdb.xml" (runtime-name : "test-vdb.xml")^M
00:31:21,985 DEBUG [org.teiid.CONNECTOR] (teiid-async-threads - 4) JDBCMetadataProcessor -
Importing tables^M
00:31:22,001 DEBUG [org.teiid.CONNECTOR] (teiid-async-threads - 4) JDBCMetadataProcessor -
Importing columns^M
00:31:22,048 DEBUG [org.jboss.jca.core.connectionmanager.pool.strategy.OnePool]
(teiid-async-threads - 4) AccessDS: returnConnection(2584a529, false) [1/20]^M
00:31:22,048 INFO [org.teiid.RUNTIME] (teiid-async-threads - 4) TEIID50030 VDB testVDB.1
model "testAccessModel" metadata loaded. End Time: 4/1/14 12:31 AM^M
00:31:22,063 WARN [org.teiid.PLANNER.RESOLVER] (teiid-async-threads - 4) TEIID31071
Invalid table; Table
testAccessModel.C:\Users\Administrator\Desktop\access-excel-artifacts\ODBC_Testing\ODBC\ODBCTesting.mdb.MSysACEs
has no columns defined^M
00:31:22,063 WARN [org.teiid.PLANNER.RESOLVER] (teiid-async-threads - 4) TEIID31071
Invalid table; Table
testAccessModel.C:\Users\Administrator\Desktop\access-excel-artifacts\ODBC_Testing\ODBC\ODBCTesting.mdb.MSysNavPaneGroupCategories
has no columns defined^M
00:31:22,063 WARN [org.teiid.PLANNER.RESOLVER] (teiid-async-threads - 4) TEIID31071
Invalid table; Table
testAccessModel.C:\Users\Administrator\Desktop\access-excel-artifacts\ODBC_Testing\ODBC\ODBCTesting.mdb.MSysNavPaneGroups
has no columns defined^M
00:31:22,063 WARN [org.teiid.PLANNER.RESOLVER] (teiid-async-threads - 4) TEIID31071
Invalid table; Table
testAccessModel.C:\Users\Administrator\Desktop\access-excel-artifacts\ODBC_Testing\ODBC\ODBCTesting.mdb.MSysNavPaneGroupToObjects
has no columns defined^M
00:31:22,063 WARN [org.teiid.PLANNER.RESOLVER] (teiid-async-threads - 4) TEIID31071
Invalid table; Table
testAccessModel.C:\Users\Administrator\Desktop\access-excel-artifacts\ODBC_Testing\ODBC\ODBCTesting.mdb.MSysNavPaneObjectIDs
has no columns defined^M
00:31:22,063 WARN [org.teiid.PLANNER.RESOLVER] (teiid-async-threads - 4) TEIID31071
Invalid table; Table
testAccessModel.C:\Users\Administrator\Desktop\access-excel-artifacts\ODBC_Testing\ODBC\ODBCTesting.mdb.MSysObjects
has no columns defined^M
00:31:22,063 WARN [org.teiid.PLANNER.RESOLVER] (teiid-async-threads - 4) TEIID31071
Invalid table; Table
testAccessModel.C:\Users\Administrator\Desktop\access-excel-artifacts\ODBC_Testing\ODBC\ODBCTesting.mdb.MSysQueries
has no columns defined^M
00:31:22,063 WARN [org.teiid.PLANNER.RESOLVER] (teiid-async-threads - 4) TEIID31071
Invalid table; Table
testAccessModel.C:\Users\Administrator\Desktop\access-excel-artifacts\ODBC_Testing\ODBC\ODBCTesting.mdb.MSysRelationships
has no columns defined^M
00:31:22,063 INFO [org.teiid.RUNTIME] (teiid-async-threads - 4) TEIID40073 The metadata
for the VDB testVDB.1 is loaded, however it is not valid. Check models for errors. Correct
the metadata and re-deploy.^M
00:31:22,063 INFO [org.teiid.RUNTIME] (teiid-async-threads - 4) TEIID40003 VDB testVDB.1
is set to FAILED^M
{noformat}
Teiid JDBC-ODBC bridge metada import fails from MS Access 2013
--------------------------------------------------------------
Key: TEIID-2912
URL:
https://issues.jboss.org/browse/TEIID-2912
Project: Teiid
Issue Type: Bug
Components: JDBC Connector, ODBC
Affects Versions: 8.4
Reporter: Filip Nguyen
Priority: Blocker
Attachments: server-importKeysFalse.log, server.log, standalone.xml,
test-vdb.xml
Environment:
* MS Access 2013
* Windows 2012 Server
VDB:
{noformat}
<?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>
{noformat}
Log exceprt (full log attached):
{noformat}
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
{noformat}
Driver (standalone.xml attached):
{noformat}
<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>
{noformat}
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see:
http://www.atlassian.com/software/jira