Persistence without using Hibernate

[ryanlbart]

Unfortunately, my company has a requirement that we are not allowed to use Hibernate (yes- it is very silly!). Any suggestions, tips, warnings, etc. on how hard it would be to replace the database access layer with stored procedures? I need the database to store process definitions, history, tasks, etc. If this is going to be a huge effort, can you recommed perhaps another similar open source tool which would be easier to use with stored procedures (i.e. Drools 5??)

Thanks in advance!

Ryan.

[jump]

Would you plz clear for me: Object Relation Mapping is disallower, or exactly Hibernate? If only Hibernate, you should find another persistence provider (toplink or something) and probably fix some mappings. Otherwise, I guess, you better look for another BPM.

[ryanlbart]

ORM is disallowed. iBatis (for stored procedures) might be allowed, but is questionable.  Most likely it will need to be straight JDBC with sprocs.