我写了一段简单得java程序通过 thin 驱动来连接RAC数据库,
经常是一会能练上,一会连不上,高不懂?谁遇到过这种情况啊
/*
* Main.java
*
* Created on 2005年9月15日, 下午4:01
*
* To change this template, choose Tools | Options and locate the template under
* the Source Creation and Management node. Right-click the template and choose
* Open. You can then make changes to the template in the Source Editor.
*/package javaapplication1;import java.net.ProxySelector;
import java.sql.Connection;
import java.sql.Driver;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;/**
*
* @author Administrator
*/
public class Main {
/** Creates a new instance of Main */
public Main() {
try {
Driver driver = (Driver) Class.forName("oracle.jdbc.driver.OracleDriver").newInstance();
DriverManager.registerDriver(driver);
} catch (Exception e) {
}
Connection con = null;
try {
System.out.println("aaaa");
ProxySelector.setDefault(null);
System.out.println("bbbb");
con = DriverManager.getConnection("jdbc:oracle:thin:@(description=(address_list= (address=(host=192.168.0.1) (protocol=tcp)(port=1521))(address=(host=192.168.0.2)(protocol=tcp) (port=1521)) (load_balance=yes)(failover=yes))(connect_data=(service_name= zytl)))", "scott", "tiger");
//logger.info("创建数据库连接成功:"+URL);
System.out.println("ssss");
Statement st = con.createStatement();
System.out.println("dddd");
ResultSet rs = st.executeQuery("select * from test");
System.out.println("eeee");
while(rs.next())
System.out.println(rs.getString("id"));
System.out.println("ffff");
} catch (Exception e) {
System.out.println(e);
}finally{
try{
con.close();
}catch (Exception e) {
System.out.println(e);
}
}
}/**
* @param args the command line arguments
*/
public static void main(String[] args) {
// TODO code application logic here
new Main();
}}
经常是一会能练上,一会连不上,高不懂?谁遇到过这种情况啊
/*
* Main.java
*
* Created on 2005年9月15日, 下午4:01
*
* To change this template, choose Tools | Options and locate the template under
* the Source Creation and Management node. Right-click the template and choose
* Open. You can then make changes to the template in the Source Editor.
*/package javaapplication1;import java.net.ProxySelector;
import java.sql.Connection;
import java.sql.Driver;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;/**
*
* @author Administrator
*/
public class Main {
/** Creates a new instance of Main */
public Main() {
try {
Driver driver = (Driver) Class.forName("oracle.jdbc.driver.OracleDriver").newInstance();
DriverManager.registerDriver(driver);
} catch (Exception e) {
}
Connection con = null;
try {
System.out.println("aaaa");
ProxySelector.setDefault(null);
System.out.println("bbbb");
con = DriverManager.getConnection("jdbc:oracle:thin:@(description=(address_list= (address=(host=192.168.0.1) (protocol=tcp)(port=1521))(address=(host=192.168.0.2)(protocol=tcp) (port=1521)) (load_balance=yes)(failover=yes))(connect_data=(service_name= zytl)))", "scott", "tiger");
//logger.info("创建数据库连接成功:"+URL);
System.out.println("ssss");
Statement st = con.createStatement();
System.out.println("dddd");
ResultSet rs = st.executeQuery("select * from test");
System.out.println("eeee");
while(rs.next())
System.out.println(rs.getString("id"));
System.out.println("ffff");
} catch (Exception e) {
System.out.println(e);
}finally{
try{
con.close();
}catch (Exception e) {
System.out.println(e);
}
}
}/**
* @param args the command line arguments
*/
public static void main(String[] args) {
// TODO code application logic here
new Main();
}}
解决方案 »
- PL/SQL Developer中如何设置让关键字大写?
- Oracle 9i Application Server
- 两张表关联取最大日期的数据
- 急寻linux下oracle10g断电后启动不了?
- like 与 = 效率上有区别吗?
- 利用TOAD软件如何察看ORACLE当前有哪些存储过程和JOB正在执行,在哪个菜单可以看到?
- 洒店管理系统的后台数据库是用Oracle好还是用Ms sqlserver好一点?
- 请教BLOB类型的建立问题!
- 关于作业的问题!
- 远程拨号访问WIN2000服务器端ORACLE的问题
- 如何能从时间中取出日期而不要时分秒?
- 这样的字符如何存储到varchar2(1000)的字段里面啊,用insert
SQLException,网络适配器什么什么错误,关键时有时候可以连上,但是连接单独得一台就没有问题,nnd
异常改一下:
finally{
//if conn.state open
//conn close
}