[teiid-users] teiid jdbc connection questions

[Sun, Bo]

Hi, Teiid users:

I started Teiid exploration and try to run the Quick start sample.

So far I have:

1) installed Jboss and Teiid run-time, and started Jboss with VDB DynamicPortfolio active.
2) installed Derby DB and populated sample tables/data, and started its NetworkServer.
3) I tested the Derby DB, I can select from tables

I have following questions hopefully you can help:

1) Please confirm that Teiid metadata repository save in xml formats in  <jboss.home>/server/default/deploy directory (v.s. in a relational DB in MetaMatrx scenario).

2) in Sample README.txt file: it suggests to test Teiid VDB connection with following command:

$./run.sh localhost 31000 dynamicportfolio "select stock.* from product, (call MarketData.getTextFiles('*.txt')) f, TEXTTABLE(f.file COLUMNS symbol string, price bigdecimal HEADER) stock where product.symbol=stock.symbol"

It seems not working for me. What is the way you normally testing VDB connection?

3) I tried to use Squirrel to connect to teiid jdbc with following details:

Driver file: teiid-7.1.0.Final-client.jar
Class Name: org.teiid.jdbc.TeiidDriver URL:jdbc:teiid:DynamicPortfolio at mm://aistelab01:31000  (aistelab01 is the server where teiid installed)
username: admin
password: teiid

I got error: Teiid: unable to find a component used authenticate on to Teiid.
I am not able to jdbc connect to Derby DB also.

Please help

Best regards,

Bo Sun



-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.jboss.org/pipermail/teiid-users/attachments/20101001/9344677f/attachment.html