Hi, guys:
Can any body know how to write the DAO when using Oracle view? I know that when we query the data is easy, but how to update and insert and delete data to the relative table? Overwrite the save() and delete() using hsql? Very appreciate thank you for your advise!

you can map your classes multiple times using different logical names (in Hibernate 3.2+),
so map it once on table, and once on view....

Thank you for your reply, it's a good idea, but I'm afraid of it made the project more complex. I've modified the DAO class and using the JDBC to control the insert,update and delete, I tested it by invoke the DAO.insert and DAO.update and DAO.delete, no problem in here, I try to invoke it by Session.save(obj), I think it maybe not pass, can anybody give me more information? Thanks again!

why you use Hibernate? to simulate DAO? It seems more difficult, and you are not using all the hibernate power.

I can't understand which is your problem.

Yes, your right. We are developing the web application, we designed N-tier structure:DB<->DAO<->Logics<->Services<->Web, so we need using DAO to manipulate DB's data, we choice the hibernate to implement the data persistance layer, so we have to simulate DAO.