JDBC Oracle 連動時エラー一覧

2007. 4. 11. 19:06

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)  
 

IDとPASSWORDが間違っている場合 
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)


firewallだから接続不可
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)


 

by artis