Re: [teiid-users] teiid jdbc connection questions

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@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 _______________________________________________ teiid-users mailing list teiid-users(a)lists.jboss.org https://lists.jboss.org/mailman/listinfo/teiid-users