2. 拷贝%JBoss%/docs/examples/jca/mysql-ds.xml 到%JBoss% /server/default/deploy文件夹里。然后修改如下:
XXX
3. 编一个名为test.jsp的JSP文件进行测试:
<%@ page language="java" import="java.util.*" pageEncoding="GB2312"%>
<%@ page import="java.sql.*"%>
<%@ page import="javax.sql.DataSource" %>
<%@ page import="javax.naming.*"%>
<%
out.print("测试JBoss/MySQL连接池
");
try{
InitialContext initCtx = new InitialContext();
DataSource ds = (DataSource)initCtx.lookup("java:/ DefaultMySqlDs ");//注意这里,如果你的JNDI名字和我的不一样,那这个" DefaultMySqlDs "要改!
Connection conn = ds.getConnection();
out.print("MySQL connection pool runs perfectly!");
conn.close();
}
catch(Exception ex){
out.println("连接错误:");
out.print(ex.getMessage());
}
%>
看到MySQL connection pool runs perfectly!就说明配置成功了!
最新评论