[ssquire]

From Database Explorer, when I attempt to establish a new database connection, using the New Connection Profile Wizard, and I select MySQL Connect/J, I get a red x under “New Database Connection Driver” that states “Driver class not found”. I’m using MyEclipse Blue, and when I check in the MyEclipse Configuration Center – it tells me that I have database tools installed. This is part of the Database Tools Tutorial, does anyone know what could be wrong?

[support-swapna]

ssquire,

1) Please share your installation details with us from MyEclipse > Installation Summary > Installation Details. Paste it here for me.

2) Attached is the screenshot for the MySQL Connector. You need to add the corresponding mysql-connector-java jar file to the Driver Jars list. User name : root, Password : root.

3) Make sure the MySQL service is running at Control Panel > Administrative Tools > Services. Once you fill in all the required values you can click on ‘Test Driver’ to check if the connection is successful.

Let me know how this works for you.

Attachments:

You must be logged in to view attached files.

[ssquire]

INSTALLATION DETAILS

*** Date:
Thursday, March 24, 2011 1:46:49 PM EDT

** System properties:
OS=WindowsVista
OS version=6.1.0
Java version=1.6.0_13

*** MyEclipse details:
MyEclipse Blue Edition
Version: 8.6 Blue
Build id: 8.6-Blue-20100806

*** Eclipse details:
MyEclipse Blue Edition

Version: 8.6 Blue
Build id: 8.6-Blue-20100806

Eclipse Platform

Version: 3.5.2.R35x_v20100210-0800-9hEiFzmFst-TiEn9hNYgDWg1XN8ulH_JvCNGB
Build id: M20100211-1343

Eclipse Java Development Tools

Version: 3.5.2.r352_v20100108-7r88FEwFI0WTuoBl0iaG0tyhfZH6
Build id: M20100211-1343

Eclipse Plug-in Development Environment

Version: 3.5.2.R35x_v20100119-7Z7_FA2FDX-aXQYWqYDBz-z0qufo
Build id: M20100211-1343

Eclipse Graphical Editing Framework GEF

Version: 3.5.2.v20100111-1352-777928194B66D5D476C33B2A
Build id: 201001111753

Eclipse RCP

Version: 3.5.2.R35x_v20100119-9SA0FxwFnoCU5XxWItFdXXb27BA6
Build id: M20100211-1343

Eclipse startup command=-os
win32
-ws
win32
-arch
x86
-showsplash
-launcher
C:\Users\ssquire\AppData\Local\Genuitec\MyEclipse-Blue-Edition-8.6\myeclipse-blue.exe
-name
Myeclipse-blue
–launcher.library
C:\Users\ssquire\AppData\Local\Genuitec\MyEclipse-Blue-Edition-8.6\../Common/plugins/org.eclipse.equinox.launcher.win32.win32.x86_1.0.200.v20090519\eclipse_1206.dll
-startup
C:\Users\ssquire\AppData\Local\Genuitec\MyEclipse-Blue-Edition-8.6\../Common/plugins/org.eclipse.equinox.launcher_1.0.201.R35x_v20090715.jar
-install
C:/Users/ssquire/AppData/Local/Genuitec/MyEclipse-Blue-Edition-8.6
-configuration
configuration
-vm
C:/Users/ssquire/AppData/Local/Genuitec/Common/binary/com.sun.java.jdk.win32.x86_1.6.0.013/jre/bin/client/jvm.dll

END INSTALLATION DETAILS

I could show you the New Database Connection Screen, but I can’t figure out how to add a graphic to this post.

[support-swapna]

ssquire,

1) Clear the contents of the .log file which is located at <workspace dir>/.metadata folder. Try to create the New MYSQL connection and check the .log file for any errors of interest. Please paste them here for me.

2) You can use the ‘pm’ button to attach the image in the ‘Add Attachment’ section.

[ssquire]

The contents of the .log file is below:

!SESSION 2011-03-25 13:11:47.865 ———————————————–
eclipse.buildId=unknown
java.version=1.6.0_13
java.vendor=Sun Microsystems Inc.
BootLoader constants: OS=win32, ARCH=x86, WS=win32, NL=en_US
Command-line arguments: -os win32 -ws win32 -arch x86

