Error Logging in to the database [message #521873] |
Fri, 19 March 2010 04:19 |
bob Messages: 8 Registered: March 2010 |
Junior Member |
|
|
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 12:21] Report message to a moderator
|
|
|
|
|
Re: Error Logging in to the database [message #522138 is a reply to message #522112] |
Sat, 20 March 2010 11:04 |
Ed Merks Messages: 33107 Registered: July 2009 |
Senior Member |
|
|
Actually it's both a forum and a newsgroup depending on how you access it...
Generally folks will change the subject line to prefix it with [Solved]
or something like that, along with a post of their solution in the body.
tbee wrote:
>> I do not know how to mark this topic as solved in this forum?
>
> You don't. This is not a forum but a newsgroup; it's just for
> exchanging messages.
>
>
>
Ed Merks
Professional Support: https://www.macromodeling.com/
|
|
|
Powered by
FUDForum. Page generated in 0.02415 seconds