±Û¾´ÀÌ :¹Ú¼±¿µ 1999³â 4¿ù 13ÀÏ 19:15:09
AIX¿¡ ÀÖ´Â IBM DB2¸¦ AccessÇÏ´Â °£´ÜÇÑ JDBC ApplicationÀ» ÀÛ¼ºÇߴµ¥ ÀÌ·± ExceptionÀÌ
¹ß»ýÇÕ´Ï´Ù.
JDBC ApplicationÀÇ Source ºÎºÐÀº
import java.sql.*;
public class SampleJdbc
{
public static void main(String[] args)
{
try
{
Class.forName("COM.ibm.db2.jdbc.app.DB2Driver").newInstance();
}catch(Exception e)
{
e.printStackTrace();
}
String url = "jdbc:db2:sample";
Connection con = null;
Statement stmt = null;
try
{
con = DriverManager.getConnection(url);
System.out.println("Database Connected");
con.close();
}catch(SQLException e)
{
e.printStackTrace();
}
}
ÀÌ°í ÄÄÆÄÀÏÇÏ°í ½ÇÇà½Ã¿¡ ÀÌ·± ExceptionÀÌ ¹ß»ýÇÕ´Ï´Ù.
java.sql.SQLException: DB2 Driver error allocating environment handle, rc=-1
at COM.ibm.db2.jdbc.app.DB2Driver.<init>(DB2Driver.java:148)
at DB2Appl.<clinit>(DB2Appl.java:28)
java.sql.SQLException: No suitable driver
at java.sql.DriverManager.getConnection(DriverManager.java:103)
at java.sql.DriverManager.getConnection(DriverManager.java:141)
at DB2Appl.main(DB2Appl.java:43)
AIX¿¡ ȯ°æº¯¼ö·Î´Â
CLASSPATH=$CLASSPATH:/home/db2inst1/sqllib/java/db2java.zip
LIBPATH=$LIBPATH:/home/db2inst1/sqllib/lib
ÀÔ´Ï´Ù.
ÀÌ ¹®Á¦¿¡ ´ëÇÑ ¾î¶² ÀÇ°ßÀÌ¶óµµ ÁÁÀ¸´Ï Á¦¹ß ºÎŹµå¸³´Ï´Ù.