User: tobias
Date: 01/02/16 13:20:04
Modified: src/docs jdbc-database.xml
Log:
added section which describes needed changes for examples for 2.0 FINAL
to work with newer versions of JBoss
Revision Changes Path
1.2 +196 -157 manual/src/docs/jdbc-database.xml
Index: jdbc-database.xml
===================================================================
RCS file: /products/cvs/ejboss/manual/src/docs/jdbc-database.xml,v
retrieving revision 1.1
retrieving revision 1.2
diff -u -r1.1 -r1.2
--- jdbc-database.xml 2001/02/11 00:55:34 1.1
+++ jdbc-database.xml 2001/02/16 21:20:04 1.2
@@ -38,7 +38,7 @@
<section><title>Installing JDBC Drivers</title>
<para>
-To install a JDBC driver, it must be distributed as one or more ZIP or JAR files.
You should copy those files to the lib/ext directory under your JBoss
+To install a JDBC driver, it must be distributed as one or more ZIP or JAR files.
You should copy those files to the <filename>lib/ext</filename> directory under your
JBoss
installation directory. In addition, you need to change one line in the file
jboss.properties located in the conf directory. Find the property named
jdbc.drivers, and add your product's driver class name to the list of drivers. The
drivers in the list should be separated by commas. Here's an
example line, listing drivers for Oracle and Sybase:
@@ -50,12 +50,12 @@
<para>
The next time you start JBoss, you should see output like the following listing
each driver that was loaded. If instead you see an error for the driver (also
-shown below), make sure that you installed the required ZIPs and/or JARs to the
lib/ext directory.
+shown below), make sure that you installed the required ZIPs and/or JARs to the
<filename>lib/ext</filename> directory.
-<computeroutput>
+<computeroutput><![CDATA[
[JDBC] Loaded JDBC-driver:oracle.jdbc.driver.OracleDriver
[JDBC] Could not load driver:com.sybase.jdbc2.jdbc.SybDriver
-</computeroutput>
+]]></computeroutput>
</para>
</section>
@@ -112,21 +112,19 @@
changes to customize your pool:
<itemizedlist>
- <listitem><para>In the first line, you should replace "vendor.jar" with the
name of the ZIPs or JARs you added to the lib/ext directory when you configured
+ <listitem><para>In the first line, you should replace "vendor.jar" with the
name of the ZIPs or JARs you added to the <filename>lib/ext</filename> directory when
you configured
the driver</para></listitem>
<listitem><para>
Enter the name you want to use for this pool instead of "PoolName" for the
first argument.</para></listitem>
<listitem><para>If your driver supports the JDBC 2.0 Optional Package, you
should use the class name of the vendor's XADataSource implementation for the
second argument. Otherwise, use the JBoss class name shown.</para></listitem>
</itemizedlist>
-
<programlisting><![CDATA[
<MLET CODE="org.jboss.jdbc.XADataSourceLoader" ARCHIVE="jboss.jar,vendor.jar"
CODEBASE="../lib/ext/">
<ARG TYPE="java.lang.String" VALUE="PoolName">
<ARG TYPE="java.lang.String" VALUE="org.jboss.minerva.xa.XADataSourceImpl">
</MLET>
]]></programlisting>
-
</para>
<para>
@@ -143,12 +141,10 @@
<attribute name="Password">tiger</attribute>
</mbean>
]]></programlisting>
-
</para>
-
<section><title>Connection Pool Parameters</title>
<para>
@@ -319,8 +315,6 @@
</section>
</section>
-
-
<section><title>Connection Pool Configuration Examples and Driver Notes</title>
<para>
@@ -338,25 +332,25 @@
<listitem><para>lib/ext: classes12.zip</para></listitem>
<listitem><para>jboss.properties</para>
<programlisting>
- jboss.xa.xidclass=oracle.jdbc.xa.OracleXid
+jboss.xa.xidclass=oracle.jdbc.xa.OracleXid
</programlisting>
</listitem>
<listitem><para>jboss.conf</para>
<programlisting><![CDATA[
- <MLET CODE="org.jboss.jdbc.XADataSourceLoader" ARCHIVE="jboss.jar"
CODEBASE="../lib/ext/">
- <ARG TYPE="java.lang.String" VALUE="OracleDB">
- <ARG TYPE="java.lang.String"
VALUE="oracle.jdbc.xa.client.OracleXADataSource">
- </MLET>
+<MLET CODE="org.jboss.jdbc.XADataSourceLoader" ARCHIVE="jboss.jar"
CODEBASE="../lib/ext/">
+ <ARG TYPE="java.lang.String" VALUE="OracleDB">
+ <ARG TYPE="java.lang.String" VALUE="oracle.jdbc.xa.client.OracleXADataSource">
+</MLET>
]]></programlisting>
</listitem>
<listitem><para>jboss.jcml</para>
<programlisting><![CDATA[
- <mbean name="DefaultDomain:service=XADataSource,name=OracleDB">
- <attribute
name="URL">jdbc:oracle:thin:@host.domain.com:1521:instance</attribute>
- <attribute name="JDBCUser">scott</attribute>
- <attribute name="Password">tiger</attribute>
- </mbean>
- ]]></programlisting>
+<mbean name="DefaultDomain:service=XADataSource,name=OracleDB">
+ <attribute name="URL">jdbc:oracle:thin:@host.domain.com:1521:instance</attribute>
+ <attribute name="JDBCUser">scott</attribute>
+ <attribute name="Password">tiger</attribute>
+</mbean>
+]]></programlisting>
</listitem>
<listitem><para>CMP Type Mapping Names (for jaws.xml): Oracle8
</para></listitem>
</itemizedlist>
@@ -371,26 +365,25 @@
Extreme Float or Double values will cause SQLExceptions
</literallayout></listitem>
<listitem><para>lib/ext: classes12.zip</para></listitem>
<listitem><para>jboss.properties</para>
- <programlisting>
- jdbc.drivers=oracle.jdbc.driver.OracleDriver
+ <programlisting>jdbc.drivers=oracle.jdbc.driver.OracleDriver
</programlisting>
</listitem>
<listitem><para> jboss.conf </para>
<programlisting><![CDATA[
- <MLET CODE="org.jboss.jdbc.XADataSourceLoader" ARCHIVE="jboss.jar"
CODEBASE="../lib/ext/">
- <ARG TYPE="java.lang.String" VALUE="OracleDB">
- <ARG TYPE="java.lang.String"
VALUE="org.jboss.minerva.xa.XADataSourceImpl">
- </MLET>
- ]]></programlisting>
+<MLET CODE="org.jboss.jdbc.XADataSourceLoader" ARCHIVE="jboss.jar"
CODEBASE="../lib/ext/">
+ <ARG TYPE="java.lang.String" VALUE="OracleDB">
+ <ARG TYPE="java.lang.String" VALUE="org.jboss.minerva.xa.XADataSourceImpl">
+</MLET>
+]]></programlisting>
</listitem>
<listitem><para>jboss.jcml</para>
<programlisting><![CDATA[
- <mbean name="DefaultDomain:service=XADataSource,name=OracleDB">
- <attribute
name="URL">jdbc:oracle:thin:@host.domain.com:1521:instance</attribute>
- <attribute name="JDBCUser">scott</attribute>
- <attribute name="Password">tiger</attribute>
- </mbean>
- ]]></programlisting>
+<mbean name="DefaultDomain:service=XADataSource,name=OracleDB">
+ <attribute name="URL">jdbc:oracle:thin:@host.domain.com:1521:instance</attribute>
+ <attribute name="JDBCUser">scott</attribute>
+ <attribute name="Password">tiger</attribute>
+</mbean>
+]]></programlisting>
</listitem>
<listitem><para>CMP Type Mapping Names (for jaws.xml): Oracle7 and
Oracle8 </para></listitem>
</itemizedlist>
@@ -401,25 +394,24 @@
<itemizedlist>
<listitem><para>lib/ext: hsql.jar</para></listitem>
<listitem><para>jboss.properties</para>
- <programlisting>
- jdbc.drivers=org.hsql.jdbcDriver
+ <programlisting>jdbc.drivers=org.hsql.jdbcDriver
</programlisting>
</listitem>
<listitem><para> jboss.conf </para>
<programlisting><![CDATA[
- <MLET CODE="org.jboss.jdbc.XADataSourceLoader" ARCHIVE="jboss.jar"
CODEBASE="../lib/ext/">
- <ARG TYPE="java.lang.String" VALUE="Hypersonic">
- <ARG TYPE="java.lang.String"
VALUE="org.jboss.minerva.xa.XADataSourceImpl">
- </MLET>
- ]]></programlisting>
+<MLET CODE="org.jboss.jdbc.XADataSourceLoader" ARCHIVE="jboss.jar"
CODEBASE="../lib/ext/">
+ <ARG TYPE="java.lang.String" VALUE="Hypersonic">
+ <ARG TYPE="java.lang.String" VALUE="org.jboss.minerva.xa.XADataSourceImpl">
+</MLET>
+]]></programlisting>
</listitem>
<listitem><para>jboss.jcml</para>
<programlisting><![CDATA[
- <mbean name="DefaultDomain:service=XADataSource,name=Hypersonic">
- <attribute
name="URL">jdbc:HypersonicSQL:hsql://localhost</attribute>
- <attribute name="JDBCUser">sa</attribute>
- </mbean>
- ]]></programlisting>
+<mbean name="DefaultDomain:service=XADataSource,name=Hypersonic">
+ <attribute name="URL">jdbc:HypersonicSQL:hsql://localhost</attribute>
+ <attribute name="JDBCUser">sa</attribute>
+</mbean>
+]]></programlisting>
</listitem>
<listitem><para>CMP Type Mapping Names (for jaws.xml): Hypersonic SQL
</para></listitem>
</itemizedlist>
@@ -437,27 +429,25 @@
implementation. To use the "net" driver, you must run the "db2jstrt
[port]" tool on your DB server. </literallayout></listitem>
<listitem><para>lib/ext: db2java.zip</para></listitem>
<listitem><para>jboss.properties</para>
- <programlisting>
- jdbc.drivers=COM.ibm.db2.jdbc.net.DB2Driver
+ <programlisting>jdbc.drivers=COM.ibm.db2.jdbc.net.DB2Driver
</programlisting>
</listitem>
<listitem><para> jboss.conf </para>
<programlisting><![CDATA[
- <MLET CODE="org.jboss.jdbc.XADataSourceLoader" ARCHIVE="jboss.jar"
CODEBASE="../lib/ext/">
- <ARG TYPE="java.lang.String" VALUE="DB2">
- <ARG TYPE="java.lang.String"
VALUE="org.jboss.minerva.xa.XADataSourceImpl">
- </MLET>
-
- ]]></programlisting>
+<MLET CODE="org.jboss.jdbc.XADataSourceLoader" ARCHIVE="jboss.jar"
CODEBASE="../lib/ext/">
+ <ARG TYPE="java.lang.String" VALUE="DB2">
+ <ARG TYPE="java.lang.String" VALUE="org.jboss.minerva.xa.XADataSourceImpl">
+</MLET>
+]]></programlisting>
</listitem>
<listitem><para>jboss.jcml</para>
<programlisting><![CDATA[
- <mbean name="DefaultDomain:service=XADataSource,name=DB2">
- <attribute
name="URL">jdbc:db2://host.domain.com:port/database</attribute>
- <attribute name="JDBCUser">username</attribute>
- <attribute name="Password">password</attribute>
- </mbean>
- ]]></programlisting>
+<mbean name="DefaultDomain:service=XADataSource,name=DB2">
+ <attribute name="URL">jdbc:db2://host.domain.com:port/database</attribute>
+ <attribute name="JDBCUser">username</attribute>
+ <attribute name="Password">password</attribute>
+</mbean>
+]]></programlisting>
</listitem>
<listitem><para>CMP Type Mapping Names (for jaws.xml):DB2
</para></listitem>
</itemizedlist>
@@ -467,27 +457,25 @@
<itemizedlist>
<listitem><para>lib/ext: jt400.jar </para></listitem>
<listitem><para>jboss.properties</para>
- <programlisting>
- jdbc.drivers=com.ibm.as400.access.AS400JDBCDriver
+ <programlisting>jdbc.drivers=com.ibm.as400.access.AS400JDBCDriver
</programlisting>
</listitem>
<listitem><para> jboss.conf </para>
<programlisting><![CDATA[
- <MLET CODE="org.jboss.jdbc.XADataSourceLoader" ARCHIVE="jboss.jar"
CODEBASE="../lib/ext/">
- <ARG TYPE="java.lang.String" VALUE="AS400">
- <ARG TYPE="java.lang.String"
VALUE="org.jboss.minerva.xa.XADataSourceImpl">
- </MLET>
-
- ]]></programlisting>
+<MLET CODE="org.jboss.jdbc.XADataSourceLoader" ARCHIVE="jboss.jar"
CODEBASE="../lib/ext/">
+ <ARG TYPE="java.lang.String" VALUE="AS400">
+ <ARG TYPE="java.lang.String" VALUE="org.jboss.minerva.xa.XADataSourceImpl">
+</MLET>
+]]></programlisting>
</listitem>
<listitem><para>jboss.jcml</para>
<programlisting><![CDATA[
- <mbean name="DefaultDomain:service=XADataSource,name=AS400">
- <attribute name="URL">jdbc:as400://hostname</attribute>
- <attribute name="JDBCUser">user</attribute>
- <attribute name="Password">pw</attribute>
- </mbean>
- ]]></programlisting>
+<mbean name="DefaultDomain:service=XADataSource,name=AS400">
+ <attribute name="URL">jdbc:as400://hostname</attribute>
+ <attribute name="JDBCUser">user</attribute>
+ <attribute name="Password">pw</attribute>
+</mbean>
+]]></programlisting>
</listitem>
<listitem><para>CMP Type Mapping Names (for jaws.xml):DB2/400
</para></listitem>
</itemizedlist>
@@ -504,27 +492,25 @@
varbinary or image). We recommend you use int variables instead to
avoid this. </literallayout></listitem>
<listitem><para>lib/ext:jconn2.jar</para></listitem>
<listitem><para>jboss.properties</para>
- <programlisting>
- jdbc.drivers=com.sybase.jdbc2.jdbc.SybDriver
+ <programlisting>jdbc.drivers=com.sybase.jdbc2.jdbc.SybDriver
</programlisting>
</listitem>
<listitem><para> jboss.conf </para>
<programlisting><![CDATA[
- <MLET CODE="org.jboss.jdbc.XADataSourceLoader" ARCHIVE="jboss.jar"
CODEBASE="../lib/ext/">
- <ARG TYPE="java.lang.String" VALUE="SybaseDB">
- <ARG TYPE="java.lang.String"
VALUE="org.jboss.minerva.xa.XADataSourceImpl">
- </MLET>
-
- ]]></programlisting>
+<MLET CODE="org.jboss.jdbc.XADataSourceLoader" ARCHIVE="jboss.jar"
CODEBASE="../lib/ext/">
+ <ARG TYPE="java.lang.String" VALUE="SybaseDB">
+ <ARG TYPE="java.lang.String" VALUE="org.jboss.minerva.xa.XADataSourceImpl">
+</MLET>
+]]></programlisting>
</listitem>
<listitem><para>jboss.jcml</para>
<programlisting><![CDATA[
- <mbean name="DefaultDomain:service=XADataSource,name=SybaseDB">
- <attribute
name="URL">jdbc:sybase:Tds:host.domain.com:4100/database</attribute>
- <attribute name="Password">password</attribute>
- <attribute name="JDBCUser">username</attribute>
- </mbean>
- ]]></programlisting>
+<mbean name="DefaultDomain:service=XADataSource,name=SybaseDB">
+ <attribute name="URL">jdbc:sybase:Tds:host.domain.com:4100/database</attribute>
+ <attribute name="Password">password</attribute>
+ <attribute name="JDBCUser">username</attribute>
+</mbean>
+]]></programlisting>
</listitem>
<listitem><para>CMP Type Mapping Names (for
jaws.xml):Sybase</para></listitem>
</itemizedlist>
@@ -537,26 +523,25 @@
Extreme Java "long" values will cause SQLExceptions and may corrupt
the driver so that further actions fail. </literallayout></listitem>
<listitem><para>lib/ext:jdbc7.0-1.2.jar</para></listitem>
<listitem><para>jboss.properties</para>
- <programlisting>
- jdbc.drivers=org.postgresql.Driver
+ <programlisting>jdbc.drivers=org.postgresql.Driver
</programlisting>
</listitem>
<listitem><para> jboss.conf </para>
<programlisting><![CDATA[
- <MLET CODE="org.jboss.jdbc.XADataSourceLoader" ARCHIVE="jboss.jar"
CODEBASE="../lib/ext/">
- <ARG TYPE="java.lang.String" VALUE="PostgresDB">
- <ARG TYPE="java.lang.String"
VALUE="org.jboss.minerva.xa.XADataSourceImpl">
- </MLET>
- ]]></programlisting>
+<MLET CODE="org.jboss.jdbc.XADataSourceLoader" ARCHIVE="jboss.jar"
CODEBASE="../lib/ext/">
+ <ARG TYPE="java.lang.String" VALUE="PostgresDB">
+ <ARG TYPE="java.lang.String" VALUE="org.jboss.minerva.xa.XADataSourceImpl">
+</MLET>
+]]></programlisting>
</listitem>
<listitem><para>jboss.jcml</para>
<programlisting><![CDATA[
- <mbean name="DefaultDomain:service=XADataSource,name=PostgresDB">
- <attribute
name="URL">jdbc:postgresql://host.domain.com/database</attribute>
- <attribute name="JDBCUser">postgres</attribute>
- <attribute name="Password">foo</attribute>
- </mbean>
- ]]></programlisting>
+<mbean name="DefaultDomain:service=XADataSource,name=PostgresDB">
+ <attribute name="URL">jdbc:postgresql://host.domain.com/database</attribute>
+ <attribute name="JDBCUser">postgres</attribute>
+ <attribute name="Password">foo</attribute>
+</mbean>
+]]></programlisting>
<para>Note: You must include a user name and password. They can be
bogus if your PostgreSQL installation is configured to "trust" the machine
you're coming from, but you can't leave them out.</para>
</listitem>
@@ -573,27 +558,25 @@
create the table anyway. </literallayout></listitem>
<listitem><para>lib/ext:interclient-core.jar</para></listitem>
<listitem><para>jboss.properties</para>
- <programlisting>
- jdbc.drivers=interbase.interclient.Driver
+ <programlisting>jdbc.drivers=interbase.interclient.Driver
</programlisting>
</listitem>
<listitem><para> jboss.conf </para>
<programlisting><![CDATA[
- <MLET CODE="org.jboss.jdbc.XADataSourceLoader" ARCHIVE="jboss.jar"
CODEBASE="../lib/ext/">
- <ARG TYPE="java.lang.String" VALUE="InterBaseDB">
- <ARG TYPE="java.lang.String"
VALUE="org.jboss.minerva.xa.XADataSourceImpl">
- </MLET>
-
- ]]></programlisting>
+<MLET CODE="org.jboss.jdbc.XADataSourceLoader" ARCHIVE="jboss.jar"
CODEBASE="../lib/ext/">
+ <ARG TYPE="java.lang.String" VALUE="InterBaseDB">
+ <ARG TYPE="java.lang.String" VALUE="org.jboss.minerva.xa.XADataSourceImpl">
+</MLET>
+]]></programlisting>
</listitem>
<listitem><para>jboss.jcml</para>
<programlisting><![CDATA[
- <mbean name="DefaultDomain:service=XADataSource,name=InterBaseDB">
- <attribute
name="URL">jdbc:interbase://host.domain.com/path/to/database.gdb</attribute>
- <attribute name="JDBCUser">sysdba</attribute>
- <attribute name="Password">changeme</attribute>
- </mbean>
- ]]></programlisting>
+<mbean name="DefaultDomain:service=XADataSource,name=InterBaseDB">
+ <attribute
name="URL">jdbc:interbase://host.domain.com/path/to/database.gdb</attribute>
+ <attribute name="JDBCUser">sysdba</attribute>
+ <attribute name="Password">changeme</attribute>
+</mbean>
+]]></programlisting>
</listitem>
<listitem><para>CMP Type Mapping Names (for
jaws.xml):InterBase</para></listitem>
</itemizedlist>
@@ -605,44 +588,42 @@
<listitem><literallayout>Notes:
mySQL does not support transactions before version 3.23.15 (experimental
support). Check the consequences for your configuration.
get mm.mysql-2.0.2-bin.jar from http://www.worldserver.com/mm.mysql/
- copy the jar to lib/ext/ </literallayout></listitem>
+ copy the jar to <filename>lib/ext/</filename> </literallayout></listitem>
<listitem><para>jboss.properties</para>
- <programlisting>
- jdbc.drivers=org.gjt.mm.mysql.Driver
+ <programlisting>jdbc.drivers=org.gjt.mm.mysql.Driver
</programlisting>
</listitem>
<listitem><para> jboss.conf </para>
<programlisting><![CDATA[
- <MLET CODE="org.jboss.jdbc.XADataSourceLoader" ARCHIVE="jboss.jar"
CODEBASE="../../lib/ext/">
- <ARG TYPE="java.lang.String" VALUE="mySQL">
- <ARG TYPE="java.lang.String"
VALUE="org.jboss.minerva.xa.XADataSourceImpl">
- </MLET>
-
- ]]></programlisting>
+<MLET CODE="org.jboss.jdbc.XADataSourceLoader" ARCHIVE="jboss.jar"
CODEBASE="../../lib/ext/">
+ <ARG TYPE="java.lang.String" VALUE="mySQL">
+ <ARG TYPE="java.lang.String" VALUE="org.jboss.minerva.xa.XADataSourceImpl">
+</MLET>
+ ]]></programlisting>
</listitem>
<listitem><para>jboss.jcml</para>
<programlisting><![CDATA[
- At least adjust URL, JDBCUser and Password in the following:
+At least adjust URL, JDBCUser and Password in the following:
- <mbean name="DefaultDomain:service=XADataSource,name=mySQL">
- <attribute name="Properties"></attribute>
- <attribute name="URL">jdbc:mysql://host/databasename</attribute>
- <attribute name="GCMinIdleTime">1200000</attribute>
- <attribute name="JDBCUser">EnterDatabaseUserHere</attribute>
- <attribute name="MaxSize">10</attribute>
- <attribute name="Password">EnterDatabasePasswordHere</attribute>
- <attribute name="GCEnabled">false</attribute>
- <attribute name="InvalidateOnError">false</attribute>
- <attribute name="TimestampUsed">false</attribute>
- <attribute name="Blocking">true</attribute>
- <attribute name="GCInterval">120000</attribute>
- <attribute name="IdleTimeout">1800000</attribute>
- <attribute name="IdleTimeoutEnabled">false</attribute>
- <attribute name="LoggingEnabled">false</attribute>
- <attribute name="MaxIdleTimeoutPercent">1.0</attribute>
- <attribute name="MinSize">0</attribute>
- </mbean>
- ]]></programlisting>
+<mbean name="DefaultDomain:service=XADataSource,name=mySQL">
+ <attribute name="Properties"></attribute>
+ <attribute name="URL">jdbc:mysql://host/databasename</attribute>
+ <attribute name="GCMinIdleTime">1200000</attribute>
+ <attribute name="JDBCUser">EnterDatabaseUserHere</attribute>
+ <attribute name="MaxSize">10</attribute>
+ <attribute name="Password">EnterDatabasePasswordHere</attribute>
+ <attribute name="GCEnabled">false</attribute>
+ <attribute name="InvalidateOnError">false</attribute>
+ <attribute name="TimestampUsed">false</attribute>
+ <attribute name="Blocking">true</attribute>
+ <attribute name="GCInterval">120000</attribute>
+ <attribute name="IdleTimeout">1800000</attribute>
+ <attribute name="IdleTimeoutEnabled">false</attribute>
+ <attribute name="LoggingEnabled">false</attribute>
+ <attribute name="MaxIdleTimeoutPercent">1.0</attribute>
+ <attribute name="MinSize">0</attribute>
+</mbean>
+]]></programlisting>
</listitem>
<listitem><para>CMP Type Mapping Names (for
jaws.xml):mySQL</para></listitem>
</itemizedlist>
@@ -661,25 +642,24 @@
while JBoss can be stopped and started concurrently.
</literallayout></listitem>
<listitem><para>lib/ext:Sun JRE's rt.jar if your not running on a Sun
virtual machine, otherwise none </para> </listitem>
<listitem><para>jboss.properties</para>
- <programlisting>
- jdbc.drivers=sun.jdbc.odbc.JdbcOdbcDriver
+ <programlisting>jdbc.drivers=sun.jdbc.odbc.JdbcOdbcDriver
</programlisting>
</listitem>
<listitem><para> jboss.conf </para>
<programlisting><![CDATA[
- <MLET CODE="org.jboss.jdbc.XADataSourceLoader" ARCHIVE="jboss.jar"
CODEBASE="../lib/ext/">
- <ARG TYPE="java.lang.String" VALUE="JetEngineDB">
- <ARG TYPE="java.lang.String"
VALUE="org.jboss.minerva.xa.XADataSourceImpl">
- </MLET>
- ]]></programlisting>
+<MLET CODE="org.jboss.jdbc.XADataSourceLoader" ARCHIVE="jboss.jar"
CODEBASE="../lib/ext/">
+ <ARG TYPE="java.lang.String" VALUE="JetEngineDB">
+ <ARG TYPE="java.lang.String" VALUE="org.jboss.minerva.xa.XADataSourceImpl">
+</MLET>
+]]></programlisting>
</listitem>
<listitem><para>jboss.jcml</para>
<programlisting><![CDATA[
- <mbean name="DefaultDomain:service=XADataSource,name=JetEngineDB">
- <attribute name="URL">jdbc:odbc:ODBC datasource name</attribute>
- <attribute name="JDBCUser"></attribute>
- <attribute name="Password"></attribute>
- </mbean>
+<mbean name="DefaultDomain:service=XADataSource,name=JetEngineDB">
+ <attribute name="URL">jdbc:odbc:ODBC datasource name</attribute>
+ <attribute name="JDBCUser"></attribute>
+ <attribute name="Password"></attribute>
+</mbean>
]]></programlisting>
</listitem>
<listitem><para> Note: a default Jet Engine data source has no user and
password, therefor the JDBCUser and Password attributes are empty. If you need
@@ -691,5 +671,64 @@
</listitem>
</itemizedlist>
</section>
+<section><title>Changes for newer versions than 2.0 FINAL</title>
+<para>Author:
+ <author><firstname>Tobias</firstname><surname>Frech</surname></author>
+</para>
+<para>
+If your are using a newer version of JBoss than 2.0 FINAL then
+all you need to configure is the file jboss.jcml in your configuration
+directory (probably this is conf/default/). The following points describe
+where the information provided for the former different files now should be
inserted into <emphasis>jboss.jcml</emphasis>:
+</para>
+<itemizedlist>
+ <listitem><formalpara>
+ <title>jboss.properties:</title>
+ <para>In the
+ <literal><![CDATA[<mbean code="org.jboss.jdbc.JdbcProvider"...>]]>
+ </literal> add the
+ additional driver entry to the comma separated list inside the
+ <literal><![CDATA[<attribute name="Drivers">]]></literal> tag.</para>
+ </formalpara></listitem>
+ <listitem><formalpara>
+ <title>jboss.conf:</title>
+ <para>This information is no longer needed.</para>
+ </formalpara></listitem>
+ <listitem><formalpara>
+ <title>jboss.jcml:</title>
+ <para>Find the entry
+ <programlisting><![CDATA[
+<mbean code="org.jboss.jdbc.XADataSourceLoader"
+name="DefaultDomain:service=XADataSource,name=DefaultDS">
+...
+</mbean>
+]]></programlisting>
+ Either you want to change the default Datasource, then change the
+ contents of this entry directly, or you want to add a new
+ datasource. For the second
+ case create a copy of the whole entry after
+ the already existing one.
+ Now change the two occurences of the <quote>DefaultDS</quote>
+ string (in <quote>name=...</quote>
+ and attribute <quote>PoolName</quote>) to the name you want
+ to specify for your new datasource.
+ Also adjust at least the following entries according to your
+ configuration and to the data given in the example:
+ <programlisting><![CDATA[
+<attribute name="URL">jdbc:url/with/your/database/name/like/in/example</attribute>
+<attribute name="JDBCUser">DatabaseUserNameHere</attribute>
+<attribute name="Password">DatabasePasswordHere</attribute>
+]]></programlisting>
+ </para>
+ </formalpara></listitem>
+</itemizedlist>
+<para>
+All other information contained in the examples like which driver jar
+to copy to <filename>lib/ext/</filename> and using which type mapping in your beans
+jaws.xml should still be valid.
+</para>
+</section>
</section>
</chapter>
+
+
