• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

jdbc program written in Eclipse3.2.1 to connect DB2

 
riyaz udeen
Ranch Hand
Posts: 66
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
Ilja Preuss
author
Sheriff
Posts: 14112
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
When you run a program from Eclipse, the classpath environment variable isn't used. Instead you need to add the jar file to the projects build path, or to the classpath of the launch configuration (in the Run... dialog).
 
Mr. C Lamont Gilbert
Ranch Hand
Posts: 1170
Eclipse IDE Hibernate Ubuntu
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
JDBC drivers don't need to be in the build path. Only in the runtime path. Depends on if its a plugin project or a java project how you can accomplish that.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic