首页 > 学习笔记 > JBOSS4.3 数据连接池配置与调用

JBOSS4.3 数据连接池配置与调用

2006年10月20日 bywzy 浏览：91 发表评论 阅读评论

在JBOSS的\server\default\deploy目录下，修改mssql-ds.xml(我用的MSSQL)

显示被隐藏内容 显示被隐藏内容

<datasources>
  <local-tx-datasource>
    <jndi-name>MSSQLDS</jndi-name>
    <connection-url>jdbc:microsoft:sqlserver://192.168.18.45:1433;DatabaseName=db_manp</connection-url>
    <driver-class>com.microsoft.jdbc.sqlserver.SQLServerDriver</driver-class>
    <user-name>sa</user-name>
    <password>123</password>
        <!– sql to call when connection is created
        <new-connection-sql>some arbitrary sql</new-connection-sql>
        –>
   <!– The minimum connections in a pool/sub-pool. Pools are lazily constructed on first use –>
      <min-pool-size>10</min-pool-size>

      <!– The maximum connections in a pool/sub-pool –>
      <max-pool-size>30</max-pool-size>
        <!– sql to call on an existing pooled connection when it is obtained from pool
        <check-valid-connection-sql>some arbitrary sql</check-valid-connection-sql>
        –>
      
      <!– corresponding type-mapping in the standardjbosscmp-jdbc.xml (optional) –>
      <metadata>
         <type-mapping>MS SQLSERVER2000</type-mapping>
      </metadata>
  </local-tx-datasource>

</datasources>
隐藏内容 隐藏内容
该内容已经被作者隐藏,只有会员才允许查阅 登录 | 注册


然后通过incdb.jsp文件调用
<%@ page import="javax.naming.*" %>
<%@ page import="javax.sql.*" %>
<%@ page import="java.sql.*" %>
<%!
    javax.sql.DataSource ds;
%>
<%
    try {
     Context ctx = new InitialContext();
     ds = (javax.sql.DataSource)ctx.lookup("java:/MSSQLDS");
    } catch (Exception e) {
     out.println("erro when connect to java naming api");
    }
    Connection conn = ds.getConnection();
    Statement st = conn.createStatement();
    
    //String sqlStr = "Select truename FROM SalesMan";
    //ResultSet rs = st.executeQuery(sqlStr);
    
%>
JSP传递中的中文乱码解决：
  request.setCharacterEncoding("gb2312"); //

分类: 学习笔记 标签:
  1. 本文目前尚无任何评论.
  1. 本文目前尚无任何 trackbacks 和 pingbacks.