1:16 a.m.
Dr.Prasad,
Thank you very much for interest in the Teiid product, we sincerely hope
that Teiid will help with your data integration issues.
Can you please post your request in the Teiid forum at
http://www.jboss.org/index.html?module=bb&op=viewforum&f=298
I will be glad to take look at the issue, that also makes few other
people to look at the issue. Also, if possible please attach your vdb to
the forum.
In the mean while please check, if you can connect to the DB2 directly
using the DSN from some other client tool other than Teiid. Connection
seems to be the issue.
Redhat does offer a supported product called MetaMatrix, which is
predecessor to Teiid and available now, but not from opensource bits.
Teiid based supported product is due later this year.
Thanks again for considering Teiid for your needs.
Ramesh..
On Sat, 2009-03-14 at 11:04 +0000, Dr. Prasad wrote:
Dear Mr. Ramesh Reddy,
Greetings. I am Dr.Prasad from Telesis Global Solutions.
We are highly interested in the wonderful functionality of JBoss Teiid
Project and waiting for it’s commercial release to integrate with our
solutions.
In the meantime, we are trying with Teiid 6.0 pre-release build to get
the familiarity.
We are facing a problem with Teiid. Here is the problem statement:
-----------------------------------------------------------------------------------------------------------------------------
My Java program is in need of fetching the result from the VDB. We are
going with teiid-embedded to get our result from the VDB as and when
needed.
I first created a ODBC connector that uses DSN for Accessing the
MS-Access Tables . I created a model for an MS-Access DB Table and
associated the Model of the table with the ODBC connector. After that,
created a simple VDB to access the data from that table and I executed
the same using a simple SQL query on VDB.
The VDB was then set in the Classpath for the teiid-embedded stand
alone Java File, it executed properly and I got my result set.
Again I created a DB2 Connector using ODBC connectivity and the DSN
name. I followed the same steps that I followed for the MS-Access
table that I have explained before for the DB2 (Ver. 9.5) table. This
time teiid-embedded is giving me the "General error" when the sql
Statement is execon VDB is executed. It was returning me the
connection object properly and the statement object as well as
properly. But at the executeQuery teiid-embedded was throwing me an
error as:
com.metamatrix.jdbc.MMSQLException: Error occurred on connector
harini_1.DB21 - com.metamatrix.data.exception.ConnectorException:
java.sql.SQLException: General error
at
com.metamatrix.jdbc.MMSQLException.create(MMSQLException.java:85)
at
com.metamatrix.jdbc.MMSQLException.create(MMSQLException.java:66)
at
com.metamatrix.jdbc.MMStatement.setException(MMStatement.java:364)
at
com.metamatrix.jdbc.MMStatement.processQueryMessage(MMStatement.java:441)
at
com.metamatrix.jdbc.MMStatement.executeSql(MMStatement.java:540)
at
com.metamatrix.jdbc.MMStatement.executeQuery(MMStatement.java:507)
at JDBCClient.execute(JDBCClient.java:81)
at JDBCClient.main(JDBCClient.java:42)
Caused by: [MetaMatrixComponentException]Error occurred on connector
harini_1.DB21 - com.metamatrix.data.exception.ConnectorException:
java.sql.SQLException: General error
1 [ConnectorException]Error occurred on connector harini_1.DB21 -
com.metamatrix.data.exception.ConnectorException:
java.sql.SQLException: General error
2
[ConnectionPoolException]com.metamatrix.data.exception.ConnectorException:
java.sql.SQLException: General error
3 [ConnectorException]java.sql.SQLException: General error
4 [SQLException]General error
at
com.metamatrix.dqp.internal.process.DataTierTupleSource.switchBatch(DataTierTupleSource.java:149)
at
com.metamatrix.dqp.internal.process.DataTierTupleSource.nextTuple(DataTierTupleSource.java:90)
at
com.metamatrix.query.processor.relational.AccessNode.nextBatchDirect(AccessNode.java:155)
at
com.metamatrix.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:243)
at
com.metamatrix.query.processor.relational.BatchCollector.collectTuples(BatchCollector.java:59)
at
com.metamatrix.query.processor.relational.BatchCollector.collectTuples(BatchCollector.java:53)
at
com.metamatrix.query.processor.relational.SourceState.collectTuples(SourceState.java:100)
at
com.metamatrix.query.processor.relational.JoinStrategy.loadRight(JoinStrategy.java:70)
at
com.metamatrix.query.processor.relational.MergeJoinStrategy.loadRight(MergeJoinStrategy.java:358)
at
com.metamatrix.query.processor.relational.JoinNode.nextBatchDirect(JoinNode.java:178)
at
com.metamatrix.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:243)
at
com.metamatrix.query.processor.relational.ProjectNode.nextBatchDirect(ProjectNode.java:175)
at
com.metamatrix.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:243)
at
com.metamatrix.query.processor.relational.RelationalPlan.nextBatch(RelationalPlan.java:111)
at
com.metamatrix.query.processor.QueryProcessor.process(QueryProcessor.java:149)
at
com.metamatrix.dqp.internal.process.RequestWorkItem.processMore(RequestWorkItem.java:276)
at
com.metamatrix.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:220)
at
com.metamatrix.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:46)
at java.util.concurrent.ThreadPoolExecutor
$Worker.runTask(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown
Source)
at java.lang.Thread.run(Unknown Source)
Caused by: com.metamatrix.data.exception.ConnectorException: Error
occurred on connector harini_1.DB21 -
com.metamatrix.data.exception.ConnectorException:
java.sql.SQLException: General error
at
com.metamatrix.dqp.internal.datamgr.impl.ConnectorWorkItem.handleError(ConnectorWorkItem.java:245)
at
com.metamatrix.dqp.internal.datamgr.impl.ConnectorWorkItem.process(ConnectorWorkItem.java:184)
at
com.metamatrix.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:46)
at
com.metamatrix.dqp.internal.datamgr.impl.SynchConnectorWorkItem.run(SynchConnectorWorkItem.java:70)
... 3 more
Caused by: com.metamatrix.data.pool.ConnectionPoolException:
com.metamatrix.data.exception.ConnectorException:
java.sql.SQLException: General error
at
com.metamatrix.data.pool.ConnectionPool.createConnection(ConnectionPool.java:378)
at
com.metamatrix.data.pool.ConnectionPool.obtain(ConnectionPool.java:302)
at
com.metamatrix.connector.jdbc.JDBCConnector.getConnection(JDBCConnector.java:164)
at
com.metamatrix.dqp.internal.datamgr.impl.ConnectorWorkItem.createConnection(ConnectorWorkItem.java:149)
at
com.metamatrix.dqp.internal.datamgr.impl.ConnectorWorkItem.createExecution(ConnectorWorkItem.java:355)
at
com.metamatrix.dqp.internal.datamgr.impl.SynchConnectorWorkItem.createExecution(SynchConnectorWorkItem.java:101)
at
com.metamatrix.dqp.internal.datamgr.impl.ConnectorWorkItem.process(ConnectorWorkItem.java:162)
... 5 more
Caused by: com.metamatrix.data.exception.ConnectorException:
java.sql.SQLException: General error
at
com.metamatrix.connector.jdbc.JDBCSourceConnectionFactory.createJDBCConnection(JDBCSourceConnectionFactory.java:116)
at
com.metamatrix.connector.jdbc.JDBCSingleIdentityConnectionFactory.createConnection(JDBCSingleIdentityConnectionFactory.java:114)
at
com.metamatrix.data.pool.ConnectionPool.createConnection(ConnectionPool.java:372)
... 11 more
Caused by: java.sql.SQLException: General error
at
com.metamatrix.common.util.exception.SQLExceptionUnroller.unRollException(SQLExceptionUnroller.java:63)
... 14 more
Exception in thread "main" java.lang.NullPointerException
at JDBCClient.execute(JDBCClient.java:87)
at JDBCClient.main(JDBCClient.java:42).....
-------------------------------------------------------------------------------------------------------------------------------------------------
I request you to investigate the problem and give us your expert
advice to resolve the issue.
Look forward to receive your positive response .
Thanks a lot for your help.
With regards
Dr.Prasad
Telesis Global Solutions Limited