- 论坛徽章:
- 0
|
花了一个小时的时间,搞了一下jboss4。0下mysql数据源的配置。下面是一些具体过程
1、首先安装mysql数据库并将其驱动程序考到jboss的server\default\lib下面
2、将mysql-ds.xml文件放置到server\default\deploy下面
内容如下:
MySqlDS
jdbc:mysql://localhost:3306/test
org.gjt.mm.mysql.Driver
root
qwe123
mySQL
3、建立一个自己的war包 testds.war
内含有META-INF/jbosscmp-jdbc.xml, 重载默认的数据源
java:/MySqlDS
mySql
4、建立一个servlet进行测试,放在上面的包中
package test;
import java.io.IOException;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import java.sql.*;
import javax.naming.*;
import javax.sql.*;
import java.io.*;
/**
* @author Administrator
*
* TODO To change the template for this generated type comment go to
* Window - Preferences - Java - Code Style - Code Templates
*/
public class myservlet extends HttpServlet {
/* (non-Javadoc)
* @see javax.servlet.http.HttpServlet#doGet(javax.servlet.http.HttpServletRequest, javax.servlet.http.HttpServletResponse)
*/
protected void doGet(HttpServletRequest req, HttpServletResponse res)
throws ServletException, IOException {
// TODO Auto-generated method stub
//super.doGet(arg0, arg1);
PrintWriter out = res.getWriter();
Connection conn = null;
Statement stmt = null;
ResultSet rs = null;
try {
Context initCtx = new InitialContext();
DataSource ds = (DataSource)initCtx.lookup("java:/MySqlDS");
conn = ds.getConnection();
if (conn != null)
out.println("ok");
else
out.println("error");
}
catch(Exception e)
{
System.out.println("Exception"+e);
}
}
}
web.xml
my Servlet
test.myservlet
my Servlet
/*
呵呵。启动jboss,在浏览器中键入
http://localhost:8080/testds/
显示OK,成功!!!
本文来自ChinaUnix博客,如果查看原文请点:http://blog.chinaunix.net/u/17667/showart_101801.html |
|