This week's book giveaway is in the OO, Patterns, UML and Refactoring forum.
We're giving away four copies of Refactoring for Software Design Smells: Managing Technical Debt and have Girish Suryanarayana, Ganesh Samarthyam & Tushar Sharma on-line!
See this thread for details.
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
Author

Java-DB2

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.
code:
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() {
super();
}

static {
try {
Class.forName("COM.ibm.db2.jdbc.app.DB2Driver");
} catch (Exception e) {
System.out.println(e);
}
}

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

Error i got is:
java.lang.ClassNotFoundException: COM.ibm.db2.jdbc.app.DB2Driver
java.sql.SQLException: No suitable driver
at java.sql.DriverManager.getConnection(DriverManager.java:563)
at java.sql.DriverManager.getConnection(DriverManager.java:216)
at ClientPrograms.JDBCConnectionFromClient.main( JDBCConnectionFromClient.java:43)

Thanks in adavnce
Prashanth
David Ulicny
Ranch Hand

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

put it in your classpath and it should be OK.


SCJP<br />SCWCD <br />ICSD(286)<br />MCP 70-216
 
I’ve looked at a lot of different solutions, and in my humble opinion Aspose is the way to go. Here’s the link: http://aspose.com
 
subject: Java-DB2
 
jQuery in Action, 3rd edition