• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

iBatis + Database Dependany

 
Tushar Kherde
Ranch Hand
Posts: 56
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi All,

I am using iBatis + JSF + Portlets + Liferay

My Question is on iBatis. I want to make the application database independent like hibernating i should be able to change the database without any change in application.

If i want to do same now i need to change driver JAR and also SQL Map files and DAO and BO.

Any body can give me suggestion on how to change database without making above changes changing.
 
Tushar Kherde
Ranch Hand
Posts: 56
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi All,

Any link on the above topic!
 
Clinton Begin
author
Greenhorn
Posts: 21
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
SQL can be written in a way that is portable across almost any database. The original JPetStore application that made iBATIS famous 4 years ago ran on 11 different databases without any code changes.

The advantage is that iBATIS lets you deal with very complex SQL or legacy schemas. You can use all of the power of SQL -- even proprietary features -- when you need to.

Cheers,
Clinton
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic