20.07.2003

The best persistence framework?

Another step for Dywel: I just managed to move my music data stored in an Access DB to mysql. Actually this was very easy...I exported the data as csv data, wrote a small action reading all the csv (one for each table), creating the business objects from the data and then putting this into mysql using Hibernate. Piece of cake. Now, for this I had to remember all of my old sql knowledge that I haven't used for years. To be honest, I had to lookup how to create a table etc. but after some time I could write my sql statements without quering the docs again. Great (also I hope that I don't need more sql to write webapps. That's the task of all these nice object/relational mapping tools). After I had all my data (objects) where I wanted it (in mysql), I started to write some queries to get my business objects in Cocoon. And then I started to realize that Hibernate offers the method of creating queries from strings that have a syntax similar to sql. Huh! As I said above: I don't want to care about sql and if I want to use a persistence framework I don't want to care where my objects are stored. That could be an sql db or a filesystem or whatever. Are there better ways in hibernate? Then I looked at OJB and voila, there you can create queries without such a crude syntax. In fact OJB is similar to my alltime favorite: EOF; so the next step will be to try to switch from Hibernate to OJB. 4:59:55 PM