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

Strange behavior with Hibernate

 
Hanna Habashy
Ranch Hand
Posts: 532
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator

I have been developing in one database with no problem. The configuration line is:

<property name="hibernate.connection.url">jdbc:sqlserver://DEVD1;DatabaseName=myProject;SelectMethod=direct</property>

The sql statement generated always append the database name to the SQL query like this: myProject.dbo.<table name>

So, far no problem.

Now: I tried to point the mapping file to different instance for testing. The new configuration file is like this:

<property name="hibernate.connection.url">jdbc:sqlserver://DEVD2;DatabaseName=myProjectTest;SelectMethod=direct</property>

Now, notice the difference. The database name changed to myProjectTest, and the sql server changed to DEVD2

When I try to connect to this database, I get a lot of errors because the generated SQL is not correct. Hibernate appends the old database name to the sql like this: myProject.dbo.<table name>, and it is supposed to be myProjectTest.dbl.<table name>

Consequently, all of my unit test fails.

I cleaned the project many times. I manually deleted the class files. I inspected the print out in the console, and hibernate reads from the correct file. I closed Eclipse to clean the cach. But, the problem is still there.

Anyone has ever seen anything like this?
Any idea where else should I look for?

Thanks
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic