±Û¾´ÀÌ :ÀÌÅÂÇÑ 1998³â 10¿ù 19ÀÏ 17:13:32
/****************************************************
import java.sql.*;
import java.math.*;
class Employee
{
public static void main (String args []) throws SQLException, ClassNotFoundExc
eption
{
Class.forName ("oracle.jdbc.driver.OracleDriver");
System.out.println ("Connect ...");
Connection conn = DriverManager.getConnection ("jdbc:oracle:thin:@www:1521:O
RA7", "id", "passwd");
System.out.println ("Connected ...");
Statement stmt = conn.createStatement ();
ResultSet rset = stmt.executeQuery ("select ENAME from EMP");
while (rset.next ())
System.out.println (rset.getString (1));
}
}
************************************************/
¼Ò½º Àä...
½ÇÇàÀ» Çϸé
/*****************************************
Connect ...
java.sql.SQLException: ?????? ??¥å?
at java.lang.Throwable.<init>(Compiled Code)
at java.lang.Exception.<init>(Compiled Code)
at java.sql.SQLException.<init>(Compiled Code)
at oracle.jdbc.dbaccess.DBError.check_error(Compiled Code)
at oracle.jdbc.driver.OracleConnection.<init>(Compiled Code)
at oracle.jdbc.driver.OracleDriver.connect(Compiled Code)
at java.sql.DriverManager.getConnection(Compiled Code)
at java.sql.DriverManager.getConnection(Compiled Code)
at Employee.main(Compiled Code)
***************************************************/
ÀÌ·± ¸Þ¼¼Áö°¡ ³ª¿É´Ï´Ù....
µå¶óÀ̹ö´Â thinµå¶óÀ̹ö¸¦ ¿À¶óŬ»ç¿¡¼ ´Ù¿î¹Þ¾Ò°í, setenv ClassPath ¿Í
setenv LD_LIBRARY_PATH /usr/lib:$ORACLE_HOME/lib/:$ORACLE_HOME/jdbc/lib/:LD_LIBRARY_PATH
´Â Á¦´ë·Î ¼ÂÆÃÇß±¸¿ä... ¹°·Ð JDK Æнºµµ ÇÏ¿´½À´Ï´Ù..
±âÁ¾Àº sunOS 5.6À̱¸¿ä...
¿Ö ÀÌ·±Çö»óÀÌ ³ª´ÂÁö °¡¸£ÃÄ ÁÖ¼¼¿ä...