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

Sun, 17 Dec 2000 12:13:49 -0800 

  User: tobias  
  Date: 00/12/17 12:24:27

  Modified:    manual   adv_config.html
  Added:       manual   msjetenginejawstypemapping.txt
  Log:
  added example section for M$ Jet Engine datasource
  
  Revision  Changes    Path
  1.3       +37 -0     newsite/manual/adv_config.html
  
  Index: adv_config.html
  ===================================================================
  RCS file: /products/cvs/ejboss/newsite/manual/adv_config.html,v
  retrieving revision 1.2
  retrieving revision 1.3
  diff -u -r1.2 -r1.3
  --- adv_config.html   2000/11/25 11:25:15     1.2
  +++ adv_config.html   2000/12/17 20:24:27     1.3
  @@ -673,6 +673,43 @@
         <li>CMP mapping in jaws.xml:<br>
         mySQL</li>
         </ul>
  +       <li>Microsoft Jet Engine/Access 97
  +         <ul> 
  +        <li>Driver Notes
  +          <ul> 
  +            <li>This example uses Sun's Jdbc-Odbc bridge. This type 1 JDBC driver 
can suffer from low performance but is very convenient if you start working with 
jBoss-Jet Engine. 
  +            </li> 
  +            <li>The ODBC data source can be created using Control Panel - ODBC Data 
Sources.
  +            </li>
  +            <li>Access and jBoss <em>cannot</em> open the datasource at the same 
time, but they can in turn (so you can use Access 97 as editor, viewer, bulk importer 
and exporter).
  +            </li>
  +          </ul> 
  +          <li>lib/ext: Sun JRE's rt.jar if your not running on a Sun virtual 
machine, otherwise none</li>
  +          <li>jboss.properties
  +             <pre> jdbc.drivers=sun.jdbc.odbc.JdbcOdbcDriver
  +             </pre> 
  +          </li> 
  +          <li>jboss.conf
  +             <pre> &lt;MLET CODE="org.jboss.jdbc.XADataSourceLoader" 
ARCHIVE="jboss.jar" CODEBASE="../lib/ext/"&gt;
  +        &lt;ARG TYPE="java.lang.String" VALUE="<b>JetEngineDB</b>"&gt;
  +        &lt;ARG TYPE="java.lang.String" 
VALUE="org.jboss.minerva.xa.XADataSourceImpl"&gt;
  +    &lt;/MLET&gt;
  + </pre> 
  +          </li> 
  +          <li>jboss.jcml
  +                     <pre> &lt;mbean 
name="DefaultDomain:service=XADataSource,name=<b>JetEngineDB</b>"&gt;
  +        &lt;attribute name="URL"&gt;jdbc:odbc:<b>ODBC datasource 
name</b>&lt;/attribute&gt;
  +        &lt;attribute name="JDBCUser"&gt;<b></b>&lt;/attribute&gt;
  +        &lt;attribute name="Password"&gt;<b></b>&lt;/attribute&gt;
  +    &lt;/mbean&gt;
  +                     </pre> 
  +Note: a default Jet Engine data source has no user and password, therefor the 
JDBCUser and Password attributes are empty. If you need a user or a password, see the 
other examples.
  +          </li> 
  +          <li>CMP Type Mapping Name (for jaws.xml): <code>MS Jet Engine</code><br>
  +             <a href="./msjetenginejawstypemapping.txt">You can download this 
mapping here.</a> Add the contents to your jaws.xml in the type-mappings section.
  +          </li> 
  +        </ul> 
  +      </li>   
       </ul>
   
   
  
  
  
  1.1                  newsite/manual/msjetenginejawstypemapping.txt
  
  Index: msjetenginejawstypemapping.txt
  ===================================================================
        <type-mapping>
                <name>MS Jet Engine</name>
                <mapping>
                        <java-type>java.lang.Integer</java-type>
                        <jdbc-type>INTEGER</jdbc-type>
                        <sql-type>INTEGER</sql-type>
                </mapping>
                <mapping>
                        <java-type>java.lang.Character</java-type>
                        <jdbc-type>CHAR</jdbc-type>
                        <sql-type>CHAR(2)</sql-type>
                </mapping>
                <mapping>
                        <java-type>java.lang.Short</java-type>
                        <jdbc-type>SMALLINT</jdbc-type>
                        <sql-type>SMALLINT</sql-type>
                </mapping>
                <mapping>
                        <java-type>java.lang.Double</java-type>
                        <jdbc-type>DOUBLE</jdbc-type>
                        <sql-type>DOUBLE</sql-type>
                </mapping>
                <mapping>
                        <java-type>java.lang.Long</java-type>
                        <jdbc-type>DECIMAL</jdbc-type>
                        <sql-type>LONG</sql-type>
                </mapping>
                <mapping>
                        <java-type>java.lang.String</java-type>
                        <jdbc-type>VARCHAR</jdbc-type>
                        <sql-type>VARCHAR(255)</sql-type>
                </mapping>
                <mapping>
                        <java-type>java.lang.Object</java-type>
                        <jdbc-type>JAVA_OBJECT</jdbc-type>
                        <sql-type>IMAGE</sql-type>
                </mapping>
                <mapping>
                        <java-type>java.lang.Byte</java-type>
                        <jdbc-type>TINYINT</jdbc-type>
                        <sql-type>SMALLINT</sql-type>
                </mapping>
                <mapping>
                        <java-type>java.sql.TimeStamp</java-type>
                        <jdbc-type>TIMESTAMP</jdbc-type>
                        <sql-type>TIMESTAMP</sql-type>
                </mapping>
                <mapping>
                        <java-type>java.util.Date</java-type>
                        <jdbc-type>DATE</jdbc-type>
                        <sql-type>DATETIME</sql-type>
                </mapping>
                <mapping>
                        <java-type>java.lang.Boolean</java-type>
                        <jdbc-type>BIT</jdbc-type>
                        <sql-type>BIT</sql-type>
                </mapping>
                <mapping>
                        <java-type>java.lang.Float</java-type>
                        <jdbc-type>FLOAT</jdbc-type>
                        <sql-type>FLOAT</sql-type>
                </mapping>
        </type-mapping>

Reply via email to