glassfish mysql datasource_GlassFish MySql连接池配置

第一步：复制D:/glassfish/lib/install/templates/resources/jdbc/mysql_type4_datasource.xml

到D:/glassfish/domains/s317/config

［注：s317是domain名称］，并命名为msql.xml

第二步：编缉D:/glassfish/domains/s317/config/msql.xml

name="mysql_pool"

datasource-classname="com.mysql.jdbc.jdbc2.optional.MysqlDataSource"

res-type="javax.sql.DataSource">

enabled="true"

jndi-name="jdbc/MySqlDB"

object-type="user"

pool-name=" mysql_pool "/>

第三步：复制mysql-connector-java-3.1.10-bin.jar到

D:/glassfish/domains/s317/lib/ext 目录下

第四步：D:/glassfish/bin>asadmin start-domain s317

第五步：asadmin add-resources msyql.xml

第六步：asadmin ping-connection-pool mysql_pool

第七步：向web.xml加入下面的内容

DBPool Connection

jdbc/MySqlDB

javax.sql.DataSource

Container

第八步：编写测试页面jdbc.jsp：

pageEncoding="ISO-8859-1"%>

-//W3C//DTD HTML 4.01 Transitional//EN""http://www.w3.org/TR/html4/loose.dtd">

Insert title here

ResultSet rs =null;

Statement stmt =null;

Connection conn =null;

try{

String strJNDIName ="jdbc/MySqlDB";

Context initialcontext =null;

initialcontext =newInitialContext();

DataSource datasource = (DataSource) initialcontext.lookup(strJNDIName);

conn = datasource.getConnection();

stmt = conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);

rs = stmt.executeQuery("select * from jbpm_task");

while(rs.next()){

out.println(rs.getString("ID_"));

}

}

catch(Exception e){

System.out.println(e.toString());

}finally{

if(rs !=null){

rs.close();

rs =null;

}

if(stmt !=null){

stmt.close();

stmt =null;

}

}

%>