java基于JDBC连接Oracle 11g Release2实例分析

2019-12-24 13:08红薯 JAVA教程

这篇文章主要介绍了java基于JDBC连接Oracle 11g Release2的方法,实例分析了JDBC连接Oracle 11g Release2容易出现的异常与解决方法,需要的朋友可以参考下

本文实例讲述了java基于JDBC连接Oracle 11g Release2的方法。分享给大家供大家参考。具体如下：

Oracle 11g Release 2 的 JDBC 连接似乎有所不同，如果你收到下面的异常：
Listener refused the connection with the following error:ORA-12505, TNS:listener does not currently know of SID given in connect descriptor.
那么你必须用下面的连接方式：

				?

									/*******************************************************

									* Created on Nov, 2011 Copyright(c) http://vigilance.co.in All Rights Reserved.

									********************************************************/

									package com.vigilance.java.sample;

									import java.sql.Connection;

									import java.sql.DriverManager;

									import java.sql.ResultSet;

									import java.sql.SQLException;

									import java.sql.Statement;

									/**

									 * @author http://vigilance.co.in

									 */

									public class ConnectJDBCOracle11g {

									/**

									 * This class demonstrates the code for connecting Oracle 11g database using JDBC.

									 * @param args

									*/

									public static void main(String[] args) {

									  String JDBC_DRIVER = "oracle.jdbc.driver.OracleDriver";

									  String JDBC_STRING = "jdbc:odbc:thin:@HOSTNAME:PORTNUMBER/SID";

									  // in case of 11g use '/' instead of :

									  String USER_NAME = "USER_NAME";

									  String PASSWD = "PASSWORD";

									  Connection conn = null;

									  ResultSet rs = null;

									  Statement stmt = null;

									  try{

									    Class.forName(JDBC_DRIVER);

									    conn = DriverManager.getConnection(JDBC_STRING, USER_NAME, PASSWD);

									    stmt = conn.createStatement();

									    String query = "SELECT * FROM TABLE TBL";

									    rs = stmt.executeQuery(query);

									  }catch(SQLException sqlEx){

									    sqlEx.printStackTrace();

									  } catch (ClassNotFoundException e) {

									    e.printStackTrace();

									  } finally{

									    try {

									      if(rs!=null) rs.close();

									      if(stmt !=null) stmt.close();

									      if(conn!=null) conn.close();

									    } catch (SQLException e) {

									      e.printStackTrace();

									    }

									  }

									}

									}