Hello all, Is it possible to use stored procedures in a CMP ejb? The primary keys for our database tables are encoded and timestamp generated using stored procs. It would be very handy if we could somehow use stored procs. instead of the container generated jdbc calls. Are there any resources available on this? Thanks a lot Cheers
If you define a CMP bean that is defined from a view instead of a table, then this might be possible. Then you can define the view using your stored procedures. Please note that i haven't tried this, but if you make it work, please post a note on whether it was possible or not.
As with any CMP question, it will depend entirely on the vendor's discretion. I know that in WebSphere we're considering making this a feature for a future version of WebSphere, but that it will not be supported in WebSphere 5.0. Kyle