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();