User: mulder
Date: 00/10/11 16:42:08
Modified: manual adv_config.html
Log:
Add PostgreSQL configuration example.
Revision Changes Path
1.10 +85 -46 jbossweb/manual/adv_config.html
Index: adv_config.html
===================================================================
RCS file: /products/cvs/ejboss/jbossweb/manual/adv_config.html,v
retrieving revision 1.9
retrieving revision 1.10
diff -u -r1.9 -r1.10
--- adv_config.html 2000/10/09 21:35:56 1.9
+++ adv_config.html 2000/10/11 23:42:08 1.10
@@ -222,10 +222,8 @@
that requests a connection will wait until one is available.
If set to <strong>false</strong>, then the pool will return
null immediately (and the client may retry).<br>
- <i>Note: Blocking is set to <strong>true</strong> by default
- and may only be changed for DataSources that are accessed
- directly by clients code that is capable of handling the
- returned null in the right way!</i></td>
+ <i>Note: If you set blocking to false, your client must be
+ prepared to handle null results!</i></td>
<td>true</td>
</tr>
<tr>
@@ -321,77 +319,105 @@
version, different JDBC driver, etc. The parameters you are
most likely to need to change are in <b>bold</b>.</p>
<ul>
- <li>Oracle
+ <li>Oracle 7.x,8.x,8i
<ul>
<li>lib/ext: <a
HREF="http://technet.oracle.com/software/tech/java/sqlj_jdbc/software_index.htm">classes12.zip</a></li>
- <li>jboss.properties
+ <li>jboss.properties
<pre>
-jdbc.drivers=oracle.jdbc.driver.OracleDriver
+ jdbc.drivers=oracle.jdbc.driver.OracleDriver
</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>OracleDB</b>">
- <ARG TYPE="java.lang.String"
VALUE="org.jboss.minerva.xa.XADataSourceImpl">
-</MLET>
+ <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="org.jboss.minerva.xa.XADataSourceImpl">
+ </MLET>
</pre>
- </li>
- <li>jboss.jcml
+ </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="Password"><b>scott</b></attribute>
- <attribute name="JDBCUser"><b>tiger</b></attribute>
- </mbean>
+ <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="Password"><b>scott</b></attribute>
+ <attribute name="JDBCUser"><b>tiger</b></attribute>
+ </mbean>
</pre>
- </li>
- </ul>
+ </li>
+ </ul>
</li>
<li>Hypersonic</li>
<ul>
<li>lib/ext: <a
HREF="http://hsql.oron.ch/hSqlDownload.html">hsql.jar</a></li>
- <li>jboss.properties
+ <li>jboss.properties
<pre>
-jdbc.drivers=org.hsql.jdbcDriver
+ jdbc.drivers=org.hsql.jdbcDriver
</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>Hypersonic</b>">
- <ARG TYPE="java.lang.String"
VALUE="org.jboss.minerva.xa.XADataSourceImpl">
-</MLET>
+ <MLET CODE="org.jboss.jdbc.XADataSourceLoader" ARCHIVE="jboss.jar"
CODEBASE="../lib/ext/">
+ <ARG TYPE="java.lang.String" VALUE="<b>Hypersonic</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>Hypersonic</b>">
- <attribute
name="URL">jdbc:HypersonicSQL:hsql://<b>localhost</b></attribute>
- <attribute name="JDBCUser"><b>sa</b></attribute>
- </mbean>
+ <mbean name="DefaultDomain:service=XADataSource,name=<b>Hypersonic</b>">
+ <attribute
name="URL">jdbc:HypersonicSQL:hsql://<b>localhost</b></attribute>
+ <attribute name="JDBCUser"><b>sa</b></attribute>
+ </mbean>
</pre>
- </li>
- </ul>
+ </li>
+ </ul>
</li>
<li>DB/2 (<i>Forthcoming...</i>)
<ul>
<li>lib/ext: <a
HREF="http://www-4.ibm.com/software/data/db2/java/">unknown.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>
- </ul>
+
+ <li>DB2/400
+ <ul>
+ <li>lib/ext: <a
HREF="http://www-4.ibm.com/software/data/db2/java/">jt400.jar</a></li>
+ <li>jboss.properties
+<pre>
+ jdbc.drivers=com.ibm.as400.access.AS400JDBCDriver
+</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>AS400</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>AS400</b>">
+ <attribute name="URL">jdbc:as400://<b>hostname</b></attribute>
+ <attribute name="JDBCUser"><b>user</b></attribute>
+ <attribute name="Password"><b>pw</b></attribute>
+ </mbean>
+</pre>
+ </li>
+ </ul>
</li>
<li>Sybase (<i>Forthcoming...</i>)
@@ -412,19 +438,32 @@
</ul>
</li>
- <li>PostgreSQL (<i>Forthcoming...</i>)
+ <li>PostgreSQL 7.x
<ul>
<li>lib/ext: <a
HREF="http://www.postgresql.org/sites.html">jdbc7.0-1.2.jar</a></li>
<li>jboss.properties
<pre>
+ jdbc.drivers=org.postgresql.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="PostgresDB">
+ <ARG TYPE="java.lang.String"
VALUE="org.jboss.minerva.xa.XADataSourceImpl">
+ </MLET>
</pre>
</li>
<li>jboss.jcml
-<pre>
+ <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>
+ <mbean name="DefaultDomain:service=XADataSource,name=<b>PostgresDB</b>">
+ <attribute
name="URL">jdbc:postgresql://<b>host.domain.com</b>/<b>database</b></attribute>
+ <attribute name="JDBCUser"><b>postgres</b></attribute>
+ <attribute name="Password"><b>foo</b></attribute>
+ </mbean>
</pre>
</li>
</ul>
