±Û¾´ÀÌ :Çѵ¿¼ö 1998³â 11¿ù 06ÀÏ 22:56:41
JDBC °ü·ÃµÈ ¿¹Á¦°¡ ÀÖ¾î¼ ½ÇÇàÀ» ½ÃÅ°´Âµ¥ compileÀº ÀߵǴµ¥ ½ÇÇà½ÃÅ°¸é ´ÙÀ½°ú
°°Àº ¿¡·¯°¡ ¹ß»ýµË´Ï´Ù.
ld.so.1: /usr/local/jdk1.1.5/bin/sparc/green_threads/java: fatal: libodbcinst.so.1: can't open file: errno=2 (libJdbcOdbc.so)
problems connecting to jdbc:odbc:wombat
problems with SQL sent to jdbc:odbc:wombat: null
Ãß°¡·Î URLÀÇ subnameÀº ¾î¶»°Ô ¸¸µå³ª¿ä ? À§¿¡¼ º¸¸é subname wombat¿¡ ¹®Á¦°¡ ÀÖ´Â°Í °°Àºµ¥..
Àú´Â solaris¿¡¼ ÀÛ¾÷À» ÇÏ°í ÀÖ½À´Ï´Ù.
Âü°í·Î Á¦°¡ ¼öÇà½ÃŲ ¼Ò½º´Â ´ÙÀ½°ú °°½À´Ï´Ù.
import java.sql.*; //import all the JDBC classes
public class CreateJoltData {
static String[] SQL = {
"create table JoltData ("+
"programmer varchar (32),"+
"day varchar (3),"+
"cups integer);",
"insert into JoltData values ('Gilbert', 'Mon', 1);",
"insert into JoltData values ('Wally', 'Mon', 2);",
"insert into JoltData values ('Edgar', 'Tue', 8);",
"insert into JoltData values ('Wally', 'Tue', 2);",
"insert into JoltData values ('Eugene', 'Tue', 3);",
"insert into JoltData values ('Josephine', 'Wed', 2);",
"insert into JoltData values ('Eugene', 'Thu', 3);",
"insert into JoltData values ('Gilbert', 'Thu', 1);",
"insert into JoltData values ('Clarence', 'Fri', 9);",
"insert into JoltData values ('Edgar', 'Fri', 3);",
"insert into JoltData values ('Josephine', 'Fri', 4);",
};
public static void main(String[] args) {
String URL = "jdbc:odbc:wombat";
String username = "";
String password = "";
try {
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
} catch (Exception e) {
System.out.println("Failed to load JDBC/ODBC driver.");
return;
}
Statement stmt = null;
Connection con=null;
try {
con = DriverManager.getConnection (
URL,
username,
password);
stmt = con.createStatement();
} catch (Exception e) {
System.err.println("problems connecting to "+URL);
}
try {
// execute SQL commands to create table, insert data
for (int i=0; i<SQL.length; i++) {
stmt.execute(SQL[i]);
}
con.close();
} catch (Exception e) {
System.err.println("problems with SQL sent to "+URL+
": "+e.getMessage());
}
}
}