package com.fzu.java2oracle.test;import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
public class Test1 {
private Connection connection;
private PreparedStatement statement;
private ResultSet resultSet;
{
try {
Class.forName("oracle.jdbc.driver.OracleDriver");
connection=DriverManager.getConnection("jdbc:oracle:thin:@127.0.0.1:1521:orcl","scott","smiler");
} catch (Exception e) {
e.printStackTrace();
}
}
public static void main(String[] args) {
new Test1();
}
}
====================================================================================================================================================================java.sql.SQLException: Io 异常: Connection refused(DESCRIPTION=(TMP=)(VSNNUM=169869568)(ERR=12505)(ERROR_STACK=(ERROR=(CODE=12505)(EMFI=4))))
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:179)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:333)
at oracle.jdbc.driver.OracleConnection.<init>(OracleConnection.java:404)
at oracle.jdbc.driver.OracleDriver.getConnectionInstance(OracleDriver.java:468)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:314)
at java.sql.DriverManager.getConnection(DriverManager.java:582)
at java.sql.DriverManager.getConnection(DriverManager.java:185)
at com.fzu.java2oracle.test.Test1.main(Test1.java:19)
====================================================================================================================================================================SQL> show parameter processes;NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
aq_tm_processes integer 0
db_writer_processes integer 1
gcs_server_processes integer 0
job_queue_processes integer 10
log_archive_max_processes integer 2
processes integer 300
SQL> select count(*) from v$process; COUNT(*)
----------
18
====================================================================================================================================================================服务什么也都启动了 ,服务器名也是ORCL ,求解啊?为什么老是报这种错误,用sqlplus可以正常使用数据库啊OracleJava
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
public class Test1 {
private Connection connection;
private PreparedStatement statement;
private ResultSet resultSet;
{
try {
Class.forName("oracle.jdbc.driver.OracleDriver");
connection=DriverManager.getConnection("jdbc:oracle:thin:@127.0.0.1:1521:orcl","scott","smiler");
} catch (Exception e) {
e.printStackTrace();
}
}
public static void main(String[] args) {
new Test1();
}
}
====================================================================================================================================================================java.sql.SQLException: Io 异常: Connection refused(DESCRIPTION=(TMP=)(VSNNUM=169869568)(ERR=12505)(ERROR_STACK=(ERROR=(CODE=12505)(EMFI=4))))
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:179)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:333)
at oracle.jdbc.driver.OracleConnection.<init>(OracleConnection.java:404)
at oracle.jdbc.driver.OracleDriver.getConnectionInstance(OracleDriver.java:468)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:314)
at java.sql.DriverManager.getConnection(DriverManager.java:582)
at java.sql.DriverManager.getConnection(DriverManager.java:185)
at com.fzu.java2oracle.test.Test1.main(Test1.java:19)
====================================================================================================================================================================SQL> show parameter processes;NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
aq_tm_processes integer 0
db_writer_processes integer 1
gcs_server_processes integer 0
job_queue_processes integer 10
log_archive_max_processes integer 2
processes integer 300
SQL> select count(*) from v$process; COUNT(*)
----------
18
====================================================================================================================================================================服务什么也都启动了 ,服务器名也是ORCL ,求解啊?为什么老是报这种错误,用sqlplus可以正常使用数据库啊OracleJava
2、确认oracle实例名正确,也就是你这里(@127.0.0.1:1521:orcl)写的orcl是否是你的oracle实例,
3、确认用户名和密码正确。
检查这几样,我觉得差不多了哈··