User: mulder
Date: 00/10/21 18:57:22
Modified: manual adv_config.html warning.html
Log:
Final DB configuration examples (Oracle XADataSource and InterBase).
Revision Changes Path
1.16 +100 -12 jbossweb/manual/adv_config.html
Index: adv_config.html
===================================================================
RCS file: /products/cvs/ejboss/jbossweb/manual/adv_config.html,v
retrieving revision 1.15
retrieving revision 1.16
diff -u -r1.15 -r1.16
--- adv_config.html 2000/10/20 18:19:45 1.15
+++ adv_config.html 2000/10/22 01:57:21 1.16
@@ -38,10 +38,10 @@
to work with you to generate a type mapping if you plan to use
container managed persistence. The mappings we have tested
extensively include PostgreSQL, InstantDB, Hypersonic SQL, Oracle 7,
- Oracle 8, and Sybase. Additional contributed mappings include
- PointBase, SOLID, mySQL, MS SQL Server, and DB2/400. If you would
- like to support CMP for another DBMS, or have a working mapping to
- share, please contact the jBoss
+ Oracle 8, Sybase, DB2, and InterBase. Additional contributed
+ mappings include PointBase, SOLID, mySQL, MS SQL Server, and
+ DB2/400. If you would like to support CMP for another DBMS, or
+ have a working mapping to share, please contact the jBoss
<a HREF="http://www.jboss.org/mailing.htm">Mailing List</a>.</p>
<h3><a NAME="installing">Installing JDBC Drivers</a></h3>
@@ -321,7 +321,7 @@
version, different JDBC driver, etc. The parameters you are
most likely to need to change are in <b>bold</b>.</p>
<ul>
- <li>Oracle 7.x,8.x,8i
+ <li>Oracle 7.x,8.x,8i with JDBC 1/2 Wrapper
<ul>
<li>Driver Notes
<ul>
@@ -360,6 +360,45 @@
</ul>
</li>
+ <li>Oracle 8i with native JDBC 2 Optional Package XADataSource
+ <ul>
+ <li>Driver Notes
+ <ul>
+ <li>Extreme Float or Double values will cause
+ SQLExceptions</li>
+ <li>The Oracle XADataSource requires the Oracle Xid
+ implementation. Other vendor's XADataSource
+ implementation may or may not be able to
+ interoperate.</li>
+ </ul>
+ </li>
+ <li>lib/ext: <a
HREF="http://technet.oracle.com/software/tech/java/sqlj_jdbc/software_index.htm">classes12.zip</a></li>
+ <li>jboss.properties
+<pre>
+jboss.xa.xidclass=oracle.jdbc.xa.OracleXid
+</pre>
+ </li>
+ <li>jboss.conf
+<pre>
+ <MLET CODE="org.jboss.jdbc.XADataSourceLoader" ARCHIVE="jboss.jar"
CODEBASE="../lib/ext/">
+ <ARG TYPE="java.lang.String" VALUE="<b>OracleDB</b>">
+ <ARG TYPE="java.lang.String"
VALUE="oracle.jdbc.xa.client.OracleXADataSource">
+ </MLET>
+</pre>
+ </li>
+ <li>jboss.jcml
+<pre>
+ <mbean name="DefaultDomain:service=XADataSource,name=<b>OracleDB</b>">
+ <attribute
name="URL">jdbc:oracle:thin:@<b>host.domain.com</b>:1521:<b>instance</b></attribute>
+ <attribute name="JDBCUser"><b>scott</b></attribute>
+ <attribute name="Password"><b>tiger</b></attribute>
+ </mbean>
+</pre>
+ </li>
+ <li>CMP Type Mapping Names (for jaws.xml): <code>Oracle8</code></li>
+ </ul>
+ </li>
+
<li>Hypersonic</li>
<ul>
<li>lib/ext: <a
HREF="http://hsql.oron.ch/hSqlDownload.html">hsql.jar</a></li>
@@ -388,22 +427,51 @@
</ul>
</li>
- <li>DB/2 (<i>Forthcoming...</i>)
+ <li>DB2 7.1
<ul>
- <li>lib/ext: <a
HREF="http://www-4.ibm.com/software/data/db2/java/">unknown.jar</a></li>
+ <li>Driver Notes
+ <ul>
+ <li>DB2 does not support variables of type "byte", so with CMP
+ entities they will be serialized. We recommend that you
+ use short or int variables to avoid this.</li>
+ <li>For CMP entities, serialized objects are stored as type
+ BLOB(n), where n is 2000 by default. If you plan to
+ serialize objects larger than 2000 bytes, you will need
+ to alter the mapping or create the table manually.</li>
+ <li>Extreme Float or Double values will cause SQLExceptions
+ and may corrupt the driver so that further actions
+ fail.</li>
+ <li>The "net" driver (type 4) is preferred over the "app"
+ driver (type 2), though only the "app" driver has a
+ native XADataSource implementation. To use the "net"
+ driver, you must run the "<code>db2jstrt [port]</code>"
+ tool on your DB server.</li>
+ </ul>
+ </li>
+ <li>lib/ext: <a
HREF="http://www-4.ibm.com/software/data/db2/java/">db2java.zip</a></li>
<li>jboss.properties
<pre>
+jdbc.drivers=COM.ibm.db2.jdbc.net.DB2Driver
</pre>
</li>
<li>jboss.conf
<pre>
+ <MLET CODE="org.jboss.jdbc.XADataSourceLoader" ARCHIVE="jboss.jar"
CODEBASE="../lib/ext/">
+ <ARG TYPE="java.lang.String" VALUE="<b>DB2</b>">
+ <ARG TYPE="java.lang.String"
VALUE="org.jboss.minerva.xa.XADataSourceImpl">
+ </MLET>
</pre>
</li>
<li>jboss.jcml
<pre>
+ <mbean name="DefaultDomain:service=XADataSource,name=<b>DB2</b>">
+ <attribute
name="URL">jdbc:db2://<b>host.domain.com</b>:<b>port</b>/<b>database</b></attribute>
+ <attribute name="JDBCUser"><b>username</b></attribute>
+ <attribute name="Password"><b>password</b></attribute>
+ </mbean>
</pre>
</li>
- <li>CMP Type Mapping Name (for jaws.xml): <code></code></li>
+ <li>CMP Type Mapping Name (for jaws.xml): <code>DB2</code></li>
</ul>
</li>
@@ -489,7 +557,8 @@
<li>Driver Notes
<ul>
<li>Extreme Java "long" values will cause SQLExceptions
- and possibly corruption of the entire record.</li>
+ and may corrupt the driver so that further actions
+ fail.</li>
</ul>
</li>
<li>lib/ext: <a
HREF="http://www.postgresql.org/sites.html">jdbc7.0-1.2.jar</a></li>
@@ -501,7 +570,7 @@
<li>jboss.conf
<pre>
<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="<b>PostgresDB</b>">
<ARG TYPE="java.lang.String"
VALUE="org.jboss.minerva.xa.XADataSourceImpl">
</MLET>
</pre>
@@ -522,22 +591,41 @@
</ul>
</li>
- <li>Interbase (<i>Forthcoming...</i>)
+ <li>Interbase 6.x
<ul>
+ <li>Driver Notes
+ <ul>
+ <li>For CMP entity beans, serialized Java Objects are
+ limited to 2000 bytes by default in automatically
+ generated tables. You may increase this limit by
+ changing the mapping or creating the table
+ manually.</li>
+ </ul>
+ </li>
<li>lib/ext: <a
HREF="http://www.borland.com/interbase/downloads/">interclient-core.jar</a></li>
<li>jboss.properties
<pre>
+jdbc.drivers=interbase.interclient.Driver
</pre>
</li>
<li>jboss.conf
<pre>
+ <MLET CODE="org.jboss.jdbc.XADataSourceLoader" ARCHIVE="jboss.jar"
CODEBASE="../lib/ext/">
+ <ARG TYPE="java.lang.String" VALUE="<b>InterBaseDB</b>">
+ <ARG TYPE="java.lang.String"
VALUE="org.jboss.minerva.xa.XADataSourceImpl">
+ </MLET>
</pre>
</li>
<li>jboss.jcml
<pre>
+ <mbean name="DefaultDomain:service=XADataSource,name=<b>InterBaseDB</b>">
+ <attribute
name="URL">jdbc:interbase://<b>host.domain.com/path/to/database.gdb</b></attribute>
+ <attribute name="JDBCUser"><b>sysdba</b></attribute>
+ <attribute name="Password"><b>changeme</b></attribute>
+ </mbean>
</pre>
</li>
- <li>CMP Type Mapping Name (for jaws.xml): <code></code></li>
+ <li>CMP Type Mapping Name (for jaws.xml): <code>InterBase</code></li>
</ul>
</li>
</ul>
1.12 +1 -2 jbossweb/manual/warning.html
Index: warning.html
===================================================================
RCS file: /products/cvs/ejboss/jbossweb/manual/warning.html,v
retrieving revision 1.11
retrieving revision 1.12
diff -u -r1.11 -r1.12
--- warning.html 2000/10/18 18:07:43 1.11
+++ warning.html 2000/10/22 01:57:22 1.12
@@ -43,8 +43,6 @@
<ul>
<li>Need DB Security Configuration</li>
<li>Need JMS Configuration</li>
- <li>Need specific configuration examples for DB/2 and
- Interbase.</li>
<li>Need to try dynamic classloading to verify directions
and get an exact procedure with security policy settings
that are required.</li>
@@ -55,6 +53,7 @@
<li>If you change the port for the webserver on 8083, confirm
that clients can access it automatically. Have verbal
confirmation, need to try.</li>
+ <li>Add directions for changing RMI object port 4444</li>
</ul>
</li>
<li>Starting & Stopping jBoss
