<config-property name="DriverClass" type="java.lang.String">com.microsoft.jdbc.sqlserver.SQLServerDriver</config-property>

            <config-property name="UserName" type="java.lang.String">sa</config-property>

            <config-property name="Password" type="java.lang.String">bodaasen</config-property>

          </properties>

        </attribute>

        <depends optional-attribute-name="OldRarDeployment">jboss.jca:service=RARDeployment,name=JBoss LocalTransaction JDBC Wrapper</depends>

      </mbean>

    </depends>

    <depends optional-attribute-name="ManagedConnectionPool">

      <mbean code="org.jboss.resource.connectionmanager.JBossManagedConnectionPool" name="jboss.jca:service=LocalTxPool,name=sqlServerDS">

        <attribute name="MinSize">0</attribute>

        <attribute name="MaxSize">50</attribute>

        <attribute name="BlockingTimeoutMillis">5000</attribute>

        <attribute name="IdleTimeoutMinutes">15</attribute>

        <attribute name="Criteria">ByContainer</attribute>

      </mbean>

    </depends>

    <depends optional-attribute-name="CachedConnectionManager">jboss.jca:service=CachedConnectionManager</depends>

    <depends optional-attribute-name="JaasSecurityManagerService">jboss.security:service=JaasSecurityManager</depends>

    <attribute name="TransactionManager">java:/TransactionManager</attribute>

    <depends>jboss.jca:service=RARDeployer</depends>

  </mbean>

</server>

三、测试数据的连接列子(我用的是jsp)

你必需要编写.war或.ear包来测试一个简易的做法就是：

一、 在deploy目录下建立sqlserver-test.war目录。

二、在sqlserver-test.war目录下建立WEB-INF目录，其中有两个文件

jboss-web.xml和web.xml

内容分别是

jboss-web.xml内容是

<jboss-web>

</jboss-web>

web.xml内容是

<?xml version="1.0"?>

<!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>

</web-app>

三、在sqlserver-test.war目录下建立新文件index.jsp其内容是

<%@page contentType="text/html"%>

<%@ page import="java.sql.*, javax.sql.DataSource, javax.naming.InitialContext" %>

<h3>Test SQL SERVER DB</h3>

<%

InitialContext ctx = new InitialContext();

DataSource ds = (DataSource) ctx.lookup("java:/SqlServerDS");

Connection conn = ds.getConnection();

Statement stmt = conn.createStatement();

ResultSet rs = stmt.executeQuery("SELECT * FROM user_infor");

while ( rs.next() ) {

out.println( rs.getString(1) + "");

上一页  [1] [2] [3] [4] [5] [6]  下一页