hye every one. i wrote a jdbc program in Eclipse 3.2.1 java perspective in order to connect Db2. the code is as follows:
import java.sql.*;
public class jdbc {
public static void main( String arg[]) {
Connection c = null;
Statement st = null;
ResultSet rs;
String query = "CREATE TABLE book ( NAME VARCHAR(20),ID INTEGER,RATE INTEGER)";
String query1 = "INSERT INTO book VALUES ( 'HFSJ',1,100)";
String query2= "INSERT INTO book VALUES ( 'JSPCOOKBOOK',2,90)";
try{
Class.forName("com.ibm.db2.jcc.DB2Driver");
}
catch( Exception ex) {
System.out.println(ex.getMessage());
}
try {
c = DriverManager.getConnection("jdbc b2://localhost:50000/sample?UserID=pentium4&password=18may2003");
st = c.createStatement();
st.executeUpdate(query);
st.executeUpdate(query1);
st.executeUpdate(query2);
st.executeUpdate("INSERT INTO BOOK VALUES ( 'SCJP',1,200)");
rs= st.executeQuery("SELECT * FROM BOOK");
while(rs.next())
{
System.out.println(rs.getString("NAME")+" " +rs.getInt("ID")+" "+rs.getInt("MARKS"));
}
}
catch(SQLException e)
{
System.out.println(e.getMessage());
}
}
}
i got the error as "com.ibm.db2.jcc.DB2Driver No suitable driver"
but i have placed the jar files (C:\Program Files\IBM\SQLLIB\java\db2jcc_license_cu.jar;C:\Program Files\IBM\SQLLIB\java\db2jcc.jar) in classpath environmental system variables.
can you kinldy provide me sollution. thanks in advance.
riyazudeen.
import java.sql.*;
public class jdbc {
public static void main( String arg[]) {
Connection c = null;
Statement st = null;
ResultSet rs;
String query = "CREATE TABLE book ( NAME VARCHAR(20),ID INTEGER,RATE INTEGER)";
String query1 = "INSERT INTO book VALUES ( 'HFSJ',1,100)";
String query2= "INSERT INTO book VALUES ( 'JSPCOOKBOOK',2,90)";
try{
Class.forName("com.ibm.db2.jcc.DB2Driver");
}
catch( Exception ex) {
System.out.println(ex.getMessage());
}
try {
c = DriverManager.getConnection("jdbc b2://localhost:50000/sample?UserID=pentium4&password=18may2003");
st = c.createStatement();
st.executeUpdate(query);
st.executeUpdate(query1);
st.executeUpdate(query2);
st.executeUpdate("INSERT INTO BOOK VALUES ( 'SCJP',1,200)");
rs= st.executeQuery("SELECT * FROM BOOK");
while(rs.next())
{
System.out.println(rs.getString("NAME")+" " +rs.getInt("ID")+" "+rs.getInt("MARKS"));
}
}
catch(SQLException e)
{
System.out.println(e.getMessage());
}
}
}
i got the error as "com.ibm.db2.jcc.DB2Driver No suitable driver"
but i have placed the jar files (C:\Program Files\IBM\SQLLIB\java\db2jcc_license_cu.jar;C:\Program Files\IBM\SQLLIB\java\db2jcc.jar) in classpath environmental system variables.
can you kinldy provide me sollution. thanks in advance.
riyazudeen.