Programming Forums > Application Development > Java

Konnor · Mar 6th, 2006, 5:49 PM

struggling to connect to a database i made in DB2.

The programs errors at the first line...

// load the DB2 Driver
Class.forName("COM.ibm.db2.jdbc.app.DB2Driver");

with..

maybe some more configaration is required.

Any hints would be much obliged.

Just for reference, the rest of the program is:

(Toggle Plain Text)

class JDBCSample1 
{
	public static void main(String argv[]) 
	{
		try 
		{
		   // load the DB2 Driver
           Class.forName("COM.ibm.db2.jdbc.app.DB2Driver");
           // establish a connection to DB2
           Connection db2Conn = 
         DriverManager.getConnection
             ("jdbc:db2:test","","");
           // use a statement to gather data from the database
            Statement st = db2Conn.createStatement();
            String myQuery = "SELECT * FROM TEST"; 
           // execute the query
            ResultSet resultSet = st.executeQuery(myQuery); 
           // cycle through the resulSet and display what was grabbed
           // clean up resources
           resultSet.close();
           st.close();
           db2Conn.close();
       }
       catch (ClassNotFoundException cnfe)
       {
           cnfe.printStackTrace();
       }
       catch (SQLException sqle)
       {
           sqle.printStackTrace();
       }
	}
}

Arevos · Mar 7th, 2006, 3:22 AM

Package names are case sensitive, IIRC, and "COM" is an unusual root. Try "com" instead.

Konnor · Mar 7th, 2006, 4:55 AM

still the same error unfortunately. I searched on the web for the URL so have no idea what it means.

Arevos · Mar 7th, 2006, 5:26 AM

Is the DB2 driver jar in the classpath?

Konnor · Mar 7th, 2006, 7:10 AM

probably not...

How do i do this?

Arevos · Mar 7th, 2006, 3:56 PM

Quote:

Originally Posted by Konnor

probably not...

How do i do this?

I've never used DB2 before, but you'll undoubtably need a JDBC driver for DB2 in order to connect to it. IBM will probably have this somewhere on its site. Once you have the driver, run your program like so:

(Toggle Plain Text)

java -classpath db2driver.jar;. YourClass

This tells Java to use the classes found in driver.jar, and in the current directory ('.' for short).

Konnor · Mar 10th, 2006, 6:54 PM

managed to get it working cheers.

ddaudi8 · Apr 1st, 2009, 1:26 PM

Hi there,

I'm having the same problem. Could please tell me what you exactly did?

Thx in advance

David

amragman · Jul 8th, 2009, 4:13 AM

Just google for JDBC DB2 driver...download it...and include it in the classpath of your program!!

Mar 6th, 2006, 5:49 PM	#1
Konnor Newbie Join Date: Aug 2005 Posts: 26 Rep Power: 0	JDBC DB2 connection struggling to connect to a database i made in DB2. The programs errors at the first line... (Toggle Plain Text) // load the DB2 Driver Class.forName("COM.ibm.db2.jdbc.app.DB2Driver"); // load the DB2 Driver Class.forName("COM.ibm.db2.jdbc.app.DB2Driver"); with.. maybe some more configaration is required. Any hints would be much obliged. Just for reference, the rest of the program is: (Toggle Plain Text) class JDBCSample1 { public static void main(String argv[]) { try { // load the DB2 Driver Class.forName("COM.ibm.db2.jdbc.app.DB2Driver"); // establish a connection to DB2 Connection db2Conn = DriverManager.getConnection ("jdbc:db2:test","",""); // use a statement to gather data from the database Statement st = db2Conn.createStatement(); String myQuery = "SELECT * FROM TEST"; // execute the query ResultSet resultSet = st.executeQuery(myQuery); // cycle through the resulSet and display what was grabbed // clean up resources resultSet.close(); st.close(); db2Conn.close(); } catch (ClassNotFoundException cnfe) { cnfe.printStackTrace(); } catch (SQLException sqle) { sqle.printStackTrace(); } } } class JDBCSample1 { public static void main(String argv[]) { try { // load the DB2 Driver Class.forName("COM.ibm.db2.jdbc.app.DB2Driver"); // establish a connection to DB2 Connection db2Conn = DriverManager.getConnection ("jdbc:db2:test","",""); // use a statement to gather data from the database Statement st = db2Conn.createStatement(); String myQuery = "SELECT * FROM TEST"; // execute the query ResultSet resultSet = st.executeQuery(myQuery); // cycle through the resulSet and display what was grabbed // clean up resources resultSet.close(); st.close(); db2Conn.close(); } catch (ClassNotFoundException cnfe) { cnfe.printStackTrace(); } catch (SQLException sqle) { sqle.printStackTrace(); } } }

Apr 1st, 2009, 1:26 PM	#8
ddaudi8 Newbie Join Date: Apr 2009 Posts: 1 Rep Power: 0	Re: JDBC DB2 connection Hi there, I'm having the same problem. Could please tell me what you exactly did? Thx in advance David

Jul 8th, 2009, 4:13 AM	#9
amragman Genemesis Join Date: Jul 2009 Posts: 44 Rep Power: 0	Re: JDBC DB2 connection Just google for JDBC DB2 driver...download it...and include it in the classpath of your program!! __________________ Genemesis

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

Mar 7th, 2006, 3:22 AM	#2
Arevos Programming Guru Join Date: Aug 2005 Location: England Posts: 1,499 Rep Power: 6	Package names are case sensitive, IIRC, and "COM" is an unusual root. Try "com" instead.

Mar 7th, 2006, 4:55 AM	#3
Konnor Newbie Join Date: Aug 2005 Posts: 26 Rep Power: 0	still the same error unfortunately. I searched on the web for the URL so have no idea what it means.

Mar 7th, 2006, 5:26 AM	#4
Arevos Programming Guru Join Date: Aug 2005 Location: England Posts: 1,499 Rep Power: 6	Is the DB2 driver jar in the classpath?

Mar 7th, 2006, 7:10 AM	#5
Konnor Newbie Join Date: Aug 2005 Posts: 26 Rep Power: 0	probably not... How do i do this?

Mar 10th, 2006, 6:54 PM	#7
Konnor Newbie Join Date: Aug 2005 Posts: 26 Rep Power: 0	managed to get it working cheers.

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)

Programming Forums > Application Development > Java

JDBC DB2 connection