Help! Status: DOWN Errors: ** There are 3 errors reported for this VDB. See the Configuration tab for details. **
m.ardito Nov 23, 2010 11:00 AMHi, i'm moving first steps around jboss as and teiid.
i installed derby on the same server where teiid is and i'm trying to follow steps from the quickstart,
"2.2. Create the Relational Database's schema and load the sample data" (done)
and got:
===================================
jbadmin@jbossas01:~/derby/db-derby$ ./bin/ij
Versione ij 10.6
ij> CONNECT 'jdbc:derby://localhost:1527/teiid/accounts;create=true;';
ij> show tables;
TABLE_SCHEM |TABLE_NAME |REMARKS
------------------------------------------------------------------------
SYS |SYSALIASES |
...
(cut)
...
SYSIBM |SYSDUMMY1 |
APP |ACCOUNT |
APP |CUSTOMER |
APP |HOLDINGS |
APP |PRODUCT |
===================================
so i assume everything ok here...
then, as for "3.1. Building Dynamic VDB"
i've left the provided portfolio-vdb.xml as it was, and copied it and the "connnections" xml into the right "deploy" folder:
===================================
jbadmin@jbossas01:~/jboss/server/default/deploy$ ls -l port*
-rw-r--r-- 1 jbadmin jbadmin 870 2010-11-23 16:08 portfolio-ds.xml
-rw-r--r-- 1 jbadmin jbadmin 1926 2010-11-23 16:29 portfolio-vdb.xml
jbadmin@jbossas01:~/jboss/server/default/deploy$ ls -l mark*
-rw-r--r-- 1 jbadmin jbadmin 729 2010-11-23 16:08 marketdata-file-ds.xml
===================================
now, from the jboss as admin console i see for:
"jbossas01.apiform.to.it>JBossAS Servers>JBoss AS 5 (default)>Data Services>Virtual Database (VDB)s>DynamicPortfolio.1"
this summary message:
===================================
General Properties
Name:DynamicPortfolio.1
Version:1
Description:Teiid Virtual Database (VDB)
Traits
Status: DOWN
Errors: ** There are 3 errors reported for this VDB. See the Configuration tab for details. **
===================================
and the configuration tab shows:
===================================
Error List VDB Errors
Severity Message Actions
ERROR VDB "DynamicPortfolio-1" - "Accounts" model metadata is currently being loaded. Start Time: 23/11/10 16.29
Edit
ERROR "DynamicPortfolio-1" is now "incomplete", because model "Accounts" can not retrieve metadata. Fix errors and re-deploy the VDB.
Edit
ERROR Error Code:0 Message:Unable to get managed connection for PortfolioDS; - nested throwable: (javax.resource.ResourceException: Unable to get managed connection for PortfolioDS)
Edit
===================================
...where i failed? what am i missing... a bit confused by all this xml around, i'm just not used...
Marco