Win a copy of 97 Things Every Java Programmer Should Know this week in the Java in General forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Paul Clapham
  • Jeanne Boyarsky
  • Junilu Lacar
  • Henry Wong
Sheriffs:
  • Ron McLeod
  • Devaka Cooray
  • Tim Cooke
Saloon Keepers:
  • Tim Moores
  • Stephan van Hulst
  • Frits Walraven
  • Tim Holloway
  • Carey Brown
Bartenders:
  • Piet Souris
  • salvin francis
  • fred rosenberger

Hibernate with Multiple Storage Engine in MySQL v5.0.81

 
Ranch Hand
Posts: 494
Eclipse IDE Postgres Database Java
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hello Friends..

i have a question..
how to configure POJO would be implemented with Several MySQL Storage Engine..
i have Configure all of POJO but.. The Table was generated with MyISAM Storage Engine..

How to describe each of POJO whether would be implemented as MyISAM or InnoDB or Memory Storage Engine?..

iam using MySQLDialect..

Thanks in advance..

 
author and cow tipper
Posts: 5000
1
Hibernate Spring Tomcat Server
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
>>how to configure POJO would be implemented with Several MySQL Storage Engine..

Does the different storage engine make a difference? I always use INNODB, and have never specified that fact in my hiberante.cfg.xml file. All I do is specify the JDBC URL and the Dialect of MySQL, and everything works fine.

It's all going to one, single database, right? One database and one schema?

If you have multiple databases, you'd need multiple Hibernate SessionFactory classes, or use something like Hibernate Shards.

-Cameron McKenzie
 
Leonardo Carreira
Ranch Hand
Posts: 494
Eclipse IDE Postgres Database Java
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Thanks Cameron for tour reply..

actually i want to build like this instance : (which implemented in a database)..
- several tables with Memory Storage Engine
- several tables with InnoDB Storage Engine
- several tables with MyISAM Storage Engine

is that possible to be implemented?..
or maybe, i have to change in manually?..
------------------------------------------------------------------------------------------------------------

Sir..
what kind of database server do you usually use?..
Do you create a database backup for your Hibernate Application?..
if, you using MySQL, what do you use InnoDB also for your Backup database/table?..

Thanks in advance..
 
Ranch Hand
Posts: 32
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I don't think hibernate needs to know what engine you are using on your tables/indecies.
 
Lookout! Runaway whale! Hide behind this tiny ad:
Devious Experiments for a Truly Passive Greenhouse!
https://www.kickstarter.com/projects/paulwheaton/greenhouse-1
    Bookmark Topic Watch Topic
  • New Topic