맥에 오라클 JDBC 드라이버 설치 , Oracle JDBC driver installation for mac

다운로드

ORACLE SITE DOWNLOAD <== click

jdk 1.5 : ojdbc5.jar

jdk 6.0 : ojdbc6.jar

아래 두파일중 하나를 다운로드 하셔도 됩니다.

ojdbc5.jar

ojdbc6.jar

다운로드된 경로에서 자신의 JVM버젼에 맡게 복사 

sudo cp ojdbc6.jar /System/Library/Frameworks/JavaVM.framework/Versions/1.6.0/Home/lib/ext/

위처럼 해도 안돼시는 분은

java -classpath /System/Library/Frameworks/JavaVM.framework/Versions/1.6.0/Home/lib/ext/  -jar ojdbc6.jar

TestCode

package Modules;

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.SQLException;

public class testStarter {

public static void main(String args[]){

try {

Class.forName("oracle.jdbc.driver.OracleDriver");

} catch (ClassNotFoundException e1) {

// TODO Auto-generated catch block

e1.printStackTrace();

}

Connection conn;

try {

conn = DriverManager.getConnection("jdbc:oracle:thin:@host:port:sid", "USER_ID", "PASSWD");

Statement stmt = conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE, 

                                                           ResultSet.CONCUR_READ_ONLY);

ResultSet srs = stmt.executeQuery("SELECT empno, ename FROM emp")

while (srs.next()) { int empno = srs.getInt("EMPNO"); String name = srs.getString("ENAME"); System.out.println(empno + " " + name); } conn.close();

} catch (SQLException e) {

// TODO Auto-generated catch block

e.printStackTrace();

}

}

}