[teiid-commits] teiid SVN: r3726 - in trunk/build: kits and 70 other directories.

Author: rareddy Date: 2011-12-08 12:13:56 -0500 (Thu, 08 Dec 2011) New Revision: 3726 Added: trunk/build/kits/jboss-as7/docs/teiid/datasources/db2/ trunk/build/kits/jboss-as7/docs/teiid/datasources/db2/db2-xa.xml trunk/build/kits/jboss-as7/docs/teiid/datasources/db2/db2.xml trunk/build/kits/jboss-as7/docs/teiid/datasources/db2/modules/ trunk/build/kits/jboss-as7/docs/teiid/datasources/db2/modules/com/ trunk/build/kits/jboss-as7/docs/teiid/datasources/db2/modules/com/ibm/ trunk/build/kits/jboss-as7/docs/teiid/datasources/db2/modules/com/ibm/db2/ trunk/build/kits/jboss-as7/docs/teiid/datasources/db2/modules/com/ibm/db2/main/ trunk/build/kits/jboss-as7/docs/teiid/datasources/db2/modules/com/ibm/db2/main/module.xml trunk/build/kits/jboss-as7/docs/teiid/datasources/db2/readme.txt trunk/build/kits/jboss-as7/docs/teiid/datasources/derby/ trunk/build/kits/jboss-as7/docs/teiid/datasources/derby/derby-xa.xml trunk/build/kits/jboss-as7/docs/teiid/datasources/derby/derby.xml trunk/build/kits/jboss-as7/docs/teiid/datasources/derby/modules/ trunk/build/kits/jboss-as7/docs/teiid/datasources/derby/modules/org/ trunk/build/kits/jboss-as7/docs/teiid/datasources/derby/modules/org/apache/ trunk/build/kits/jboss-as7/docs/teiid/datasources/derby/modules/org/apache/derby/ trunk/build/kits/jboss-as7/docs/teiid/datasources/derby/modules/org/apache/derby/main/ trunk/build/kits/jboss-as7/docs/teiid/datasources/derby/modules/org/apache/derby/main/module.xml trunk/build/kits/jboss-as7/docs/teiid/datasources/derby/readme.txt trunk/build/kits/jboss-as7/docs/teiid/datasources/file/ trunk/build/kits/jboss-as7/docs/teiid/datasources/file/file.xml trunk/build/kits/jboss-as7/docs/teiid/datasources/file/readme.txt trunk/build/kits/jboss-as7/docs/teiid/datasources/h2/ trunk/build/kits/jboss-as7/docs/teiid/datasources/h2/h2.xml trunk/build/kits/jboss-as7/docs/teiid/datasources/h2/readme.txt trunk/build/kits/jboss-as7/docs/teiid/datasources/hive/ trunk/build/kits/jboss-as7/docs/teiid/datasources/hive/hive.xml trunk/build/kits/jboss-as7/docs/teiid/datasources/hive/modules/ trunk/build/kits/jboss-as7/docs/teiid/datasources/hive/modules/org/ trunk/build/kits/jboss-as7/docs/teiid/datasources/hive/modules/org/apache/ trunk/build/kits/jboss-as7/docs/teiid/datasources/hive/modules/org/apache/hadoop/ trunk/build/kits/jboss-as7/docs/teiid/datasources/hive/modules/org/apache/hadoop/hive/ trunk/build/kits/jboss-as7/docs/teiid/datasources/hive/modules/org/apache/hadoop/hive/main/ trunk/build/kits/jboss-as7/docs/teiid/datasources/hive/modules/org/apache/hadoop/hive/main/module.xml trunk/build/kits/jboss-as7/docs/teiid/datasources/hive/readme.txt trunk/build/kits/jboss-as7/docs/teiid/datasources/ingres/ trunk/build/kits/jboss-as7/docs/teiid/datasources/ingres/ingres-xa.xml trunk/build/kits/jboss-as7/docs/teiid/datasources/ingres/ingres.xml trunk/build/kits/jboss-as7/docs/teiid/datasources/ingres/modules/ trunk/build/kits/jboss-as7/docs/teiid/datasources/ingres/modules/com/ trunk/build/kits/jboss-as7/docs/teiid/datasources/ingres/modules/com/ingres/ trunk/build/kits/jboss-as7/docs/teiid/datasources/ingres/modules/com/ingres/main/ trunk/build/kits/jboss-as7/docs/teiid/datasources/ingres/modules/com/ingres/main/module.xml trunk/build/kits/jboss-as7/docs/teiid/datasources/ingres/readme.txt trunk/build/kits/jboss-as7/docs/teiid/datasources/intersystems-cache/ trunk/build/kits/jboss-as7/docs/teiid/datasources/intersystems-cache/intersystems-cache.xml trunk/build/kits/jboss-as7/docs/teiid/datasources/intersystems-cache/modules/ trunk/build/kits/jboss-as7/docs/teiid/datasources/intersystems-cache/modules/com/ trunk/build/kits/jboss-as7/docs/teiid/datasources/intersystems-cache/modules/com/intersys/ trunk/build/kits/jboss-as7/docs/teiid/datasources/intersystems-cache/modules/com/intersys/main/ trunk/build/kits/jboss-as7/docs/teiid/datasources/intersystems-cache/modules/com/intersys/main/module.xml trunk/build/kits/jboss-as7/docs/teiid/datasources/intersystems-cache/readme.txt trunk/build/kits/jboss-as7/docs/teiid/datasources/ldap/ trunk/build/kits/jboss-as7/docs/teiid/datasources/ldap/ldap.xml trunk/build/kits/jboss-as7/docs/teiid/datasources/ldap/readme.txt trunk/build/kits/jboss-as7/docs/teiid/datasources/mysql/ trunk/build/kits/jboss-as7/docs/teiid/datasources/mysql/modules/ trunk/build/kits/jboss-as7/docs/teiid/datasources/mysql/modules/com/ trunk/build/kits/jboss-as7/docs/teiid/datasources/mysql/modules/com/mysql/ trunk/build/kits/jboss-as7/docs/teiid/datasources/mysql/modules/com/mysql/main/ trunk/build/kits/jboss-as7/docs/teiid/datasources/mysql/modules/com/mysql/main/module.xml trunk/build/kits/jboss-as7/docs/teiid/datasources/mysql/mysql-xa.xml trunk/build/kits/jboss-as7/docs/teiid/datasources/mysql/mysql.xml trunk/build/kits/jboss-as7/docs/teiid/datasources/mysql/readme.txt trunk/build/kits/jboss-as7/docs/teiid/datasources/odbc/ trunk/build/kits/jboss-as7/docs/teiid/datasources/odbc/odbc.xml trunk/build/kits/jboss-as7/docs/teiid/datasources/odbc/readme.txt trunk/build/kits/jboss-as7/docs/teiid/datasources/olap/ trunk/build/kits/jboss-as7/docs/teiid/datasources/olap/modules/ trunk/build/kits/jboss-as7/docs/teiid/datasources/olap/modules/org/ trunk/build/kits/jboss-as7/docs/teiid/datasources/olap/modules/org/olap4j/ trunk/build/kits/jboss-as7/docs/teiid/datasources/olap/modules/org/olap4j/main/ trunk/build/kits/jboss-as7/docs/teiid/datasources/olap/modules/org/olap4j/main/module.xml trunk/build/kits/jboss-as7/docs/teiid/datasources/olap/mondrian.xml trunk/build/kits/jboss-as7/docs/teiid/datasources/olap/olap-xmla.xml trunk/build/kits/jboss-as7/docs/teiid/datasources/olap/readme.txt trunk/build/kits/jboss-as7/docs/teiid/datasources/oracle/ trunk/build/kits/jboss-as7/docs/teiid/datasources/oracle/modules/ trunk/build/kits/jboss-as7/docs/teiid/datasources/oracle/modules/com/ trunk/build/kits/jboss-as7/docs/teiid/datasources/oracle/modules/com/oracle/ trunk/build/kits/jboss-as7/docs/teiid/datasources/oracle/modules/com/oracle/main/ trunk/build/kits/jboss-as7/docs/teiid/datasources/oracle/modules/com/oracle/main/module.xml trunk/build/kits/jboss-as7/docs/teiid/datasources/oracle/oracle-xa.xml trunk/build/kits/jboss-as7/docs/teiid/datasources/oracle/oracle.xml trunk/build/kits/jboss-as7/docs/teiid/datasources/oracle/readme.txt trunk/build/kits/jboss-as7/docs/teiid/datasources/postgresql/ trunk/build/kits/jboss-as7/docs/teiid/datasources/postgresql/modules/ trunk/build/kits/jboss-as7/docs/teiid/datasources/postgresql/modules/org/ trunk/build/kits/jboss-as7/docs/teiid/datasources/postgresql/modules/org/postgresql/ trunk/build/kits/jboss-as7/docs/teiid/datasources/postgresql/modules/org/postgresql/main/ trunk/build/kits/jboss-as7/docs/teiid/datasources/postgresql/modules/org/postgresql/main/module.xml trunk/build/kits/jboss-as7/docs/teiid/datasources/postgresql/postgresql-xa.xml trunk/build/kits/jboss-as7/docs/teiid/datasources/postgresql/postgresql.xml trunk/build/kits/jboss-as7/docs/teiid/datasources/postgresql/readme.txt trunk/build/kits/jboss-as7/docs/teiid/datasources/salesforce/ trunk/build/kits/jboss-as7/docs/teiid/datasources/salesforce/readme.txt trunk/build/kits/jboss-as7/docs/teiid/datasources/salesforce/salesforce.xml trunk/build/kits/jboss-as7/docs/teiid/datasources/sqlserver/ trunk/build/kits/jboss-as7/docs/teiid/datasources/sqlserver/jtds/ trunk/build/kits/jboss-as7/docs/teiid/datasources/sqlserver/jtds/modules/ trunk/build/kits/jboss-as7/docs/teiid/datasources/sqlserver/jtds/modules/net/ trunk/build/kits/jboss-as7/docs/teiid/datasources/sqlserver/jtds/modules/net/sourceforge/ trunk/build/kits/jboss-as7/docs/teiid/datasources/sqlserver/jtds/modules/net/sourceforge/jtds/ trunk/build/kits/jboss-as7/docs/teiid/datasources/sqlserver/jtds/modules/net/sourceforge/jtds/main/ trunk/build/kits/jboss-as7/docs/teiid/datasources/sqlserver/jtds/modules/net/sourceforge/jtds/main/module.xml trunk/build/kits/jboss-as7/docs/teiid/datasources/sqlserver/jtds/readme.txt trunk/build/kits/jboss-as7/docs/teiid/datasources/sqlserver/jtds/sqlserver-xa.xml trunk/build/kits/jboss-as7/docs/teiid/datasources/sqlserver/jtds/sqlserver.xml trunk/build/kits/jboss-as7/docs/teiid/datasources/sqlserver/native/ trunk/build/kits/jboss-as7/docs/teiid/datasources/sqlserver/native/modules/ trunk/build/kits/jboss-as7/docs/teiid/datasources/sqlserver/native/modules/com/ trunk/build/kits/jboss-as7/docs/teiid/datasources/sqlserver/native/modules/com/microsoft/ trunk/build/kits/jboss-as7/docs/teiid/datasources/sqlserver/native/modules/com/microsoft/sqlserver/ trunk/build/kits/jboss-as7/docs/teiid/datasources/sqlserver/native/modules/com/microsoft/sqlserver/main/ trunk/build/kits/jboss-as7/docs/teiid/datasources/sqlserver/native/modules/com/microsoft/sqlserver/main/module.xml trunk/build/kits/jboss-as7/docs/teiid/datasources/sqlserver/native/readme.txt trunk/build/kits/jboss-as7/docs/teiid/datasources/sqlserver/native/sqlserver-xa.xml trunk/build/kits/jboss-as7/docs/teiid/datasources/sqlserver/native/sqlserver.xml trunk/build/kits/jboss-as7/docs/teiid/datasources/teiid/ trunk/build/kits/jboss-as7/docs/teiid/datasources/teiid/readme.txt trunk/build/kits/jboss-as7/docs/teiid/datasources/teiid/teiid-local.xml trunk/build/kits/jboss-as7/docs/teiid/datasources/teiid/teiid-xa.xml trunk/build/kits/jboss-as7/docs/teiid/datasources/teiid/teiid.xml trunk/build/kits/jboss-as7/docs/teiid/datasources/web-service/ trunk/build/kits/jboss-as7/docs/teiid/datasources/web-service/readme.txt trunk/build/kits/jboss-as7/docs/teiid/datasources/web-service/ws.xml Removed: trunk/build/assembly/jboss-container/ trunk/build/kits/jboss-as7/docs/teiid/datasources/file.xml trunk/build/kits/jboss-as7/docs/teiid/datasources/h2.xml trunk/build/kits/jboss-as7/docs/teiid/datasources/mysql.xml trunk/build/kits/jboss-as7/docs/teiid/datasources/oracle.xml trunk/build/kits/jboss-as7/docs/teiid/datasources/postgresql.xml trunk/build/kits/jboss-as7/docs/teiid/datasources/salesforce.xml trunk/build/kits/jboss-as7/docs/teiid/datasources/ws.xml trunk/build/kits/jboss-container/ Log: TEIID-1720: Adding the examples document section on how to create data sources under AS7 for Teiid 8. Added: trunk/build/kits/jboss-as7/docs/teiid/datasources/db2/db2-xa.xml =================================================================== --- trunk/build/kits/jboss-as7/docs/teiid/datasources/db2/db2-xa.xml (rev 0) +++ trunk/build/kits/jboss-as7/docs/teiid/datasources/db2/db2-xa.xml 2011-12-08 17:13:56 UTC (rev 3726) @@ -0,0 +1,48 @@ +<!-- If susbsytem is already defined, only copy the contents under it and edit to suit your needs --> +<subsystem xmlns="urn:jboss:domain:datasources:1.0"> + <datasources> + <xa-datasource jndi-name="java:/db2DS" pool-name="db2DS" enabled="true" use-java-context="true" use-ccm="true"> + + <xa-datasource-property name="PortNumber">3306</xa-datasource-property> + <xa-datasource-property name="DatabaseName">{db-name}</xa-datasource-property> + <xa-datasource-property name="ServerName">{host}</xa-datasource-property> + + <driver>db2</driver> + + <!-- + <new-connection-sql>select 1/new-connection-sql> + <transaction-isolation>TRANSACTION_READ_COMMITTED</transaction-isolation> + --> + + <xa-pool> + <min-pool-size>10</min-pool-size> + <max-pool-size>20</max-pool-size> + <is-same-rm-override>true</is-same-rm-override> + <prefill>false</prefill> + <use-strict-min>false</use-strict-min> + <flush-strategy>FailingConnectionOnly</flush-strategy> + <no-tx-separate-pools/> + </xa-pool> + + <security> + <user-name>{user}</user-name> + <password>{password}</password> + <!-- + <security-domain>mysecurity-realm</security-domain> + --> + </security> + + <!-- + <validation> + <check-valid-connection-sql>select 1</check-valid-connection-sql> + </validation> + --> + </xa-datasource> + <drivers> + <driver name="db2" module="com.ibm.db2"> + <driver-class>com.ibm.db2.jcc.DB2Driver</driver-class> + <xa-datasource-class>com.ibm.db2.jcc.DB2XADataSource</xa-datasource-class> + </driver> + </drivers> + </datasources> +</subsystem> \ No newline at end of file Property changes on: trunk/build/kits/jboss-as7/docs/teiid/datasources/db2/db2-xa.xml ___________________________________________________________________ Added: svn:mime-type + text/plain Added: trunk/build/kits/jboss-as7/docs/teiid/datasources/db2/db2.xml =================================================================== --- trunk/build/kits/jboss-as7/docs/teiid/datasources/db2/db2.xml (rev 0) +++ trunk/build/kits/jboss-as7/docs/teiid/datasources/db2/db2.xml 2011-12-08 17:13:56 UTC (rev 3726) @@ -0,0 +1,24 @@ +<!-- If susbsytem is already defined, only copy the contents under it and edit to suit your needs --> +<subsystem xmlns="urn:jboss:domain:datasources:1.0"> + <datasources> + <datasource jndi-name="java:/db2DS" pool-name="db2DS"> + <connection-url>jdbc:db2://{host}:{port}/{database_name}</connection-url> + <driver>db2</driver> + <pool> + <prefill>false</prefill> + <use-strict-min>false</use-strict-min> + <flush-strategy>FailingConnectionOnly</flush-strategy> + </pool> + <security> + <user-name>{user}</user-name> + <password>{password}</password> + </security> + </datasource> + <drivers> + <driver name="db2" module="com.ibm.db2"> + <driver-class>com.ibm.db2.jcc.DB2Driver</driver-class> + <xa-datasource-class>com.ibm.db2.jcc.DB2XADataSource</xa-datasource-class> + </driver> + </drivers> + </datasources> +</subsystem> \ No newline at end of file Property changes on: trunk/build/kits/jboss-as7/docs/teiid/datasources/db2/db2.xml ___________________________________________________________________ Added: svn:mime-type + text/plain Added: trunk/build/kits/jboss-as7/docs/teiid/datasources/db2/modules/com/ibm/db2/main/module.xml =================================================================== --- trunk/build/kits/jboss-as7/docs/teiid/datasources/db2/modules/com/ibm/db2/main/module.xml (rev 0) +++ trunk/build/kits/jboss-as7/docs/teiid/datasources/db2/modules/com/ibm/db2/main/module.xml 2011-12-08 17:13:56 UTC (rev 3726) @@ -0,0 +1,9 @@ +<?xml version="1.0" encoding="UTF-8"?> +<module xmlns="urn:jboss:module:1.0" name="com.ibm.db2"> + <resources> + <resource-root path="db2jcc4.jar"/> + </resources> + <dependencies> + <module name="javax.api"/> + </dependencies> +</module> Property changes on: trunk/build/kits/jboss-as7/docs/teiid/datasources/db2/modules/com/ibm/db2/main/module.xml ___________________________________________________________________ Added: svn:mime-type + text/plain Added: trunk/build/kits/jboss-as7/docs/teiid/datasources/db2/readme.txt =================================================================== --- trunk/build/kits/jboss-as7/docs/teiid/datasources/db2/readme.txt (rev 0) +++ trunk/build/kits/jboss-as7/docs/teiid/datasources/db2/readme.txt 2011-12-08 17:13:56 UTC (rev 3726) @@ -0,0 +1,31 @@ +There are two parts to creating a datasource, depending upon whether this is the first time you are doing this, +you can skip the deploying JDBC driver for the database, if you have previously already done this. + +Step 1: Deploying the JDBC Driver + + Option 1: use the JBoss CLI tool, and deploy the "db2jcc4.jar" or later jar by issuing the command + deploy db2jcc4.jar + + Note: when you use CLI based deployment, the <driver> element in the <datasources> xml fragment, must + be the name of the jar file deployed, and no need for adding <drivers> element in standalone-teiid.xml + or domain-teiid.xml file + + Option 2: + 1) Stop the server if it is running. + + 2) Overlay the "modules" directory on the "<jboss-as>/modules" directory + + 3) Then copy the db2 database JDBC driver jar file "db2jcc4.jar" into + "<jboss-as>/modules/com/ibm/db2/main" directory. + 4) start server + +Step 2: Creating the datasource + + Option 1: Edit the standalone-teiid.xml or domain-teiid.xml file and add contents of the "db2.xml" + or "db2-xa.xml" file under the "datasources" subsystem. You may have to edit contents according + to where your db2 server is located and credentials you need to use to access it. + + Option 2: Take a look at create-ds.cli script, and modify and execute using JBoss CLI tool as below + + ./Jboss-admin.sh --file create-ds.cli + \ No newline at end of file Property changes on: trunk/build/kits/jboss-as7/docs/teiid/datasources/db2/readme.txt ___________________________________________________________________ Added: svn:mime-type + text/plain Added: trunk/build/kits/jboss-as7/docs/teiid/datasources/derby/derby-xa.xml =================================================================== --- trunk/build/kits/jboss-as7/docs/teiid/datasources/derby/derby-xa.xml (rev 0) +++ trunk/build/kits/jboss-as7/docs/teiid/datasources/derby/derby-xa.xml 2011-12-08 17:13:56 UTC (rev 3726) @@ -0,0 +1,48 @@ +<!-- If susbsytem is already defined, only copy the contents under it and edit to suit your needs --> +<subsystem xmlns="urn:jboss:domain:datasources:1.0"> + <datasources> + <xa-datasource jndi-name="java:/derbyDS" pool-name="derbyDS" enabled="true" use-java-context="true" use-ccm="true"> + + <xa-datasource-property name="PortNumber">1527</xa-datasource-property> + <xa-datasource-property name="DatabaseName">{db-name}</xa-datasource-property> + <xa-datasource-property name="ServerName">{host}</xa-datasource-property> + + <driver>derby</driver> + + <!-- + <new-connection-sql>select 1/new-connection-sql> + <transaction-isolation>TRANSACTION_READ_COMMITTED</transaction-isolation> + --> + + <xa-pool> + <min-pool-size>10</min-pool-size> + <max-pool-size>20</max-pool-size> + <is-same-rm-override>true</is-same-rm-override> + <prefill>false</prefill> + <use-strict-min>false</use-strict-min> + <flush-strategy>FailingConnectionOnly</flush-strategy> + <no-tx-separate-pools/> + </xa-pool> + + <security> + <user-name>{user}</user-name> + <password>{password}</password> + <!-- + <security-domain>mysecurity-realm</security-domain> + --> + </security> + + <!-- + <validation> + <check-valid-connection-sql>select 1</check-valid-connection-sql> + </validation> + --> + </xa-datasource> + <drivers> + <driver name="derby" module="org.apache.derby"> + <driver-class>org.apache.derby.jdbc.ClientDriver</driver-class> + <xa-datasource-class>org.apache.derby.jdbc.ClientXADataSource</xa-datasource-class> + </driver> + </drivers> + </datasources> +</subsystem> \ No newline at end of file Property changes on: trunk/build/kits/jboss-as7/docs/teiid/datasources/derby/derby-xa.xml ___________________________________________________________________ Added: svn:mime-type + text/plain Added: trunk/build/kits/jboss-as7/docs/teiid/datasources/derby/derby.xml =================================================================== --- trunk/build/kits/jboss-as7/docs/teiid/datasources/derby/derby.xml (rev 0) +++ trunk/build/kits/jboss-as7/docs/teiid/datasources/derby/derby.xml 2011-12-08 17:13:56 UTC (rev 3726) @@ -0,0 +1,24 @@ +<!-- If susbsytem is already defined, only copy the contents under it and edit to suit your needs --> +<subsystem xmlns="urn:jboss:domain:datasources:1.0"> + <datasources> + <datasource jndi-name="java:/derbyDS" pool-name="derbyDS"> + <connection-url>jdbc:derby://{host}:1527/{db-name}</connection-url> + <driver>derby</driver> + <pool> + <prefill>false</prefill> + <use-strict-min>false</use-strict-min> + <flush-strategy>FailingConnectionOnly</flush-strategy> + </pool> + <security> + <user-name>{user}</user-name> + <password>{password}</password> + </security> + </datasource> + <drivers> + <driver name="derby" module="org.apache.derby"> + <driver-class>org.apache.derby.jdbc.ClientDriver</driver-class> + <xa-datasource-class>org.apache.derby.jdbc.ClientXADataSource</xa-datasource-class> + </driver> + </drivers> + </datasources> +</subsystem> \ No newline at end of file Property changes on: trunk/build/kits/jboss-as7/docs/teiid/datasources/derby/derby.xml ___________________________________________________________________ Added: svn:mime-type + text/plain Added: trunk/build/kits/jboss-as7/docs/teiid/datasources/derby/modules/org/apache/derby/main/module.xml =================================================================== --- trunk/build/kits/jboss-as7/docs/teiid/datasources/derby/modules/org/apache/derby/main/module.xml (rev 0) +++ trunk/build/kits/jboss-as7/docs/teiid/datasources/derby/modules/org/apache/derby/main/module.xml 2011-12-08 17:13:56 UTC (rev 3726) @@ -0,0 +1,9 @@ +<?xml version="1.0" encoding="UTF-8"?> +<module xmlns="urn:jboss:module:1.0" name="org.apache.derby"> + <resources> + <resource-root path="derbyclient.jar"/> + </resources> + <dependencies> + <module name="javax.api"/> + </dependencies> +</module> Property changes on: trunk/build/kits/jboss-as7/docs/teiid/datasources/derby/modules/org/apache/derby/main/module.xml ___________________________________________________________________ Added: svn:mime-type + text/plain Added: trunk/build/kits/jboss-as7/docs/teiid/datasources/derby/readme.txt =================================================================== --- trunk/build/kits/jboss-as7/docs/teiid/datasources/derby/readme.txt (rev 0) +++ trunk/build/kits/jboss-as7/docs/teiid/datasources/derby/readme.txt 2011-12-08 17:13:56 UTC (rev 3726) @@ -0,0 +1,31 @@ +There are two parts to creating a datasource, depending upon whether this is the first time you are doing this, +you can skip the deploying JDBC driver for the database, if you have previously already done this. + +Step 1: Deploying the JDBC Driver + + Option 1: use the JBoss CLI tool, and deploy the "derbyclient.jar" or later jar by issuing the command + deploy derbyclient.jar + + Note: when you use CLI based deployment, the <driver> element in the <datasources> xml fragment, must + be the name of the jar file deployed, and no need for adding <drivers> element in standalone-teiid.xml + or domain-teiid.xml file + + Option 2: + 1) Stop the server if it is running. + + 2) Overlay the "modules" directory on the "<jboss-as>/modules" directory + + 3) Then copy the derby database JDBC driver jar file "derbyclient.jar" into + "<jboss-as>/modules/com/apache/derby/main" directory. + 4) start server + +Step 2: Creating the datasource + + Option 1: Edit the standalone-teiid.xml or domain-teiid.xml file and add contents of the "derby.xml" + or "derby-xa.xml" file under the "datasources" subsystem. You may have to edit contents according + to where your derby server is located and credentials you need to use to access it. + + Option 2: Take a look at create-ds.cli script, and modify and execute using JBoss CLI tool as below + + ./Jboss-admin.sh --file create-ds.cli + \ No newline at end of file Property changes on: trunk/build/kits/jboss-as7/docs/teiid/datasources/derby/readme.txt ___________________________________________________________________ Added: svn:mime-type + text/plain Copied: trunk/build/kits/jboss-as7/docs/teiid/datasources/file/file.xml (from rev 3720, trunk/build/kits/jboss-as7/docs/teiid/datasources/file.xml) =================================================================== --- trunk/build/kits/jboss-as7/docs/teiid/datasources/file/file.xml (rev 0) +++ trunk/build/kits/jboss-as7/docs/teiid/datasources/file/file.xml 2011-12-08 17:13:56 UTC (rev 3726) @@ -0,0 +1,31 @@ +<!-- 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:/fileDS" + enabled="true" + use-java-context="true" + pool-name="teiid-file-ds"> + + <!-- Directory where the data files are stored --> + <config-property name="ParentDirectory">/home/rareddy/testing/</config-property> + + <!-- Optional properties --> + + <!-- Set FileMapping to redirect specific relative paths (case sensitive) to alternative locations. + The string value specifies a map in the format key=value(,key=value)* + --> + <!-- <config-property name="FileMapping">file1.txt=fileX.txt,file2.txt=fileY.txt</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> Property changes on: trunk/build/kits/jboss-as7/docs/teiid/datasources/file/file.xml ___________________________________________________________________ Added: svn:mime-type + text/plain Added: trunk/build/kits/jboss-as7/docs/teiid/datasources/file/readme.txt =================================================================== --- trunk/build/kits/jboss-as7/docs/teiid/datasources/file/readme.txt (rev 0) +++ trunk/build/kits/jboss-as7/docs/teiid/datasources/file/readme.txt 2011-12-08 17:13:56 UTC (rev 3726) @@ -0,0 +1,3 @@ +In Teiid, for File datasource a JCA connector is provided and deployed at the install time. To create +file datasource connection edit the "standalone-teiid.xml" file or "doamin-teiid.xml" file and add +the contents of the file.xml under "resource-adapters" subsystem section. \ No newline at end of file Property changes on: trunk/build/kits/jboss-as7/docs/teiid/datasources/file/readme.txt ___________________________________________________________________ Added: svn:mime-type + text/plain Deleted: trunk/build/kits/jboss-as7/docs/teiid/datasources/file.xml =================================================================== --- trunk/build/kits/jboss-as7/docs/teiid/datasources/file.xml 2011-12-08 16:14:29 UTC (rev 3725) +++ trunk/build/kits/jboss-as7/docs/teiid/datasources/file.xml 2011-12-08 17:13:56 UTC (rev 3726) @@ -1,31 +0,0 @@ -<!-- 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:/fileDS" - enabled="true" - use-java-context="true" - pool-name="teiid-file-ds"> - - <!-- Directory where the data files are stored --> - <config-property name="ParentDirectory">/home/rareddy/testing/</config-property> - - <!-- Optional properties --> - - <!-- Set FileMapping to redirect specific relative paths (case sensitive) to alternative locations. - The string value specifies a map in the format key=value(,key=value)* - --> - <!-- <config-property name="FileMapping">file1.txt=fileX.txt,file2.txt=fileY.txt</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> Copied: trunk/build/kits/jboss-as7/docs/teiid/datasources/h2/h2.xml (from rev 3720, trunk/build/kits/jboss-as7/docs/teiid/datasources/h2.xml) =================================================================== --- trunk/build/kits/jboss-as7/docs/teiid/datasources/h2/h2.xml (rev 0) +++ trunk/build/kits/jboss-as7/docs/teiid/datasources/h2/h2.xml 2011-12-08 17:13:56 UTC (rev 3726) @@ -0,0 +1,21 @@ +<!-- If susbsytem is already defined, only copy the contents under it and edit to suit your needs --> +<subsystem xmlns="urn:jboss:domain:datasources:1.0"> + <datasources> + <datasource jndi-name="java:jboss/datasources/ExampleDS" enabled="true" use-java-context="true" pool-name="H2DS"> + <connection-url>jdbc:h2:mem:test;DB_CLOSE_DELAY=-1</connection-url> + <driver>h2</driver> + <pool></pool> + <security> + <user-name>sa</user-name> + <password>sa</password> + </security> + </datasource> + <drivers> + <driver name="h2" module="com.h2database.h2"> + <xa-datasource-class>org.h2.jdbcx.JdbcDataSource</xa-datasource-class> + </driver> + </drivers> + </datasources> +</subsystem> + + Property changes on: trunk/build/kits/jboss-as7/docs/teiid/datasources/h2/h2.xml ___________________________________________________________________ Added: svn:mime-type + text/plain Added: trunk/build/kits/jboss-as7/docs/teiid/datasources/h2/readme.txt =================================================================== --- trunk/build/kits/jboss-as7/docs/teiid/datasources/h2/readme.txt (rev 0) +++ trunk/build/kits/jboss-as7/docs/teiid/datasources/h2/readme.txt 2011-12-08 17:13:56 UTC (rev 3726) @@ -0,0 +1,4 @@ +H2 driver is already pre-intalled in the JBoss AS, so deploy a data soruce + +1) edit standalone-teiid.xml or domain-teiid.xml file, under "datasources" subsystem copy the contents of h2.xml file +and modify it according to your h2 server details. \ No newline at end of file Property changes on: trunk/build/kits/jboss-as7/docs/teiid/datasources/h2/readme.txt ___________________________________________________________________ Added: svn:mime-type + text/plain Deleted: trunk/build/kits/jboss-as7/docs/teiid/datasources/h2.xml =================================================================== --- trunk/build/kits/jboss-as7/docs/teiid/datasources/h2.xml 2011-12-08 16:14:29 UTC (rev 3725) +++ trunk/build/kits/jboss-as7/docs/teiid/datasources/h2.xml 2011-12-08 17:13:56 UTC (rev 3726) @@ -1,21 +0,0 @@ -<!-- If susbsytem is already defined, only copy the contents under it and edit to suit your needs --> -<subsystem xmlns="urn:jboss:domain:datasources:1.0"> - <datasources> - <datasource jndi-name="java:jboss/datasources/ExampleDS" enabled="true" use-java-context="true" pool-name="H2DS"> - <connection-url>jdbc:h2:mem:test;DB_CLOSE_DELAY=-1</connection-url> - <driver>h2</driver> - <pool></pool> - <security> - <user-name>sa</user-name> - <password>sa</password> - </security> - </datasource> - <drivers> - <driver name="h2" module="com.h2database.h2"> - <xa-datasource-class>org.h2.jdbcx.JdbcDataSource</xa-datasource-class> - </driver> - </drivers> - </datasources> -</subsystem> - - Added: trunk/build/kits/jboss-as7/docs/teiid/datasources/hive/hive.xml =================================================================== --- trunk/build/kits/jboss-as7/docs/teiid/datasources/hive/hive.xml (rev 0) +++ trunk/build/kits/jboss-as7/docs/teiid/datasources/hive/hive.xml 2011-12-08 17:13:56 UTC (rev 3726) @@ -0,0 +1,19 @@ +<!-- If susbsytem "datasources" is already defined, only copy the contents under it and edit to suit your needs --> +<subsystem xmlns="urn:jboss:domain:datasources:1.0"> + <datasources> + <datasource jndi-name="java:/hive" pool-name="hive-ds"> + <connection-url>jdbc:hive://localhost:10000/default</connection-url> + <driver>hive</driver> + <pool> + <prefill>false</prefill> + <use-strict-min>false</use-strict-min> + <flush-strategy>FailingConnectionOnly</flush-strategy> + </pool> + </datasource> + <drivers> + <driver name="hive" module="org.apache.hadoop.hive"> + <driver-class>org.apache.hadoop.hive.jdbc.HiveDriver</driver-class> + </driver> + </drivers> + </datasources> +</subsystem> \ No newline at end of file Property changes on: trunk/build/kits/jboss-as7/docs/teiid/datasources/hive/hive.xml ___________________________________________________________________ Added: svn:mime-type + text/plain Added: trunk/build/kits/jboss-as7/docs/teiid/datasources/hive/modules/org/apache/hadoop/hive/main/module.xml =================================================================== --- trunk/build/kits/jboss-as7/docs/teiid/datasources/hive/modules/org/apache/hadoop/hive/main/module.xml (rev 0) +++ trunk/build/kits/jboss-as7/docs/teiid/datasources/hive/modules/org/apache/hadoop/hive/main/module.xml 2011-12-08 17:13:56 UTC (rev 3726) @@ -0,0 +1,16 @@ +<?xml version="1.0" encoding="UTF-8"?> +<module xmlns="urn:jboss:module:1.0" name="org.apache.hadoop.hive"> + <resources> + <resource-root path="hadoop-core-0.20.203.0.jar"/> + <resource-root path="hive-exec-0.7.1.jar"/> + <resource-root path="hive-jdbc-0.7.1.jar"/> + <resource-root path="hive-metastore-0.7.1.jar"/> + <resource-root path="hive-service-0.7.1.jar"/> + <resource-root path="libfb303.jar"/> + </resources> + + <dependencies> + <module name="javax.api"/> + <module name="javax.resource.api"/> + </dependencies> +</ \ No newline at end of file Property changes on: trunk/build/kits/jboss-as7/docs/teiid/datasources/hive/modules/org/apache/hadoop/hive/main/module.xml ___________________________________________________________________ Added: svn:mime-type + text/plain Added: trunk/build/kits/jboss-as7/docs/teiid/datasources/hive/readme.txt =================================================================== --- trunk/build/kits/jboss-as7/docs/teiid/datasources/hive/readme.txt (rev 0) +++ trunk/build/kits/jboss-as7/docs/teiid/datasources/hive/readme.txt 2011-12-08 17:13:56 UTC (rev 3726) @@ -0,0 +1,13 @@ +To configure the hive as datasource, + +1) Stop the server if it is running. + +2) Overlay the "modules" directory on the "<jboss-as>/modules" directory + +3) Then copy need hive jar files defined in the "<jboss-as>/modules/org/apache/hadoop/hive/main/modules.xml" file into +"<jboss-as>/modules/org/apache/hadoop/hive/main" directory. + +4) Edit the standalone-teiid.xml or domain-teiid.xml file and add contents of the "hive.xml" file under the "datasources" subsystem. +you may have edit these contents according to where your hadoop/hive server is located. + +5) restart \ No newline at end of file Property changes on: trunk/build/kits/jboss-as7/docs/teiid/datasources/hive/readme.txt ___________________________________________________________________ Added: svn:mime-type + text/plain Added: trunk/build/kits/jboss-as7/docs/teiid/datasources/ingres/ingres-xa.xml =================================================================== --- trunk/build/kits/jboss-as7/docs/teiid/datasources/ingres/ingres-xa.xml (rev 0) +++ trunk/build/kits/jboss-as7/docs/teiid/datasources/ingres/ingres-xa.xml 2011-12-08 17:13:56 UTC (rev 3726) @@ -0,0 +1,50 @@ +<!-- If susbsytem is already defined, only copy the contents under it and edit to suit your needs --> +<subsystem xmlns="urn:jboss:domain:datasources:1.0"> + <datasources> + <xa-datasource jndi-name="java:/ingresDS" pool-name="ingresDS" enabled="true" use-java-context="true" use-ccm="true"> + + <xa-datasource-property name="DatabaseName">{database}</xa-datasource-property> + <xa-datasource-property name="PortNumber">21071</xa-datasource-property> + <xa-datasource-property name="ServerName">{host}</xa-datasource-property> + <xa-datasource-property name="timeZone">GMT</xa-datasource-property> + + + <driver>ingres</driver> + + <!-- + <new-connection-sql>select 1/new-connection-sql> + <transaction-isolation>TRANSACTION_READ_COMMITTED</transaction-isolation> + --> + + <xa-pool> + <min-pool-size>10</min-pool-size> + <max-pool-size>20</max-pool-size> + <is-same-rm-override>true</is-same-rm-override> + <prefill>false</prefill> + <use-strict-min>false</use-strict-min> + <flush-strategy>FailingConnectionOnly</flush-strategy> + <no-tx-separate-pools/> + </xa-pool> + + <security> + <user-name>{user}</user-name> + <password>{password}</password> + <!-- + <security-domain>mysecurity-realm</security-domain> + --> + </security> + + <!-- + <validation> + <check-valid-connection-sql>select 1</check-valid-connection-sql> + </validation> + --> + </xa-datasource> + <drivers> + <driver name="ingres" module="com.ingres"> + <driver-class>com.ingres.jdbc.IngresDriver</driver-class> + <xa-datasource-class>com.ingres.jdbc.IngresXADataSource</xa-datasource-class> + </driver> + </drivers> + </datasources> +</subsystem> \ No newline at end of file Property changes on: trunk/build/kits/jboss-as7/docs/teiid/datasources/ingres/ingres-xa.xml ___________________________________________________________________ Added: svn:mime-type + text/plain Added: trunk/build/kits/jboss-as7/docs/teiid/datasources/ingres/ingres.xml =================================================================== --- trunk/build/kits/jboss-as7/docs/teiid/datasources/ingres/ingres.xml (rev 0) +++ trunk/build/kits/jboss-as7/docs/teiid/datasources/ingres/ingres.xml 2011-12-08 17:13:56 UTC (rev 3726) @@ -0,0 +1,24 @@ +<!-- If susbsytem is already defined, only copy the contents under it and edit to suit your needs --> +<subsystem xmlns="urn:jboss:domain:datasources:1.0"> + <datasources> + <datasource jndi-name="java:/ingresDS" pool-name="ingresDS"> + <connection-url>jdbc:ingres://{host}:{port:21071}/{database_name}</connection-url> + <driver>ingres</driver> + <pool> + <prefill>false</prefill> + <use-strict-min>false</use-strict-min> + <flush-strategy>FailingConnectionOnly</flush-strategy> + </pool> + <security> + <user-name>{user}</user-name> + <password>{password}</password> + </security> + </datasource> + <drivers> + <driver name="ingres" module="com.ingres"> + <driver-class>com.ingres.jdbc.IngresDriver</driver-class> + <xa-datasource-class>com.ingres.jdbc.IngresXADataSource</xa-datasource-class> + </driver> + </drivers> + </datasources> +</subsystem> \ No newline at end of file Property changes on: trunk/build/kits/jboss-as7/docs/teiid/datasources/ingres/ingres.xml ___________________________________________________________________ Added: svn:mime-type + text/plain Added: trunk/build/kits/jboss-as7/docs/teiid/datasources/ingres/modules/com/ingres/main/module.xml =================================================================== --- trunk/build/kits/jboss-as7/docs/teiid/datasources/ingres/modules/com/ingres/main/module.xml (rev 0) +++ trunk/build/kits/jboss-as7/docs/teiid/datasources/ingres/modules/com/ingres/main/module.xml 2011-12-08 17:13:56 UTC (rev 3726) @@ -0,0 +1,9 @@ +<?xml version="1.0" encoding="UTF-8"?> +<module xmlns="urn:jboss:module:1.0" name="com.ingres"> + <resources> + <resource-root path="iijdbc.jar"/> + </resources> + <dependencies> + <module name="javax.api"/> + </dependencies> +</module> Property changes on: trunk/build/kits/jboss-as7/docs/teiid/datasources/ingres/modules/com/ingres/main/module.xml ___________________________________________________________________ Added: svn:mime-type + text/plain Added: trunk/build/kits/jboss-as7/docs/teiid/datasources/ingres/readme.txt =================================================================== --- trunk/build/kits/jboss-as7/docs/teiid/datasources/ingres/readme.txt (rev 0) +++ trunk/build/kits/jboss-as7/docs/teiid/datasources/ingres/readme.txt 2011-12-08 17:13:56 UTC (rev 3726) @@ -0,0 +1,31 @@ +There are two parts to creating a datasource, depending upon whether this is the first time you are doing this, +you can skip the deploying JDBC driver for the database, if you have previously already done this. + +Step 1: Deploying the JDBC Driver + + Option 1: use the JBoss CLI tool, and deploy the "iijdbc.jar " or later jar by issuing the command + deploy iijdbc.jar + + Note: when you use CLI based deployment, the <driver> element in the <datasources> xml fragment, must + be the name of the jar file deployed, and no need for adding <drivers> element in standalone-teiid.xml + or domain-teiid.xml file + + Option 2: + 1) Stop the server if it is running. + + 2) Overlay the "modules" directory on the "<jboss-as>/modules" directory + + 3) Then copy the ingres database JDBC driver jar file "iijdbc.jar " into + "<jboss-as>/modules/com/ingres/main" directory. + 4) start server + +Step 2: Creating the datasource + + Option 1: Edit the standalone-teiid.xml or domain-teiid.xml file and add contents of the "ingres.xml" + or "ingres-xa.xml" file under the "datasources" subsystem. You may have to edit contents according + to where your ingres server is located and credentials you need to use to access it. + + Option 2: Take a look at create-ds.cli script, and modify and execute using JBoss CLI tool as below + + ./Jboss-admin.sh --file create-ds.cli + \ No newline at end of file Property changes on: trunk/build/kits/jboss-as7/docs/teiid/datasources/ingres/readme.txt ___________________________________________________________________ Added: svn:mime-type + text/plain Copied: trunk/build/kits/jboss-as7/docs/teiid/datasources/intersystems-cache/intersystems-cache.xml (from rev 3720, trunk/build/kits/jboss-container/teiid-examples/jca/intersystems-cache-ds.xml) =================================================================== --- trunk/build/kits/jboss-as7/docs/teiid/datasources/intersystems-cache/intersystems-cache.xml (rev 0) +++ trunk/build/kits/jboss-as7/docs/teiid/datasources/intersystems-cache/intersystems-cache.xml 2011-12-08 17:13:56 UTC (rev 3726) @@ -0,0 +1,23 @@ +<!-- If susbsytem is already defined, only copy the contents under it and edit to suit your needs --> +<subsystem xmlns="urn:jboss:domain:datasources:1.0"> + <datasources> + <datasource jndi-name="java:/cacheDS" pool-name="cacheDS"> + <connection-url>jdbc:Cache://{host}:1972/{database}</connection-url> + <driver>mysql</driver> + <pool> + <prefill>false</prefill> + <use-strict-min>false</use-strict-min> + <flush-strategy>FailingConnectionOnly</flush-strategy> + </pool> + <security> + <user-name>{user}</user-name> + <password>{password}</password> + </security> + </datasource> + <drivers> + <driver name="intersys" module="com.intersys"> + <driver-class>com.intersys.jdbc.CacheDriver</driver-class> + </driver> + </drivers> + </datasources> +</subsystem> \ No newline at end of file Property changes on: trunk/build/kits/jboss-as7/docs/teiid/datasources/intersystems-cache/intersystems-cache.xml ___________________________________________________________________ Added: svn:mime-type + text/plain Added: trunk/build/kits/jboss-as7/docs/teiid/datasources/intersystems-cache/modules/com/intersys/main/module.xml =================================================================== --- trunk/build/kits/jboss-as7/docs/teiid/datasources/intersystems-cache/modules/com/intersys/main/module.xml (rev 0) +++ trunk/build/kits/jboss-as7/docs/teiid/datasources/intersystems-cache/modules/com/intersys/main/module.xml 2011-12-08 17:13:56 UTC (rev 3726) @@ -0,0 +1,9 @@ +<?xml version="1.0" encoding="UTF-8"?> +<module xmlns="urn:jboss:module:1.0" name="com.intersys"> + <resources> + <resource-root path="CacheDB.jar"/> + </resources> + <dependencies> + <module name="javax.api"/> + </dependencies> +</module> Property changes on: trunk/build/kits/jboss-as7/docs/teiid/datasources/intersystems-cache/modules/com/intersys/main/module.xml ___________________________________________________________________ Added: svn:mime-type + text/plain Added: trunk/build/kits/jboss-as7/docs/teiid/datasources/intersystems-cache/readme.txt =================================================================== --- trunk/build/kits/jboss-as7/docs/teiid/datasources/intersystems-cache/readme.txt (rev 0) +++ trunk/build/kits/jboss-as7/docs/teiid/datasources/intersystems-cache/readme.txt 2011-12-08 17:13:56 UTC (rev 3726) @@ -0,0 +1,30 @@ +There are two parts to creating a datasource, depending upon whether this is the first time you are doing this, +you can skip the deploying JDBC driver for the database, if you have previously already done this. + +Step 1: Deploying the JDBC Driver + + Option 1: use the JBoss CLI tool, and deploy the "CacheDB.jar" or later jar by issuing the command + deploy CacheDB.jar + + Note: when you use CLI based deployment, the <driver> element in the <datasources> xml fragment, must + be the name of the jar file deployed, and no need for adding <drivers> element in standalone-teiid.xml + or domain-teiid.xml file + + Option 2: + 1) Stop the server if it is running. + + 2) Overlay the "modules" directory on the "<jboss-as>/modules" directory + + 3) Then copy the mysql database JDBC driver jar file "CacheDB.jar" into + "<jboss-as>/modules/com/intersys/main" directory. + 4) start server + +Step 2: Creating the datasource + + Option 1: Edit the standalone-teiid.xml or domain-teiid.xml file and add contents of the "intersystems-cache.xml" + file under the "datasources" subsystem. You may have to edit contents according + to where your intersystems server is located and credentials you need to use to access it. + + Option 2: Take a look at create-ds.cli script, and modify and execute using JBoss CLI tool as below + + ./Jboss-admin.sh --file create-ds.cli Property changes on: trunk/build/kits/jboss-as7/docs/teiid/datasources/intersystems-cache/readme.txt ___________________________________________________________________ Added: svn:mime-type + text/plain Added: trunk/build/kits/jboss-as7/docs/teiid/datasources/ldap/ldap.xml =================================================================== --- trunk/build/kits/jboss-as7/docs/teiid/datasources/ldap/ldap.xml (rev 0) +++ trunk/build/kits/jboss-as7/docs/teiid/datasources/ldap/ldap.xml 2011-12-08 17:13:56 UTC (rev 3726) @@ -0,0 +1,30 @@ +<!-- 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-ldap.rar</archive> + <transaction-support>NoTransaction</transaction-support> + <connection-definitions> + <connection-definition class-name="org.teiid.resource.adapter.ldap.LDAPManagedConnectionFactory" + jndi-name="java:/ldapDS" + enabled="true" + use-java-context="true" + pool-name="ldap-ds"> + + <!-- LDAP Directroy URL (required)--> + <config-property name="LdapUrl">ldap://ldapServer:389</config-property> + + <!-- Ldap Admin User DN (required)--> + <config-property name="LdapAdminUserDN">cn=???,ou=???,dc=???</config-property> + + <!-- Ldap Admin Password (required)--> + <config-property name="LdapAdminUserPassword">pass</config-property> + + <!-- Ldap Transaction Timeout (ms) -1 = no time out (optional) --> + <config-property name="LdapTxnTimeoutInMillis">-1</config-property> + + </connection-definition> + </connection-definitions> + </resource-adapter> + </resource-adapters> +</subsystem> \ No newline at end of file Property changes on: trunk/build/kits/jboss-as7/docs/teiid/datasources/ldap/ldap.xml ___________________________________________________________________ Added: svn:mime-type + text/plain Added: trunk/build/kits/jboss-as7/docs/teiid/datasources/ldap/readme.txt =================================================================== --- trunk/build/kits/jboss-as7/docs/teiid/datasources/ldap/readme.txt (rev 0) +++ trunk/build/kits/jboss-as7/docs/teiid/datasources/ldap/readme.txt 2011-12-08 17:13:56 UTC (rev 3726) @@ -0,0 +1,3 @@ +In Teiid, for LDAP datasource a JCA connector is provided and deployed at the install time. To create +ldap datasource connection edit the "standalone-teiid.xml" file or "doamin-teiid.xml" file and add +the contents of the ldap.xml under "resource-adapters" subsystem section. \ No newline at end of file Property changes on: trunk/build/kits/jboss-as7/docs/teiid/datasources/ldap/readme.txt ___________________________________________________________________ Added: svn:mime-type + text/plain Added: trunk/build/kits/jboss-as7/docs/teiid/datasources/mysql/modules/com/mysql/main/module.xml =================================================================== --- trunk/build/kits/jboss-as7/docs/teiid/datasources/mysql/modules/com/mysql/main/module.xml (rev 0) +++ trunk/build/kits/jboss-as7/docs/teiid/datasources/mysql/modules/com/mysql/main/module.xml 2011-12-08 17:13:56 UTC (rev 3726) @@ -0,0 +1,9 @@ +<?xml version="1.0" encoding="UTF-8"?> +<module xmlns="urn:jboss:module:1.0" name="com.mysql"> + <resources> + <resource-root path="mysql-connector-java-5.1.5.jar"/> + </resources> + <dependencies> + <module name="javax.api"/> + </dependencies> +</module> Property changes on: trunk/build/kits/jboss-as7/docs/teiid/datasources/mysql/modules/com/mysql/main/module.xml ___________________________________________________________________ Added: svn:mime-type + text/plain Added: trunk/build/kits/jboss-as7/docs/teiid/datasources/mysql/mysql-xa.xml =================================================================== --- trunk/build/kits/jboss-as7/docs/teiid/datasources/mysql/mysql-xa.xml (rev 0) +++ trunk/build/kits/jboss-as7/docs/teiid/datasources/mysql/mysql-xa.xml 2011-12-08 17:13:56 UTC (rev 3726) @@ -0,0 +1,48 @@ +<!-- If susbsytem is already defined, only copy the contents under it and edit to suit your needs --> +<subsystem xmlns="urn:jboss:domain:datasources:1.0"> + <datasources> + <xa-datasource jndi-name="java:/mysqlDS" pool-name="mySQlDS" enabled="true" use-java-context="true" use-ccm="true"> + + <xa-datasource-property name="PortNumber">3306</xa-datasource-property> + <xa-datasource-property name="DatabaseName">{db-name}</xa-datasource-property> + <xa-datasource-property name="ServerName">{host}</xa-datasource-property> + + <driver>mysql</driver> + + <!-- + <new-connection-sql>select 1/new-connection-sql> + <transaction-isolation>TRANSACTION_READ_COMMITTED</transaction-isolation> + --> + + <xa-pool> + <min-pool-size>10</min-pool-size> + <max-pool-size>20</max-pool-size> + <is-same-rm-override>true</is-same-rm-override> + <prefill>false</prefill> + <use-strict-min>false</use-strict-min> + <flush-strategy>FailingConnectionOnly</flush-strategy> + <no-tx-separate-pools/> + </xa-pool> + + <security> + <user-name>{user}</user-name> + <password>{password}</password> + <!-- + <security-domain>mysecurity-realm</security-domain> + --> + </security> + + <!-- + <validation> + <check-valid-connection-sql>select 1</check-valid-connection-sql> + </validation> + --> + </xa-datasource> + <drivers> + <driver name="mysql" module="com.mysql"> + <driver-class>com.mysql.jdbc.Driver</driver-class> + <xa-datasource-class>com.mysql.jdbc.jdbc2.optional.MysqlXADataSource</xa-datasource-class> + </driver> + </drivers> + </datasources> +</subsystem> \ No newline at end of file Property changes on: trunk/build/kits/jboss-as7/docs/teiid/datasources/mysql/mysql-xa.xml ___________________________________________________________________ Added: svn:mime-type + text/plain Copied: trunk/build/kits/jboss-as7/docs/teiid/datasources/mysql/mysql.xml (from rev 3720, trunk/build/kits/jboss-as7/docs/teiid/datasources/mysql.xml) =================================================================== --- trunk/build/kits/jboss-as7/docs/teiid/datasources/mysql/mysql.xml (rev 0) +++ trunk/build/kits/jboss-as7/docs/teiid/datasources/mysql/mysql.xml 2011-12-08 17:13:56 UTC (rev 3726) @@ -0,0 +1,24 @@ +<!-- If susbsytem is already defined, only copy the contents under it and edit to suit your needs --> +<subsystem xmlns="urn:jboss:domain:datasources:1.0"> + <datasources> + <datasource jndi-name="java:/mysql-ds" pool-name="mysqlDS"> + <connection-url>jdbc:mysql://{host}:3306/{database}</connection-url> + <driver>mysql</driver> + <pool> + <prefill>false</prefill> + <use-strict-min>false</use-strict-min> + <flush-strategy>FailingConnectionOnly</flush-strategy> + </pool> + <security> + <user-name>{user}</user-name> + <password>{password}</password> + </security> + </datasource> + <drivers> + <driver name="mysql" module="com.mysql"> + <driver-class>com.mysql.jdbc.Driver</driver-class> + <xa-datasource-class>com.mysql.jdbc.jdbc2.optional.MysqlXADataSource</xa-datasource-class> + </driver> + </drivers> + </datasources> +</subsystem> \ No newline at end of file Property changes on: trunk/build/kits/jboss-as7/docs/teiid/datasources/mysql/mysql.xml ___________________________________________________________________ Added: svn:mime-type + text/plain Added: trunk/build/kits/jboss-as7/docs/teiid/datasources/mysql/readme.txt =================================================================== --- trunk/build/kits/jboss-as7/docs/teiid/datasources/mysql/readme.txt (rev 0) +++ trunk/build/kits/jboss-as7/docs/teiid/datasources/mysql/readme.txt 2011-12-08 17:13:56 UTC (rev 3726) @@ -0,0 +1,36 @@ +There are two parts to creating a datasource, depending upon whether this is the first time you are doing this, +you can skip the deploying JDBC driver for the database, if you have previously already done this. + +Step 1: Deploying the JDBC Driver + + Option 1: use the JBoss CLI tool, and deploy the "mysql-connector-java-5.1.5.jar" or later jar by issuing the command + deploy mysql-connector-java-5.1.5.jar + + Note: when you use CLI based deployment, the <driver> element in the <datasources> xml fragment, must + be the name of the jar file deployed, and no need for adding <drivers> element in standalone-teiid.xml + or domain-teiid.xml file + + Option 2: + 1) Stop the server if it is running. + + 2) Overlay the "modules" directory on the "<jboss-as>/modules" directory + + 3) Then copy the mysql database JDBC driver jar file "mysql-connector-java-5.1.5.jar" into + "<jboss-as>/modules/com/mysql/main" directory. + 4) start server + +Step 2: Creating the datasource + + Option 1: Edit the standalone-teiid.xml or domain-teiid.xml file and add contents of the "mysql.xml" + or "mysql-xa.xml" file under the "datasources" subsystem. You may have to edit contents according + to where your mysql server is located and credentials you need to use to access it. + + Option 2: Take a look at create-ds.cli script, and modify and execute using JBoss CLI tool as below + + ./Jboss-admin.sh --file create-ds.cli + +************************************************************************************************************** +NOTE: MySQL JDBC driver does not include the Driver file name as the service loader mechanism as of +version 5.1.5, so as is Step 1, Option 1 will not work. However you if you can manually fix jar to include +service definitions as described here http://community.jboss.org/docs/DOC-16657 then you can use it. +*************************************************************************************************************** \ No newline at end of file Property changes on: trunk/build/kits/jboss-as7/docs/teiid/datasources/mysql/readme.txt ___________________________________________________________________ Added: svn:mime-type + text/plain Deleted: trunk/build/kits/jboss-as7/docs/teiid/datasources/mysql.xml =================================================================== --- trunk/build/kits/jboss-as7/docs/teiid/datasources/mysql.xml 2011-12-08 16:14:29 UTC (rev 3725) +++ trunk/build/kits/jboss-as7/docs/teiid/datasources/mysql.xml 2011-12-08 17:13:56 UTC (rev 3726) @@ -1,23 +0,0 @@ -<!-- If susbsytem is already defined, only copy the contents under it and edit to suit your needs --> -<subsystem xmlns="urn:jboss:domain:datasources:1.0"> - <datasources> - <datasource jndi-name="java:/mysql-ds" pool-name="mysqlDS"> - <connection-url>jdbc:mysql://{host}:3306/{database}</connection-url> - <driver>mysql</driver> - <pool> - <prefill>false</prefill> - <use-strict-min>false</use-strict-min> - <flush-strategy>FailingConnectionOnly</flush-strategy> - </pool> - <security> - <user-name>user</user-name> - <password>password</password> - </security> - </datasource> - <drivers> - <driver name="mysql" module="com.mysql"> - <xa-datasource-class>com.mysql.jdbc.jdbc2.optional.MysqlXADataSource</xa-datasource-class> - </driver> - </drivers> - </datasources> -</subsystem> \ No newline at end of file Copied: trunk/build/kits/jboss-as7/docs/teiid/datasources/odbc/odbc.xml (from rev 3720, trunk/build/kits/jboss-container/teiid-examples/jca/odbc-ds.xml) =================================================================== --- trunk/build/kits/jboss-as7/docs/teiid/datasources/odbc/odbc.xml (rev 0) +++ trunk/build/kits/jboss-as7/docs/teiid/datasources/odbc/odbc.xml 2011-12-08 17:13:56 UTC (rev 3726) @@ -0,0 +1,25 @@ +<!-- If susbsytem is already defined, only copy the contents under it and edit to suit your needs --> +<subsystem xmlns="urn:jboss:domain:datasources:1.0"> + <datasources> + <datasource jndi-name="java:/odbcDS" pool-name="odbcDS"> + <!-- Create a DSN using ODBC driver manager, and replace {DSN} below with your DSN name --> + <connection-url>jdbc:odbc:{DSN}</connection-url> + + <!-- For DSN less connection URL use the below form to connect to a Excel Sheet + <connection-url>jdbc:odbc:Driver={Microsoft Excel Driver (*.xls)};Dbq=c:\ODBC\ExcelData.xls</connection-url> + --> + <driver-class>sun.jdbc.odbc.JdbcOdbcDriver</driver-class> + <transaction-isolation>TRANSACTION_NONE</transaction-isolation> + + <pool> + <prefill>false</prefill> + <use-strict-min>false</use-strict-min> + <flush-strategy>FailingConnectionOnly</flush-strategy> + </pool> + <security> + <user-name>{user}</user-name> + <password>{password}</password> + </security> + </datasource> + </datasources> +</subsystem> \ No newline at end of file Property changes on: trunk/build/kits/jboss-as7/docs/teiid/datasources/odbc/odbc.xml ___________________________________________________________________ Added: svn:mime-type + text/plain Added: trunk/build/kits/jboss-as7/docs/teiid/datasources/odbc/readme.txt =================================================================== --- trunk/build/kits/jboss-as7/docs/teiid/datasources/odbc/readme.txt (rev 0) +++ trunk/build/kits/jboss-as7/docs/teiid/datasources/odbc/readme.txt 2011-12-08 17:13:56 UTC (rev 3726) @@ -0,0 +1,10 @@ +For ODBC datasource, we use JDBC <--> ODBC bridge driver provided by Oracle that comes with Sun JDK. So, the driver +is already installed and available. + +1) First create DSN to the data source you are trying to connect. +2) if you want to create DSN-less connection then use the following connection URL format in the odbc.xml file +<connection-url>jdbc:odbc:Driver={Microsoft Excel Driver (*.xls)};Dbq=c:\ODBC\ExcelData.xls</connection-url> + +3) Edit the standalone-teiid.xml or domain-teiid.xml file and add contents of the "odbc.xml" +file under the "datasources" subsystem. You may have to edit contents according +to where your odbc server is located and credentials you need to use to access it. \ No newline at end of file Property changes on: trunk/build/kits/jboss-as7/docs/teiid/datasources/odbc/readme.txt ___________________________________________________________________ Added: svn:mime-type + text/plain Added: trunk/build/kits/jboss-as7/docs/teiid/datasources/olap/modules/org/olap4j/main/module.xml =================================================================== --- trunk/build/kits/jboss-as7/docs/teiid/datasources/olap/modules/org/olap4j/main/module.xml (rev 0) +++ trunk/build/kits/jboss-as7/docs/teiid/datasources/olap/modules/org/olap4j/main/module.xml 2011-12-08 17:13:56 UTC (rev 3726) @@ -0,0 +1,18 @@ +<?xml version="1.0" encoding="UTF-8"?> +<module xmlns="urn:jboss:module:1.0" name="org.olap4j"> + <resources> + <resource-root path="olap4j.jar"/> + <!-- below jar files needed only for the direct connection to mondrian. For XMLA, only olap4j.jar is required --> + <resource-root path="commons-math-1.0.jar"/> + <resource-root path="commons-vfs-1.0.jar"/> + <resource-root path="eigenbase-properties.jar"/> + <resource-root path="eigenbase-resgen.jar"/> + <resource-root path="eigenbase-xom.jar"/> + <resource-root path="javacup.jar"/> + <resource-root path="mondrian.jar"/> + </resources> + + <dependencies> + <module name="javax.api"/> + </dependencies> +</module> Property changes on: trunk/build/kits/jboss-as7/docs/teiid/datasources/olap/modules/org/olap4j/main/module.xml ___________________________________________________________________ Added: svn:mime-type + text/plain Copied: trunk/build/kits/jboss-as7/docs/teiid/datasources/olap/mondrian.xml (from rev 3720, trunk/build/kits/jboss-container/teiid-examples/jca/mondrian-ds.xml) =================================================================== --- trunk/build/kits/jboss-as7/docs/teiid/datasources/olap/mondrian.xml (rev 0) +++ trunk/build/kits/jboss-as7/docs/teiid/datasources/olap/mondrian.xml 2011-12-08 17:13:56 UTC (rev 3726) @@ -0,0 +1,43 @@ + <!-- + Provide these jars in JBoss AS profile's "lib" directory, to place the mondrian JDBC driver + on classpath. + + commons-math-1.0.jar + commons-vfs-1.0.jar + eigenbase-properties.jar + eigenbase-resgen.jar + eigenbase-xom.jar + javacup.jar + mondrian.jar + olap4j.jar + + Only use this datasource, if your mondrian server is also deployed to same JBoss AS + server, this will make embedded connection to mondrian. If you are working remote + then use olap-xmla-ds.xml file + --> + + + + +<!-- If susbsytem is already defined, only copy the contents under it and edit to suit your needs --> +<subsystem xmlns="urn:jboss:domain:datasources:1.0"> + <datasources> + <datasource jndi-name="java:/mondrianDS" pool-name="mondrianDS"> + <connection-url>jdbc:mondrian:Provider=Mondrian;DataSource=java:foodmart;Catalog=FoodMart;Catalog=${jboss.server.home.dir}/deploy/mondrian.war/WEB-INF/queries/FoodMart.xml;</connection-url> + <driver>olap</driver> + <driver-class>mondrian.olap4j.MondrianOlap4jDriver</driver-class> + <pool> + <prefill>false</prefill> + <use-strict-min>false</use-strict-min> + <flush-strategy>FailingConnectionOnly</flush-strategy> + </pool> + <security> + <user-name>{user}</user-name> + <password>{password}</password> + </security> + </datasource> + <drivers> + <driver name="olap" module="org.olap4j"/> + </drivers> + </datasources> +</subsystem \ No newline at end of file Property changes on: trunk/build/kits/jboss-as7/docs/teiid/datasources/olap/mondrian.xml ___________________________________________________________________ Added: svn:mime-type + text/plain Copied: trunk/build/kits/jboss-as7/docs/teiid/datasources/olap/olap-xmla.xml (from rev 3720, trunk/build/kits/jboss-container/teiid-examples/jca/olap-xmla-ds.xml) =================================================================== --- trunk/build/kits/jboss-as7/docs/teiid/datasources/olap/olap-xmla.xml (rev 0) +++ trunk/build/kits/jboss-as7/docs/teiid/datasources/olap/olap-xmla.xml 2011-12-08 17:13:56 UTC (rev 3726) @@ -0,0 +1,23 @@ +<subsystem xmlns="urn:jboss:domain:datasources:1.0"> + <datasources> + <datasource jndi-name="java:/olapDS" pool-name="olapDS"> + <!-- note here that you need to also create datasource for source, this is for mondrian as source for teiid --> + <connection-url>jdbc:xmla:Server=http://127.0.0.1:8080/mondrian/xmla;Provider=Mondrian;DataSource=java:foodmart;Catalog=FoodMart;</connection-url> + <driver>olap</driver> + <driver-class>org.olap4j.driver.xmla.XmlaOlap4jDriver</driver-class> + <transaction-isolation>-1</transaction-isolation> + <pool> + <prefill>false</prefill> + <use-strict-min>false</use-strict-min> + <flush-strategy>FailingConnectionOnly</flush-strategy> + </pool> + <security> + <user-name>{user}</user-name> + <password>{password}</password> + </security> + </datasource> + <drivers> + <driver name="olap" module="org.olap4j"/> + </drivers> + </datasources> +</subsystem \ No newline at end of file Property changes on: trunk/build/kits/jboss-as7/docs/teiid/datasources/olap/olap-xmla.xml ___________________________________________________________________ Added: svn:mime-type + text/plain Added: trunk/build/kits/jboss-as7/docs/teiid/datasources/olap/readme.txt =================================================================== --- trunk/build/kits/jboss-as7/docs/teiid/datasources/olap/readme.txt (rev 0) +++ trunk/build/kits/jboss-as7/docs/teiid/datasources/olap/readme.txt 2011-12-08 17:13:56 UTC (rev 3726) @@ -0,0 +1,30 @@ +There are two parts to creating a datasource, depending upon whether this is the first time you are doing this, +you can skip the deploying JDBC driver for the database, if you have previously already done this. + +Step 1: Deploying the JDBC Driver + + 1) Stop the server if it is running. + + 2) Overlay the "modules" directory on the "<jboss-as>/modules" directory + + 3) Then copy the olap4j database JDBC driver jar file "olap4j.jar" into + "<jboss-as>/modules/org/olap4j/main" directory. + + 4) if you are working with mondrian directly then copy these jars too into "<jboss-as>/modules/org/olap4j/main" directory. + + commons-math-1.0.jar + commons-vfs-1.0.jar + eigenbase-properties.jar + eigenbase-resgen.jar + eigenbase-xom.jar + javacup.jar + mondrian.jar + + 5) start server + +Step 2: Creating the datasource + + Option 1: Edit the standalone-teiid.xml or domain-teiid.xml file and add contents of the "mondrian.xml" + or "olap-xmla.xml" file under the "datasources" subsystem. You may have to edit contents according + to where your olap server is located and credentials you need to use to access it. + \ No newline at end of file Property changes on: trunk/build/kits/jboss-as7/docs/teiid/datasources/olap/readme.txt ___________________________________________________________________ Added: svn:mime-type + text/plain Added: trunk/build/kits/jboss-as7/docs/teiid/datasources/oracle/modules/com/oracle/main/module.xml =================================================================== --- trunk/build/kits/jboss-as7/docs/teiid/datasources/oracle/modules/com/oracle/main/module.xml (rev 0) +++ trunk/build/kits/jboss-as7/docs/teiid/datasources/oracle/modules/com/oracle/main/module.xml 2011-12-08 17:13:56 UTC (rev 3726) @@ -0,0 +1,11 @@ +<?xml version="1.0" encoding="UTF-8"?> +<module xmlns="urn:jboss:module:1.0" name="com.oracle"> + <resources> + <resource-root path="ojdbc6.jar"/> + </resources> + + <dependencies> + <module name="javax.api"/> + <module name="javax.resource.api"/> + </dependencies> +</ \ No newline at end of file Property changes on: trunk/build/kits/jboss-as7/docs/teiid/datasources/oracle/modules/com/oracle/main/module.xml ___________________________________________________________________ Added: svn:mime-type + text/plain Added: trunk/build/kits/jboss-as7/docs/teiid/datasources/oracle/oracle-xa.xml =================================================================== --- trunk/build/kits/jboss-as7/docs/teiid/datasources/oracle/oracle-xa.xml (rev 0) +++ trunk/build/kits/jboss-as7/docs/teiid/datasources/oracle/oracle-xa.xml 2011-12-08 17:13:56 UTC (rev 3726) @@ -0,0 +1,47 @@ +<!-- If susbsytem is already defined, only copy the contents under it and edit to suit your needs --> +<subsystem xmlns="urn:jboss:domain:datasources:1.0"> + <datasources> + <xa-datasource jndi-name="java:/OracleDS" pool-name="OracleDS" enabled="true" use-java-context="true" use-ccm="true"> + + <xa-datasource-property name="PortNumber">1557</xa-datasource-property> + <xa-datasource-property name="DatabaseName">{db-name}</xa-datasource-property> + <xa-datasource-property name="ServerName">{host}</xa-datasource-property> + + <driver>oracle</driver> + + <!-- + <new-connection-sql>select * from dual</new-connection-sql> + <transaction-isolation>TRANSACTION_READ_COMMITTED</transaction-isolation> + --> + + <xa-pool> + <min-pool-size>10</min-pool-size> + <max-pool-size>20</max-pool-size> + <is-same-rm-override>true</is-same-rm-override> + <prefill>false</prefill> + <use-strict-min>false</use-strict-min> + <flush-strategy>FailingConnectionOnly</flush-strategy> + <no-tx-separate-pools/> + </xa-pool> + + <security> + <user-name>{user}</user-name> + <password>{password}</password> + <!-- + <security-domain>mysecurity-realm</security-domain> + --> + </security> + + <!-- + <validation> + <check-valid-connection-sql>select * from dual</check-valid-connection-sql> + </validation> + --> + </xa-datasource> + <drivers> + <driver name="oracle" module="com.oracle"> + <xa-datasource-class>oracle.jdbc.xa.client.OracleXADataSource</xa-datasource-class> + </driver> + </drivers> + </datasources> +</subsystem> \ No newline at end of file Property changes on: trunk/build/kits/jboss-as7/docs/teiid/datasources/oracle/oracle-xa.xml ___________________________________________________________________ Added: svn:mime-type + text/plain Copied: trunk/build/kits/jboss-as7/docs/teiid/datasources/oracle/oracle.xml (from rev 3720, trunk/build/kits/jboss-as7/docs/teiid/datasources/oracle.xml) =================================================================== --- trunk/build/kits/jboss-as7/docs/teiid/datasources/oracle/oracle.xml (rev 0) +++ trunk/build/kits/jboss-as7/docs/teiid/datasources/oracle/oracle.xml 2011-12-08 17:13:56 UTC (rev 3726) @@ -0,0 +1,23 @@ +<!-- If susbsytem is already defined, only copy the contents under it and edit to suit your needs --> +<subsystem xmlns="urn:jboss:domain:datasources:1.0"> + <datasources> + <datasource jndi-name="java:/OracleDS" pool-name="OracleDS" enabled="true" jta="true" use-java-context="true" use-ccm="true"> + <connection-url>jdbc:oracle:thin:{host}:1521:orcl</connection-url> + <driver>oracle</driver> + <pool> + <prefill>false</prefill> + <use-strict-min>false</use-strict-min> + <flush-strategy>FailingConnectionOnly</flush-strategy> + </pool> + <security> + <user-name>{user}</user-name> + <password>{password}</password> + </security> + </datasource> + <drivers> + <driver name="oracle" module="com.oracle"> + <xa-datasource-class>oracle.jdbc.xa.client.OracleXADataSource</xa-datasource-class> + </driver> + </drivers> + </datasources> +</subsystem> Property changes on: trunk/build/kits/jboss-as7/docs/teiid/datasources/oracle/oracle.xml ___________________________________________________________________ Added: svn:mime-type + text/plain Added: trunk/build/kits/jboss-as7/docs/teiid/datasources/oracle/readme.txt =================================================================== --- trunk/build/kits/jboss-as7/docs/teiid/datasources/oracle/readme.txt (rev 0) +++ trunk/build/kits/jboss-as7/docs/teiid/datasources/oracle/readme.txt 2011-12-08 17:13:56 UTC (rev 3726) @@ -0,0 +1,31 @@ +There are two parts to creating a datasource, depending upon whether this is the first time you are doing this, +you can skip the deploying JDBC driver for the database, if you have previously already done this. + +Step 1: Deploying the JDBC Driver + + Option 1: use the JBoss CLI tool, and deploy the "ojdbc6.jar" or later jar by issuing the command + deploy ojdbc6.jar + + Note: when you use CLI based deployment, the <driver> element in the <datasources> xml fragment, must + be the name of the jar file deployed, and no need for adding <drivers> element in standalone-teiid.xml + or domain-teiid.xml file + + Option 2: + + 1) Stop the server if it is running. + + 2) Overlay the "modules" directory on the "<jboss-as>/modules" directory + + 3) Then copy the oracle database JDBC driver jar file "ojdbc6.jar" into + "<jboss-as>/modules/com/oracle/main" directory. + 4) start server + +Step 2: Creating the datasource + + Option 1: Edit the standalone-teiid.xml or domain-teiid.xml file and add contents of the "oracle.xml" + or "oracle-xa.xml" file under the "datasources" subsystem. You may have to edit contents according + to where your oracle server is located and credentials you need to use to access it. + + Option 2: Take a look at create-ds.cli script, and modify and execute using JBoss CLI tool as below + + ./Jboss-admin.sh --file create-ds.cli \ No newline at end of file Property changes on: trunk/build/kits/jboss-as7/docs/teiid/datasources/oracle/readme.txt ___________________________________________________________________ Added: svn:mime-type + text/plain Deleted: trunk/build/kits/jboss-as7/docs/teiid/datasources/oracle.xml =================================================================== --- trunk/build/kits/jboss-as7/docs/teiid/datasources/oracle.xml 2011-12-08 16:14:29 UTC (rev 3725) +++ trunk/build/kits/jboss-as7/docs/teiid/datasources/oracle.xml 2011-12-08 17:13:56 UTC (rev 3726) @@ -1,23 +0,0 @@ -<!-- If susbsytem is already defined, only copy the contents under it and edit to suit your needs --> -<subsystem xmlns="urn:jboss:domain:datasources:1.0"> - <datasources> - <datasource jndi-name="java:/OracleDS" pool-name="OracleDS" enabled="true" jta="true" use-java-context="true" use-ccm="true"> - <connection-url>jdbc:oracle:thin:{host}:1521:orcl</connection-url> - <driver>oracle</driver> - <pool> - <prefill>false</prefill> - <use-strict-min>false</use-strict-min> - <flush-strategy>FailingConnectionOnly</flush-strategy> - </pool> - <security> - <user-name>{user}</user-name> - <password>{password}</password> - </security> - </datasource> - <drivers> - <driver name="oracle" module="com.oracle"> - <xa-datasource-class>oracle.jdbc.xa.client.OracleXADataSource</xa-datasource-class> - </driver> - </drivers> - </datasources> -</subsystem> Added: trunk/build/kits/jboss-as7/docs/teiid/datasources/postgresql/modules/org/postgresql/main/module.xml =================================================================== --- trunk/build/kits/jboss-as7/docs/teiid/datasources/postgresql/modules/org/postgresql/main/module.xml (rev 0) +++ trunk/build/kits/jboss-as7/docs/teiid/datasources/postgresql/modules/org/postgresql/main/module.xml 2011-12-08 17:13:56 UTC (rev 3726) @@ -0,0 +1,9 @@ +<?xml version="1.0" encoding="UTF-8"?> +<module xmlns="urn:jboss:module:1.0" name="org.postgresql"> + <resources> + <resource-root path="postgresql-8.3-603.jdbc3.jar"/> + </resources> + <dependencies> + <module name="javax.api"/> + </dependencies> +</module> Property changes on: trunk/build/kits/jboss-as7/docs/teiid/datasources/postgresql/modules/org/postgresql/main/module.xml ___________________________________________________________________ Added: svn:mime-type + text/plain Added: trunk/build/kits/jboss-as7/docs/teiid/datasources/postgresql/postgresql-xa.xml =================================================================== --- trunk/build/kits/jboss-as7/docs/teiid/datasources/postgresql/postgresql-xa.xml (rev 0) +++ trunk/build/kits/jboss-as7/docs/teiid/datasources/postgresql/postgresql-xa.xml 2011-12-08 17:13:56 UTC (rev 3726) @@ -0,0 +1,47 @@ +<!-- If susbsytem is already defined, only copy the contents under it and edit to suit your needs --> +<subsystem xmlns="urn:jboss:domain:datasources:1.0"> + <datasources> + <xa-datasource jndi-name="java:/postgresDS" pool-name="postgresDS" enabled="true" use-java-context="true" use-ccm="true"> + + <xa-datasource-property name="PortNumber">5432</xa-datasource-property> + <xa-datasource-property name="DatabaseName">{db-name}</xa-datasource-property> + <xa-datasource-property name="ServerName">{host}</xa-datasource-property> + + <driver>postgresql</driver> + + <!-- + <new-connection-sql>select 1</new-connection-sql> + <transaction-isolation>TRANSACTION_READ_COMMITTED</transaction-isolation> + --> + + <xa-pool> + <min-pool-size>10</min-pool-size> + <max-pool-size>20</max-pool-size> + <is-same-rm-override>true</is-same-rm-override> + <prefill>false</prefill> + <use-strict-min>false</use-strict-min> + <flush-strategy>FailingConnectionOnly</flush-strategy> + <no-tx-separate-pools/> + </xa-pool> + + <security> + <user-name>{user}</user-name> + <password>{password}</password> + <!-- + <security-domain>mysecurity-realm</security-domain> + --> + </security> + + <!-- + <validation> + <check-valid-connection-sql>select 1</check-valid-connection-sql> + </validation> + --> + </xa-datasource> + <drivers> + <driver name="postgresql" module="org.postgresql"> + <xa-datasource-class>org.postgresql.xa.PGXADataSource</xa-datasource-class> + </driver> + </drivers> + </datasources> +</subsystem> \ No newline at end of file Property changes on: trunk/build/kits/jboss-as7/docs/teiid/datasources/postgresql/postgresql-xa.xml ___________________________________________________________________ Added: svn:mime-type + text/plain Copied: trunk/build/kits/jboss-as7/docs/teiid/datasources/postgresql/postgresql.xml (from rev 3720, trunk/build/kits/jboss-as7/docs/teiid/datasources/postgresql.xml) =================================================================== --- trunk/build/kits/jboss-as7/docs/teiid/datasources/postgresql/postgresql.xml (rev 0) +++ trunk/build/kits/jboss-as7/docs/teiid/datasources/postgresql/postgresql.xml 2011-12-08 17:13:56 UTC (rev 3726) @@ -0,0 +1,23 @@ +<!-- If susbsytem is already defined, only copy the contents under it and edit to suit your needs --> +<subsystem xmlns="urn:jboss:domain:datasources:1.0"> + <datasources> + <datasource jndi-name="java:/postgres-ds" pool-name="PostgreDS"> + <connection-url>jdbc:postgresql://{host}:5432/{database}</connection-url> + <driver>postgresql</driver> + <pool> + <prefill>false</prefill> + <use-strict-min>false</use-strict-min> + <flush-strategy>FailingConnectionOnly</flush-strategy> + </pool> + <security> + <user-name>user</user-name> + <password>pass</password> + </security> + </datasource> + <drivers> + <driver name="postgresql" module="org.postgresql"> + <xa-datasource-class>org.postgresql.xa.PGXADataSource</xa-datasource-class> + </driver> + </drivers> + </datasources> +</subsystem> \ No newline at end of file Property changes on: trunk/build/kits/jboss-as7/docs/teiid/datasources/postgresql/postgresql.xml ___________________________________________________________________ Added: svn:mime-type + text/plain Added: trunk/build/kits/jboss-as7/docs/teiid/datasources/postgresql/readme.txt =================================================================== --- trunk/build/kits/jboss-as7/docs/teiid/datasources/postgresql/readme.txt (rev 0) +++ trunk/build/kits/jboss-as7/docs/teiid/datasources/postgresql/readme.txt 2011-12-08 17:13:56 UTC (rev 3726) @@ -0,0 +1,31 @@ +There are two parts to creating a datasource, depending upon whether this is the first time you are doing this, +you can skip the deploying JDBC driver for the database, if you have previously already done this. + +Step 1: Deploying the JDBC Driver + + Option 1: use the JBoss CLI tool, and deploy the "postgresql-8.3-603.jdbc3.jar" or later jar by issuing the command + deploy postgresql-8.3-603.jdbc3.jar + + Note: when you use CLI based deployment, the <driver> element in the <datasources> xml fragment, must + be the name of the jar file deployed, and no need for adding <drivers> element in standalone-teiid.xml + or domain-teiid.xml file + + Option 2: + + 1) Stop the server if it is running. + + 2) Overlay the "modules" directory on the "<jboss-as>/modules" directory + + 3) Then copy the postgres database JDBC driver jar file "postgresql-8.3-603.jdbc3.jar" into + "<jboss-as>/modules/org/postgres/main" directory. + 4) start server + +Step 2: Creating the datasource + + Option 1: Edit the standalone-teiid.xml or domain-teiid.xml file and add contents of the "postgresql.xml" + or "postgresql-xa.xml" file under the "datasources" subsystem. You may have to edit contents according + to where your postgresql server is located and credentials you need to use to access it. + + Option 2: Take a look at create-ds.cli script, and modify and execute using JBoss CLI tool. + + \ No newline at end of file Property changes on: trunk/build/kits/jboss-as7/docs/teiid/datasources/postgresql/readme.txt ___________________________________________________________________ Added: svn:mime-type + text/plain Deleted: trunk/build/kits/jboss-as7/docs/teiid/datasources/postgresql.xml =================================================================== --- trunk/build/kits/jboss-as7/docs/teiid/datasources/postgresql.xml 2011-12-08 16:14:29 UTC (rev 3725) +++ trunk/build/kits/jboss-as7/docs/teiid/datasources/postgresql.xml 2011-12-08 17:13:56 UTC (rev 3726) @@ -1,23 +0,0 @@ -<!-- If susbsytem is already defined, only copy the contents under it and edit to suit your needs --> -<subsystem xmlns="urn:jboss:domain:datasources:1.0"> - <datasources> - <datasource jndi-name="java:/postgres-ds" pool-name="PostgreDS"> - <connection-url>jdbc:postgresql://{host}:5432/{database}</connection-url> - <driver>postgresql</driver> - <pool> - <prefill>false</prefill> - <use-strict-min>false</use-strict-min> - <flush-strategy>FailingConnectionOnly</flush-strategy> - </pool> - <security> - <user-name>user</user-name> - <password>pass</password> - </security> - </datasource> - <drivers> - <driver name="postgresql" module="org.postgresql"> - <xa-datasource-class>org.postgresql.xa.PGXADataSource</xa-datasource-class> - </driver> - </drivers> - </datasources> -</subsystem> \ No newline at end of file Added: trunk/build/kits/jboss-as7/docs/teiid/datasources/salesforce/readme.txt =================================================================== --- trunk/build/kits/jboss-as7/docs/teiid/datasources/salesforce/readme.txt (rev 0) +++ trunk/build/kits/jboss-as7/docs/teiid/datasources/salesforce/readme.txt 2011-12-08 17:13:56 UTC (rev 3726) @@ -0,0 +1,3 @@ +In Teiid, for Salesforce datasource a JCA connector is provided and deployed at the install time. To create +salesforce datasource connection edit the "standalone-teiid.xml" file or "doamin-teiid.xml" file and add +the contents of the salesforce.xml under "resource-adapters" subsystem section. \ No newline at end of file Property changes on: trunk/build/kits/jboss-as7/docs/teiid/datasources/salesforce/readme.txt ___________________________________________________________________ Added: svn:mime-type + text/plain Copied: trunk/build/kits/jboss-as7/docs/teiid/datasources/salesforce/salesforce.xml (from rev 3720, trunk/build/kits/jboss-as7/docs/teiid/datasources/salesforce.xml) =================================================================== --- trunk/build/kits/jboss-as7/docs/teiid/datasources/salesforce/salesforce.xml (rev 0) +++ trunk/build/kits/jboss-as7/docs/teiid/datasources/salesforce/salesforce.xml 2011-12-08 17:13:56 UTC (rev 3726) @@ -0,0 +1,30 @@ +<!-- 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-salesforce.rar</archive> + <transaction-support>NoTransaction</transaction-support> + <connection-definitions> + <connection-definition class-name="org.teiid.resource.adapter.salesforce.SalesForceManagedConnectionFactory" + jndi-name="java:/sfDS" + enabled="true" + use-java-context="true" + pool-name="teiid-sf-ds"> + + <!-- URL; the below is test; replace with actual URL you need to connect to --> + <config-property name="URL">https://test.salesforce.com/services/Soap/u/10.0&... + + <config-property name="username">user</config-property> + <config-property name="password">pass</config-property> + + <!-- + Uncomment this property to supply specific configuration for SalesForce service. This configuration + must contain config for "SforceService" service with namespace "urn:partner.soap.sforce.com" + <config-property name="configFile">path/to/jbossws-cxf.xml</config-property> + --> + </connection-definition> + </connection-definitions> + </resource-adapter> + </resource-adapters> +</subsystem> + Property changes on: trunk/build/kits/jboss-as7/docs/teiid/datasources/salesforce/salesforce.xml ___________________________________________________________________ Added: svn:mime-type + text/plain Deleted: trunk/build/kits/jboss-as7/docs/teiid/datasources/salesforce.xml =================================================================== --- trunk/build/kits/jboss-as7/docs/teiid/datasources/salesforce.xml 2011-12-08 16:14:29 UTC (rev 3725) +++ trunk/build/kits/jboss-as7/docs/teiid/datasources/salesforce.xml 2011-12-08 17:13:56 UTC (rev 3726) @@ -1,30 +0,0 @@ -<!-- 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-salesforce.rar</archive> - <transaction-support>NoTransaction</transaction-support> - <connection-definitions> - <connection-definition class-name="org.teiid.resource.adapter.salesforce.SalesForceManagedConnectionFactory" - jndi-name="java:/sfDS" - enabled="true" - use-java-context="true" - pool-name="teiid-sf-ds"> - - <!-- URL; the below is test; replace with actual URL you need to connect to --> - <config-property name="URL">https://test.salesforce.com/services/Soap/u/10.0&... - - <config-property name="username">user</config-property> - <config-property name="password">pass</config-property> - - <!-- - Uncomment this property to supply specific configuration for SalesForce service. This configuration - must contain config for "SforceService" service with namespace "urn:partner.soap.sforce.com" - <config-property name="configFile">path/to/jbossws-cxf.xml</config-property> - --> - </connection-definition> - </connection-definitions> - </resource-adapter> - </resource-adapters> -</subsystem> - Added: trunk/build/kits/jboss-as7/docs/teiid/datasources/sqlserver/jtds/modules/net/sourceforge/jtds/main/module.xml =================================================================== --- trunk/build/kits/jboss-as7/docs/teiid/datasources/sqlserver/jtds/modules/net/sourceforge/jtds/main/module.xml (rev 0) +++ trunk/build/kits/jboss-as7/docs/teiid/datasources/sqlserver/jtds/modules/net/sourceforge/jtds/main/module.xml 2011-12-08 17:13:56 UTC (rev 3726) @@ -0,0 +1,9 @@ +<?xml version="1.0" encoding="UTF-8"?> +<module xmlns="urn:jboss:module:1.0" name="net.sourceforge.jtds"> + <resources> + <resource-root path="jtds-1.2.5.jar"/> + </resources> + <dependencies> + <module name="javax.api"/> + </dependencies> +</module> Property changes on: trunk/build/kits/jboss-as7/docs/teiid/datasources/sqlserver/jtds/modules/net/sourceforge/jtds/main/module.xml ___________________________________________________________________ Added: svn:mime-type + text/plain Added: trunk/build/kits/jboss-as7/docs/teiid/datasources/sqlserver/jtds/readme.txt =================================================================== --- trunk/build/kits/jboss-as7/docs/teiid/datasources/sqlserver/jtds/readme.txt (rev 0) +++ trunk/build/kits/jboss-as7/docs/teiid/datasources/sqlserver/jtds/readme.txt 2011-12-08 17:13:56 UTC (rev 3726) @@ -0,0 +1,30 @@ +There are two parts to creating a datasource, depending upon whether this is the first time you are doing this, +you can skip the deploying JDBC driver for the database, if you have previously already done this. + +Step 1: Deploying the JDBC Driver + + Option 1: use the JBoss CLI tool, and deploy the "jtds-1.2.5.jar" or later jar by issuing the command + deploy jtds-1.2.5.jar + + Note: when you use CLI based deployment, the <driver> element in the <datasources> xml fragment, must + be the name of the jar file deployed, and no need for adding <drivers> element in standalone-teiid.xml + or domain-teiid.xml file + + Option 2: + 1) Stop the server if it is running. + + 2) Overlay the "modules" directory on the "<jboss-as>/modules" directory + + 3) Then copy the jtds JDBC driver jar file "jtds-1.2.5.jar" into + "<jboss-as>/modules/net/sourceforge/jtds/main" directory. + 4) start server + +Step 2: Creating the datasource + + Option 1: Edit the standalone-teiid.xml or domain-teiid.xml file and add contents of the "sqlserver.xml" + or "sqlserver-xa.xml" file under the "datasources" subsystem. You may have to edit contents according + to where your sqlserver server is located and credentials you need to use to access it. + + Option 2: Take a look at create-ds.cli script, and modify and execute using JBoss CLI tool as below + + ./Jboss-admin.sh --file create-ds.cli \ No newline at end of file Property changes on: trunk/build/kits/jboss-as7/docs/teiid/datasources/sqlserver/jtds/readme.txt ___________________________________________________________________ Added: svn:mime-type + text/plain Added: trunk/build/kits/jboss-as7/docs/teiid/datasources/sqlserver/jtds/sqlserver-xa.xml =================================================================== --- trunk/build/kits/jboss-as7/docs/teiid/datasources/sqlserver/jtds/sqlserver-xa.xml (rev 0) +++ trunk/build/kits/jboss-as7/docs/teiid/datasources/sqlserver/jtds/sqlserver-xa.xml 2011-12-08 17:13:56 UTC (rev 3726) @@ -0,0 +1,48 @@ +<!-- If susbsytem is already defined, only copy the contents under it and edit to suit your needs --> +<subsystem xmlns="urn:jboss:domain:datasources:1.0"> + <datasources> + <xa-datasource jndi-name="java:/sqlserverDS" pool-name="sqlserverDS" enabled="true" use-java-context="true" use-ccm="true"> + + <xa-datasource-property name="PortNumber">1433</xa-datasource-property> + <xa-datasource-property name="DatabaseName">{db-name}</xa-datasource-property> + <xa-datasource-property name="ServerName">{host}</xa-datasource-property> + + <driver>jtds</driver> + + <!-- + <new-connection-sql>select 1/new-connection-sql> + <transaction-isolation>TRANSACTION_READ_COMMITTED</transaction-isolation> + --> + + <xa-pool> + <min-pool-size>10</min-pool-size> + <max-pool-size>20</max-pool-size> + <is-same-rm-override>true</is-same-rm-override> + <prefill>false</prefill> + <use-strict-min>false</use-strict-min> + <flush-strategy>FailingConnectionOnly</flush-strategy> + <no-tx-separate-pools/> + </xa-pool> + + <security> + <user-name>{user}</user-name> + <password>{password}</password> + <!-- + <security-domain>mysecurity-realm</security-domain> + --> + </security> + + <!-- + <validation> + <check-valid-connection-sql>select 1</check-valid-connection-sql> + </validation> + --> + </xa-datasource> + <drivers> + <driver name="jtds" module="net.sourceforge.jtds"> + <driver-class>net.sourceforge.jtds.jdbc.Driver</driver-class> + <xa-datasource-class>net.sourceforge.jtds.jdbcx.JtdsDataSource</xa-datasource-class> + </driver> + </drivers> + </datasources> +</subsystem> \ No newline at end of file Property changes on: trunk/build/kits/jboss-as7/docs/teiid/datasources/sqlserver/jtds/sqlserver-xa.xml ___________________________________________________________________ Added: svn:mime-type + text/plain Added: trunk/build/kits/jboss-as7/docs/teiid/datasources/sqlserver/jtds/sqlserver.xml =================================================================== --- trunk/build/kits/jboss-as7/docs/teiid/datasources/sqlserver/jtds/sqlserver.xml (rev 0) +++ trunk/build/kits/jboss-as7/docs/teiid/datasources/sqlserver/jtds/sqlserver.xml 2011-12-08 17:13:56 UTC (rev 3726) @@ -0,0 +1,24 @@ +<!-- If susbsytem is already defined, only copy the contents under it and edit to suit your needs --> +<subsystem xmlns="urn:jboss:domain:datasources:1.0"> + <datasources> + <datasource jndi-name="java:/sqlserverDS" pool-name="sqlserverDS"> + <connection-url>jdbc:jtds:sqlserver://{host}:1433/{database}</connection-url> + <driver>jtds</driver> + <pool> + <prefill>false</prefill> + <use-strict-min>false</use-strict-min> + <flush-strategy>FailingConnectionOnly</flush-strategy> + </pool> + <security> + <user-name>{user}</user-name> + <password>{password}</password> + </security> + </datasource> + <drivers> + <driver name="jtds" module="net.sourceforge.jtds"> + <driver-class>net.sourceforge.jtds.jdbc.Driver</driver-class> + <xa-datasource-class>net.sourceforge.jtds.jdbcx.JtdsDataSource</xa-datasource-class> + </driver> + </drivers> + </datasources> +</subsystem> \ No newline at end of file Property changes on: trunk/build/kits/jboss-as7/docs/teiid/datasources/sqlserver/jtds/sqlserver.xml ___________________________________________________________________ Added: svn:mime-type + text/plain Added: trunk/build/kits/jboss-as7/docs/teiid/datasources/sqlserver/native/modules/com/microsoft/sqlserver/main/module.xml =================================================================== --- trunk/build/kits/jboss-as7/docs/teiid/datasources/sqlserver/native/modules/com/microsoft/sqlserver/main/module.xml (rev 0) +++ trunk/build/kits/jboss-as7/docs/teiid/datasources/sqlserver/native/modules/com/microsoft/sqlserver/main/module.xml 2011-12-08 17:13:56 UTC (rev 3726) @@ -0,0 +1,9 @@ +<?xml version="1.0" encoding="UTF-8"?> +<module xmlns="urn:jboss:module:1.0" name="com.microsoft.sqlserver"> + <resources> + <resource-root path="sqljdbc4.jar"/> + </resources> + <dependencies> + <module name="javax.api"/> + </dependencies> +</module> Property changes on: trunk/build/kits/jboss-as7/docs/teiid/datasources/sqlserver/native/modules/com/microsoft/sqlserver/main/module.xml ___________________________________________________________________ Added: svn:mime-type + text/plain Added: trunk/build/kits/jboss-as7/docs/teiid/datasources/sqlserver/native/readme.txt =================================================================== --- trunk/build/kits/jboss-as7/docs/teiid/datasources/sqlserver/native/readme.txt (rev 0) +++ trunk/build/kits/jboss-as7/docs/teiid/datasources/sqlserver/native/readme.txt 2011-12-08 17:13:56 UTC (rev 3726) @@ -0,0 +1,30 @@ +There are two parts to creating a datasource, depending upon whether this is the first time you are doing this, +you can skip the deploying JDBC driver for the database, if you have previously already done this. + +Step 1: Deploying the JDBC Driver + + Option 1: use the JBoss CLI tool, and deploy the "sqljdbc4.jar" or later jar by issuing the command + deploy sqljdbc4.jar + + Note: when you use CLI based deployment, the <driver> element in the <datasources> xml fragment, must + be the name of the jar file deployed, and no need for adding <drivers> element in standalone-teiid.xml + or domain-teiid.xml file + + Option 2: + 1) Stop the server if it is running. + + 2) Overlay the "modules" directory on the "<jboss-as>/modules" directory + + 3) Then copy the sqlserver database JDBC driver jar file "sqljdbc4.jar" into + "<jboss-as>/modules/com/microsoft/sqlserver/main" directory. + 4) start server + +Step 2: Creating the datasource + + Option 1: Edit the standalone-teiid.xml or domain-teiid.xml file and add contents of the "sqlserver.xml" + or "sqlserver-xa.xml" file under the "datasources" subsystem. You may have to edit contents according + to where your sqlserver server is located and credentials you need to use to access it. + + Option 2: Take a look at create-ds.cli script, and modify and execute using JBoss CLI tool as below + + ./Jboss-admin.sh --file create-ds.cli \ No newline at end of file Property changes on: trunk/build/kits/jboss-as7/docs/teiid/datasources/sqlserver/native/readme.txt ___________________________________________________________________ Added: svn:mime-type + text/plain Added: trunk/build/kits/jboss-as7/docs/teiid/datasources/sqlserver/native/sqlserver-xa.xml =================================================================== --- trunk/build/kits/jboss-as7/docs/teiid/datasources/sqlserver/native/sqlserver-xa.xml (rev 0) +++ trunk/build/kits/jboss-as7/docs/teiid/datasources/sqlserver/native/sqlserver-xa.xml 2011-12-08 17:13:56 UTC (rev 3726) @@ -0,0 +1,48 @@ +<!-- If susbsytem is already defined, only copy the contents under it and edit to suit your needs --> +<subsystem xmlns="urn:jboss:domain:datasources:1.0"> + <datasources> + <xa-datasource jndi-name="java:/sqlserverDS" pool-name="sqlserverDS" enabled="true" use-java-context="true" use-ccm="true"> + + <xa-datasource-property name="PortNumber">1433</xa-datasource-property> + <xa-datasource-property name="DatabaseName">{db-name}</xa-datasource-property> + <xa-datasource-property name="ServerName">{host}</xa-datasource-property> + + <driver>sqlserver</driver> + + <!-- + <new-connection-sql>select 1/new-connection-sql> + <transaction-isolation>TRANSACTION_READ_COMMITTED</transaction-isolation> + --> + + <xa-pool> + <min-pool-size>10</min-pool-size> + <max-pool-size>20</max-pool-size> + <is-same-rm-override>true</is-same-rm-override> + <prefill>false</prefill> + <use-strict-min>false</use-strict-min> + <flush-strategy>FailingConnectionOnly</flush-strategy> + <no-tx-separate-pools/> + </xa-pool> + + <security> + <user-name>{user}</user-name> + <password>{password}</password> + <!-- + <security-domain>mysecurity-realm</security-domain> + --> + </security> + + <!-- + <validation> + <check-valid-connection-sql>select 1</check-valid-connection-sql> + </validation> + --> + </xa-datasource> + <drivers> + <driver name="sqlserver" module="com.microsoft.sqlserver"> + <driver-class>com.microsoft.jdbc.sqlserver.SQLServerDriver</driver-class> + <xa-datasource-class>com.microsoft.sqlserver.jdbc.SQLServerXADataSource</xa-datasource-class> + </driver> + </drivers> + </datasources> +</subsystem> \ No newline at end of file Property changes on: trunk/build/kits/jboss-as7/docs/teiid/datasources/sqlserver/native/sqlserver-xa.xml ___________________________________________________________________ Added: svn:mime-type + text/plain Added: trunk/build/kits/jboss-as7/docs/teiid/datasources/sqlserver/native/sqlserver.xml =================================================================== --- trunk/build/kits/jboss-as7/docs/teiid/datasources/sqlserver/native/sqlserver.xml (rev 0) +++ trunk/build/kits/jboss-as7/docs/teiid/datasources/sqlserver/native/sqlserver.xml 2011-12-08 17:13:56 UTC (rev 3726) @@ -0,0 +1,24 @@ +<!-- If susbsytem is already defined, only copy the contents under it and edit to suit your needs --> +<subsystem xmlns="urn:jboss:domain:datasources:1.0"> + <datasources> + <datasource jndi-name="java:/sqlserverDS" pool-name="sqlserverDS"> + <connection-url>jdbc:microsoft:sqlserver://{host}:1433</connection-url> + <driver>sqlserver</driver> + <pool> + <prefill>false</prefill> + <use-strict-min>false</use-strict-min> + <flush-strategy>FailingConnectionOnly</flush-strategy> + </pool> + <security> + <user-name>{user}</user-name> + <password>{password}</password> + </security> + </datasource> + <drivers> + <driver name="sqlserver" module="com.microsoft.sqlserver"> + <driver-class>com.microsoft.jdbc.sqlserver.SQLServerDriver</driver-class> + <xa-datasource-class>com.microsoft.sqlserver.jdbc.SQLServerXADataSource</xa-datasource-class> + </driver> + </drivers> + </datasources> +</subsystem> \ No newline at end of file Property changes on: trunk/build/kits/jboss-as7/docs/teiid/datasources/sqlserver/native/sqlserver.xml ___________________________________________________________________ Added: svn:mime-type + text/plain Added: trunk/build/kits/jboss-as7/docs/teiid/datasources/teiid/readme.txt =================================================================== --- trunk/build/kits/jboss-as7/docs/teiid/datasources/teiid/readme.txt (rev 0) +++ trunk/build/kits/jboss-as7/docs/teiid/datasources/teiid/readme.txt 2011-12-08 17:13:56 UTC (rev 3726) @@ -0,0 +1,12 @@ +If you installed Teiid into JBoss AS then the driver is already installed, you only need to create a datasource + +Creating the datasource + + Option 1: Edit the standalone-teiid.xml or domain-teiid.xml file and add contents of the "teiid.xml" + or "teiid-xa.xml" or "teiid-local.xml" file under the "datasources" subsystem. You may have to edit contents according + to where your Teiid server is located and credentials you need to use to access it. + + Option 2: Take a look at create-ds.cli script, and modify and execute using JBoss CLI tool as below + + ./Jboss-admin.sh --file create-ds.cli + Property changes on: trunk/build/kits/jboss-as7/docs/teiid/datasources/teiid/readme.txt ___________________________________________________________________ Added: svn:mime-type + text/plain Added: trunk/build/kits/jboss-as7/docs/teiid/datasources/teiid/teiid-local.xml =================================================================== --- trunk/build/kits/jboss-as7/docs/teiid/datasources/teiid/teiid-local.xml (rev 0) +++ trunk/build/kits/jboss-as7/docs/teiid/datasources/teiid/teiid-local.xml 2011-12-08 17:13:56 UTC (rev 3726) @@ -0,0 +1,24 @@ +<!-- If susbsytem is already defined, only copy the contents under it and edit to suit your needs --> +<subsystem xmlns="urn:jboss:domain:datasources:1.0"> + <datasources> + <datasource jndi-name="java:/teiidDS" pool-name="teiidDS"> + <connection-url>jdbc:teiid:{vdb}</connection-url> + <driver>teiid-local</driver> + <pool> + <prefill>false</prefill> + <use-strict-min>false</use-strict-min> + <flush-strategy>FailingConnectionOnly</flush-strategy> + </pool> + <security> + <user-name>{user}</user-name> + <password>{password}</password> + </security> + </datasource> + <drivers> + <driver name="teiid-local" module="org.jboss.teiid"> + <driver-class>org.teiid.jdbc.TeiidDriver</driver-class> + <xa-datasource-class>org.teiid.jdbc.TeiidDataSource</xa-datasource-class> + </driver> + </drivers> + </datasources> +</subsystem> \ No newline at end of file Property changes on: trunk/build/kits/jboss-as7/docs/teiid/datasources/teiid/teiid-local.xml ___________________________________________________________________ Added: svn:mime-type + text/plain Added: trunk/build/kits/jboss-as7/docs/teiid/datasources/teiid/teiid-xa.xml =================================================================== --- trunk/build/kits/jboss-as7/docs/teiid/datasources/teiid/teiid-xa.xml (rev 0) +++ trunk/build/kits/jboss-as7/docs/teiid/datasources/teiid/teiid-xa.xml 2011-12-08 17:13:56 UTC (rev 3726) @@ -0,0 +1,48 @@ +<!-- If susbsytem is already defined, only copy the contents under it and edit to suit your needs --> +<subsystem xmlns="urn:jboss:domain:datasources:1.0"> + <datasources> + <xa-datasource jndi-name="java:/teiidDS" pool-name="teiidDS" enabled="true" use-java-context="true" use-ccm="true"> + + <xa-datasource-property name="PortNumber">31000</xa-datasource-property> + <xa-datasource-property name="DatabaseName">{db-name}</xa-datasource-property> + <xa-datasource-property name="ServerName">{host}</xa-datasource-property> + + <driver>teiid</driver> + + <!-- + <new-connection-sql>select 1/new-connection-sql> + <transaction-isolation>TRANSACTION_READ_COMMITTED</transaction-isolation> + --> + + <xa-pool> + <min-pool-size>10</min-pool-size> + <max-pool-size>20</max-pool-size> + <is-same-rm-override>true</is-same-rm-override> + <prefill>false</prefill> + <use-strict-min>false</use-strict-min> + <flush-strategy>FailingConnectionOnly</flush-strategy> + <no-tx-separate-pools/> + </xa-pool> + + <security> + <user-name>{user}</user-name> + <password>{password}</password> + <!-- + <security-domain>mysecurity-realm</security-domain> + --> + </security> + + <!-- + <validation> + <check-valid-connection-sql>select 1</check-valid-connection-sql> + </validation> + --> + </xa-datasource> + <drivers> + <driver name="teiid" module="org.jboss.teiid.client"> + <driver-class>org.teiid.jdbc.TeiidDriver</driver-class> + <xa-datasource-class>org.teiid.jdbc.TeiidDataSource</xa-datasource-class> + </driver> + </drivers> + </datasources> +</subsystem> \ No newline at end of file Property changes on: trunk/build/kits/jboss-as7/docs/teiid/datasources/teiid/teiid-xa.xml ___________________________________________________________________ Added: svn:mime-type + text/plain Copied: trunk/build/kits/jboss-as7/docs/teiid/datasources/teiid/teiid.xml (from rev 3720, trunk/build/kits/jboss-container/teiid-examples/jca/teiid-jdbc-template-ds.xml) =================================================================== --- trunk/build/kits/jboss-as7/docs/teiid/datasources/teiid/teiid.xml (rev 0) +++ trunk/build/kits/jboss-as7/docs/teiid/datasources/teiid/teiid.xml 2011-12-08 17:13:56 UTC (rev 3726) @@ -0,0 +1,24 @@ +<!-- If susbsytem is already defined, only copy the contents under it and edit to suit your needs --> +<subsystem xmlns="urn:jboss:domain:datasources:1.0"> + <datasources> + <datasource jndi-name="java:/teiidDS" pool-name="teiidDS"> + <connection-url>jdbc:teiid:{vdb}@mm://{host}:31000</connection-url> + <driver>teiid</driver> + <pool> + <prefill>false</prefill> + <use-strict-min>false</use-strict-min> + <flush-strategy>FailingConnectionOnly</flush-strategy> + </pool> + <security> + <user-name>{user}</user-name> + <password>{password}</password> + </security> + </datasource> + <drivers> + <driver name="teiid" module="org.jboss.teiid.client"> + <driver-class>org.teiid.jdbc.TeiidDriver</driver-class> + <xa-datasource-class>org.teiid.jdbc.TeiidDataSource</xa-datasource-class> + </driver> + </drivers> + </datasources> +</subsystem> \ No newline at end of file Property changes on: trunk/build/kits/jboss-as7/docs/teiid/datasources/teiid/teiid.xml ___________________________________________________________________ Added: svn:keywords + Id Revision Added: svn:eol-style + LF Added: trunk/build/kits/jboss-as7/docs/teiid/datasources/web-service/readme.txt =================================================================== --- trunk/build/kits/jboss-as7/docs/teiid/datasources/web-service/readme.txt (rev 0) +++ trunk/build/kits/jboss-as7/docs/teiid/datasources/web-service/readme.txt 2011-12-08 17:13:56 UTC (rev 3726) @@ -0,0 +1,3 @@ +In Teiid, for web-service(SOAP, REST/HTTP) datasource a JCA connector is provided and deployed at the install time. To create +web service datasource connection edit the "standalone-teiid.xml" file or "doamin-teiid.xml" file and add +the contents of the ws.xml under "resource-adapters" subsystem section. \ No newline at end of file Property changes on: trunk/build/kits/jboss-as7/docs/teiid/datasources/web-service/readme.txt ___________________________________________________________________ Added: svn:mime-type + text/plain Copied: trunk/build/kits/jboss-as7/docs/teiid/datasources/web-service/ws.xml (from rev 3720, trunk/build/kits/jboss-as7/docs/teiid/datasources/ws.xml) =================================================================== --- trunk/build/kits/jboss-as7/docs/teiid/datasources/web-service/ws.xml (rev 0) +++ trunk/build/kits/jboss-as7/docs/teiid/datasources/web-service/ws.xml 2011-12-08 17:13:56 UTC (rev 3726) @@ -0,0 +1,27 @@ +<!-- 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-ws.rar</archive> + <transaction-support>NoTransaction</transaction-support> + <connection-definitions> + <connection-definition class-name="org.teiid.resource.adapter.ws.WSManagedConnectionFactory" + jndi-name="java:/wsDS" + enabled="true" + use-java-context="true" + pool-name="teiid-ws-ds"> + + <!-- End point for the web service --> + <config-property name="EndPoint">endpoint url</config-property> + + <!-- + Uncomment these properties to supply specific CXF configuration for this service. This file + must contain configuration for name defined on "configName" property. + <config-property name="configFile">path/to/jbossws-cxf.xml</config-property> + <config-property name="configName">webSVC</config-property> + --> + </connection-definition> + </connection-definitions> + </resource-adapter> + </resource-adapters> +</subsystem> Property changes on: trunk/build/kits/jboss-as7/docs/teiid/datasources/web-service/ws.xml ___________________________________________________________________ Added: svn:mime-type + text/plain Deleted: trunk/build/kits/jboss-as7/docs/teiid/datasources/ws.xml =================================================================== --- trunk/build/kits/jboss-as7/docs/teiid/datasources/ws.xml 2011-12-08 16:14:29 UTC (rev 3725) +++ trunk/build/kits/jboss-as7/docs/teiid/datasources/ws.xml 2011-12-08 17:13:56 UTC (rev 3726) @@ -1,27 +0,0 @@ -<!-- 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-ws.rar</archive> - <transaction-support>NoTransaction</transaction-support> - <connection-definitions> - <connection-definition class-name="org.teiid.resource.adapter.ws.WSManagedConnectionFactory" - jndi-name="java:/wsDS" - enabled="true" - use-java-context="true" - pool-name="teiid-ws-ds"> - - <!-- End point for the web service --> - <config-property name="EndPoint">endpoint url</config-property> - - <!-- - Uncomment these properties to supply specific CXF configuration for this service. This file - must contain configuration for name defined on "configName" property. - <config-property name="configFile">path/to/jbossws-cxf.xml</config-property> - <config-property name="configName">webSVC</config-property> - --> - </connection-definition> - </connection-definitions> - </resource-adapter> - </resource-adapters> -</subsystem>