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.




Recent Posts:




Code2care is an initiative to publish and share varied knowledge in programming and technical areas gathered during day-to-day learnings and development activities.

Students and Software Developers can leverage this portal to find solutions to their various queries without re-inventing the wheel by referring to our easy to understand posts. Technical posts might include Learnings, Video Tutorials, Code Snippets, How Tos, Blogs, Articles, etc.