User: mulder
Date: 00/10/20 11:19:46
Modified: manual adv_config.html
Log:
Update supported database list, and add comments to the DB products
in the examples.
Revision Changes Path
1.15 +54 -29 jbossweb/manual/adv_config.html
Index: adv_config.html
===================================================================
RCS file: /products/cvs/ejboss/jbossweb/manual/adv_config.html,v
retrieving revision 1.14
retrieving revision 1.15
diff -u -r1.14 -r1.15
--- adv_config.html 2000/10/18 21:22:39 1.14
+++ adv_config.html 2000/10/20 18:19:45 1.15
@@ -15,7 +15,7 @@
data sources for your EJBs. You must create a data source for
CMP entity beans, and it is the recommended way to interact with
a database for BMP entity beans and session beans.</p>
- <p>jBoss data source provide database connection pooling. This
+ <p>jBoss data sources provide database connection pooling. This
means that when your application closes a connection, it is not
<em>really</em> closed, just returned to the "ready" state. The
next time your application requests a database connection, it may
@@ -36,11 +36,12 @@
<h4><a NAME="cmp">Mappings Available for CMP Entities</a></h4>
<p>If we have not worked with a database product before we may need
to work with you to generate a type mapping if you plan to use
- container managed persistence. The currently available mappings
- include PostgreSQL, InstantDB, Hypersonic SQL, PointBase, Oracle,
- SOLID, mySQL, MS SQLSERVER, Sybase, and DB2/400. If you would
- like to support CMP for another DBMS, or have a working mapping
- to share, please contact the jBoss
+ 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
<a HREF="http://www.jboss.org/mailing.htm">Mailing List</a>.</p>
<h3><a NAME="installing">Installing JDBC Drivers</a></h3>
@@ -322,6 +323,15 @@
<ul>
<li>Oracle 7.x,8.x,8i
<ul>
+ <li>Driver Notes
+ <ul>
+ <li>For CMP Entity Beans, Oracle 7 only allows 1 serialized
+ Java Object per bean (column type LONG RAW). Oracle 8
+ does not have this limitation (column type BLOB).</li>
+ <li>Extreme Float or Double values will cause
+ SQLExceptions</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>
@@ -345,6 +355,8 @@
</mbean>
</pre>
</li>
+ <li>CMP Type Mapping Names (for jaws.xml):
+ <code>Oracle7</code> and <code>Oracle8</code></li>
</ul>
</li>
@@ -372,6 +384,7 @@
</mbean>
</pre>
</li>
+ <li>CMP Type Mapping Name (for jaws.xml): <code>Hypersonic SQL</code></li>
</ul>
</li>
@@ -390,6 +403,7 @@
<pre>
</pre>
</li>
+ <li>CMP Type Mapping Name (for jaws.xml): <code></code></li>
</ul>
</li>
@@ -418,6 +432,7 @@
</mbean>
</pre>
</li>
+ <li>CMP Type Mapping Name (for jaws.xml): <code>DB2/400</code></li>
</ul>
</li>
@@ -438,24 +453,25 @@
variables of type <code>byte</code> or
<code>short</code>, so they will be serialized (column
type must be <code>varbinary</code> or
- <code>image</code>).</li>
+ <code>image</code>). We recommend you use
+ <code>int</code> variables instead to avoid this.</li>
</ul>
</li>
<li>lib/ext: <a
HREF="http://www.sybase.com/detail/1,3693,1009796,00.html">jconn2.jar</a></li>
- <li>jboss.properties
+ <li>jboss.properties
<pre>
jdbc.drivers=com.sybase.jdbc2.jdbc.SybDriver
</pre>
- </li>
- <li>jboss.conf
+ </li>
+ <li>jboss.conf
<pre>
<MLET CODE="org.jboss.jdbc.XADataSourceLoader" ARCHIVE="jboss.jar"
CODEBASE="../lib/ext/">
<ARG TYPE="java.lang.String" VALUE="<b>SybaseDB</b>">
<ARG TYPE="java.lang.String"
VALUE="org.jboss.minerva.xa.XADataSourceImpl">
</MLET>
</pre>
- </li>
- <li>jboss.jcml
+ </li>
+ <li>jboss.jcml
<pre>
<mbean name="DefaultDomain:service=XADataSource,name=<b>SybaseDB</b>">
<attribute
name="URL">jdbc:sybase:Tds:<b>host.domain.com</b>:4100/<b>database</b></attribute>
@@ -463,28 +479,35 @@
<attribute name="JDBCUser"><b>username</b></attribute>
</mbean>
</pre>
- </li>
- </ul>
+ </li>
+ <li>CMP Type Mapping Name (for jaws.xml): <code>Sybase</code></li>
+ </ul>
</li>
<li>PostgreSQL 7.x
<ul>
+ <li>Driver Notes
+ <ul>
+ <li>Extreme Java "long" values will cause SQLExceptions
+ and possibly corruption of the entire record.</li>
+ </ul>
+ </li>
<li>lib/ext: <a
HREF="http://www.postgresql.org/sites.html">jdbc7.0-1.2.jar</a></li>
- <li>jboss.properties
+ <li>jboss.properties
<pre>
jdbc.drivers=org.postgresql.Driver
</pre>
- </li>
- <li>jboss.conf
+ </li>
+ <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="org.jboss.minerva.xa.XADataSourceImpl">
</MLET>
</pre>
- </li>
- <li>jboss.jcml
- <p>Note: You must include a user name and password. They can be
+ </li>
+ <li>jboss.jcml
+ <p>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.</p>
<pre>
@@ -494,26 +517,28 @@
<attribute name="Password"><b>foo</b></attribute>
</mbean>
</pre>
- </li>
- </ul>
+ </li>
+ <li>CMP Type Mapping Name (for jaws.xml): <code>PostgreSQL</code></li>
+ </ul>
</li>
<li>Interbase (<i>Forthcoming...</i>)
<ul>
<li>lib/ext: <a
HREF="http://www.borland.com/interbase/downloads/">interclient-core.jar</a></li>
- <li>jboss.properties
+ <li>jboss.properties
<pre>
</pre>
- </li>
- <li>jboss.conf
+ </li>
+ <li>jboss.conf
<pre>
</pre>
- </li>
- <li>jboss.jcml
+ </li>
+ <li>jboss.jcml
<pre>
</pre>
- </li>
- </ul>
+ </li>
+ <li>CMP Type Mapping Name (for jaws.xml): <code></code></li>
+ </ul>
</li>
</ul>
