EJB使用(JBOSS+MYSQL的JNDI配置)

java 代码

根据mysql_ds.xml
<?xml version="1.0" encoding="UTF-8"?>

<!-- $Id: mysql-ds.xml 41016 2006-02-07 14:23:00Z acoliver $ -->
<!--  Datasource config for MySQL using 3.0.9 available from:
http://www.mysql.com/downloads/api-jdbc-stable.html
-->

<datasources>
  <local-tx-datasource>
    <jndi-name>MySqlDS</jndi-name>
    <connection-url>jdbc:mysql://localhost:3306/usertest</connection-url>
    <driver-class>org.gjt.mm.mysql.Driver</driver-class>
    <user-name>root</user-name>
    <password>root</password>
    <exception-sorter-class-name>org.jboss.resource.adapter.jdbc.vendor.MySQLExceptionSorter</exception-sorter-class-name>
    <!-- should only be used on drivers after 3.22.1 with "ping" support
    <valid-connection-checker-class-name>org.jboss.resource.adapter.jdbc.vendor.MySQLValidConnectionChecker</valid-connection-checker-class-name>
    -->
    <!-- sql to call when connection is created
    <new-connection-sql>some arbitrary sql</new-connection-sql>
      -->
    <!-- sql to call on an existing pooled connection when it is obtained from pool - MySQLValidConnectionChecker is preferred for newer drivers
    <check-valid-connection-sql>some arbitrary sql</check-valid-connection-sql>
      -->

    <!-- corresponding type-mapping in the standardjbosscmp-jdbc.xml (optional) -->
    <metadata>
       <type-mapping>mySQL</type-mapping>
    </metadata>
  </local-tx-datasource>
</datasources>

配制jbosscmp-jdbc.xml
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE jbosscmp-jdbc PUBLIC "-//JBoss//DTD JBOSSCMP-JDBC 4.0//EN" "http://www.jboss.org/j2ee/dtd/jbosscmp-jdbc_4_0.dtd">

<jbosscmp-jdbc>
   <defaults>
     <datasource>java:/MySqlDS</datasource>
     <datasource-mapping>mySQL</datasource-mapping>
     <create-table>false</create-table>
       <alter-table>false</alter-table>
     <remove-table>false</remove-table>
     <preferred-relation-mapping>foreign-key</preferred-relation-mapping>
   </defaults>

   <enterprise-beans>

     <!--
       To add beans that you have deployment descriptor info for, add
       a file to your XDoclet merge directory called jbosscmp-jdbc-beans.xml
       that contains the <entity></entity> markup for those beans.
     -->

      <entity>
         <ejb-name>User</ejb-name>
         <datasource>java:/MySqlDS</datasource>
         <datasource-mapping>mySQL</datasource-mapping>
         <create-table>false</create-table>
         <remove-table>false</remove-table>
         <table-name>userinfo</table-name>

         <cmp-field>
            <field-name>user</field-name>
            <read-only>false</read-only>
            <column-name>User</column-name>

            <jdbc-type>VARCHAR</jdbc-type>
            <sql-type>VARCHAR(11)</sql-type>

        </cmp-field>
         <cmp-field>
            <field-name>password</field-name>
            <read-only>false</read-only>
            <column-name>Password</column-name>

            <jdbc-type>VARCHAR</jdbc-type>
            <sql-type>VARCHAR(12)</sql-type>

        </cmp-field>
         <cmp-field>
            <field-name>level</field-name>
            <read-only>false</read-only>
            <column-name>Level</column-name>

            <jdbc-type>INTEGER</jdbc-type>
            <sql-type>INTEGER</sql-type>

        </cmp-field>
         <cmp-field>
            <field-name>email</field-name>
            <read-only>false</read-only>
            <column-name>Email_address</column-name>

            <jdbc-type>VARCHAR</jdbc-type>
            <sql-type>VARCHAR(50)</sql-type>

        </cmp-field>

<!-- jboss 3.2 features -->
<!-- optimistic locking does not express the exclusions needed -->
      </entity>

   </enterprise-beans>

</jbosscmp-jdbc>
其中jboss-jdbc.xml里的<datasource-mapping>的值与mysql_ds.xml中<type-mapping>中的值相同，区分大小写

分享到：

报表系统的学习 | oscache学习(三)

• 2007-08-07 12:34
• 浏览 3295
• 评论(0)
• 查看更多