User: d_jencks Date: 02/01/13 17:14:43 Modified: src/xdocs resource.xml Log: Moved example configurations into examples directory and replaced text with links to cvs history pages. Now you can find the config version for your jboss version. Revision Changes Path 3.8 +34 -359 manual/src/xdocs/resource.xml Index: resource.xml =================================================================== RCS file: /cvsroot/jboss/manual/src/xdocs/resource.xml,v retrieving revision 3.7 retrieving revision 3.8 diff -u -r3.7 -r3.8 --- resource.xml 2002/01/13 23:34:52 3.7 +++ resource.xml 2002/01/14 01:14:43 3.8 @@ -238,366 +238,41 @@ <section id="resource-db-specific"> <title>Examples for specific databases</title> <para>Please contribute your working example now!</para> - <para><emphasis>IMPORTANT: THESE EXAMPLES ARE FOR POST JBOSS3.0ALPHA ONLY! THEY WILL NOT WORK ON JBOSS 2.4.x. TO ADAPT THEM TO JBOSS3.0ALPHA, REPLACE "depends" WITH "mbean-ref" AND "optional-attribute-name=" WITH "name=". ALSO REPLACE jboss.jca: IN THE OBJECT NAMES WITH JCA:</emphasis></para> + <para>The example ConnectionFactoryLoader configuration files are now maintained individually in jboss cvs. Here is a <ulink url = "http://cvs.sourceforge.net/cgi-bin/viewcvs.cgi/jboss/manual/src/examples/resources/jca/"><citetitle>link to a cvs view</citetitle></ulink> of the directory containing the examples. Please examine the checkin comments to find the version appropriate for the version of jboss 3 that you are using. These examples will not work with any jboss 2.x version.</para> + <para>Here are links to the cvs history pages for individual examples. + <orderedlist> + <listitem> + <para> + <ulink url = "http://cvs.sourceforge.net/cgi-bin/viewcvs.cgi/jboss/manual/src/examples/resources/jca/firebird-service.xml"><citetitle>Firebird jca-jdbc driver (Not Interclient)</citetitle></ulink> + </para> + </listitem> + + <listitem> + <para> + <ulink url = "http://cvs.sourceforge.net/cgi-bin/viewcvs.cgi/jboss/manual/src/examples/resources/jca/mssql-service.xml"><citetitle>MSSQL database with Atinav driver</citetitle></ulink> + </para> + </listitem> + + <listitem> + <para> + <ulink url = "http://cvs.sourceforge.net/cgi-bin/viewcvs.cgi/jboss/manual/src/examples/resources/jca/mysql-service.xml"><citetitle>MySql database.</citetitle></ulink> + </para> + </listitem> + + <listitem> + <para> + <ulink url = "http://cvs.sourceforge.net/cgi-bin/viewcvs.cgi/jboss/manual/src/examples/resources/jca/oracle-service.xml"><citetitle>Oracle 8 database</citetitle></ulink> + </para> + </listitem> + + <listitem> + <para> + <ulink url = "http://cvs.sourceforge.net/cgi-bin/viewcvs.cgi/jboss/manual/src/examples/resources/jca/postgres-service.xml"><citetitle>Postgres database</citetitle></ulink> + </para> + </listitem> + </orderedlist> + </para> - <section id="firebirdsql"> - <title>firebirdsql</title> - <para>Here is a sample firebird-service.xml configuration file for the (incomplete) firebirdsql jca-jdbc driver. Note that this is not the Borland interclient driver. It does support xa transactions correctly, although recover is not yet implemented. To obtain it, visit the firebird project at sourceforge, checkout the client-java module from cvs, and build it using the ant script. This configuration is written by - <author> - <firstname>David</firstname> - <surname>Jencks</surname> - </author> - <email>[EMAIL PROTECTED]</email> -<programlisting><![CDATA[<?xml version="1.0" encoding="UTF-8"?> - - -<!-- ===================================================================== --> -<!-- --> -<!-- JBoss Server Configuration --> -<!-- --> -<!-- ===================================================================== --> - - - -<server> - - - - <!-- ==================================================================== --> - <!-- Example ConnectionFactoryLoader for Firebird jca-jdbc connector --> - <!-- Put firebirdsql.rar in deploy also. --> - <!-- ==================================================================== --> - - - <mbean code="org.jboss.resource.ConnectionFactoryLoader" - name="jboss.jca:service=ConnectionFactoryLoader,name=FirebirdDS"> - <attribute name="ManagedConnectionFactoryProperties">Database=localhost/3050:/usr/java/jboss/co6/jboss-all/build/output/jboss-3.0.0alpha/db/firebirdsql/jbosstest.gdb</attribute> - <attribute name="JndiName">DefaultDS</attribute> - <attribute name="TransactionManagerName">java:/TransactionManager</attribute> - <depends optional-attribute-name="ResourceAdapterName">jboss.jca:service=RARDeployment,name=Firebird Database Connector</depends> - <depends optional-attribute-name="ConnectionManagerFactoryLoaderName">jboss.jca:service=ConnectionManagerFactoryLoader,name=MinervaXACMFactory</depends> - <attribute name="ConnectionManagerProperties"># - BlockingTimeoutMillis=500000 - IdleTimeoutMinutes=30 - MaxSize=10 - CleanupIntervalMinutes=30 - MinSize=0 - MaxIdleTimeoutPercent=1.0 - </attribute> - <attribute name="PrincipalMappingClass"> - org.jboss.resource.security.ManyToOnePrincipalMapping - </attribute> - <attribute name="PrincipalMappingProperties">UserName=sysdba -UserPassword=masterkey</attribute> - </mbean> - -</server> -]]></programlisting> -</para> - </section> - - - <section id="MSSQL 2000"> - <title>MSSQL 2000, ATINAV thin driver</title> - <para>Here is a sample mssqlds-service.xml for the atinav thin driver configuration file contributed by - <author> - <firstname>Alex</firstname> - <surname>Pavlov</surname> - </author> - <email>[EMAIL PROTECTED]</email>. This driver is available from <ulink url = "http://www.atinav.com/products/aveconnect/aveconnect.htm"><citetitle>Atinav</citetitle></ulink>. -<programlisting><![CDATA[<?xml version="1.0" encoding="UTF-8"?> - -<!-- =====================================================================--> -<!-- mssqlds-service.xml --> -<!-- JBoss v3.0alpha (november 23, 2001) ATINAV thin driver Configuration ---> -<!-- tested against MS SQL 2000 --> -<!-- ==================================================================== ---> -<!-- --> -<!-- please put jdbc driver (in this case TaveConn25C.jar) under -jboss_home/lib/ext --> -<!-- please put this file (mssqlds-service.xml) under jboss_home/deploy ---> -<!-- --> -<!-- ===================================================================== ---> - -<server> - - <classpath archives="TaveConn25C.jar"/> -<!-- ==================================================================== ---> -<!-- JDBC - Initialize the databases --> -<!-- to ConnectionFactoryLoader --> -<!-- ==================================================================== ---> - <mbean code="org.jboss.resource.ConnectionFactoryLoader" - name="jboss.jca:service=ConnectionFactoryLoader,name=MSSQL2000DS"> - <attribute name="ManagedConnectionFactoryProperties"> - ConnectionURL=jdbc:AvenirDriver://<INSERT_HERE_MSSQL_HOST>:<INSERT_HERE_MSSQL_PORT>/<INSERT_HERE_DB_NAME>;uid=<INSERT_HERE_USERNAME>;pwd=<INSERT_HERE_PASSWORD> - DriverClass=net.avenir.jdbc2.Driver - </attribute> - <attribute name="JndiName">MSSQL2000DS</attribute> - <attribute name="TransactionManagerName">java:/TransactionManager</attribute> - <depends optional-attribute-name="ResourceAdapterName">jboss.jca:service=RARDeployment,name=Minerva -JDBC LocalTransaction ResourceAdapter</depends> - <depends optional-attribute-name="ConnectionManagerFactoryLoaderName">jboss.jca:service=ConnectionManagerFactoryLoader,name=MinervaSharedLocalCMFactory</depends> - <attribute name="ConnectionManagerProperties"># - #Wed Aug 15 16:17:29 EDT 2001 - BlockingTimeoutMillis=50000 - IdleTimeoutMinutes=30 - MaxSize=10 - CleanupIntervalMinutes=10 - MinSize=0 - MaxIdleTimeoutPercent=1.0 - </attribute> - <attribute name="PrincipalMappingClass"> - org.jboss.resource.security.ManyToOnePrincipalMapping - </attribute> - <attribute name="PrincipalMappingProperties">userName=<INSERT_HERE_USERNAME> - password=<INSERT_HERE_PASSWORD></attribute> - </mbean> -</server> -]]></programlisting> -</para> - </section> - - - - - <section id="mysql"> - <title>Mysql</title> - <para>Here is a sample mysql-service.xml configuration file contributed by - <author> - <firstname>Ignacio</firstname> - <surname>Coloma</surname> - </author> - <email>[EMAIL PROTECTED]</email> -<programlisting><![CDATA[<?xml version="1.0" encoding="UTF-8"?> - - -<!-- ===================================================================== --> -<!-- --> -<!-- foo App DataSource --> -<!-- --> -<!-- ===================================================================== --> - -<!-- $Id: resource.xml,v 3.7 2002/01/13 23:34:52 d_jencks Exp $ --> - - -<server> - - - <classpath archives=" - mm.mysql-2.0.4-bin.jar"/> - - <!-- ==================================================================== --> - <!-- JDBC - Initialize the databases --> - <!-- to ConnectionFactoryLoader --> - <!-- ==================================================================== --> - - <mbean code="org.jboss.resource.ConnectionFactoryLoader" - name="jboss.jca:service=ConnectionFactoryLoader,name=fooDS"> - <attribute name="ManagedConnectionFactoryProperties">ConnectionURL=jdbc:mysql://localhost/foo - DriverClass=org.gjt.mm.mysql.Driver - UserName=</attribute> - <attribute name="JndiName">fooDS</attribute> - <attribute name="TransactionManagerName">java:/TransactionManager</attribute> - <depends optional-attribute-name="ResourceAdapterName">jboss.jca:service=RARDeployment,name=Minerva JDBC LocalTransaction ResourceAdapter</depends> - <depends optional-attribute-name="ConnectionManagerFactoryLoaderName">jboss.jca:service=ConnectionManagerFactoryLoader,name=MinervaSharedLocalCMFactory</depends> - <attribute name="ConnectionManagerProperties"># - #Wed Aug 15 16:17:29 EDT 2001 - BlockingTimeoutMillis=500000 - IdleTimeoutMinutes=30 - MaxSize=10 - CleanupIntervalMinutes=10 - MinSize=0 - MaxIdleTimeoutPercent=1.0 - </attribute> - <attribute name="PrincipalMappingClass"> - org.jboss.resource.security.ManyToOnePrincipalMapping - </attribute> - <attribute name="PrincipalMappingProperties">UserName=</attribute> - </mbean> - -</server> -]]></programlisting> -</para> - </section> - <section id="oracle"> - <title>Oracle</title> - <para>Here is a sample oracle-service.xml configuration file contributed by - <author> - <firstname>Christian</firstname> - <surname>Biasuzzi</surname> - </author> - <email>[EMAIL PROTECTED]</email> -<programlisting><![CDATA[<?xml version="1.0" encoding="UTF-8"?> - -<!-- =====================================================================--> -<!-- oracleds-service.xml --> -<!-- JBoss v3.0alpha (november 23, 2001) ORACLE thin driver Configuration --> -<!-- tested against ORACLE v8.x --> -<!-- ==================================================================== --> -<!-- --> -<!-- please put jdbc driver (in this case classes12.zip) under jboss_home/lib/ext --> -<!-- please put this file (oracleds-service.xml) under jboss_home/deploy --> -<!-- --> -<!-- ===================================================================== --> - -<server> - - <classpath archives=" - classes12.zip - "/> -<!-- ==================================================================== --> -<!-- JDBC - Initialize the databases --> -<!-- to ConnectionFactoryLoader --> -<!-- ==================================================================== --> - <mbean code="org.jboss.resource.ConnectionFactoryLoader" - name="jboss.jca:service=ConnectionFactoryLoader,name=OracleDS"> - <attribute name="ManagedConnectionFactoryProperties"> - ConnectionURL=jdbc:oracle:thin:@<INSERT_HERE_ORACLEURL>:<INSERT_HERE_ORACLEPORT>:<INSERT_HERE_ORACLESID> - DriverClass=oracle.jdbc.driver.OracleDriver - </attribute> - <attribute name="JndiName">OracleDS</attribute> - <attribute name="TransactionManagerName">java:/TransactionManager</attribute> - <depends optional-attribute-name="ResourceAdapterName">jboss.jca:service=RARDeployment,name=Minerva JDBC LocalTransaction ResourceAdapter</depends> - <depends optional-attribute-name="ConnectionManagerFactoryLoaderName">jboss.jca:service=ConnectionManagerFactoryLoader,name=MinervaSharedLocalCMFactory</depends> - <attribute name="ConnectionManagerProperties"># - #Wed Aug 15 16:17:29 EDT 2001 - BlockingTimeoutMillis=50000 - IdleTimeoutMinutes=30 - MaxSize=10 - CleanupIntervalMinutes=10 - MinSize=0 - MaxIdleTimeoutPercent=1.0 - </attribute> - <attribute name="PrincipalMappingClass"> - org.jboss.resource.security.ManyToOnePrincipalMapping - </attribute> - <attribute name="PrincipalMappingProperties">userName=<INSERT_HERE_USERNAME> - password=<INSERT_HERE_PASSWORD></attribute> - </mbean> -</server> -]]></programlisting> -</para> - </section> - <section id="postgres"> - <title>Postgres</title> - <para>Here is a sample postgres-service.xml configuration file contributed by - <author> - <firstname>Ignacio</firstname> - <surname>Coloma</surname> - </author> - <email>[EMAIL PROTECTED]</email> -<programlisting><![CDATA[<?xml version="1.0" encoding="UTF-8"?> - - -<!-- ===================================================================== --> -<!-- --> -<!-- foo App DataSource --> -<!-- --> -<!-- ===================================================================== --> - -<!-- $Id: resource.xml,v 3.7 2002/01/13 23:34:52 d_jencks Exp $ --> - -<server> - - <classpath archives=" - jdbc7.0-1.2.jar"/> - - <!-- ==================================================================== --> - <!-- JDBC - Initialize the databases --> - <!-- to ConnectionFactoryLoader --> - <!-- ==================================================================== --> - - <mbean code="org.jboss.resource.ConnectionFactoryLoader" - name="jboss.jca:service=ConnectionFactoryLoader,name=FooPostgresDS"> - <attribute name="ManagedConnectionFactoryProperties">ConnectionURL=jdbc:postgresql://192.168.0.4:5432/foo - DriverClass=org.postgresql.Driver - UserName=postgres - Password=postgres</attribute> - <attribute name="JndiName">FooPostgresDS</attribute> - <attribute name="TransactionManagerName">java:/TransactionManager</attribute> - <depends optional-attribute-name="ResourceAdapterName">jboss.jca:service=RARDeployment,name=Minerva JDBC LocalTransaction ResourceAdapter</depends> - <depends optional-attribute-name="ConnectionManagerFactoryLoaderName">jboss.jca:service=ConnectionManagerFactoryLoader,name=MinervaSharedLocalCMFactory</depends> - <attribute name="ConnectionManagerProperties"># - #Wed Aug 15 16:17:29 EDT 2001 - BlockingTimeoutMillis=500000 - IdleTimeoutMinutes=30 - MaxSize=10 - CleanupIntervalMinutes=10 - MinSize=0 - MaxIdleTimeoutPercent=1.0 - </attribute> - <attribute name="PrincipalMappingClass"> - org.jboss.resource.security.ManyToOnePrincipalMapping - </attribute> - <attribute name="PrincipalMappingProperties">UserName=</attribute> - </mbean> - -</server> -]]></programlisting> -</para> - </section> - <section id="Sybase"> - <title>Sybase</title> - <para>Here is a sample sybase-service.xml configuration file contributed by - <author> - <firstname>Peter</firstname> - <surname>Levart</surname> - </author> - <email>[EMAIL PROTECTED]</email> -<programlisting><![CDATA[<?xml version="1.0" encoding="UTF-8"?> - -<server> - - <!-- put jconn2.jar from the Sybase jConnect 5.x into the JBoss lib/ext -directory !!! --> - <classpath archives="jconn2.jar"/> - - <mbean code="org.jboss.resource.ConnectionFactoryLoader" - name="jboss.jca:service=ConnectionFactoryLoader,name=Sybase_J2EETEST"> - - <attribute name="ManagedConnectionFactoryProperties">ConnectionURL=jdbc:sybase:Tds:vino:4100 - DriverClass=com.sybase.jdbc2.jdbc.SybDriver - UserName=j2eetest - Password=j2eetest</attribute> - - <attribute name="JndiName">Sybase_J2EETEST</attribute> - - <attribute name="TransactionManagerName">java:/TransactionManager</attribute> - - <depends optional-attribute-name="ResourceAdapterName">jboss.jca:service=RARDeployment,name=Minerva -JDBC LocalTransaction ResourceAdapter</depends> - <depends optional-attribute-name="ConnectionManagerFactoryLoaderName">jboss.jca:service=ConnectionManagerFactoryLoader,name=MinervaSharedLocalCMFactory</depends> - - <attribute name="ConnectionManagerProperties"># - #Wed Aug 15 16:17:29 EDT 2001 - MinSize=0 - MaxSize=10 - BlockingTimeoutMillis=5000 - IdleTimeoutMinutes=30 - CleanupIntervalMinutes=10 - MaxIdleTimeoutPercent=1.0 - </attribute> - - <attribute name="PrincipalMappingClass"> - org.jboss.resource.security.ManyToOnePrincipalMapping - </attribute> - - <attribute name="PrincipalMappingProperties"/> - - </mbean> - -</server> - - -]]></programlisting> -</para> - </section> </section> <section id="resource-migration"> <title>Migration from older jboss versions</title>
_______________________________________________ Jboss-development mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-development