我这里的配置分为以下几步:
第一步:从jboss-4.0.2\docs\examples\jca目录下的mysql-ds.xml复制文件到D:\jboss-4.0.2\server\default\deploy目录下并编辑如下:<?xml version="1.0" encoding="UTF-8"?>
MySqlDS
jdbc:mysql://localhost:3306/test
com.mysql.jdbc.Driver
root
root
org.jboss.resource.adapter.jdbc.vendor.MySQLExceptionSorter
mySQL
第二步:编辑jboss-4.0.2\server\default\conf下的三个文件:standardjbosscmp-jdbc.xml,standardjaws.xml,login-config.xml
standardjbosscmp-jdbc.xml修改部分:java:/MySqltDS
mySQL
standardjaws.xml修改部分:java:/MySqltDS
mySQL
login-config.xml修改部分:(可以添加这一段,复制一段进行修改)
flag = "required">
test
root
root
jboss.jca:service=LocalTxCM,name=MySqlDS
第三步:重启jboss没有出现异常,就会有如下显示,证明配置正确:
第四步:如果你还步放心,现在写个servlet试试吧:response.setContentType("text/html;charset=gb2312");
PrintWriter out = response.getWriter();
try {
// Put your code here
Context cx = new InitialContext();
Object obj = cx.lookup("java:/MySqlDS");
DataSource ds = (DataSource)obj;
Connection connect = ds.getConnection();
Statement stmt = connect.createStatement();
ResultSet rs = stmt.executeQuery("select * from customers");
while(rs.next()){
out.println(rs.getString("name"));
}
} catch (NamingException e) {
e.printStackTrace();
} catch(SQLException e1){
e1.printStackTrace();
}
out.flush();
out.close();