I think there could be three different pieces to this:
(1) SQL rendering (2) JDBC wrappers (3) A metamodel for relational data
Currently, Hibernate has classes for rendering things like inserts, updates,
selects, outer joins, case where, in, etc in the .sql package. However, the
APIs here are probably not especially convenient, so you might want to heavily
refactor this stuff.
We do not have any JDBC framework for stuff like "executing an insert", or "running a query", however we do have some primitives for parameter binding and reading result sets (the Hibernate Types). We would need to grow some classes for actually executing SQL and handling exceptions correctly, etc. We *do* have Batcher for abstracting the JDBC batch API.
We have a relational metamodel as part of the .mapping package, however it is only really adapted to DDL generation, whereas I think a really useful facility would be able to also conventiently generate DML (on top of the SQL rendering stuff).
Alexey Loubyansky wrote:
Hello colleagues,
there are areas in JBoss that need persistence solutions. Right now each area has its own more or less ugly solution (not because of developers' skills but more because of JDBC portability issues, differences in database data types, etc). We could use Hibernate. But Hibernate is a solution for business domain persistence and looks like too much for our local problems. So what is in fact needed is some very simple persistence API and the ability to generate database schema (in fact one-two tables) which guarantees portability across database products and can be re-used in different areas in JBoss. Up to this level, it's not really a big problem and I could implement it as a separate library but after some discussions there was a decision to try and add (or maybe just externalize/refactor) this functionality in Hibernate. First of all I would appreciate comments from the Hibernate team on this. Is the problem more or less clear? How would you imagine this done in Hibernate? What should I start with? What branch? Any other comments, ideas?
Thanks!
alex
------------------------------------------------------- This SF.Net email is sponsored by: YOU BE THE JUDGE. Be one of 170 Project Admins to receive an Apple iPod Mini FREE for your judgement on who ports your project to Linux PPC the best. Sponsored by IBM. Deadline: Sept. 24. Go here: http://sf.net/ppc_contest.php _______________________________________________ hibernate-devel mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/hibernate-devel
-- Gavin King +61 410 534 454 +1 404 822 8349 callto://gavinking
Hibernate [EMAIL PROTECTED] http://hibernate.org
JBoss Inc [EMAIL PROTECTED] http://jboss.com
------------------------------------------------------- This SF.Net email is sponsored by: YOU BE THE JUDGE. Be one of 170 Project Admins to receive an Apple iPod Mini FREE for your judgement on who ports your project to Linux PPC the best. Sponsored by IBM. Deadline: Sept. 24. Go here: http://sf.net/ppc_contest.php _______________________________________________ hibernate-devel mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/hibernate-devel
