Setting Java-Oracle

Aq udah pernah nyoba dan berhasil…

Mudah2an berhasil juga bwt kamu…

Yang aq pake Java JDK1.6 dan Oracle 10g

Langkah-langkah :

1. Download file classes12.jar di http://otn.oracle.com/software/tech/java/sqlj_jdbc/content.html

atau

search di folder installan Oracle dengan nama classes12.jar

2. Taruh file tersebut d java-nya. Contoh : C:\Program Files\Java\jdk1.6.0_03\jre\lib\ext. Kemudian setting classpath-nya untuk classes12.jar.
Contoh setting classpath di command prompt :  set CLASSPATH=C:\Program Files\Java\jdk1.6.0_03\jre\lib\ext\classes12.jar
Cek dengan memakai command prompt : java oracle.jdbc.driver.OracleDriver.
Kalau errornya kayak gini,Exception in thread “main” java.lang.NoSuchMethodError: main, selamat anda berhasil.
Kalau errornya kayak giniException in thread “main” java.lang.NoClassDefFoundError: oracle/jdbc/driver/OracleDriver, wahh.. harus ngulang lagi dari setting classpath-nya.

Kalo pake netbeans(netbeans 6), file tersebut langsung bisa digunakan tanpa harus setting classpath.

3. Kemudian coba script ini:
import java.sql.*;
import oracle.jdbc.driver.*;
public class DBTest {
public static void main (String args[]) throws Exception {

// Load the Oracle JDBC driver
DriverManager.registerDriver
(new oracle.jdbc.driver.OracleDriver());

// connect through driver
Connection conn = DriverManager.getConnection
(“jdbc:oracle:thin:@127.0.0.1:1521:ORCL”,”scott”,”tiger”);

// Create Oracle DatabaseMetaData object
DatabaseMetaData meta = conn.getMetaData();

// gets driver info:
System.out.println(“JDBC driver version is ” + meta.getDriverVersion());

// Create a statement
Statement stmt = conn.createStatement();

// Do the SQL “Hello World” thing
ResultSet rset = stmt.executeQuery(“SELECT * FROM TAB”);

while (rset.next())
System.out.println(rset.getString(1));

// close the result set, the statement and disconnect
rset.close();
stmt.close();
conn.close();
System.out.println(“Your JDBC installation is correct.”);
}
}

Kalo sukses,alhamdulillah,

Kalo nggak,”Anda belum beruntung”

Peace men….