Converting a JDBC app from MySQL to Oracle 9

[M Burke]

I have an app I want to convert to Oracle 9. But I am not sure what settings I need, and what needs to go into my classpath.


Here is a simplified version...

import java.sql.*;
import com.mysql.jdbc.Driver;

public class DBTest{

public static void main(String[] args){
try{
Class.forName("com.mysql.jdbc.Driver").newInstance();
java.sql.Connection con;
con = DriverManager.getConnection("jdbc:mysql:///customer", "root", "");
Statement st = con.createStatement();
ResultSet rs = st.executeQuery("Select * from names");

while(rs.next()){
System.out.println(rs.getString(1) + " " + rs.getString(2) + " " + rs.getString(3));
}

rs.close();
st.close();
con.close();


} catch (SQLException se){
System.out.println("MYSQL: " + se);
} catch (Exception e) {
System.out.println("Excep : " + e);
}

}
}

[Akshatha Nayak]

hi

if u have installed oracle properly & if u r using thin client .. then u need to put classes12.jar in ur claspath .. & run this program ... if it runs properly displaying all the metadata .. then everything is fn .. see how they have connecte to oracle u have to use change host & databasename & enter whatz in ur oracle ..

  import java.sql.*;
import oracle.jdbc.OracleDatabaseMetaData;
public class DatabaseMetaDataSample  {
static final String dbURI = "jdbc :-o	 racle:thin:@host :mrgreen: atabasename";
  public static void main(String args[]) throws Exception {
 
    // Connection reference
    Connection conn = null;
 
    try {
 
      // Load database driver
      DriverManager.registerDriver (new oracle.jdbc.OracleDriver());
 
      // Make connection
      conn = DriverManager.getConnection(dbURI,"SCOTT","TIGER");
 
      // Get the database meta data
      OracleDatabaseMetaData dmd = (OracleDatabaseMetaData)conn.getMetaData();
 

      if (dmd == null) {
        System.out.println("Database meta data not available");
      } else {
 
        // Dispay Database Produce Name
        System.out.println("Database Product Name : " +
            dmd.getDatabaseProductName());
 
        // Dispay Database Produce Version
        System.out.println("Database Product Version : " +
            dmd.getDatabaseProductVersion());
 
        // Dispay Maximum Lenght of Table Name
        System.out.println("Maximum Table Name length : " +
            dmd.getMaxTableNameLength());
 
        // Dispay precision for LOB
        System.out.println("LOB Precision : " +
            dmd.getLobPrecision());
 

        // Dispay if the database uses local files
        if (dmd.usesLocalFiles())
          System.out.println("The Database uses Local Files");
        else
          System.out.println("The Database does not use Local Files");
 

        System.out.println("The following Schemas are available in the database:");
        ResultSet rs = dmd.getSchemas();
        ResultSet rs1 = null;
        while(rs.next()) {
          System.out.println(rs.getString(1));
          System.out.println(
              "The following tables are available in the "+rs.getString(1)+" schema:");
          rs1 = dmd.getTables(null,rs.getString(1),"%",null);
          while(rs1.next()) {
            System.out.println("   "+ rs1.getString(3)+" : "+rs1.getString(4));
          }
        }
      }
    } finally {
 
      // Close connection
      if (conn != null) {
        try {
          conn.close();
        } catch (SQLException ex) {
           System.out.println("Error in closing Conection");
        }
      }
    }
  }
}

[M Burke]

Thanks, but what does this mean?

static final String dbURI = "jdbc racle:thin:@host atabasename";

[Akshatha Nayak]

that is the url you r using to connect to ur oracle database ..
it is jdbc racle:thin@<hostname>:<databasename>
checkout this site http://www.javaskyline.com/learnjdbc.html

[Akshatha Nayak]

also check out this site

http://www.informit.com/articles/article.asp?p=26251&seqNum=3

[M Burke]

It works, Akshatha. Thank you for your help

[Bear Bibeault]

Akshatha Nayak,

JavaRanch is a community of people from all over the world, many of who are not native English speakers. While using abbreviations like "u" instead of spelling out "you" is convenient when text messaging your friends on a cell phone or in a chat room, it presents an extra challenge to those that are already struggling with English. Additionally, such shortcuts may confound automated translation tools that patrons of the Ranch may be making use of.

I would like to ask for your help in making the content of JavaRanch a little easier to read for everybody that visits here by not using such abbreviations.

thanks,
bear
Forum Bartender