Author: rareddy Date: 2012-02-01 17:01:48 -0500 (Wed, 01 Feb 2012) New Revision: 3841 Added: trunk/build/kits/jboss-as7/docs/teiid/examples/dynamicvdb-portfolio/portfolio-ds.xml trunk/build/kits/jboss-as7/docs/teiid/examples/dynamicvdb-portfolio/portfolio-vdb.xml.dodeploy Modified: trunk/build/kits/jboss-as7/docs/teiid/examples/dynamicvdb-portfolio/README.txt trunk/build/kits/jboss-as7/docs/teiid/examples/dynamicvdb-portfolio/customer-schema.sql trunk/build/kits/jboss-as7/docs/teiid/examples/dynamicvdb-portfolio/data-roles-ext/README.txt trunk/build/kits/jboss-as7/docs/teiid/examples/dynamicvdb-portfolio/data-roles-ext/portfolio-vdb.xml trunk/build/kits/jboss-as7/docs/teiid/examples/dynamicvdb-portfolio/marketdata-file-ds.xml trunk/build/kits/jboss-as7/docs/teiid/examples/dynamicvdb-portfolio/portfolio-vdb.xml trunk/build/kits/jboss-as7/docs/teiid/examples/simpleclient/run.bat trunk/build/kits/jboss-as7/docs/teiid/examples/simpleclient/run.sh Log: TEIID-1901: updated for AS7 and H2 database Modified: trunk/build/kits/jboss-as7/docs/teiid/examples/dynamicvdb-portfolio/README.txt =================================================================== --- trunk/build/kits/jboss-as7/docs/teiid/examples/dynamicvdb-portfolio/README.txt 2012-02-01 21:56:42 UTC (rev 3840) +++ trunk/build/kits/jboss-as7/docs/teiid/examples/dynamicvdb-portfolio/README.txt 2012-02-01 22:01:48 UTC (rev 3841) @@ -1,31 +1,31 @@ Dynamicvdb-portfolio demonstrates how to federate data from a relational data source with a -text file-based data source. This example uses the HSQL database which is referenced as -the PortfolioDS data source in the server, but the creation SQL could be adapted to another +text file-based data source. This example uses the H2 database which is referenced as +the "accouts-ds" data source in the server, but the creation SQL could be adapted to another database if you choose. Data Source(s) setup: -- Start the server (if not already started) -- go to the JMX console (http://localhost:8080/jmx-console/) and select: database=localDB,service=Hypersonic -to present bean options. Now invoke "startDatabaseManager" to bring up HSQL Database Manager. -- Use the File/Open Script menu option to load the teiid-examples/dynamicvdb-portfolio/customer-schema.sql script and and then click Execute SQL to create the required tables and insert the example data. +- Edit the contents of "standalone-teiid.xml" file, and add contents of following files to create H2, CSV data sources - + (1) portfolio-ds.xml.xml - under "datasources" subsystem element + (2) marketdata-file-ds.xml - under "resource-adapter" subsystem + Teiid Deployment: +Copy the following files to the "<jboss.home>/standalone/deployments" directory -Copy the following files to the <jboss.home>/server/default/deploy directory. + (1) portfolio-vdb.xml + (2) portfolio-vdb.xml.dodeploy - (1) portfolio-vdb.xml - (2) marketdata-file-ds.xml + +make sure the VDB is deloyed in the AS7 console. - Query Demonstrations: ==== Using the simpleclient example ==== -1) Change your working directory to teiid-examples/simpleclient +1) Change your working directory to "<jboss-install>/docs/teiid/examples/simpleclient" 2) Use the simpleclient example run script, using the following format Modified: trunk/build/kits/jboss-as7/docs/teiid/examples/dynamicvdb-portfolio/customer-schema.sql =================================================================== --- trunk/build/kits/jboss-as7/docs/teiid/examples/dynamicvdb-portfolio/customer-schema.sql 2012-02-01 21:56:42 UTC (rev 3840) +++ trunk/build/kits/jboss-as7/docs/teiid/examples/dynamicvdb-portfolio/customer-schema.sql 2012-02-01 22:01:48 UTC (rev 3841) @@ -69,25 +69,24 @@ INSERT INTO CUSTOMER (SSN,FIRSTNAME,LASTNAME,ST_ADDRESS,APT_NUMBER,CITY,STATE,ZIPCODE,PHONE) VALUES ('CST01035','Henry','Thomas','345 Hilltop Parkway',null,'San Francisco','California','94129','(415)555-2093'); INSERT INTO CUSTOMER (SSN,FIRSTNAME,LASTNAME,ST_ADDRESS,APT_NUMBER,CITY,STATE,ZIPCODE,PHONE) VALUES ('CST01036','James','Drew','876 Lakefront Lane',null,'Cleveland','Ohio','44107','(216)555-6523'); +INSERT INTO ACCOUNT (ACCOUNT_ID,SSN,STATUS,TYPE,DATEOPENED,DATECLOSED) VALUES (19980002,'CST01002','Personal ','Active ', '1998-02-01 00:00:00.000', NULL); +INSERT INTO ACCOUNT (ACCOUNT_ID,SSN,STATUS,TYPE,DATEOPENED,DATECLOSED) VALUES (19980003,'CST01003','Personal ','Active ','1998-03-06 00:00:00.000',null); +INSERT INTO ACCOUNT (ACCOUNT_ID,SSN,STATUS,TYPE,DATEOPENED,DATECLOSED) VALUES (19980004,'CST01004','Personal ','Active ','1998-03-07 00:00:00.000',null); +INSERT INTO ACCOUNT (ACCOUNT_ID,SSN,STATUS,TYPE,DATEOPENED,DATECLOSED) VALUES (19980005,'CST01005','Personal ','Active ','1998-06-15 00:00:00.000',null); +INSERT INTO ACCOUNT (ACCOUNT_ID,SSN,STATUS,TYPE,DATEOPENED,DATECLOSED) VALUES (19980006,'CST01006','Personal ','Active ','1998-09-15 00:00:00.000',null); +INSERT INTO ACCOUNT (ACCOUNT_ID,SSN,STATUS,TYPE,DATEOPENED,DATECLOSED) VALUES (19990007,'CST01007','Personal ','Active ','1999-01-20 00:00:00.000',null); +INSERT INTO ACCOUNT (ACCOUNT_ID,SSN,STATUS,TYPE,DATEOPENED,DATECLOSED) VALUES (19990008,'CST01008','Personal ','Active ','1999-04-16 00:00:00.000',null); +INSERT INTO ACCOUNT (ACCOUNT_ID,SSN,STATUS,TYPE,DATEOPENED,DATECLOSED) VALUES (19990009,'CST01009','Business ','Active ','1999-06-25 00:00:00.000',null); +INSERT INTO ACCOUNT (ACCOUNT_ID,SSN,STATUS,TYPE,DATEOPENED,DATECLOSED) VALUES (20000015,'CST01015','Personal ','Closed ','2000-04-20 00:00:00.000','2001-06-22 00:00:00.000'); +INSERT INTO ACCOUNT (ACCOUNT_ID,SSN,STATUS,TYPE,DATEOPENED,DATECLOSED) VALUES (20000019,'CST01019','Personal ','Active ','2000-10-08 00:00:00.000',null); +INSERT INTO ACCOUNT (ACCOUNT_ID,SSN,STATUS,TYPE,DATEOPENED,DATECLOSED) VALUES (20000020,'CST01020','Personal ','Active ','2000-10-20 00:00:00.000',null); +INSERT INTO ACCOUNT (ACCOUNT_ID,SSN,STATUS,TYPE,DATEOPENED,DATECLOSED) VALUES (20000021,'CST01021','Personal ','Active ','2000-12-05 00:00:00.000',null); +INSERT INTO ACCOUNT (ACCOUNT_ID,SSN,STATUS,TYPE,DATEOPENED,DATECLOSED) VALUES (20010022,'CST01022','Personal ','Active ','2001-01-05 00:00:00.000',null); +INSERT INTO ACCOUNT (ACCOUNT_ID,SSN,STATUS,TYPE,DATEOPENED,DATECLOSED) VALUES (20010027,'CST01027','Personal ','Active ','2001-08-22 00:00:00.000',null); +INSERT INTO ACCOUNT (ACCOUNT_ID,SSN,STATUS,TYPE,DATEOPENED,DATECLOSED) VALUES (20020034,'CST01034','Business ','Active ','2002-01-22 00:00:00.000',null); +INSERT INTO ACCOUNT (ACCOUNT_ID,SSN,STATUS,TYPE,DATEOPENED,DATECLOSED) VALUES (20020035,'CST01035','Personal ','Active ','2002-02-12 00:00:00.000',null); +INSERT INTO ACCOUNT (ACCOUNT_ID,SSN,STATUS,TYPE,DATEOPENED,DATECLOSED) VALUES (20020036,'CST01036','Personal ','Active ','2002-03-22 00:00:00.000',null); -INSERT INTO ACCOUNT (ACCOUNT_ID,SSN,STATUS,TYPE,DATEOPENED,DATECLOSED) VALUES (19980002,'CST01002','Personal ','Active ',{ts '1998-02-01 00:00:00.000'},null); -INSERT INTO ACCOUNT (ACCOUNT_ID,SSN,STATUS,TYPE,DATEOPENED,DATECLOSED) VALUES (19980003,'CST01003','Personal ','Active ',{ts '1998-03-06 00:00:00.000'},null); -INSERT INTO ACCOUNT (ACCOUNT_ID,SSN,STATUS,TYPE,DATEOPENED,DATECLOSED) VALUES (19980004,'CST01004','Personal ','Active ',{ts '1998-03-07 00:00:00.000'},null); -INSERT INTO ACCOUNT (ACCOUNT_ID,SSN,STATUS,TYPE,DATEOPENED,DATECLOSED) VALUES (19980005,'CST01005','Personal ','Active ',{ts '1998-06-15 00:00:00.000'},null); -INSERT INTO ACCOUNT (ACCOUNT_ID,SSN,STATUS,TYPE,DATEOPENED,DATECLOSED) VALUES (19980006,'CST01006','Personal ','Active ',{ts '1998-09-15 00:00:00.000'},null); -INSERT INTO ACCOUNT (ACCOUNT_ID,SSN,STATUS,TYPE,DATEOPENED,DATECLOSED) VALUES (19990007,'CST01007','Personal ','Active ',{ts '1999-01-20 00:00:00.000'},null); -INSERT INTO ACCOUNT (ACCOUNT_ID,SSN,STATUS,TYPE,DATEOPENED,DATECLOSED) VALUES (19990008,'CST01008','Personal ','Active ',{ts '1999-04-16 00:00:00.000'},null); -INSERT INTO ACCOUNT (ACCOUNT_ID,SSN,STATUS,TYPE,DATEOPENED,DATECLOSED) VALUES (19990009,'CST01009','Business ','Active ',{ts '1999-06-25 00:00:00.000'},null); -INSERT INTO ACCOUNT (ACCOUNT_ID,SSN,STATUS,TYPE,DATEOPENED,DATECLOSED) VALUES (20000015,'CST01015','Personal ','Closed ',{ts '2000-04-20 00:00:00.000'},{ts '2001-06-22 00:00:00.000'}); -INSERT INTO ACCOUNT (ACCOUNT_ID,SSN,STATUS,TYPE,DATEOPENED,DATECLOSED) VALUES (20000019,'CST01019','Personal ','Active ',{ts '2000-10-08 00:00:00.000'},null); -INSERT INTO ACCOUNT (ACCOUNT_ID,SSN,STATUS,TYPE,DATEOPENED,DATECLOSED) VALUES (20000020,'CST01020','Personal ','Active ',{ts '2000-10-20 00:00:00.000'},null); -INSERT INTO ACCOUNT (ACCOUNT_ID,SSN,STATUS,TYPE,DATEOPENED,DATECLOSED) VALUES (20000021,'CST01021','Personal ','Active ',{ts '2000-12-05 00:00:00.000'},null); -INSERT INTO ACCOUNT (ACCOUNT_ID,SSN,STATUS,TYPE,DATEOPENED,DATECLOSED) VALUES (20010022,'CST01022','Personal ','Active ',{ts '2001-01-05 00:00:00.000'},null); -INSERT INTO ACCOUNT (ACCOUNT_ID,SSN,STATUS,TYPE,DATEOPENED,DATECLOSED) VALUES (20010027,'CST01027','Personal ','Active ',{ts '2001-08-22 00:00:00.000'},null); -INSERT INTO ACCOUNT (ACCOUNT_ID,SSN,STATUS,TYPE,DATEOPENED,DATECLOSED) VALUES (20020034,'CST01034','Business ','Active ',{ts '2002-01-22 00:00:00.000'},null); -INSERT INTO ACCOUNT (ACCOUNT_ID,SSN,STATUS,TYPE,DATEOPENED,DATECLOSED) VALUES (20020035,'CST01035','Personal ','Active ',{ts '2002-02-12 00:00:00.000'},null); -INSERT INTO ACCOUNT (ACCOUNT_ID,SSN,STATUS,TYPE,DATEOPENED,DATECLOSED) VALUES (20020036,'CST01036','Personal ','Active ',{ts '2002-03-22 00:00:00.000'},null); - INSERT INTO PRODUCT (ID,SYMBOL,COMPANY_NAME) VALUES(1002,'BA','The Boeing Company'); INSERT INTO PRODUCT (ID,SYMBOL,COMPANY_NAME) VALUES(1003,'MON','Monsanto Company'); INSERT INTO PRODUCT (ID,SYMBOL,COMPANY_NAME) VALUES(1004,'PNRA','Panera Bread Company'); @@ -114,47 +113,46 @@ INSERT INTO PRODUCT (ID,SYMBOL,COMPANY_NAME) VALUES(1034,'SAP','SAP AG'); INSERT INTO PRODUCT (ID,SYMBOL,COMPANY_NAME) VALUES(1036,'TM','Toyota Motor Corporation'); -INSERT INTO HOLDINGS (ACCOUNT_ID,PRODUCT_ID,PURCHASE_DATE,SHARES_COUNT) VALUES (19980002,1008,{ts '1998-02-01 00:00:00.000'},50); -INSERT INTO HOLDINGS (ACCOUNT_ID,PRODUCT_ID,PURCHASE_DATE,SHARES_COUNT) VALUES (19980002,1036,{ts '1998-02-01 00:00:00.000'},25); -INSERT INTO HOLDINGS (ACCOUNT_ID,PRODUCT_ID,PURCHASE_DATE,SHARES_COUNT) VALUES (19980003,1002,{ts '1998-03-06 00:00:00.000'},100); -INSERT INTO HOLDINGS (ACCOUNT_ID,PRODUCT_ID,PURCHASE_DATE,SHARES_COUNT) VALUES (19980003,1029,{ts '1998-03-06 00:00:00.000'},25); -INSERT INTO HOLDINGS (ACCOUNT_ID,PRODUCT_ID,PURCHASE_DATE,SHARES_COUNT) VALUES (19980003,1016,{ts '1998-03-06 00:00:00.000'},51); -INSERT INTO HOLDINGS (ACCOUNT_ID,PRODUCT_ID,PURCHASE_DATE,SHARES_COUNT) VALUES (19980004,1011,{ts '1998-03-07 00:00:00.000'},30); -INSERT INTO HOLDINGS (ACCOUNT_ID,PRODUCT_ID,PURCHASE_DATE,SHARES_COUNT) VALUES (19980005,1024,{ts '1998-06-15 00:00:00.000'},18); -INSERT INTO HOLDINGS (ACCOUNT_ID,PRODUCT_ID,PURCHASE_DATE,SHARES_COUNT) VALUES (19980006,1033,{ts '1998-09-15 00:00:00.000'},200); -INSERT INTO HOLDINGS (ACCOUNT_ID,PRODUCT_ID,PURCHASE_DATE,SHARES_COUNT) VALUES (19990007,1031,{ts '1999-01-20 00:00:00.000'},65); -INSERT INTO HOLDINGS (ACCOUNT_ID,PRODUCT_ID,PURCHASE_DATE,SHARES_COUNT) VALUES (19990008,1012,{ts '1999-04-16 00:00:00.000'},102); -INSERT INTO HOLDINGS (ACCOUNT_ID,PRODUCT_ID,PURCHASE_DATE,SHARES_COUNT) VALUES (19990007,1008,{ts '1999-05-11 00:00:00.000'},85); -INSERT INTO HOLDINGS (ACCOUNT_ID,PRODUCT_ID,PURCHASE_DATE,SHARES_COUNT) VALUES (19990008,1005,{ts '1999-05-21 00:00:00.000'},105); -INSERT INTO HOLDINGS (ACCOUNT_ID,PRODUCT_ID,PURCHASE_DATE,SHARES_COUNT) VALUES (19990009,1004,{ts '1999-06-25 00:00:00.000'},120); -INSERT INTO HOLDINGS (ACCOUNT_ID,PRODUCT_ID,PURCHASE_DATE,SHARES_COUNT) VALUES (19980003,1024,{ts '1999-07-22 00:00:00.000'},150); -INSERT INTO HOLDINGS (ACCOUNT_ID,PRODUCT_ID,PURCHASE_DATE,SHARES_COUNT) VALUES (20000015,1018,{ts '2000-04-20 00:00:00.000'},135); -INSERT INTO HOLDINGS (ACCOUNT_ID,PRODUCT_ID,PURCHASE_DATE,SHARES_COUNT) VALUES (19980006,1030,{ts '2000-06-12 00:00:00.000'},91); -INSERT INTO HOLDINGS (ACCOUNT_ID,PRODUCT_ID,PURCHASE_DATE,SHARES_COUNT) VALUES (20000019,1029,{ts '2000-10-08 00:00:00.000'},351); -INSERT INTO HOLDINGS (ACCOUNT_ID,PRODUCT_ID,PURCHASE_DATE,SHARES_COUNT) VALUES (20000020,1030,{ts '2000-10-20 00:00:00.000'},127); -INSERT INTO HOLDINGS (ACCOUNT_ID,PRODUCT_ID,PURCHASE_DATE,SHARES_COUNT) VALUES (20000020,1018,{ts '2000-11-14 00:00:00.000'},100); -INSERT INTO HOLDINGS (ACCOUNT_ID,PRODUCT_ID,PURCHASE_DATE,SHARES_COUNT) VALUES (20000019,1031,{ts '2000-11-15 00:00:00.000'},125); -INSERT INTO HOLDINGS (ACCOUNT_ID,PRODUCT_ID,PURCHASE_DATE,SHARES_COUNT) VALUES (20000021,1028,{ts '2000-12-05 00:00:00.000'},400); -INSERT INTO HOLDINGS (ACCOUNT_ID,PRODUCT_ID,PURCHASE_DATE,SHARES_COUNT) VALUES (20010022,1006,{ts '2001-01-05 00:00:00.000'},237); -INSERT INTO HOLDINGS (ACCOUNT_ID,PRODUCT_ID,PURCHASE_DATE,SHARES_COUNT) VALUES (19990008,1015,{ts '2001-01-23 00:00:00.000'},180); -INSERT INTO HOLDINGS (ACCOUNT_ID,PRODUCT_ID,PURCHASE_DATE,SHARES_COUNT) VALUES (19980005,1025,{ts '2001-03-23 00:00:00.000'},125); -INSERT INTO HOLDINGS (ACCOUNT_ID,PRODUCT_ID,PURCHASE_DATE,SHARES_COUNT) VALUES (20010027,1024,{ts '2001-08-22 00:00:00.000'},70); -INSERT INTO HOLDINGS (ACCOUNT_ID,PRODUCT_ID,PURCHASE_DATE,SHARES_COUNT) VALUES (20000020,1006,{ts '2001-11-14 00:00:00.000'},125); -INSERT INTO HOLDINGS (ACCOUNT_ID,PRODUCT_ID,PURCHASE_DATE,SHARES_COUNT) VALUES (19980003,1029,{ts '2001-11-15 00:00:00.000'},100); -INSERT INTO HOLDINGS (ACCOUNT_ID,PRODUCT_ID,PURCHASE_DATE,SHARES_COUNT) VALUES (20000021,1011,{ts '2001-12-18 00:00:00.000'},44); -INSERT INTO HOLDINGS (ACCOUNT_ID,PRODUCT_ID,PURCHASE_DATE,SHARES_COUNT) VALUES (20010027,1028,{ts '2001-12-19 00:00:00.000'},115); -INSERT INTO HOLDINGS (ACCOUNT_ID,PRODUCT_ID,PURCHASE_DATE,SHARES_COUNT) VALUES (20020034,1024,{ts '2002-01-22 00:00:00.000'},189); -INSERT INTO HOLDINGS (ACCOUNT_ID,PRODUCT_ID,PURCHASE_DATE,SHARES_COUNT) VALUES (19990009,1029,{ts '2002-01-24 00:00:00.000'},30); -INSERT INTO HOLDINGS (ACCOUNT_ID,PRODUCT_ID,PURCHASE_DATE,SHARES_COUNT) VALUES (20020035,1013,{ts '2002-02-12 00:00:00.000'},110); -INSERT INTO HOLDINGS (ACCOUNT_ID,PRODUCT_ID,PURCHASE_DATE,SHARES_COUNT) VALUES (20020035,1034,{ts '2002-02-13 00:00:00.000'},70); -INSERT INTO HOLDINGS (ACCOUNT_ID,PRODUCT_ID,PURCHASE_DATE,SHARES_COUNT) VALUES (20020034,1003,{ts '2002-02-22 00:00:00.000'},25); -INSERT INTO HOLDINGS (ACCOUNT_ID,PRODUCT_ID,PURCHASE_DATE,SHARES_COUNT) VALUES (20000019,1013,{ts '2002-02-26 00:00:00.000'},195); -INSERT INTO HOLDINGS (ACCOUNT_ID,PRODUCT_ID,PURCHASE_DATE,SHARES_COUNT) VALUES (19980004,1007,{ts '2002-03-05 00:00:00.000'},250); -INSERT INTO HOLDINGS (ACCOUNT_ID,PRODUCT_ID,PURCHASE_DATE,SHARES_COUNT) VALUES (20000021,1014,{ts '2002-03-12 00:00:00.000'},300); -INSERT INTO HOLDINGS (ACCOUNT_ID,PRODUCT_ID,PURCHASE_DATE,SHARES_COUNT) VALUES (20010027,1024,{ts '2002-03-14 00:00:00.000'},136); -INSERT INTO HOLDINGS (ACCOUNT_ID,PRODUCT_ID,PURCHASE_DATE,SHARES_COUNT) VALUES (20020036,1012,{ts '2002-03-22 00:00:00.000'},54); -INSERT INTO HOLDINGS (ACCOUNT_ID,PRODUCT_ID,PURCHASE_DATE,SHARES_COUNT) VALUES (20020036,1010,{ts '2002-03-26 00:00:00.000'},189); -INSERT INTO HOLDINGS (ACCOUNT_ID,PRODUCT_ID,PURCHASE_DATE,SHARES_COUNT) VALUES (19980005,1010,{ts '2002-04-01 00:00:00.000'},26); +INSERT INTO HOLDINGS (ACCOUNT_ID,PRODUCT_ID,PURCHASE_DATE,SHARES_COUNT) VALUES (19980002,1008,'1998-02-01 00:00:00.000',50); +INSERT INTO HOLDINGS (ACCOUNT_ID,PRODUCT_ID,PURCHASE_DATE,SHARES_COUNT) VALUES (19980002,1036,'1998-02-01 00:00:00.000',25); +INSERT INTO HOLDINGS (ACCOUNT_ID,PRODUCT_ID,PURCHASE_DATE,SHARES_COUNT) VALUES (19980003,1002,'1998-03-06 00:00:00.000',100); +INSERT INTO HOLDINGS (ACCOUNT_ID,PRODUCT_ID,PURCHASE_DATE,SHARES_COUNT) VALUES (19980003,1029,'1998-03-06 00:00:00.000',25); +INSERT INTO HOLDINGS (ACCOUNT_ID,PRODUCT_ID,PURCHASE_DATE,SHARES_COUNT) VALUES (19980003,1016,'1998-03-06 00:00:00.000',51); +INSERT INTO HOLDINGS (ACCOUNT_ID,PRODUCT_ID,PURCHASE_DATE,SHARES_COUNT) VALUES (19980004,1011,'1998-03-07 00:00:00.000',30); +INSERT INTO HOLDINGS (ACCOUNT_ID,PRODUCT_ID,PURCHASE_DATE,SHARES_COUNT) VALUES (19980005,1024,'1998-06-15 00:00:00.000',18); +INSERT INTO HOLDINGS (ACCOUNT_ID,PRODUCT_ID,PURCHASE_DATE,SHARES_COUNT) VALUES (19980006,1033,'1998-09-15 00:00:00.000',200); +INSERT INTO HOLDINGS (ACCOUNT_ID,PRODUCT_ID,PURCHASE_DATE,SHARES_COUNT) VALUES (19990007,1031,'1999-01-20 00:00:00.000',65); +INSERT INTO HOLDINGS (ACCOUNT_ID,PRODUCT_ID,PURCHASE_DATE,SHARES_COUNT) VALUES (19990008,1012,'1999-04-16 00:00:00.000',102); +INSERT INTO HOLDINGS (ACCOUNT_ID,PRODUCT_ID,PURCHASE_DATE,SHARES_COUNT) VALUES (19990007,1008,'1999-05-11 00:00:00.000',85); +INSERT INTO HOLDINGS (ACCOUNT_ID,PRODUCT_ID,PURCHASE_DATE,SHARES_COUNT) VALUES (19990008,1005,'1999-05-21 00:00:00.000',105); +INSERT INTO HOLDINGS (ACCOUNT_ID,PRODUCT_ID,PURCHASE_DATE,SHARES_COUNT) VALUES (19990009,1004,'1999-06-25 00:00:00.000',120); +INSERT INTO HOLDINGS (ACCOUNT_ID,PRODUCT_ID,PURCHASE_DATE,SHARES_COUNT) VALUES (19980003,1024,'1999-07-22 00:00:00.000',150); +INSERT INTO HOLDINGS (ACCOUNT_ID,PRODUCT_ID,PURCHASE_DATE,SHARES_COUNT) VALUES (20000015,1018,'2000-04-20 00:00:00.000',135); +INSERT INTO HOLDINGS (ACCOUNT_ID,PRODUCT_ID,PURCHASE_DATE,SHARES_COUNT) VALUES (19980006,1030,'2000-06-12 00:00:00.000',91); +INSERT INTO HOLDINGS (ACCOUNT_ID,PRODUCT_ID,PURCHASE_DATE,SHARES_COUNT) VALUES (20000019,1029,'2000-10-08 00:00:00.000',351); +INSERT INTO HOLDINGS (ACCOUNT_ID,PRODUCT_ID,PURCHASE_DATE,SHARES_COUNT) VALUES (20000020,1030,'2000-10-20 00:00:00.000',127); +INSERT INTO HOLDINGS (ACCOUNT_ID,PRODUCT_ID,PURCHASE_DATE,SHARES_COUNT) VALUES (20000020,1018,'2000-11-14 00:00:00.000',100); +INSERT INTO HOLDINGS (ACCOUNT_ID,PRODUCT_ID,PURCHASE_DATE,SHARES_COUNT) VALUES (20000019,1031,'2000-11-15 00:00:00.000',125); +INSERT INTO HOLDINGS (ACCOUNT_ID,PRODUCT_ID,PURCHASE_DATE,SHARES_COUNT) VALUES (20000021,1028,'2000-12-05 00:00:00.000',400); +INSERT INTO HOLDINGS (ACCOUNT_ID,PRODUCT_ID,PURCHASE_DATE,SHARES_COUNT) VALUES (20010022,1006,'2001-01-05 00:00:00.000',237); +INSERT INTO HOLDINGS (ACCOUNT_ID,PRODUCT_ID,PURCHASE_DATE,SHARES_COUNT) VALUES (19990008,1015,'2001-01-23 00:00:00.000',180); +INSERT INTO HOLDINGS (ACCOUNT_ID,PRODUCT_ID,PURCHASE_DATE,SHARES_COUNT) VALUES (19980005,1025,'2001-03-23 00:00:00.000',125); +INSERT INTO HOLDINGS (ACCOUNT_ID,PRODUCT_ID,PURCHASE_DATE,SHARES_COUNT) VALUES (20010027,1024,'2001-08-22 00:00:00.000',70); +INSERT INTO HOLDINGS (ACCOUNT_ID,PRODUCT_ID,PURCHASE_DATE,SHARES_COUNT) VALUES (20000020,1006,'2001-11-14 00:00:00.000',125); +INSERT INTO HOLDINGS (ACCOUNT_ID,PRODUCT_ID,PURCHASE_DATE,SHARES_COUNT) VALUES (19980003,1029,'2001-11-15 00:00:00.000',100); +INSERT INTO HOLDINGS (ACCOUNT_ID,PRODUCT_ID,PURCHASE_DATE,SHARES_COUNT) VALUES (20000021,1011,'2001-12-18 00:00:00.000',44); +INSERT INTO HOLDINGS (ACCOUNT_ID,PRODUCT_ID,PURCHASE_DATE,SHARES_COUNT) VALUES (20010027,1028,'2001-12-19 00:00:00.000',115); +INSERT INTO HOLDINGS (ACCOUNT_ID,PRODUCT_ID,PURCHASE_DATE,SHARES_COUNT) VALUES (20020034,1024,'2002-01-22 00:00:00.000',189); +INSERT INTO HOLDINGS (ACCOUNT_ID,PRODUCT_ID,PURCHASE_DATE,SHARES_COUNT) VALUES (19990009,1029,'2002-01-24 00:00:00.000',30); +INSERT INTO HOLDINGS (ACCOUNT_ID,PRODUCT_ID,PURCHASE_DATE,SHARES_COUNT) VALUES (20020035,1013,'2002-02-12 00:00:00.000',110); +INSERT INTO HOLDINGS (ACCOUNT_ID,PRODUCT_ID,PURCHASE_DATE,SHARES_COUNT) VALUES (20020035,1034,'2002-02-13 00:00:00.000',70); +INSERT INTO HOLDINGS (ACCOUNT_ID,PRODUCT_ID,PURCHASE_DATE,SHARES_COUNT) VALUES (20020034,1003,'2002-02-22 00:00:00.000',25); +INSERT INTO HOLDINGS (ACCOUNT_ID,PRODUCT_ID,PURCHASE_DATE,SHARES_COUNT) VALUES (20000019,1013,'2002-02-26 00:00:00.000',195); +INSERT INTO HOLDINGS (ACCOUNT_ID,PRODUCT_ID,PURCHASE_DATE,SHARES_COUNT) VALUES (19980004,1007,'2002-03-05 00:00:00.000',250); +INSERT INTO HOLDINGS (ACCOUNT_ID,PRODUCT_ID,PURCHASE_DATE,SHARES_COUNT) VALUES (20000021,1014,'2002-03-12 00:00:00.000',300); +INSERT INTO HOLDINGS (ACCOUNT_ID,PRODUCT_ID,PURCHASE_DATE,SHARES_COUNT) VALUES (20010027,1024,'2002-03-14 00:00:00.000',136); +INSERT INTO HOLDINGS (ACCOUNT_ID,PRODUCT_ID,PURCHASE_DATE,SHARES_COUNT) VALUES (20020036,1012,'2002-03-22 00:00:00.000',54); +INSERT INTO HOLDINGS (ACCOUNT_ID,PRODUCT_ID,PURCHASE_DATE,SHARES_COUNT) VALUES (20020036,1010,'2002-03-26 00:00:00.000',189); +INSERT INTO HOLDINGS (ACCOUNT_ID,PRODUCT_ID,PURCHASE_DATE,SHARES_COUNT) VALUES (19980005,1010,'2002-04-01 00:00:00.000',26); - Modified: trunk/build/kits/jboss-as7/docs/teiid/examples/dynamicvdb-portfolio/data-roles-ext/README.txt =================================================================== --- trunk/build/kits/jboss-as7/docs/teiid/examples/dynamicvdb-portfolio/data-roles-ext/README.txt 2012-02-01 21:56:42 UTC (rev 3840) +++ trunk/build/kits/jboss-as7/docs/teiid/examples/dynamicvdb-portfolio/data-roles-ext/README.txt 2012-02-01 22:01:48 UTC (rev 3841) @@ -14,7 +14,7 @@ To deploy the VDB, follow same steps as before in the previous example. To define the new users and their roles to be used with this example,copy both the teiid-security-user.properties, -teiid-security-roles.properties into "<jboss-as>/server/<profile>/conf/props" directory. Server restart is required after this +teiid-security-roles.properties into "<jboss-as>/modules/org/jboss/teiid/conf" directory. Server restart is required after this operation. Modified: trunk/build/kits/jboss-as7/docs/teiid/examples/dynamicvdb-portfolio/data-roles-ext/portfolio-vdb.xml =================================================================== --- trunk/build/kits/jboss-as7/docs/teiid/examples/dynamicvdb-portfolio/data-roles-ext/portfolio-vdb.xml 2012-02-01 21:56:42 UTC (rev 3840) +++ trunk/build/kits/jboss-as7/docs/teiid/examples/dynamicvdb-portfolio/data-roles-ext/portfolio-vdb.xml 2012-02-01 22:01:48 UTC (rev 3841) @@ -3,47 +3,15 @@ <description>A Dynamic VDB</description> - <!-- - Setting to use connector supplied metadata. Can be "true" or "cached". - "true" will obtain metadata once for every launch of Teiid. - "cached" will save a file containing the metadata into - the deploy/<vdb name>/<vdb version/META-INF directory - --> <property name="UseConnectorMetadata" value="true" /> - - <!-- - Each model represents a access to one or more sources. - The name of the model will be used as a top level schema name - for all of the metadata imported from the connector. - - NOTE: Multiple model, with different import settings, can be bound to - the same connector binding and will be treated as the same source at - runtime. - --> <model name="MarketData"> - <!-- - Each source represents a translator and data source. There are - pre-defined translators, or you can create one. ConnectionFactories - or DataSources in JBoss AS they are typically defined using "xxx-ds.xml" files. - --> - <source name="text-connector" translator-name="file" connection-jndi-name="java:marketdata-file"/> + <source name="text-connector" translator-name="file" connection-jndi-name="java:/marketdata-file"/> </model> <model name="Accounts"> - <!-- - JDBC Import settings - - importer.useFullSchemaName directs the importer to drop the source - schema from the Teiid object name, so that the Teiid fully qualified name - will be in the form of <model name>.<table name> - --> <property name="importer.useFullSchemaName" value="false"/> - - <!-- - This connector is defined to reference the HSQL localDS" - --> - <source name="hsql-connector" translator-name="hsql" connection-jndi-name="java:DefaultDS"/> + <source name="hsql-connector" translator-name="hsql" connection-jndi-name="java:/accounts-ds"/> </model> <!-- For detailed description about data roles please refer to Reference Guide's Data Roles chapter --> @@ -91,7 +59,7 @@ <!-- This role must defined in the JAAS security domain, the sample UserRolesLoginModules based roles file provided in this sample directory. copy these "teiid-security-roles.properties" and "teiid-security-users.proeprties" - into "servers/default/conf/props" directory and replace the old ones. + into "<jboss-install>/modules/org/jboss/teiid/conf" directory and replace the old ones. --> <mapped-role-name>supervisor</mapped-role-name> </data-role> Modified: trunk/build/kits/jboss-as7/docs/teiid/examples/dynamicvdb-portfolio/marketdata-file-ds.xml =================================================================== --- trunk/build/kits/jboss-as7/docs/teiid/examples/dynamicvdb-portfolio/marketdata-file-ds.xml 2012-02-01 21:56:42 UTC (rev 3840) +++ trunk/build/kits/jboss-as7/docs/teiid/examples/dynamicvdb-portfolio/marketdata-file-ds.xml 2012-02-01 22:01:48 UTC (rev 3841) @@ -1,20 +1,24 @@ -<?xml version="1.0" encoding="UTF-8"?> - -<connection-factories> - - <no-tx-connection-factory> - <jndi-name>marketdata-file</jndi-name> - <rar-name>teiid-connector-file.rar</rar-name> - <connection-definition>javax.resource.cci.ConnectionFactory</connection-definition> - <!-- - All the available properties for this connector are defined inside the "ra.xml" defined inside the rar - file mentioned above. - --> - - <config-property name="ParentDirectory" type="java.lang.String">${jboss.server.home.dir}/teiid-examples/dynamicvdb-portfolio/data</config-property> - - <max-pool-size>20</max-pool-size> - - </no-tx-connection-factory> - -</connection-factories> \ No newline at end of file +<!-- If susbsytem is already defined, only copy the contents under it and edit to suit your needs --> +<subsystem xmlns="urn:jboss:domain:resource-adapters:1.0"> + <resource-adapters> + <resource-adapter> + <archive>teiid-connector-file.rar</archive> + <transaction-support>NoTransaction</transaction-support> + <connection-definitions> + <connection-definition class-name="org.teiid.resource.adapter.file.FileManagedConnectionFactory" + jndi-name="java:/marketdata-file" + enabled="true" + use-java-context="true" + pool-name="marketdata-file"> + + <!-- Directory where the data files are stored --> + <config-property name="ParentDirectory" type="java.lang.String">../docs/teiid/examples/dynamicvdb-portfolio/data</config-property> + + <!-- Set AllowParentPaths to false to disallow .. in paths. + This prevent requesting files that are not contained in the parent directory --> + <config-property name="AllowParentPaths">true</config-property> + </connection-definition> + </connection-definitions> + </resource-adapter> + </resource-adapters> +</subsystem> Added: trunk/build/kits/jboss-as7/docs/teiid/examples/dynamicvdb-portfolio/portfolio-ds.xml =================================================================== --- trunk/build/kits/jboss-as7/docs/teiid/examples/dynamicvdb-portfolio/portfolio-ds.xml (rev 0) +++ trunk/build/kits/jboss-as7/docs/teiid/examples/dynamicvdb-portfolio/portfolio-ds.xml 2012-02-01 22:01:48 UTC (rev 3841) @@ -0,0 +1,10 @@ +<datasources> + <datasource jndi-name="java:/accounts-ds" pool-name="accounts-ds" enabled="true" use-java-context="true"> + <connection-url> jdbc:h2:mem:accounts;INIT=RUNSCRIPT FROM '../docs/teiid/examples/dynamicvdb-portfolio/customer-schema.sql'\;</connection-url> + <driver>h2</driver> + <security> + <user-name>sa</user-name> + <password>sa</password> + </security> + </datasource> +</datasources> \ No newline at end of file Property changes on: trunk/build/kits/jboss-as7/docs/teiid/examples/dynamicvdb-portfolio/portfolio-ds.xml ___________________________________________________________________ Added: svn:mime-type + text/plain Modified: trunk/build/kits/jboss-as7/docs/teiid/examples/dynamicvdb-portfolio/portfolio-vdb.xml =================================================================== --- trunk/build/kits/jboss-as7/docs/teiid/examples/dynamicvdb-portfolio/portfolio-vdb.xml 2012-02-01 21:56:42 UTC (rev 3840) +++ trunk/build/kits/jboss-as7/docs/teiid/examples/dynamicvdb-portfolio/portfolio-vdb.xml 2012-02-01 22:01:48 UTC (rev 3841) @@ -27,7 +27,7 @@ pre-defined translators, or you can create one. ConnectionFactories or DataSources in JBoss AS they are typically defined using "xxx-ds.xml" files. --> - <source name="text-connector" translator-name="file" connection-jndi-name="java:marketdata-file"/> + <source name="text-connector" translator-name="file" connection-jndi-name="java:/marketdata-file"/> </model> <model name="Accounts"> @@ -41,9 +41,9 @@ <property name="importer.useFullSchemaName" value="false"/> <!-- - This connector is defined to reference the HSQL localDS" + This connector is defined to reference the H2 localDS" --> - <source name="hsql-connector" translator-name="hsql" connection-jndi-name="java:DefaultDS"/> + <source name="h2-connector" translator-name="h2" connection-jndi-name="java:/accounts-ds"/> </model> </vdb> \ No newline at end of file Added: trunk/build/kits/jboss-as7/docs/teiid/examples/dynamicvdb-portfolio/portfolio-vdb.xml.dodeploy =================================================================== Modified: trunk/build/kits/jboss-as7/docs/teiid/examples/simpleclient/run.bat =================================================================== --- trunk/build/kits/jboss-as7/docs/teiid/examples/simpleclient/run.bat 2012-02-01 21:56:42 UTC (rev 3840) +++ trunk/build/kits/jboss-as7/docs/teiid/examples/simpleclient/run.bat 2012-02-01 22:01:48 UTC (rev 3841) @@ -2,7 +2,7 @@ set CLIENT_PATH=. rem Second one adds the Teiid client -set TEIID_PATH=../../lib/teiid-${pom.version}-client.jar +set TEIID_PATH=../../../modules/org/jboss/teiid/common-core/main/teiid-common-core-${pom.version}.jar;../../../modules/org/jboss/teiid/client/main/teiid-client-${pom.version}.jar java -cp %CLIENT_PATH%;%TEIID_PATH% JDBCClient %* Modified: trunk/build/kits/jboss-as7/docs/teiid/examples/simpleclient/run.sh =================================================================== --- trunk/build/kits/jboss-as7/docs/teiid/examples/simpleclient/run.sh 2012-02-01 21:56:42 UTC (rev 3840) +++ trunk/build/kits/jboss-as7/docs/teiid/examples/simpleclient/run.sh 2012-02-01 22:01:48 UTC (rev 3841) @@ -4,6 +4,6 @@ CLIENT_PATH=. #Second one for the Teiid client jar -TEIID_PATH=../../lib/teiid-${pom.version}-client.jar +TEIID_PATH=../../../modules/org/jboss/teiid/common-core/main/teiid-common-core-${pom.version}.jar:../../../modules/org/jboss/teiid/client/main/teiid-client-${pom.version}.jar java -cp ${CLIENT_PATH}:${TEIID_PATH} JDBCClient "$@"