[teiid-users] Re: Teiid Project
Ramesh Reddy
rareddy at redhat.com
Sat Mar 14 12:16:04 EDT 2009
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
>
More information about the teiid-users
mailing list