[nmatrix9]

Hello

I’ve been trying out myeclipse for the past two weeks and overall it’s been interesting. But there are a still a few things which have frustrated/prevented me from progressing further with the myeclipse system (primarily the tutorials errors/mismatch/bugs).

I’ve been going through the Hibernate Introduction Tutorial and I’ve followed the steps but encountered a error up to the 6th step using the HQL editor.

When I type “from User” the Hibernate Dynamic Query Translator displays the proper results as expected just like the tutorial video. But when I try to RUN that HQL I get the error in the Hibernate Query Result Window:

“org.hibernate.exception.GenericJDBCException: Cannot open connection”

It is quite strange to me in that I can connect to the database via the DB Browser, I can view all the tables etc. But I just can’t RUN ANY HQL queries on the selected tables via the HQL editor? I have the mysql-connector-java-5.0.8-bin.jar in my project path also

Iam also using a super user root mysql account if that makes any difference which at the moment it doesn’t seem to.

Iam using:

Eclipse 3.2.1
OS: CentOS 5 x64
MySQL Server: 5.0.22
MyEclipse: 5.5.1 GA

*** Date:
Monday, November 12, 2007 11:20:33 PM EST

** System properties:
OS=Linux
OS version=2.6.18-8.1.10.el5
Java version=1.6.0_02

*** MyEclipse details:
MyEclipse Enterprise Workbench
Version: 5.5.1 GA
Build id: 20070521-5.5.1-GA

*** Eclipse details:
Eclipse SDK

Version: 3.2.1
Build id: M20060921-0945

Eclipse Project SDK

Version: 3.2.1.r321_v20060801-tQ1w49KnTArT0FZ
Build id: M20060921-0945

Eclipse Plug-in Development Environment

Version: 3.2.1.r321_v20060823-6vYLLdQ3Nk8DrFG
Build id: M20060921-0945

Eclipse Platform

Version: 3.2.1.r321_v20060921-b_XVA-INSQSyMtx
Build id: M20060921-0945

Eclipse Graphical Editing Framework

Version: 3.2.2.v20070208
Build id: 20070208-1315

Eclipse RCP

Version: 3.2.1.r321_v20060801-2ekW2BxmcpPUOoq
Build id: M20060921-0945

Eclipse Java Development Tools

Version: 3.2.1.r321_v20060905-R4CM1Znkvre9wC-
Build id: M20060921-0945

Eclipse Graphical Editing Framework

Version: 3.2.2.v20070208
Build id: 20070208-1315

Eclipse startup command=-os
linux
-ws
gtk
-arch
x86_64
-launcher
/home/nmatrix9/eclipse/eclipse
-name
Eclipse
-showsplash
600
-exitdata
147780ca
-vm
/usr/bin/java

Thank you for your time.

[Riyad Kalla]

nmatrix9,
Is this a Spring-Hibernate project? Also are you using Hibernate 2 libraries or Hibernate 3?

[nmatrix9]

This is just for hibernate, Iam using the HIbernate 3 libraries.

Iam using this tutorial: http://www.myeclipseide.com/documentation/quickstarts/hibernateintroduction/

[nmatrix9]

The issue has been resolved it was because of user permissions to access the database, it now works fine, please close this thread.

Thank you,

[Riyad Kalla]

THanks for following up, I’m glad to hear it’s working.

[Author]

Posts