Getting error in configuration of hibernate , mysql in java

Question

i am new to hibernate . and I am getting error like hibernate.properties not found and Access denied for user 'root'@'localhost' (using password: YES)

I am using MySqlWorkbench version 5.7.19 and hibernate version 5.2.6.Final jdk 1.8 with eclipse oxygen

this is my hibernate.cfg.xml file

<hibernate-configuration>
<session-factory>
    <property name="hibernate.connection.driver_class">com.mysql.jdbc.Driver</property>
    <property name="hibernate.connection.password">gary@1234</property>
    <property name="hibernate.connection.url">jdbc:mysql://localhost:3306/hibernate</property>
    <property name="hibernate.connection.username">root</property>
    <property name="hibernate.dialect">org.hibernate.dialect.MySQLDialect</property>
    <property name="hbm2ddl.auto">update</property>
</session-factory>

and here is pom.xml

  <dependencies>
<dependency>
  <groupId>junit</groupId>
  <artifactId>junit</artifactId>
  <version>3.8.1</version>
  <scope>test</scope>
</dependency>
<!-- https://mvnrepository.com/artifact/org.hibernate/hibernate-core -->
    <dependency>
        <groupId>org.hibernate</groupId>
        <artifactId>hibernate-core</artifactId>
        <version>5.2.6.Final</version>
    </dependency>
    <!-- https://mvnrepository.com/artifact/mysql/mysql-connector-java -->
    <dependency>
        <groupId>mysql</groupId>
        <artifactId>mysql-connector-java</artifactId>
        <version>5.1.39</version>
    </dependency>

and here is my code

public class App {
public static void main(String[] args) {
    Alien alien = new Alien();
    alien.setAid(101);
    alien.setAname("pawan");
    alien.setColor("purple");
    Configuration con = new Configuration().configure();
    SessionFactory sf = con.buildSessionFactory();
    Session session = sf.openSession();
    Transaction tx = session.beginTransaction();
    session.save(alien);
    tx.commit();
}}

and this is pojo class

public class Alien {

@Id
private int aid;
private String aname;
private String color;

public int getAid() {
    return aid;
}

public void setAid(int aid) {
    this.aid = aid;
}

public String getAname() {
    return aname;
}

public void setAname(String aname) {
    this.aname = aname;
}

public String getColor() {
    return color;
}

public void setColor(String color) {
    this.color = color;
}

}

Are you sure your database user is 'root' and your password is 'gary@1234'? — Tobias Geiselmann
– Tobias Geiselmann, Commented Aug 16, 2017 at 9:31
yes other application without hibernate is working fine on same — Pavan Kumar
– Pavan Kumar, Commented Aug 16, 2017 at 9:31
i created it by using hibernate plugin and in the src/main/java — Pavan Kumar
– Pavan Kumar, Commented Aug 16, 2017 at 9:35

Pavan Kumar · Accepted Answer · 2017-08-16 10:20:26Z

1

thanks to all for giving your precious time . i got the solution by just makin changes as

Configuration con = new Configuration().configure("hibernate.cfg.xml").addAnnotatedClass(Alien.class);

Actually it was not getting the properties of hibernate.cfg.xml and class as well

answered Aug 16, 2017 at 10:20

Pavan Kumar

4221 gold badge6 silver badges15 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

diguage · Accepted Answer · 2017-08-16 10:14:41Z

0

You shold add @Entity to Alien, as follows:

@Entity
public class Alien {

//...

}

answered Aug 16, 2017 at 10:14

diguage

3971 gold badge4 silver badges19 bronze badges

1 Comment

diguage Over a year ago

That is OK. You can test my solution. If you have many class, adding @Entity to entity class is a better way.

Amal lal T L · Accepted Answer · 2017-08-16 11:23:41Z

0

Using password: YES, means, the password you have entered to connect to the database is not correct.

answered Aug 16, 2017 at 11:23

Amal lal T L

4306 silver badges20 bronze badges

Collectives™ on Stack Overflow

Getting error in configuration of hibernate , mysql in java

3 Answers 3

Comments

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related