!ENTRY org.eclipse.jface 2 0 2011-03-25 13:12:02.654
!MESSAGE Keybinding conflicts occurred. They may interfere with normal accelerator operation.
!SUBENTRY 1 org.eclipse.jface 2 0 2011-03-25 13:12:02.654
!MESSAGE A conflict occurred for SHIFT+DEL:
Binding(SHIFT+DEL,
ParameterizedCommand(Command(org.eclipse.datatools.sqltools.result.removeAllInstances,Remove All Visible Results,
,
Category(org.eclipse.datatools.sqltools.result.category,SQL Results View,null,true),
,
,,true),null),
org.eclipse.ui.defaultAcceleratorConfiguration,
org.eclipse.ui.contexts.window,,,system)
Binding(SHIFT+DEL,
ParameterizedCommand(Command(org.eclipse.ui.edit.cut,Cut,
Cut the selection to the clipboard,
Category(org.eclipse.ui.category.edit,Edit,null,true),
org.eclipse.ui.internal.handlers.WidgetMethodHandler@11addf0,
,,true),null),
org.eclipse.ui.defaultAcceleratorConfiguration,
org.eclipse.ui.contexts.dialogAndWindow,,,system)
Binding(SHIFT+DEL,
ParameterizedCommand(Command(org.topcased.modeler.deleteModelObject,Delete From Model,
Allows the user to delete the selected graph element and its associated model element in a Topcased editor.,
Category(org.eclipse.ui.category.edit,Edit,null,true),
,
,,true),null),
org.eclipse.ui.defaultAcceleratorConfiguration,
org.eclipse.ui.contexts.window,,,system)

!ENTRY org.eclipse.osgi 2 1 2011-03-25 13:12:03.730
!MESSAGE NLS unused message: prompt.optclasspath in: com.genuitec.eclipse.easie.core.configuration

!ENTRY org.eclipse.osgi 2 1 2011-03-25 13:12:03.730
!MESSAGE NLS unused message: prompt.preclasspath in: com.genuitec.eclipse.easie.core.configuration

!ENTRY org.eclipse.osgi 2 1 2011-03-25 13:12:03.730
!MESSAGE NLS unused message: prompt.optlibrarypath in: com.genuitec.eclipse.easie.core.configuration

[ssquire]

Swapna – after studying this problem virtually all day, do I simply need to import the MySQL driver to MyEclipse? If so, where is the driver stored?

[ssquire]

Swapna – thank you for your help! I believe I found the answer by looking at your graphic and filling in MySQL in the second line. I think I may have made it harder than it was. Sorry!

[support-swapna]

ssquire,

Glad that it is working fine.
Do let us know if you have any other issues.

[ssquire]

Why is the only database name “<dbname>” that the MySQL Connector/J accepts “test”? I don’t seem to be able to use any other names. (See your example image above)

[support-swapna]

ssquire,

The screenshot shows Test just as an example. You can use any other database in the connection string. I created a new database test1 and used it in the connection string and it works.
Attached is the screenshot for the same. Can you check if the same works for you?

Attachments:

You must be logged in to view attached files.

[support-swapna]

ssquire,

The screenshot shows Test just as an example. You can use any other database in the connection string. I created a new database test1 and used it in the connection string and it works.
Attached is the screenshot for the same. Can you check if the same works for you?

Attachments:

You must be logged in to view attached files.

[ssquire]

Swapna,
What is a good source to study so I can start integrating my Struts, JSPs, & MySQL knowledge. I’m trying to build a Web based, database driven application. For instance, I now know how to create my Employee Table with fields etc. in MySQL, but I don’t know how to lay my page out the way I want it, or the syntax for storing the employee data entered on my page in my database.

[support-swapna]

ssquire,

Here is the link to the tutorials section of MyEclipse. Please refer to them. They will be a good starting point.
http://myeclipseide.com/module-htmlpages-display-pid-7.html

For all java development related queries you can look up on the internet or post to the dev forums.

Hope this helps

[Author]

Posts