在jboss3。2。5中配置oracle数据库连接池

最新推荐文章于 2025-07-12 20:51:47 发布

原创最新推荐文章于 2025-07-12 20:51:47 发布 · 1.2k 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#oracle #数据库连接池 #jboss #数据库驱动程序 #import #exception

jboss+struts+bv+hpunix 专栏收录该内容

39 篇文章

订阅专栏

本文详细介绍了使用JBoss连接Oracle数据库的具体步骤，包括下载jboss-3.2.5和struts例子，修改run.bat文件，修改并放置oracle-ds.xml，添加数据库驱动程序，在struts.war中添加并修改jsp文件，最后通过访问特定URL进行测试。

1。从www.jboss.org上下载一个jboss-3.2.5的zip包。

2。从www.jarkata.org上下载一个struts的例子，当作deploy下面的一个war包。D:/jboss/server/default/deploy/struts.war

3。修改D:/jboss/bin中run.bat文件
set JAVA_HOME=C:/jdk

4。从D:/jboss/docs/examples/jca中找到oracle-ds.xml修改。

<?xml version="1.0" encoding="UTF-8"?>

<datasources>
<local-tx-datasource>
<jndi-name>OracleDS</jndi-name>
<connection-url>jdbc:oracle:thin:@10.1.101.138:1521:zhdb</connection-url>
<!--

Here are a couple of the possible OCI configurations.
For more information, see http://otn.oracle.com/docs/products/oracle9i/doc_library/release2/java.920/a96654/toc.htm

<connection-url>jdbc:oracle:oci:@youroracle-tns-name</connection-url>
or
<connection-url>jdbc:oracle:oci:@(description=(address=(host=youroraclehost)(protocol=tcp)(port=1521))(connect_data=(SERVICE_NAME=yourservicename)))</connection-url>

Clearly, its better to have TNS set up properly.
-->
    <driver-class>oracle.jdbc.driver.OracleDriver</driver-class>
    <user-name>zhtb</user-name>
    <password>zhtb</password>
    
    
    
    <exception-sorter-class-name>org.jboss.resource.adapter.jdbc.vendor.OracleExceptionSorter</exception-sorter-class-name>

</local-tx-datasource>

</datasources>

5。将oracle-ds.xml修改后放置在D:/jboss/server/default/deploy

6。将oracle数据库驱动程序classes12.zip放置到D:/jboss/server/default/lib中

7。在D:/jboss/server/default/deploy/struts.war中放置一个新的jsp文件testlq.jsp

8。修改testlq.jsp

<%@ page language="java" %>
<%@ page import="java.util.*" %>
<%@ page import="javax.sql.*" %>
<%@ page import="java.sql.*" %>
<%@ page import="javax.naming.*" %>
<html>
<head><title>this is test</title></head>
<%

        try
        {
            InitialContext ic = new InitialContext();
            DataSource dataSource = (DataSource) ic.lookup("java:/OracleDS");
            Connection dbConnection = dataSource.getConnection();
            PreparedStatement pstmt = null;
     ResultSet result = null;
     String queryStr = "SELECT OID FROM T_ORDER";
     dbConnection = dataSource.getConnection();
            pstmt = dbConnection.prepareStatement (queryStr);
            result = pstmt.executeQuery();
            while(result.next()){
            out.println(""+result.getLong("OID"));
            }

}
        catch (NamingException ne)
        {
            throw new SQLException("Naming Exception while looking " +
                                               " up DataSource Connection " +
                                               ": /n" + ne.getMessage());
        }

%>
</html>

9。访问http://10.1.101.138/struts/testlq.jsp