When I go into the Database Explorer and try to create a new database connection driver it always shows the error message: "Driver class not found" and thus does not let me complete the operation. Can anyone lead me in the right direction to solve this problem?

Here are my steps to reprroduce:
1. Go to the Database Explorer
2. Right click on the view and select the New... option
3. Add the jar file for PostgreSQL version 8.3
4. Doesn't matter what I put in all the other input fields it always says "Driver class not found"

By the way if I select any driver template the same thing happens.

Can you go to MyEclipse > Installation Summary > Installation Details and paste the information here for me.

Quote:

3. Add the jar file for PostgreSQL version 8.3

Is this the driver jar that you are adding here? Does the Driver Classname drop down get populated when you add the jar?

You can refer to this tutorial:-
http://www.myeclipseide.com/documentation/quickstarts/dbexplorer/#4

Installation Details:

*** Date:
Monday, July 14, 2008 9:58:02 AM MDT

** System properties:
OS=WindowsVista
OS version=6.0
Java version=1.5.0_14


*** MyEclipse details:
MyEclipse Enterprise Workbench
Version: 6.5.0 GA
Build id: 6.5.0-GA-20080609


*** Eclipse details:
MyEclipse Enterprise Workbench

Version: 6.5.0 GA
Build id: 6.5.0-GA-20080609




Eclipse Platform

Version: 3.3.3.r33x_r20080129-_19UEl7Ezk_gXF1kouft
Build id: M20080221-1800


Eclipse Java Development Tools

Version: 3.3.2.r33x_r20080129-7o7jE7_EDhYDiyVEnjb1pFd7ZGD7
Build id: M20080221-1800


Eclipse Project SDK

Version: 3.3.3.r33x_r20080129-7M7J7LB-u3aphGW6o3_VmiVfGXWO
Build id: M20080221-1800


Eclipse RCP

Version: 3.3.3.r33x_r20080129-8y8eE9UEUWI6qujeED0xT7bc
Build id: M20080221-1800


Eclipse Plug-in Development Environment

Version: 3.3.3.r33x_r20080129-7N7M5DQVIA_6oJsEFkEL
Build id: M20080221-1800


Eclipse Graphical Editing Framework

Version: 3.3.2.v20080129
Build id: 20080221-1602




Eclipse startup command=-os
win32
-ws
win32
-arch
x86
-showsplash
-launcher
C:\Dev\MyEclipse 6.5M1\eclipse\eclipse.exe
-name
Eclipse
--launcher.library
C:\Dev\MyEclipse 6.5M1\eclipse\plugins\org.eclipse.equinox.launcher.win32.win32.x86_1.0.3.R33x_v20080118\eclipse_1023.dll
-startup
C:\Dev\MyEclipse 6.5M1\eclipse\plugins\org.eclipse.equinox.launcher_1.0.1.R33x_v20080118.jar
-exitdata
1630_64
-vm
C:\Dev\MyEclipse 6.5M1\jre\bin\javaw.exe


On your question about 3, yes it is the driver jar for postgres -- postgresql-8.3-603.jdbc4.jar
The driver classname drop down does not get populated when I add the jar. I have tried selecting older jars with the same result.

gregpola,

The jdbc4.jar requires Java 6 but MyEclipse runs using Java 5 by default. As a result the jdbc4 variant of the driver cannot be loaded. I would suggest using 8.3-603 JDBC 3 instead.
These drivers can be downloaded here: http://jdbc.postgresql.org/download.html

Hope this helps, let us know if you require further assistance.

I'm having this same problem with MyEclipse 7.1 using SQL Server 2005 and sqljdbc4.jar. I need the jdbc4 driver. No matter what I do, I can't get rid of the "Driver class not found" error. I pointed directly to the jar file with the driver in it. The error message is misleading at best. How can I use this driver in MyEclipse?

Thanks,
John

jbender11,
Can you paste your installation details here? You can get them from MyEclipse > Installation Summary > Installation Details.

JDBC type 4 driver (sqljdbc2.jar) is loaded only when the JDK version is 6. If your ME default JDK is set to 5, you can change it by going to windows > preferences > java > installed JREs. There you may have to add JDK6 and then set it as default.

You can use JDBC type 3 driver(sqljdbc.jar) for SQL Server 2005 which is JDK5 compatible.

John,

A small clarification, sqljdbc4.jar will only work if MyEclipse itself starts with Java 6 (adding a Java 6 JRE to your list of JREs will not help). To do this you need to edit your myeclipse.ini file (you will find it in the same folder as the myeclipse executable) and edit the -vm switch you see there to point to the binary from Java 6, not Java 5 as it does right now.

The only other way is to use the other driver as Joy pointed out, but I realize you mentioned that is not an option for you. Please let me know if you need further assistance.

Editing the .ini file to point to the 1.6 jre worked. Thanks.

I guess I have a suggestion then. Since there have been several other forum discussions on this topic and I'm sure others have run into the same problem, could the error message be changed to say "Incompatible jre version, full JDBC 4 integration required" or something like that. I would have search down a whole different path if the error message were more indicative of the problem.

Thanks,
John

John,

Yes, that is a good suggestion. We are coming out with ME7.5 shortly. Tentatively due for release by end of May. ME7.5 by default will be launched with JRE 6.

Hi joy, brian or nipu,


I'm facing the same the problem too. Doesn't matter whether you give the jar or name, still shows the same error. In my case i'm using Sybase and here are my other driver details :
Driver Template : sybase(jTDS driver) / sybase adaptive server enterprise (not sure which one to choose but i tried with both, doesn't help much)
Driver name : Sybase
Connection URL: jdbc\:sybase\:Tds\:sampletest\:9000/crcdb (i tried with \ and also without \)
Driver Jars: c:\sybase\jconnect-6_0\classes\jTDS3.jar
Driver classname : com.sybase.jdbc3.jdbc.SybDriver

Any help would appreciate. Here i'm trying to create ER diagram using MyEclipse and we are developing a web application using Spring/hibernate under tomcat 6.0. Mail me if you need any further info.
Here is my installation summary:

*** Date:
Friday, March 5, 2010 12:38:03 PM CST

** System properties:
OS=WindowsXP
OS version=5.1.0
Java version=1.6.0_13


*** MyEclipse details:
MyEclipse Enterprise Workbench
Version: 8.0
Build id: 8.0-20091120


*** Eclipse details:
MyEclipse Enterprise Workbench

Version: 8.0
Build id: 8.0-20091120






Eclipse startup command=-os
win32
-ws
win32
-arch
x86
-showsplash
-launcher
C:\Program Files\Genuitec\MyEclipse 8.x Latest\myeclipse.exe
-name
Myeclipse
--launcher.library
C:\Program Files\Genuitec\MyEclipse 8.x Latest\../Common/plugins/org.eclipse.equinox.launcher.win32.win32.x86_1.0.200.v20090519\eclipse_1206.dll
-startup
C:\Program Files\Genuitec\MyEclipse 8.x Latest\../Common/plugins/org.eclipse.equinox.launcher_1.0.201.R35x_v20090715.jar
-install
C:/Program Files/Genuitec/MyEclipse 8.x Latest
-configuration
configuration
-vm
C:/Program Files/Genuitec/Common/binary/com.sun.java.jdk.win32.x86_1.6.0.013/jre/bin/client/jvm.dll


Thanks,
Chitra.

Chitra,
Can you configure your connector as given in the screen shot below and let me know if that works for you?

Still no success.

I have taken a screen shot of my DB Connection screen. But how could i upload/attach that file.png into this reply.(same as yours).


Thanks,
Chitra.


[img]C:\Documents and Settings\CVeerapp\My Documents\Snagit\SVN_Checkout_DOC\db.png[/img]

Chitra,
You can use the PM button at the end of the post or you can mail your screen shot to support@myeclipseide.com. Please add ATTN:Shalini in the subject and refer to this post.
Also can you give us a few more details?
1. What is the version of sybase that you are using?
2. What is the jar file that you are using?
3. Can you to switch to a brand new workspace and check if the issue still persists?

Hi Shalini,

I figured it out. First thing is instead of sybase jtds server in driver template we need to give Sybase Adaptive Server Enterprise and the second thing is i added only JTDS3.jar and missed jconn3.jar, now i included both the jar and driver classname came up automatically. I could able to establish a connection with DB.

I don't have to explain all the above stuff bcos you guys know it already. This is just for people like me who could find it useful if they face these knid of problems in future and i hope it would be helpful for them.

Thanks Shalini and keep up the good work. I appreciate all your effort and responses.

Thanks,
Chitra.

Thank you Chitra.
Its Good to know that you are all set and thank you for posting your findings.
Do let us know if you have any issues.