[jBoss-Dev] CVS update: newsite/manual adv_config.html

[jBoss CVS Development]

  User: tobias  
  Date: 00/11/25 03:25:15

  Modified:    manual   adv_config.html
  Log:
  added configuration example for mySQL. Fixes bug #220.
  
  Revision  Changes    Path
  1.2       +41 -0     newsite/manual/adv_config.html
  
  Index: adv_config.html
  ===================================================================
  RCS file: /products/cvs/ejboss/newsite/manual/adv_config.html,v
  retrieving revision 1.1
  retrieving revision 1.2
  diff -u -r1.1 -r1.2
  --- adv_config.html   2000/11/12 20:32:05     1.1
  +++ adv_config.html   2000/11/25 11:25:15     1.2
  @@ -632,6 +632,47 @@
             <li>CMP Type Mapping Name (for jaws.xml): <code>InterBase</code></li>
           </ul>
         </li>
  +
  +
  +      <li><a href="http://www.mysql.com">mySQL</a> 3.23.24-beta
  +      <ul>
  +      <li>Notes:<br>
  +      mySQL does not support transactions before version 3.23.15 (experimental 
support). Check the consequences for your configuration.
  +      <li>get mm.mysql-2.0.2-bin.jar from <a 
href="http://www.worldserver.com/mm.mysql/">http://www.worldserver.com/mm.mysql/</a><br>
  +      copy the jar to lib/ext/<p></li>
  +      <li>jboss.properties:<br>
  +      <code>jdbc.drivers=org.gjt.mm.mysql.Driver</code><p></li>
  +      <li>jboss.conf:<br>
  +      <pre>&lt;MLET CODE="org.jboss.jdbc.XADataSourceLoader" ARCHIVE="jboss.jar"
  +CODEBASE="../../lib/ext/"&gt;
  +    &lt;ARG TYPE="java.lang.String" VALUE="mySQL"&gt;
  +    &lt;ARG TYPE="java.lang.String" 
VALUE="org.jboss.minerva.xa.XADataSourceImpl"&gt;
  +&lt;/MLET&gt;
  +</pre></li>
  +      <li>jboss.jcml:<br>
  +At least adjust URL, JDBCUser and Password in the following:
  +<pre>&lt;mbean name="DefaultDomain:service=XADataSource,name=mySQL"&gt;
  +       &lt;attribute name="Properties"&gt;&lt;/attribute&gt;
  +       &lt;attribute 
name="URL"&gt;jdbc:mysql:<b>//host/databasename</b>&lt;/attribute&gt;
  +       &lt;attribute name="GCMinIdleTime"&gt;1200000&lt;/attribute&gt;
  +       &lt;attribute 
name="JDBCUser"&gt;<b>EnterDatabaseUserHere</b>&lt;/attribute&gt;
  +       &lt;attribute name="MaxSize"&gt;10&lt;/attribute&gt;
  +       &lt;attribute 
name="Password"&gt;<b>EnterDatabasePasswordHere</b>&lt;/attribute&gt;
  +       &lt;attribute name="GCEnabled"&gt;false&lt;/attribute&gt;
  +       &lt;attribute name="InvalidateOnError"&gt;false&lt;/attribute&gt;
  +       &lt;attribute name="TimestampUsed"&gt;false&lt;/attribute&gt;
  +       &lt;attribute name="Blocking"&gt;true&lt;/attribute&gt;
  +       &lt;attribute name="GCInterval"&gt;120000&lt;/attribute&gt;
  +       &lt;attribute name="IdleTimeout"&gt;1800000&lt;/attribute&gt;
  +       &lt;attribute name="IdleTimeoutEnabled"&gt;false&lt;/attribute&gt;
  +       &lt;attribute name="LoggingEnabled"&gt;false&lt;/attribute&gt;
  +       &lt;attribute name="MaxIdleTimeoutPercent"&gt;1.0&lt;/attribute&gt;
  +       &lt;attribute name="MinSize"&gt;0&lt;/attribute&gt;
  +&lt;/mbean&gt;
  +</pre></li>
  +      <li>CMP mapping in jaws.xml:<br>
  +      mySQL</li>
  +      </ul>
       </ul>