아래 myTestDB01.java를 실행하면 이런 오류 메시지가 생깁니다.
Krona Error : java.sql.SQLException: 부적합한 Oracle URL이 지정되었습니다: OracleDriver.connect
-------------------------------------------------------------------------------
//myTestDB01.java 파일입니다.
import java.io.*;
import java.sql.*;
public class myTestDB01{
public static void main(String[] args){
String url = "jdbc:oracle:thin@210.106.228.11:1521:ORCL";
String query = "Select * from Bonus";
Connection myCon = null;
Statement stmt = null;
try{
Class.forName("oracle.jdbc.driver.OracleDriver");
}catch(ClassNotFoundException e){
System.err.println(e.getMessage());
}
try {
myCon = DriverManager.getConnection(url,"scott","tiger");
stmt = myCon.createStatement();
ResultSet rs = stmt.executeQuery(query);
while(rs.next()){
String col1 = rs.getString(1);
String col2 = rs.getString(2);
int col3 = rs.getInt(3);
int col4 = rs.getInt(4);
System.out.println(" " + col1 + ":" + col2 + ":" + col3 + " : " + col4 );
System.out.println("gkgkgkgk");
}
rs.close();
stmt.close();
myCon.close();
} catch(Exception e) { System.out.println("Krona Error : " + e);}
}
}
-------------------------------------------------------------------------------------
//autoexec.bat
SET BLASTER=A220 I7 D3 H7 P330 T6
SET SBPCI=C:\SBPCI
loadhigh C:\WINDOWS\COMMAND\nlsfunc.exe C:\WINDOWS\country.sys
SET PATH=C:\HNC\;C:\ORACLE\ORA81\BIN;"C:\PROGRAM;FILES\ORACLE\JRE\1.1.7\BIN";C:\PROGRA~1\ULTRAE~1;C:\JDK1.3\BIN
SET CLASSPATH=.;C:\jdk1.3\lib\tools.jar;C:\jdk1.3\classes;c:\jdk1.3\jre\lib\classes12.zip
SET JAVA_HOME=C:\jdk1.3
SET TOMCAT_HOME=C:\Apache Group\jakarta-tomcat
//tnsnames.ora
# C:\ORACLE\ORA81\NETWORK\ADMIN\TNSNAMES.ORA Configuration File:c:\Oracle\Ora81\NETWORK\ADMIN\tnsnames.ora
# Generated by Oracle Net8 Assistant
ORAKRONA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 210.106.228.11)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = ORCL)
)
)
//listener.ora
# C:\ORACLE\ORA81\NETWORK\ADMIN\LISTENER.ORA Configuration File:c:\Oracle\Ora81\network\admin\listener.ora
# Generated by Oracle Net8 Assistant
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = www)(PORT = 1521))
)
)
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = c:\Oracle\Ora81)
(PROGRAM = extproc)
)
)
|