Hi My company works a lot with Java access to PL/SQL with cursors. In the present we're using plain old JDBC to do this. We have checked some frameworks like Spring Dao and Hibernate and they don't fit for this particular case. In the case of Hibernate is aimed at mapping Objects with Tables not PL/SQL. In the case of Spring Dao using this framework will require to break down my 10 line methods that call the PL/SQL into 2 or 3 classes per PL/SQL, if you count the lines of code that will requiere to implement SpringDao you get almost double the number of lines of code than plain old JDBC. Any other framework I should check?

Have you seen JPublisher? It might however require some re-factoring of PL/SQL code to "typify" returned cursors.

Have you seen JPublisher? It might however require some re-factoring of PL/SQL code to "typify" returned cursors.

Thanks for the answer. I would prefer an open source solution. Regards, Néstor Boscán

No other solutions?