I am having a hard time understanding something that might be simple..... PLEASE HELP !
I am trying to write a program ,,,,,,,,
import java.sql.*;
import java.io.*;
public class JavaSql1 {
public static void main(
String str[]){
Statement stat;
ResultSet rs;
Connection conn;
try{
Class.forName("*** What do i write here *** "); //what Driver name to specify ??
conn = DriverManager.getConnection("*** What do i write here *** "); // HOw do i specify database name ??
stat = conn.createStatement();
rs = stat.executeQuery("Select * From My_Reminders");
ResultSetMetaData rsmd = rs.getMetaData();
System.out.println("NO. of Clouumns is: " + rsmd.getColumnCount());
for (int i = 0; i <= (rsmd.getColumnCount()); i++)
{
String name = rsmd.getColumnName(i);
System.out.println( name +"/t"+ rsmd.getColumnType(i));
}
stat.close();
conn.close();
}
catch(Exception e){
System.out.println("error");
}
}
}
I am working on Windows 2000
I Am using jdk1.3.1_01
i set the path to "h:\jdk1.3.1_01\bin"
Wish to assess my Database which is in Oracle 9i
Database name "HOME"
and my Program "JavaSql1.java is saved in "h:\My Java"
Where do i see the list of various drivers i have on my system...how do i set it ??
HOw do i know which one to use ?
Your help is greatly appreciated
Thanks
[ March 13, 2002: Message edited by: Richa Jeetah ]