[teiid-commits] teiid SVN: r3273 - trunk/build/kits/jboss-container/teiid-examples/jca.

Author: van.halbert Date: 2011-06-27 10:25:00 -0400 (Mon, 27 Jun 2011) New Revision: 3273 Modified: trunk/build/kits/jboss-container/teiid-examples/jca/readme.txt trunk/build/kits/jboss-container/teiid-examples/jca/teiid-jdbc-template-ds.xml Log: propagated the updated reame from 7.4.x and fixed the teiid template, the user param should be user-name Modified: trunk/build/kits/jboss-container/teiid-examples/jca/readme.txt =================================================================== --- trunk/build/kits/jboss-container/teiid-examples/jca/readme.txt 2011-06-27 14:23:19 UTC (rev 3272) +++ trunk/build/kits/jboss-container/teiid-examples/jca/readme.txt 2011-06-27 14:25:00 UTC (rev 3273) @@ -3,6 +3,28 @@ LDAP SalesForce Web Services (for ws-security see Admin Guide) + ODBC + OLAP + Mondrian + Ingres + Intersystems Cache + Teiid JDBC template -JDBC Users: Please see the examples in the "<jboss-as>/docs/examples/jca" directory for creating data source configuration -files for any type of relational database. These examples demonstrate creating both "local" and "xa" data sources. +JDBC Users: Please see the examples in the "<jboss-as>/docs/examples/jca" directory for creating data source configuration files for any type of relational database. These examples demonstrate creating both "local" and "xa" data sources. + + +--------- + +When server applications wants to obtain their Teiid jdbc connection from the server connection pool, then Teiid needs to be deployed as a datasource. + +We have provided a datasource -ds.xml template file to assist in the Teiid datasource deployment. + +To deploy, using the template, do the following: + +1. make a copy of the teiid-jdbc-template-ds.xml file +2. edit the file and replace "(vdb)" with the name of your vdb that you will be accessing, updating the user and password accordingly. +3. then copy the new -ds.xml file to the deploy directory of the profile you will be using. + +Your application should be able to obtain a jdbc connection from the connection pool using the JNDI name defined in the -ds.xml file. +By default, it called "TeiidDS". If you have changed it, then your application will need to refer to it by the new name. + Modified: trunk/build/kits/jboss-container/teiid-examples/jca/teiid-jdbc-template-ds.xml =================================================================== --- trunk/build/kits/jboss-container/teiid-examples/jca/teiid-jdbc-template-ds.xml 2011-06-27 14:23:19 UTC (rev 3272) +++ trunk/build/kits/jboss-container/teiid-examples/jca/teiid-jdbc-template-ds.xml 2011-06-27 14:25:00 UTC (rev 3273) @@ -21,7 +21,7 @@ <connection-url>jdbc:teiid:(vdb)@mm://localhost:31000</connection-url> <driver-class>org.teiid.jdbc.TeiidDriver</driver-class> - <user>user</user> + <user-name>user</user-name> <password>user</password> <metadata>