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

最新推荐文章于 2021-04-07 16:26:21 发布

overmind

最新推荐文章于 2021-04-07 16:26:21 发布

阅读量1.1k

点赞数

分类专栏： jboss+struts+bv+hpunix 文章标签： oracle 数据库连接池 jboss 数据库驱动程序 import exception

本文链接：https://blog.csdn.net/overmind/article/details/58472

版权

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

39 篇文章 0 订阅

订阅专栏

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

overmind

关注

0
点赞
踩
0

收藏

觉得还不错? 一键收藏
0
评论
在jboss3。2。5中配置oracle数据库连接池

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/exam
复制链接

扫一扫

专栏目录