Stored Procedures

[bryan p]

So, according to the following post there is no support for stored procedures within AJ: 

https://groups.google.com/forum/#!searchin/activejdbc-group/stored$20procedures/activejdbc-group/l1-ZCyg2uRk/OdIjHHIqdA4J

I'm wondering if anything has been added to support this since then or if it's even something that would be considered.  It seems like

a pretty useful part of a db to support as it is used pretty widely. 

[Igor Polevoy]

Bryan, this is correct. No support for stored procs have been  implemented since then. ActiveJDBC is an ORM, where each model is mapped to a row from a table. 

Since stored procedures do not follow the same convention, there is no way to somehow relate them to models. 

If you have a better idea, please propose 

tx

[bryan p]

I might look into it as we would like to use SPs on our project.  Otherwise I might just create a class to handle stored procedures via: 

Connection connection = Base.connection();
CallableStatement cs = cnxn.prepareCall(...);

Not sure if it will be a good solution mixing this approach with using the Models as the db interface though.  I wonder if anyone on here has implemented SPs with

this project?   

[Igor Polevoy]

we have, but simply using approach above