HIVE2: fail to get tables when using HIVE from JDBC javax.sql.DataSource

[ichanjasper]

Hi,

I am having an issue when using JDBC javax.sql.DataSource that created by org.apache.commons.dbcp.PoolableConnectionFactory for HIVE data source.  However, if I use JNDI java.sql.DataSource instead, everything works fine.  Do you guys have any internal MangedConnectionFactory for HIVE data source?   Thanks a lot.

Here is the exception that I got.  And I am using 8.7 Beta 1:

org.teiid.jdbc.TeiidSQLException: Error trying to obtain metadata information for the tables that match %: TEIID30489 Unable to load metadata for VDB name.

        at org.teiid.jdbc.TeiidSQLException.create(TeiidSQLException.java:103)

        at org.teiid.jdbc.DatabaseMetaDataImpl.getTables(DatabaseMetaDataImpl.java:1507)

[rareddy]

It means that Hive does not implement XAConnection interface that PoolableConnectionFactory expecting, thus the error.

Ramesh..

[ichanjasper]

I can get around it by using java.sql.DriverManager.getConnection(...).   I guess it is ok.  Thanks for your help.