java.sql.SQLException: Io 异常: Connection refused(DESCRIPTION=(TMP=)(VSNNUM=186646784)(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(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)刚接触oracle,连不了,请高手支招,在此先谢谢了
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(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)刚接触oracle,连不了,请高手支招,在此先谢谢了
driver=“oracle.jdbc.driver.Driver”
url = jdbc:oracle:@thin:IP地址:1521:你的Oracle名字
username="scott"
pass="tiger"
第二,Oracle驱动包是否加入lib下
第三,检查服务名,用户名和密码是否正确
1.是否有jar包
2.是否打开Oracle服务
3.不是hibernate自动生成的连接字符串,检查是否写错.
把代码贴上来。
应该是密码错误了,
应该是sid 和password有问题
本人的情况是因为jdbc url 中所指定的实例名给错了,给的是service_name而不是SID,后来改成SID就行了,不知道SID的,可以用sys/sysdba用户登陆然后select INSTANCE_NAME from v$instance;
貌似tns配置sid或者service_name都可以认出,而jdbc url里只认SID而不认SERVICE_NAME