connection.url property value in hibernate.cfg.xml for mysql


If you are using Oracle's MySQL as database in your Hibernate project then you must use mysql-connector-java-5.x.xx-bin.jar JDBC jar. The <property name="connection.url"> tag in hibernate.cfg.xml must have the value jdbc:mysql://localhost:3306/myDb where myDb is your database name.

Code snippet for Hibernate's Database connection settings in hibernate.cfg.xml,

<property name="connection.driver_class">com.mysql.jdbc.Driver</property>
        <property name="connection.url">jdbc:mysql://localhost:3306/myDb</property>
        <property name="connection.username">root</property>
        <property name="connection.password"></property>

If you are not working on the localhost then it must be the IP address of the server where the MySQL database is located.