Specifically, I'm not exactly planning on a Query-by-Example API, but rather a dynamic SQL statement builder API (also insert, update, delete, etc.). I run into this problem all the time where the user is specifying what they'd like to search for, and so you need to build a SQL statement on-the-fly. I think we can do better than straight String concatenation :) I already wrote something similar at my old firm (it supported both SQL and HQL) that worked great in production systems, but it is not open source. So I'm starting again, this time open source, and whatever I come up with will be almost like a version 2.0 once its version 1.0 comes out.
You can download the source I've written so far from here: http://www.crystalcognition.com/sgarlatm/persistence.zip
If you're curious, take a look at the DynamicSqlSelectStatment interface.
Let me know if you have any comments, questions, etc!
Matt
Max Rudman wrote:
I've just discovered Commons Mapper project and would like to contribute. I built my own abstraction layer for Hibernate but would love to move to Mapper instead. I looked through current documentation and have a couple of questions.
1) Are specific implementations within the scope of this project? You mention several data mapping technologies (such as Hibernate, iBATIS, etc.) in project overview but I saw no specific implementations in the JavaDocs API. As I said, I have experience with Hibernate and would like to contribute in providing Hibernate Mapper implementation (if this is something that needs to be done).
2) Is query API something you envision being part of this package? Specifically, a Query-By-Example API which I found to be very useful in enterprise application development where one often needs to have the ability to search for records with flexible (dynamic) WHERE clause. Hibernate package provides such an API but obviously it is specific to their implementation and it would be nice to have the abstraction layer against that functionality as well.
This is my first time inquiring about contributing to Jakarta Commons so I apologize in advance if I am doing something inappropriate. I did search through both user and dev mailing list archives but couldn't find any information on the topics above.
Thanks in advance,
Max
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
