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

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


Category

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

오라클 에러


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] [자바] 활용팁(오라클)  신훈재 2004/06/18 6269 1665
  [Java/PHP] [자바] 오라클 각종 에러  신훈재 2004/06/18 6809 1759
21   [Java/PHP] [자바] 여러종류의 데이타베이스 테스트 소스  신훈재 2004/06/18 6877 1537
20   [Java/PHP] [자바] 시스템 프로퍼티를 이용한 드라이버 로드  신훈재 2004/06/18 5777 1501
19   [Java/PHP] [자바] Update예제  신훈재 2004/06/18 5687 1410
18   [Java/PHP] [자바] Select예제  신훈재 2004/06/18 8172 1628
17   [Java/PHP] [자바] ResultSet 질의결과  신훈재 2004/06/18 6399 1379
16   [Java/PHP] [자바] Query Statement  신훈재 2004/06/18 8075 1559
15   [Java/PHP] [자바] JDBC-ODBC 연결 예제  신훈재 2004/06/18 9964 1762
14   [Java/PHP] [자바] JDBC 테스트 소스(오라클)  신훈재 2004/06/18 5713 1412
13   [Java/PHP] [자바] JDBC 코딩시 주위사항(jsp, servlet)  신훈재 2004/06/18 7622 1431
12   [Java/PHP] [자바] JDBC Connect  신훈재 2004/06/18 10939 1571
11   [Java/PHP] [자바] Insert 예제  신훈재 2004/06/18 6768 1751
10   [Java/PHP] [자바] DB 컨넥션 풀  신훈재 2004/06/18 10031 1937
9   [Java/PHP] [소스] snmp 를 이용한 시스템 가용율 구하기 예제  김영대 2003/12/01 10134 2181
8   [Java/PHP] [소스] Oolong 언어를 이용한 Factorial 계산 프로그램 예제  김영대 2003/11/10 6943 1777
7   [Java/PHP] [문서] Java Web Services Development Pack (JWSDP) 1.0 tutorial  김영대 2003/03/24 6104 1516
6   [Java/PHP] [문서] Java Tutorial 도움말  김영대 2003/03/24 5821 1528
5   [Java/PHP] [문서] Java Swing v1.1.1 도움말  김영대 2003/03/24 6027 1533
4   [Java/PHP] [문서] Java Servlet Development Kit (JSDK) v2.3 도움말  김영대 2003/03/24 5785 1522

1 [2]
 

Copyright 1999-2019 Zeroboard / skin by zero