::: 강좌/소스/문서 :::

강좌/소스/문서 성격에 맞지 않는 광고,비방,질문의 글은 즉시 삭제하며
내용을 복사하여 사용할 경우 반드시 이곳(http://www.howto.pe.kr)을 출처로 명시하여 주세요


Category

  신훈재(2004-06-18 14:07:15, Hit : 6489, Vote : 1671
 [자바] 오라클 각종 에러

오라클 에러


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 주소가 맞지 않은 경우입니다.
또는 listener가 떠있지 않은 상태입니다.
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)







23   [Java/PHP] [자바] DB 컨넥션 풀  신훈재 2004/06/18 9511 1857
22   [Java/PHP] [자바] JDBC-ODBC 연결 예제  신훈재 2004/06/18 9046 1672
21   [Java/PHP] [자바] 시스템 프로퍼티를 이용한 드라이버 로드  신훈재 2004/06/18 5487 1425
  [Java/PHP] [자바] 오라클 각종 에러  신훈재 2004/06/18 6489 1671
19   [Java/PHP] [자바] 활용팁(오라클)  신훈재 2004/06/18 5997 1603
18   [Java/PHP] [자바] ResultSet 질의결과  신훈재 2004/06/18 6111 1317
17   [Java/PHP] [자바] Select예제  신훈재 2004/06/18 6249 1562
16   [Java/PHP] [자바] Update예제  신훈재 2004/06/18 5414 1333
15   [Java/PHP] [자바] Insert 예제  신훈재 2004/06/18 6493 1673
14   [Java/PHP] [자바] Query Statement  신훈재 2004/06/18 7763 1468
13   [Java/PHP] [자바] JDBC Connect  신훈재 2004/06/18 6718 1489
12   [Java/PHP] [자바] JDBC 코딩시 주위사항(jsp, servlet)  신훈재 2004/06/18 6137 1357
11   [Java/PHP] [자바] 여러종류의 데이타베이스 테스트 소스  신훈재 2004/06/18 6421 1457
10   [Java/PHP] [자바] JDBC 테스트 소스(오라클)  신훈재 2004/06/18 5436 1345
9   [Java/PHP] [소스] snmp 를 이용한 시스템 가용율 구하기 예제  김영대 2003/12/01 9570 2092
8   [Java/PHP] [소스] Oolong 언어를 이용한 Factorial 계산 프로그램 예제  김영대 2003/11/10 6633 1683
7   [Java/PHP] [문서] Java Web Services Development Pack (JWSDP) 1.0 tutorial  김영대 2003/03/24 5851 1457
6   [Java/PHP] [문서] Java Swing v1.1.1 도움말  김영대 2003/03/24 5782 1470
5   [Java/PHP] [문서] Java Servlet Development Kit (JSDK) v2.3 도움말  김영대 2003/03/24 5520 1454
4   [Java/PHP] [문서] Java 2 SDK, Enterprise Edition (J2EE) 1.3.1 도움말  김영대 2003/03/24 5617 1469

1 [2]
 

Copyright 1999-2017 Zeroboard / skin by zero