Code to access db2e databse from java ?

[Former Member]

i am woking on MAM application of SAP MI

[Former Member]

Hai,

how do you want to access the database.

u want code for JDBC.

Different 4 types of drivers r there.

give more info.

for MYSQL

Class.forName("org.gjt.mm.mysql.Driver").newInstance();

}

catch (Exception exc) {

System.err.println("Exception in init(): Unable to load JDBC driver");

exc.printStackTrace();

}

try {

conn = DriverManager.getConnection("jdbc:mysql://localhost/" + DBNAME);

FOR ORACLE

// Connection conn = new oracle.jdbc.driver.OracleDriver().

// defaultConnection ();

Connection conn = DriverManager.getConnection(connStr,

"scott", "tiger");

Statement stmt = conn.createStatement ();

ResultSet rset = stmt.executeQuery ("SELECT DIVISION, COMPLAINT, " +

" CPU_CODE ,COMP_DT FROM scott.Bug ");

come back for more info.good luck