Simple persistence for Java 2.1.0 review

Simple persistence for Java is an object/relation mapping framework for Java

License: LGPL (GNU Lesser General Public License) File size: 1028K Developer: Robert

0

Simple persistence for Java is an object/relation mapping framework for Java. It is designed to be easy to use.

There are no XML files to write, no tables to create, no IDs to generate, and no primary keys to fiddle with; just point it to the database, check the API documentation for three basic methods, and code away.

Simple persistence for Java supports transactions, has its own simple query language (very similar to SQL), and can handle object references, lists, and maps.

You may ask: Why another O/R mapping library? Well.. I've searched the 'net for a suitable O/R tool for a long time now, also tried a few in live projects, but each time, at the end of the project, I had always had a few thoughts to simplify the database interaction code. I've started with EJB around 2000. Now, I think everyone who used EJBs also at least once wondered why saveing a friggin object requires a separate server installation, the extensive knowledge of a 200+ page documentation, generating 3 classes/interfaces per object, installing stubs, rmi, and other things I don't even want to know about. Let's just skip this chapter of my life directly to my last experience with an O/R library: pbeans. This library is generally good, I can recommend it for those, who want a stable O/R mapping tool, but it was not the one for me. I found a few points I couldn't get over:

Save and insert should be one method. I usually don't care if an object is inserted or saved phisically, as long as it's saved.
It should handle Lists and Maps. Well, "Lists should be enough for everybody", but sometimes Maps are handy too. Lists are used very often, I think it should be handled automatically.
The query code is too difficult, and at the same time does not offer enough features.
The code you have to write won't be "pretty". It requires classes to be parameters, at least for queries, and I can't read the query itself.
The Id handling is not transparent.

What's New in This Release:
HSQLDB support was added.
Full documentation is now available.
Minor bugs were fixed in cache and transaction listener notifications.