User: d_jencks
Date: 02/01/13 16:06:00
Added: src/examples/resources/jca firebird-service.xml
mssql-service.xml mysql-service.xml
oracle-service.xml postgres-service.xml
Log:
ConnectionFactoryLoader config files. Version for jboss 3.0 alpha of nov 30 2001
Revision Changes Path
1.1 manual/src/examples/resources/jca/firebird-service.xml
Index: firebird-service.xml
===================================================================
<?xml version="1.0" encoding="UTF-8"?>
<!-- $Id: firebird-service.xml,v 1.1 2002/01/14 00:05:59 d_jencks Exp $ -->
<!-- ===================================================================== -->
<!-- -->
<!-- JBoss Server Configuration -->
<!-- -->
<!-- ===================================================================== -->
<server>
<!-- ==================================================================== -->
<!-- Example ConnectionFactoryLoader for Firebird jca-jdbc connector -->
<!-- Put firebirdsql.rar in deploy also. -->
<!-- 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. -->
<!-- Author: David Jencks [EMAIL PROTECTED] -->
<!-- ==================================================================== -->
<mbean code="org.jboss.resource.ConnectionFactoryLoader"
name="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>
<mbean-ref name="ResourceAdapterName">JCA:service=RARDeployment,name=Firebird
Database Connector</mbean-ref>
<mbean-ref
name="ConnectionManagerFactoryLoaderName">JCA:service=ConnectionManagerFactoryLoader,name=MinervaXACMFactory</mbean-ref>
<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
Password=masterkey</attribute>
</mbean>
</server>
1.1 manual/src/examples/resources/jca/mssql-service.xml
Index: mssql-service.xml
===================================================================
<?xml version="1.0" encoding="UTF-8"?>
<!-- $Id: mssql-service.xml,v 1.1 2002/01/14 00:06:00 d_jencks Exp $ -->
<!-- =====================================================================-->
<!-- mssql-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 -->
<!-- The atinav driver is from -->
<!-- http://www.atinav.com/products/aveconnect/aveconnect.htm -->
<!-- This configuration is contributed by Alex Pavlov [EMAIL PROTECTED] -->
<!-- =====================================================================-->
<server>
<classpath archives="TaveConn25C.jar"/>
<!-- ==================================================================== -->
<!-- JDBC - Initialize the databases -->
<!-- to ConnectionFactoryLoader -->
<!-- ==================================================================== -->
<mbean code="org.jboss.resource.ConnectionFactoryLoader"
name="JBOSS-SYSTEM: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>
<mbean-ref name="ResourceAdapterName">JCA:service=RARDeployment,name=Minerva
JDBC LocalTransaction ResourceAdapter</mbean-ref>
<mbean-ref
name="ConnectionManagerFactoryLoaderName">JCA:service=ConnectionManagerFactoryLoader,name=MinervaSharedLocalCMFactory</mbean-ref>
<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>
1.1 manual/src/examples/resources/jca/mysql-service.xml
Index: mysql-service.xml
===================================================================
<?xml version="1.0" encoding="UTF-8"?>
<!-- $Id: mysql-service.xml,v 1.1 2002/01/14 00:06:00 d_jencks Exp $ -->
<!-- ===================================================================== -->
<!-- -->
<!-- Example configuration for the mysql database. -->
<!-- Put the driver jar mm.mysql-2.0.4-bin.jar in lib/ext -->
<!-- Contributed by Ignacio Coloma [EMAIL PROTECTED] -->
<!-- ===================================================================== -->
<server>
<classpath archives="
mm.mysql-2.0.4-bin.jar"/>
<!-- ==================================================================== -->
<!-- JDBC - Initialize the databases -->
<!-- to ConnectionFactoryLoader -->
<!-- ==================================================================== -->
<mbean code="org.jboss.resource.ConnectionFactoryLoader"
name="DefaultDomain: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>
<mbean-ref name="ResourceAdapterName">JCA:service=RARDeployment,name=Minerva
JDBC LocalTransaction ResourceAdapter</mbean-ref>
<mbean-ref
name="ConnectionManagerFactoryLoaderName">JCA:service=ConnectionManagerFactoryLoader,name=MinervaSharedLocalCMFactory</mbean-ref>
<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>
1.1 manual/src/examples/resources/jca/oracle-service.xml
Index: oracle-service.xml
===================================================================
<?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) in jboss_home/lib/ext -->
<!-- please put this file (oracleds-service.xml) under jboss_home/deploy -->
<!-- Contributed by Christian Biasuzzi [EMAIL PROTECTED]>
<!-- ===================================================================== -->
<server>
<classpath archives="
classes12.zip
"/>
<mbean code="org.jboss.resource.ConnectionFactoryLoader"
name="JBOSS-SYSTEM: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>
<mbean-ref name="ResourceAdapterName">JCA:service=RARDeployment,name=Minerva
JDBC LocalTransaction ResourceAdapter</mbean-ref>
<mbean-ref
name="ConnectionManagerFactoryLoaderName">JCA:service=ConnectionManagerFactoryLoader,name=MinervaSharedLocalCMFactory</mbean-ref>
<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>
1.1 manual/src/examples/resources/jca/postgres-service.xml
Index: postgres-service.xml
===================================================================
<?xml version="1.0" encoding="UTF-8"?>
<!-- $Id: postgres-service.xml,v 1.1 2002/01/14 00:06:00 d_jencks Exp $ -->
<!-- ===================================================================== -->
<!-- -->
<!-- Example configuration for the postgres database. -->
<!-- Put the driver jar jdbc7.0-1.2.jar in lib/ext -->
<!-- Contributed by Ignacio Coloma [EMAIL PROTECTED] -->
<!-- ===================================================================== -->
<server>
<classpath archives="
jdbc7.0-1.2.jar"/>
<mbean code="org.jboss.resource.ConnectionFactoryLoader"
name="DefaultDomain: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>
<mbean-ref name="ResourceAdapterName">JCA:service=RARDeployment,name=Minerva
JDBC LocalTransaction ResourceAdapter</mbean-ref>
<mbean-ref
name="ConnectionManagerFactoryLoaderName">JCA:service=ConnectionManagerFactoryLoader,name=MinervaSharedLocalCMFactory</mbean-ref>
<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>
_______________________________________________
Jboss-development mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-development