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

java 代码

1. 根据mysql_ds.xml   
2. <?xml version="1.0" encoding="UTF-8"?>   
3.   
4. <!-- $Id: mysql-ds.xml 41016 2006-02-07 14:23:00Z acoliver $ -->   
5. <!--  Datasource config for MySQL using 3.0.9 available from:   
6. http://www.mysql.com/downloads/api-jdbc-stable.html   
7. -->   
8.   
9. <datasources>   
10.   <local-tx-datasource>   
11.     <jndi-name>MySqlDS</jndi-name>   
12.     <connection-url>jdbc:mysql://localhost:3306/usertest</connection-url>   
13.     <driver-class>org.gjt.mm.mysql.Driver</driver-class>   
14.     <user-name>root</user-name>   
15.     <password>root</password>   
16.     <exception-sorter-class-name>org.jboss.resource.adapter.jdbc.vendor.MySQLExceptionSorter</exception-sorter-class-name>   
17.     <!-- should only be used on drivers after 3.22.1 with "ping" support   
18.     <valid-connection-checker-class-name>org.jboss.resource.adapter.jdbc.vendor.MySQLValidConnectionChecker</valid-connection-checker-class-name>   
19.     -->   
20.     <!-- sql to call when connection is created   
21.     <new-connection-sql>some arbitrary sql</new-connection-sql>   
22.       -->   
23.     <!-- sql to call on an existing pooled connection when it is obtained from pool - MySQLValidConnectionChecker is preferred for newer drivers   
24.     <check-valid-connection-sql>some arbitrary sql</check-valid-connection-sql>   
25.       -->   
26.   
27.     <!-- corresponding type-mapping in the standardjbosscmp-jdbc.xml (optional) -->   
28.     <metadata>   
29.        <type-mapping>mySQL</type-mapping>   
30.     </metadata>   
31.   </local-tx-datasource>   
32. </datasources>   
33.   
34. 配制jbosscmp-jdbc.xml   
35. <?xml version="1.0" encoding="UTF-8"?>   
36. <!DOCTYPE jbosscmp-jdbc PUBLIC "-//JBoss//DTD JBOSSCMP-JDBC 4.0//EN" "http://www.jboss.org/j2ee/dtd/jbosscmp-jdbc_4_0.dtd">   
37.   
38. <jbosscmp-jdbc>   
39.    <defaults>   
40.      <datasource>java:/MySqlDS</datasource>   
41.      <datasource-mapping>mySQL</datasource-mapping>   
42.      <create-table>false</create-table>   
43.        <alter-table>false</alter-table>   
44.      <remove-table>false</remove-table>   
45.      <preferred-relation-mapping>foreign-key</preferred-relation-mapping>   
46.    </defaults>   
47.   
48.    <enterprise-beans>   
49.   
50.      <!--   
51.        To add beans that you have deployment descriptor info for, add   
52.        a file to your XDoclet merge directory called jbosscmp-jdbc-beans.xml   
53.        that contains the <entity></entity> markup for those beans.   
54.      -->   
55.   
56.       <entity>   
57.          <ejb-name>User</ejb-name>   
58.          <datasource>java:/MySqlDS</datasource>   
59.          <datasource-mapping>mySQL</datasource-mapping>   
60.          <create-table>false</create-table>   
61.          <remove-table>false</remove-table>   
62.          <table-name>userinfo</table-name>   
63.   
64.          <cmp-field>   
65.             <field-name>user</field-name>   
66.             <read-only>false</read-only>   
67.             <column-name>User</column-name>   
68.   
69.             <jdbc-type>VARCHAR</jdbc-type>   
70.             <sql-type>VARCHAR(11)</sql-type>   
71.   
72.         </cmp-field>   
73.          <cmp-field>   
74.             <field-name>password</field-name>   
75.             <read-only>false</read-only>   
76.             <column-name>Password</column-name>   
77.   
78.             <jdbc-type>VARCHAR</jdbc-type>   
79.             <sql-type>VARCHAR(12)</sql-type>   
80.   
81.         </cmp-field>   
82.          <cmp-field>   
83.             <field-name>level</field-name>   
84.             <read-only>false</read-only>   
85.             <column-name>Level</column-name>   
86.   
87.             <jdbc-type>INTEGER</jdbc-type>   
88.             <sql-type>INTEGER</sql-type>   
89.   
90.         </cmp-field>   
91.          <cmp-field>   
92.             <field-name>email</field-name>   
93.             <read-only>false</read-only>   
94.             <column-name>Email_address</column-name>   
95.   
96.             <jdbc-type>VARCHAR</jdbc-type>   
97.             <sql-type>VARCHAR(50)</sql-type>   
98.   
99.         </cmp-field>   
100.   
101. <!-- jboss 3.2 features -->   
102. <!-- optimistic locking does not express the exclusions needed -->   
103.       </entity>   
104.   
105.    </enterprise-beans>   
106.   
107. </jbosscmp-jdbc>   
108. 其中jboss-jdbc.xml里的<datasource-mapping>的值与mysql_ds.xml中<type-mapping>中的值相同，区分大小写