Changing Database from mysql to oracle using Hibernate

Question

Hi I have a small java project and am using hibernate with it. Now I would like to change the database to oracle, what changes would I have to do in configuration file to make it possible.

just change the data source details.

Rahul
– Rahul

2013-02-25 10:41:49 +00:00
Commented Feb 25, 2013 at 10:41 — Rahul
– Rahul, Commented Feb 25, 2013 at 10:41

NickJ · Accepted Answer · 2013-02-25 10:44:33Z

6

In you hibernate.cfg.xml, you should have a dialect defined. The line looks like this:

 <property name="dialect">org.hibernate.dialect.MySQLInnoDBDialect</property>

change it to this:

<property name="dialect">org.hibernate.dialect.OracleDialect</property>

Also change the database connection parameters in the same file.

answered Feb 25, 2013 at 10:44

NickJ

9,6399 gold badges53 silver badges80 bronze badges

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

Comments

NIVESH SENGAR · Accepted Answer · 2013-02-25 11:16:50Z

2

Modify these properties. In hibernate.cfg.xml

<property name="hibernate.connection.driver_class">oracle.jdbc.driver.OracleDriver</property>
            <property name="hibernate.connection.password">your_new_password</property>
            <property name="hibernate.connection.url">jdbc:oracle:thin:@loalhost:xe</property>
            <property name="hibernate.connection.username">user_name</property>
            <property name="hibernate.dialect">org.hibernate.dialect.Oracle10gDialect</property>

answered Feb 25, 2013 at 11:16

NIVESH SENGAR

1,3436 gold badges20 silver badges46 bronze badges

Collectives™ on Stack Overflow

Changing Database from mysql to oracle using Hibernate

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related