Aaron, how far are you from FINAL???
marc
|-----Original Message-----
|From: [EMAIL PROTECTED]
|[mailto:[EMAIL PROTECTED]]On Behalf Of jBoss CVS
|Development
|Sent: Friday, October 20, 2000 11:20 AM
|To: [EMAIL PROTECTED]
|Subject: [jBoss-Dev] CVS update: jbossweb/manual adv_config.html
|
|
| 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/softwa
|re_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.j
|ar</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>databa
|se</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>
|
|
|
|
|
|
