Eclipse Community Forums: Newcomers » Connecting to MySql 5.0

Home » Newcomers » Newcomers » Connecting to MySql 5.0

Connecting to MySql 5.0 [message #193207]

Sat, 10 February 2007 07:01

Eclipse User

Originally posted by: alnoor20000.yahoo.co.uk

Hi,
I have got the 3.2.1 eclipse version and MySql 5.0, how do I make a
connection to the database; What plug-ins if any do I need to install.
Any pointers on how do i connect??
Thanks

Re: Connecting to MySql 5.0 [message #193213 is a reply to message #193207]

Sat, 10 February 2007 08:17

Eclipse User

Originally posted by: csae7511.uibk.ac.at

Hi,

you can use the jdbc drivers prodived by MySQL or use persistency
frameworks like hibernate.

HTH,
Stefan

Jalal schrieb:
> Hi,
> I have got the 3.2.1 eclipse version and MySql 5.0, how do I make a
> connection to the database; What plug-ins if any do I need to install.
> Any pointers on how do i connect??
> Thanks
>
>

Re: Connecting to MySql 5.0 [message #193303 is a reply to message #193207]

Sat, 10 February 2007 23:10

Eclipse User

Originally posted by: eclipse5.rizzoweb.com

Jalal wrote:
> Hi,
> I have got the 3.2.1 eclipse version and MySql 5.0, how do I make a
> connection to the database; What plug-ins if any do I need to install.
> Any pointers on how do i connect??
> Thanks

Honestly, you do not provide enough details about what you want to do.
Do you need to connect from a program you are writing? Do you want a
database "browsing" tool to inspect your db? Etc?

Help us help you - give details of what you're trying to achieve.

Re: Connecting to MySql 5.0 [message #193361 is a reply to message #193303]

Sun, 11 February 2007 08:49

Eclipse User

Originally posted by: alnoor20000.yahoo.co.uk

Hi there, Thanks for your reply. What i want to do is, I have a java program
that connects to the MySql database, and retrieve some records from the
table. I would like also to be able to update records in the the tables.(
Running the program through the command line window works fine, the
connection is established and the records are retrieved) but comming to
eclipse, it is just giving me the following error.
java.lang.ClassNotFoundException: com.mysql.jdbc.Driver

at java.net.URLClassLoader$1.run(Unknown Source)

at java.security.AccessController.doPrivileged(Native Method)

at java.net.URLClassLoader.findClass(Unknown Source)

at java.lang.ClassLoader.loadClass(Unknown Source)

at sun.misc.Launcher$AppClassLoader.loadClass(Unknown Source)

at java.lang.ClassLoader.loadClass(Unknown Source)

at java.lang.ClassLoader.loadClassInternal(Unknown Source)

at java.lang.Class.forName0(Native Method)

at java.lang.Class.forName(Unknown Source)

at menu.DisplayAuthors.main(DisplayAuthors.java:26)

"Eric Rizzo" <eclipse5@rizzoweb.com> wrote in message
news:eqm4s0$hvc$4@utils.eclipse.org...
> Jalal wrote:
>> Hi,
>> I have got the 3.2.1 eclipse version and MySql 5.0, how do I make a
>> connection to the database; What plug-ins if any do I need to install.
>> Any pointers on how do i connect??
>> Thanks
>
> Honestly, you do not provide enough details about what you want to do. Do
> you need to connect from a program you are writing? Do you want a database
> "browsing" tool to inspect your db? Etc?
>
> Help us help you - give details of what you're trying to achieve.

Re: Connecting to MySql 5.0 [message #193552 is a reply to message #193361]

Mon, 12 February 2007 10:39

Eclipse User

Ok, this does not sound like a problem with Eclipse.

You have to download a JDBC driver for MySQL, and you have to put it in
the classpath of your project. To put it in the classpath in Eclipse,
right-click your project, choose Properties in the pop-up menu, go to Java
Build Path, go to the tab Libraries, and click on the button "Add JARs"
(if the JAR file with the driver is in your project) or "Add External
JARs" (if you have the JAR file somewhere outside your project).

Then add the JAR file with the JDBC driver.

[OT: add jar at runtime] Re: Connecting to MySql 5.0 [message #193561 is a reply to message #193552]

Mon, 12 February 2007 11:43

Eclipse User

Originally posted by: hkaest.mro.man.de

"Jesper" wrote:

> right-click your project, choose Properties in the pop-up menu, go to Java
> Build Path, go to the tab Libraries, and click on the button "Add JARs"
> (if the JAR file with the driver is in your project) or "Add External
> JARs" (if you have the JAR file somewhere outside your project).

Hi,

my problem is not far away from the topic of this thread. That's why i try
to post it here.

I have a plug-in that has the option to store data in a database, that is
not known at development time. The user of the plugin has to declare the
driver and the URL for the connection. That means the jar file has to be
added to the classpath at runtime. Who can i manage this?

Thanks
Harald

Re: [OT: add jar at runtime] Re: Connecting to MySql 5.0 [message #197163 is a reply to message #193561]

Thu, 01 March 2007 07:26

Eclipse User

Hi,
Please report your problum as detail. If you wand to connect with java
and MySQL or C/C++ with MYSQL or PHP with MYSQL. These all things are
possible. Please write the details.

Sabeesh.C.S

Re: [OT: add jar at runtime] Re: Connecting to MySql 5.0 [message #197457 is a reply to message #197163]

Fri, 02 March 2007 04:14

Eclipse User

Originally posted by: hkaest.mro.man.de

> Please report your problum as detail. If you wand to connect with java
> and MySQL or C/C++ with MYSQL or PHP with MYSQL. These all things are
> possible. Please write the details.

My need was to connect with java and any database which can be connected
with a jdbc driver. I managed it in the meantime by writting my own
DriverManager and using an URLClassLoader. Like the tool squirrel does.

Thanks for your help.

--Harald

Previous Topic:	subclassing org.eclipse.wst.xmleditor?
Next Topic:	new FormEntry gives a Discouraged access warning

Goto Forum:

-=] Back to Top [=-

Current Time: Fri Jul 25 02:29:42 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter