Hello,
I'm using eclipse link (OSGI version) and MySQL Connector/J
to connect to MySQL database.
And i keep getting this error:
| Quote: |
The class com.mysql.jdbc.Driver was not found please ensure the JDBC driver is on the system classpath
|
To Fix it I added
C:\eclipselink\mysql-connector-java-5.1.12\mysql-connector-j ava-5.1.12-bin.jar
to the CLASSPATH in system variable (Windows 7)
and also I added:
DRIVER_CLASSPATH=C:\eclipselink\mysql-connector-java-5.1.12\ mysql-connector-java-5.1.12-bin.jar
to setenv.cmd file in eclipselink>bin folder
Also I added
C:\eclipselink\mysql-connector-java-5.1.12\mysql-connector-j ava-5.1.12-bin.jar
in General tab of the eclipselink
the Driver class is also set to com.mysql.jdbc.Driver
Still i get the same error when I want to log in to database!!!!
I appreciate any help to solve this problem.
thank-abu
Here is the setenv.cmd content:
@REM User MUST set DRIVER_CLASSPATH to point to their desired driver jar(s), such as JDBC and J2C. For example:
@REM DRIVER_CLASSPATH=c:\some_dir\jdbc\ojdbc14.jar;c:\some_other_ dir\j2c\aqapi.jar
@REM
@REM Note: DRIVER_CLASSPATH should NOT contain any classes for your persistent business objects - these are
@REM configured in the Mapping Workbench project.
@REM User MUST set JAVA_HOME to point a supported JRE. If none
@REM is provided for INSTALL_JAVA_HOME then the system JAVA_HOME
@REM value will be used
set INSTALL_JAVA_HOME=%s_jreDirectory%
if "%JAVA_HOME%"=="" (
set JAVA_HOME=%INSTALL_JAVA_HOME%
)
DRIVER_CLASSPATH=C:\eclipselink\mysql-connector-java-5.1.12\ mysql-connector-java-5.1.12-bin.jar
@REM Please do not change any of the following lines:
set _FIXPATH=
call :fixpath "%DRIVER_CLASSPATH%"
set DRIVER_CLASSPATH=%_FIXPATH:~1%
set _FIXPATH=
call :fixpath "%JAVA_HOME%"
set JAVA_HOME=%_FIXPATH:~1%
goto :EOF
:fixpath
if not %1.==. (
for /f "tokens=1* delims=;" %%a in (%1) do (
call :shortfilename "%%a" & call :fixpath "%%b"
)
)
goto :EOF
:shortfilename
for %%i in (%1) do set _FIXPATH=%_FIXPATH%;%%~fsi
goto :EOF
[Updated on: Fri, 19 March 2010 08:21]
Report message to a moderator