Win a copy of The Little Book of Impediments (e-book only) this week in the Agile and Other Processes forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

issue with hibernate oracle schemas

 
Gran Roguismo
Ranch Hand
Posts: 77
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I'm another hibernate noobie, so please correct me if I get anything wrong here.
I'm working off an oracle db here, with 2 schemas for development and testing. I should be switching between them using the hibernate config xml file I thought, but that doesn't seem to be working. I only seem to get the development data back. I've searched through the code for any other connections that might take the place of that config file, but I've found nothing. Ideas?

my two setups look like this:




the two connections do have the same password and when I log into either schema using toad I will be directed to the schema based off the user name.
 
Jonathan Huang
Ranch Hand
Posts: 35
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I don't know what the myeclipse properties are, but try using a schema tag.

<property name="hibernate.default_schema">YOUR_DEVS_SCHEMA</property>
vs
<property name="hibernate.default_schema">YOUR_PROD_SCHEMA</property>

Be sure it's capitalized like in the DB.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic