Eclipse Community Forums: Java Development Tools (JDT) » JDBC Connection for Java ( IBM Data Studio )

Home » Language IDEs » Java Development Tools (JDT) » JDBC Connection for Java ( IBM Data Studio )(Java codes for JDBC)

Show: Today's Messages :: Show Polls :: Message Navigator

JDBC Connection for Java ( IBM Data Studio ) [message #957149]

Thu, 25 October 2012 02:59

Bert Hernandez

Messages: 4
Registered: October 2012

Junior Member

package SMART;

import java.sql.*;
public class HelloWorld {
public static void main(String[] args) {
try
{
Class.forName("COM.ibm.db2.jdbc.app.DB2Driver");
Connection con = DriverManager.getConnection("jdbc:db2:/localhost:50000/CSP");
Statement statement = con.createStatement();
String createProductTable="CREATE TABLE PRODUCT"+
"(NAME VARCHAR(64)," +
"ID VARCHAR(32) NOT NULL," +
"PRICE FLOAT," +
"DESC VARCHAR(256)," +
"PRIMARY KEY(ID))";
statement.executeUpdate(createProductTable);
}
catch(Exception e){ e.printStackTrace();
}
}

}

- Everytime I run this . This error always pop out
" java.lang.ClassNotFoundException: COM.ibm.db2.jdbc.app.DB2Driver
at java.lang.Class.forName(Class.java:139)
at SMART.HelloWorld.main(HelloWorld.java:8) "

They have said that my Class.forName has no source. Also if I needed to attach a source? what is it and where will I find it?

Best Regards,
G.L Hernandez

Report message to a moderator

Re: JDBC Connection for Java ( IBM Data Studio ) [message #957827 is a reply to message #957149]

Thu, 25 October 2012 14:24

Eclipse User

> - Everytime I run this . This error always pop out
> " java.lang.ClassNotFoundException: COM.ibm.db2.jdbc.app.DB2Driver
> at java.lang.Class.forName(Class.java:139)
> at SMART.HelloWorld.main(HelloWorld.java:8) "
>
> They have said that my Class.forName has no source. Also if I needed to
> attach a source? what is it and where will I find it?
>
> Best Regards,
> G.L Hernandez

It basically says it can't find that class (i.e. ClassNotFoundException
means it can't find that class). That is the old obsolete type 2 DB2
driver. You should be using the now standard com.ibm.db2.jcc.DB2Driver
which is in the db2jcc.jar from DB2.

Rich

Report message to a moderator

Re: JDBC Connection for Java ( IBM Data Studio ) [message #957873 is a reply to message #957827]

Thu, 25 October 2012 15:08

Bert Hernandez

Messages: 4
Registered: October 2012

Junior Member

Okay sir. Thank you very much for the answer. I will try this ASAP

Report message to a moderator

Re: JDBC Connection for Java ( IBM Data Studio ) [message #957908 is a reply to message #957827]

Thu, 25 October 2012 15:41

Bert Hernandez

Messages: 4
Registered: October 2012

Junior Member

Still same error sir Rich . What should I do?

Report message to a moderator

Re: JDBC Connection for Java ( IBM Data Studio ) [message #958006 is a reply to message #957908]

Thu, 25 October 2012 17:16

Eclipse User

It means it is not in your classpath. Make sure that the db2jcc.jar is
in your classpath for your launch configuration. (Using the com. not
COM. class name in Class.forName("...")

On 10/25/2012 11:41 AM, Bert Hernandez wrote:
> Still same error sir Rich . What should I do?

Report message to a moderator

Previous Topic:	ECJ usage in eclipse plugin
Next Topic:	[SOLVED] generated equals missing not null check

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Apr 23 08:55:56 GMT 2024

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter