1.在\server\default\deploy下新建文件mysql-ds.xml，内容如下：
MySqlDS
jdbc:mysql://localhost:3306/test
com.mysql.jdbc.Driver
root
123456
org.jboss.resource.adapter.jdbc.vendor.MySQLExceptionSorter
<!-- should only be used on drivers after 3.22.1 with "ping" support
org.jboss.resource.adapter.jdbc.vendor.MySQLValidConnectionChecker
-->
<!-- sql to call when connection is created
some arbitrary sql
-->
<!-- sql to call on an existing pooled connection when it is obtained from pool - MySQLValidConnectionChecker is preferred for newer drivers
some arbitrary sql
-->
<!-- corresponding type-mapping in the standardjbosscmp-jdbc.xml (optional) -->
<metadata>
<type-mapping>mySQL</type-mapping>
</metadata>
2.修改\server\default\conf\ standardjbosscmp-jdbc.xml
java:/MySqlDS
mySQL
3.在jboss-4.0.4\server\default\conf\ login-config.xml中追加如下内容
"org.jboss.resource.security.ConfiguredIdentityLoginModule"
flag = "required">
MySqlDS
root
123456
jboss.jca:service=LocalTxCM,name=MySqlDS
4.测试代码：
try {
Context envCtx = new InitialContext();
DataSource ds = (DataSource) envCtx.lookup("java:/MySqlDS");
return ds.getConnection();
} catch (SQLException e) {
System.out.println("数据源配置发生错误" + e.toString());
return null;
} catch (NamingException e2) {
System.out.print("数据源配置" + e2.toString());
return null;
}
5.在测试连接池是不是好用时报错如下：
10:17:30,093 INFO [STDOUT] 数据源配置javax.naming.NameNotFoundException: MySqlDS not bound
10:17:33,875 ERROR [[jsp]] Servlet.service() for servlet jsp threw exception
java.lang.NullPointerException
at org.apache.jsp.MyJsp_jsp._jspService(MyJsp_jsp.java:80)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:373)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:336)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:265)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:230)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175)
at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:182)
at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:84)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at org.jboss.web.tomcat.service.jca.CachedConnectionValve.invoke(CachedConnectionValve.java:157)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:262)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:446)
at java.lang.Thread.run(Unknown Source)
[b]问题补充：[/b]
在server\default\conf\下没有 standardjaws.xml，现在是不是只要修改standardjbosscmp-jdbc.xml就可以了
