How complicated are your objects and queries? I've worked with Hibernate (a lot, actually), and it's good for some things and horrible for others and a menace in the hands of the wrong people. There simply is no substitute for understanding your schema and your queries. If you have a good understanding of those, then Hibernate (and other ORMs) can be useful for generating code you would otherwise have to write yourself--sometimes a lot of code--but someone with no grasp of relational databases can create perfectly reasonable object graphs that produce dreadful performance. I know of a project that used EBJ 3.0 (the JPA spec that was based on Hibernate) to create a query with 25 left outer joins.
If your objects and queries are simple, there's no harm in coding the database access by hand. ----- Original Message ----- From: "Wenbo Zhao" <zha...@gmail.com> To: <sqlite-users@sqlite.org> Sent: Thursday, September 10, 2009 8:12 PM Subject: [sqlite] looking for a solution of Object/Relation Mapping with sqlite > Hi, all > I have been looking for a simple and practical solution of > Object/Relation > Mapping over JDBC > to use with sqlite. I think this should be a common problem for > all users > who write app with > sqlite in java. > > On the net, it seems everybody is talking about Hibernate in this > field. > I'm new in the JxEE thing > and I'm not going to write that big app. So the Hibernate official > web > really terrified me with the > long long list of documents and so many packages to learn. The > start up is > 3 days long ! > comparing to sqlite's 5minute startup, it's not acceptable to me. > > I think for most app, read/write db at most several times per > seconds, there > should be something > simple and good, just like sqlite in db. > Can anybody give me a hint ? > > -- > > Best Regards, > ZHAO, Wenbo > > ======================= > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
