Hibernate Community • View topic

View unanswered posts | View active topics

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

Oracle MySql

Page 1 of 1

[ 3 posts ]

Previous topic | Next topic

Author

Message

mcbi4kh2

Post subject: Oracle MySql

Posted: Tue Aug 05, 2008 3:36 pm

Beginner

Joined: Thu Jun 12, 2008 10:48 am
Posts: 24

Hello all,

I normally use Hibernate with Oracle and connect to my db using the following:

hibernate.dialect=org.hibernate.dialect.OracleDialect

hibernate.connection.isolation=2
hibernate.max_fetch_depth=1
hibernate.show_sql=true
hibernate.connection.driver_class=oracle.jdbc.driver.OracleDriver
hibernate.connection.url=jdbc:oracle:thin:@localhost:1521:mypc
hibernate.connection.username=db
hibernate.connection.password=password

Im now using the latest MySql freeware db, so what is the MySql version of:
hibernate.connection.driver_class=oracle.jdbc.driver.OracleDriver
hibernate.connection.url=jdbc:oracle:thin:@localhost:1521:mypc

And do I need anything else?

Top

tfecw

Post subject:

Posted: Tue Aug 05, 2008 5:09 pm

Newbie

Joined: Tue Jul 22, 2008 11:30 am
Posts: 13

I think you need to change the SQL dialect as well.

HEre is a list of ones to pick from. It looks like mysql has a few depending on your version

Top

nordborg

Post subject:

Posted: Tue Aug 05, 2008 5:24 pm

Expert

Joined: Wed Mar 03, 2004 6:35 am
Posts: 1240
Location: Lund, Sweden

Here is an example for MySQL:

Code:

hibernate.dialect = org.hibernate.dialect.MySQLInnoDBDialect
hibernate.connection.driver_class  = com.mysql.jdbc.Driver
hibernate.connection.url = jdbc:mysql://localhost/mydb

Top

Page 1 of 1

[ 3 posts ]

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum