File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases and the fly likes Java-DB2 Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "Java-DB2" Watch "Java-DB2" New topic


Prashanth Bhanu
Ranch Hand

Joined: Sep 25, 2003
Posts: 110
Hi Friends,
I've written a simple JDBC program with the intension of connecting to DB2 7.02.I've craeted a table in DB and want my JDBC program shown below to connect it.I'm getting the following error.please help me to sort and understand it better.
import java.util.Hashtable;
import java.util.Properties;

import javax.naming.Context;
import javax.naming.InitialContext;

public class JDBCConnectionFromClient {
static java.sql.Connection con;
* Constructor for JDBCConnectionFromClient.
public JDBCConnectionFromClient() {

static {
try {
} catch (Exception e) {

public static void main(String[] args) {
try {
Connection con = DriverManager.getConnection("jdbc b2 RASHDB");
}catch(Exception ex) {

Error i got is:
java.sql.SQLException: No suitable driver
at java.sql.DriverManager.getConnection(
at java.sql.DriverManager.getConnection(
at ClientPrograms.JDBCConnectionFromClient.main(

Thanks in adavnce
David Ulicny
Ranch Hand

Joined: Aug 04, 2004
Posts: 724
You must have the driver class in your classpath.
this file is and its location on windows is

put it in your classpath and it should be OK.

SCJP<br />SCWCD <br />ICSD(286)<br />MCP 70-216
I agree. Here's the link:
subject: Java-DB2
jQuery in Action, 3rd edition