i'm running an example at http://www.laliluna.de/first-hibernate- ... orial.html. i use eclipse 3.1 with wtp 1.0, jboss4.0.2, but when i open in hibernator perspective, i get the error : "java.sql.SQLException: Access denied for user 'hibernate'@'%' to database 'firsthibernate'".

can anyone help me to figure out??

by the way, is that any useful websites provides hibernate tutorial? thanks.

Which database are you using? And where is your database server located. If it is on the same machine than you should have a user for the host 'localhost'

i use mysql database. i have try to run mysql server in DOS prompt to retrieve the database but no database can be fetched.

my hibernate.cfg.xml is as shown below:

<?xml version="1.0" encoding="utf-8"?>
<!DOCTYPE hibernate-configuration
PUBLIC "-//Hibernate/Hibernate Configuration DTD//EN"
"http://hibernate.sourceforge.net/hibernate-configuration-2.0.dtd">

<!-- DO NOT EDIT: This is a generated file that is synchronized -->
<!-- by MyEclipse Hibernate tool integration. -->
<hibernate-configuration>

<session-factory>
<!-- properties -->
<property name="hibernate.connection.username">
hibernate
</property>
<property name="connection.url">
jdbc:mysql://localhost/firsthibernate
</property>
<property name="dialect">
net.sf.hibernate.dialect.MySQLDialect
</property>
<property name="hibernate.show_sql">false</property>
<property name="hibernate.use_outer_join">true</property>
<property name="hibernate.transaction.factory_class">
net.sf.hibernate.transaction.JBossTransactionManagerLookup
</property>
<property name="jta.UserTransaction">
java:comp/UserTransaction
</property>
<property name="hibernate.connection.password">mysql</property>
<property name="connection.driver_class">
com.mysql.jdbc.Driver
</property>

<!-- mapping files -->
<mapping resource="de/laliluna/example/Honey.hbm.xml" />
</session-factory>
</hibernate-configuration>

what happens, if you edit the configuration like this?

<property name="hibernate.connection.username">hibernate</property>

Maybe there are some strange characters after the "hibernate" string in your xml file.

greetings, arno

now the errors shown in the hibernator console is:

java.lang.ClassNotFoundException: com.mysql.jdbc.Driver
at java.net.URLClassLoader$1.run(Unknown Source)
at java.security.AccessController.doPrivileged(Native Method)
at java.net.URLClassLoader.findClass(Unknown Source)
at java.lang.ClassLoader.loadClass(Unknown Source)
at java.lang.ClassLoader.loadClass(Unknown Source)
at net.sf.hibernator.HibernateConnection.createConnection(HibernateConnection.java:152)
at net.sf.hibernator.views.ConnectionView$8.run(ConnectionView.java:199)
at org.eclipse.jface.operation.ModalContext$ModalContextThread.run(ModalContext.java:113)

i have put 'mysql-connector-java.3.1.12-bin.jar in the project build path. what is missing again??

it is in the project build path, which means your compiler can see it (think buildtime). you are then pushing the application into a new environment (the jvm). Now it needs to go in the classpath of the application (think runtime).

i had put the mysql-connector-java-3.1.12-bin.jar under the JRE system library [jdk1.5.0_05]. where i should put this file again??

if you are working with eclipse, you have to add the jdbc jar file to the build path of your project, but btw that´s simple stupid java stuff and is not related to hibernate in any way!

This is an access permission error coming from MySQL. Look up the GRANT command syntax on the MySQL reference manual.