자바 jdbc 오라클 연동시 에러 모음

Tip]jdbc oracle 연동시 에러 모음  
 

classes12.zip 이 연결이 안된 경우입니다.
java.lang.ClassNotFoundException: oracle.jdbc.driver.oracleDriver
at java.net.URLClassLoader$1.run(URLClassLoader.java:200)
at java.security.AccessController.doPrivileged(Native Method)
at java.net.URLClassLoader.findClass(URLClassLoader.java:188)
at java.lang.ClassLoader.loadClass(ClassLoader.java:297)
at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:286)
at java.lang.ClassLoader.loadClass(ClassLoader.java:253)
at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:313)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Class.java:120)
at getEmp.main(getEmp.java:18)
 
 
host 주소가 맞지 않은 경우입니다.
java.sql.SQLException: IO 예외 상황: The Network Adapter could not establish the connection
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:114)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:156)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:269)
at oracle.jdbc.driver.oracleConnection.(oracleConnection.java:210)
at oracle.jdbc.driver.oracleDriver.getConnectionInstance(oracleDriver.java:251)
at oracle.jdbc.driver.oracleDriver.connect(oracleDriver.java:224)
at java.sql.DriverManager.getConnection(DriverManager.java:517)
at java.sql.DriverManager.getConnection(DriverManager.java:177)
at getEmp.main(getEmp.java:20)
 
db명이 틀릴경우입니다. 호스트스트링이라고도 합니다.
java.sql.SQLException: IO 예외 상황: Connection refused(DESCRIPTION=(TMP=)(VSNNUM=135290880)(ERR=12505)(ERROR_STACK=(ERROR=(CODE=12505)(EMFI=4))))
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:114)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:156)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:269)
at oracle.jdbc.driver.oracleConnection.(oracleConnection.java:210)
at oracle.jdbc.driver.oracleDriver.getConnectionInstance(oracleDriver.java:251)
at oracle.jdbc.driver.oracleDriver.connect(oracleDriver.java:224)
at java.sql.DriverManager.getConnection(DriverManager.java:517)
at java.sql.DriverManager.getConnection(DriverManager.java:177)
at getEmp.main(getEmp.java:20)
 
아이디와 패스워드가 틀릴경우입니다.
java.sql.SQLException: 널 사용자나 암호가 THIN 드라이버에서 지원되지 않습니다
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:114)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:156)
at oracle.jdbc.dbaccess.DBError.check_error(DBError.java:803)
at oracle.jdbc.ttc7.TTC7Protocol.logon(TTC7Protocol.java:179)
at oracle.jdbc.driver.oracleConnection.(oracleConnection.java:198)
at oracle.jdbc.driver.oracleDriver.getConnectionInstance(oracleDriver.java:251)
at oracle.jdbc.driver.oracleDriver.connect(oracleDriver.java:224)
at java.sql.DriverManager.getConnection(DriverManager.java:517)
at java.sql.DriverManager.getConnection(DriverManager.java:177)
at getEmp.main(getEmp.java:20)

 

방화벽때문에 접속불가
java.sql.SQLException: IO 예외 상황: The Network Adapter could not establish
the connection
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:169)
 at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:211)
 at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:324)
 at oracle.jdbc.driver.OracleConnection.<init>(OracleConnection.java:266)
 at oracle.jdbc.driver.OracleDriver.getConnectionInstance(OracleDriver.java:365)
 at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:260)
 at java.sql.DriverManager.getConnection(DriverManager.java:512)
 at java.sql.DriverManager.getConnection(DriverManager.java:171)