jboss4。0下mysql数据源的配置

王朝java/jsp·作者佚名 2006-01-09

宽屏版字体: 小|中|大|超大

花了一个小时的时间，搞了一下jboss4。0下mysql数据源的配置。下面是一些具体过程

1、首先安装mysql数据库并将其驱动程序考到jboss的server\default\lib下面

2、将mysql-ds.xml文件放置到server\default\deploy下面

内容如下：

<local-tx-datasource>

<jndi-name>MySqlDS</jndi-name>

<connection-url>jdbc:mysql://localhost:3306/test</connection-url>

<driver-class>org.gjt.mm.mysql.Driver</driver-class>

<user-name>root</user-name>

<type-mapping>mySQL</type-mapping>

</metadata>

</local-tx-datasource>

</datasources>

3、建立一个自己的war包 testds.war

内含有META-INF/jbosscmp-jdbc.xml, 重载默认的数据源

<jbosscmp-jdbc>

<datasource>java:/MySqlDS</datasource>

<datasource-mapping>mySql</datasource-mapping>

</defaults>

</jbosscmp-jdbc>

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

<?xml version="1.0" encoding="ISO-8859-1"?>

<!DOCTYPE web-app

PUBLIC "-//Sun Microsystems, Inc.//DTD Web Application 2.3//EN"

"http://java.sun.com/dtd/web-app_2_3.dtd">

<web-app>

<servlet-name>my Servlet</servlet-name>

<servlet-class>test.myservlet</servlet-class>

</servlet>

<servlet-mapping>

<servlet-name>my Servlet</servlet-name>

<url-pattern>/*</url-pattern>

</servlet-mapping>

</web-app>

呵呵。启动jboss,在浏览器中键入http://localhost:8080/testds/ 显示OK,成功！！！