글쓴이 :박검영 2000년 3월 14일 14:45:09
다음과 같은 소스에 아래와 같은 컴파일을 해서 실행을 했는데
아래와 같은 문장이 나오며 실행이 안되는데...
왜 그런지 갈켜주세요~~~부탁합니다.....
import java.sql.*;
import java.lang.*;
public class SelcetSql {
public static void main (String args[]) {
String url = "jdbc:oracle:thin:@localhost:1521:ITFT";
String username = "";
String password = "";
try
{
Class.forName("oracle.jdbc.driver.OracleDriver").newInstance();
System.out.println("로드 성공");
}
catch (Exception e)
{
System.out.println(e.getMessage());
System.out.println("JDBC/ODBC 드라이브 로드 실패");
return;
}
Statement stmt = null;
Connection con = null;
try
{
con = DriverManager.getConnection(url, "system", "manager");
stmt = con.createStatement();
System.out.println("연결 성공");
}
catch (Exception e)
{
System.out.println(e.getMessage());
System.err.println("데이터베이스 연결 실패"+url);
}
try {
ResultSet result = stmt.executeQuery("select * from selectDBtable; ");
while(result.next()) {
String field1 = result.getString(1);
String field2 = result.getString(2);
System.out.println("첫번째 필드:"+field1+"두번째 필드"+field2);
}
con.close();
}
catch (Exception e) {
System.out.println(e.getMessage());
e.printStackTrace();
}
}
}
/users/kypark/javaservlet: javac SelcetSql.java
/users/kypark/javaservlet: java SelcetSql
로드 성공
연결 성공
ORA-00911: invalid character
java.sql.SQLException: ORA-00911: invalid character
at java.lang.Throwable.<init>(Compiled Code)
at java.lang.Exception.<init>(Compiled Code)
at java.sql.SQLException.<init>(Compiled Code)
at oracle.jdbc.ttc7.TTIoer.processError(Compiled Code)
at oracle.jdbc.ttc7.Oall7.receive(Compiled Code)
at oracle.jdbc.ttc7.TTC7Protocol.doOall7(Compiled Code)
at oracle.jdbc.ttc7.TTC7Protocol.parseExecuteDescribe(Compiled Code)
at oracle.jdbc.driver.OracleStatement.doExecuteQuery(Compiled Code)
at oracle.jdbc.driver.OracleStatement.doExecute(Compiled Code)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(Compiled Code)
at oracle.jdbc.driver.OracleStatement.executeQuery(Compiled Code)
at SelcetSql.main(Compiled Code)