>> Most devs that are dead set against stored procs do not have an open mind.
Too strong. I think also that he was just saying he was not a "fan" versus anti-stored-procedure. >> Stored procs offer an interface into the db that is consistent. That is to say they provide a "uniform implementation" which I noted as beneficial. >> They also let your dba/dbd do his job and ensure correct operation/isolation >> of the underlying schema as well as give him the control that he requires to >> do his job optimally. Stored procedures do not ensure anything other than a lack of portability. That aside the provide the opportunity for skilled database application programmers (a DBA or DBD may or may not fall under that heading) to use the native procedural language to great benefit. >> You do not need to use out parameters, you'd just return resultsets that >> you'll map onto an object. You need to use out parameters if the existing library is littered with them. It doesn't help to declare them optional after the fact. >> It's a fine choice for those companies that require fine grained control >> over database access, ... It's a fine alternative to POJO persistence using EJB 3.0 entity beans. I'm choosing the latter every time, given the choice, with a sprinkling of native stored procedure calls if necessary. They are competing strategies. >> The point is that when you knock (or see someone knocking) a technology like >> stored procs, they usually don't really understand the uses (good and/or >> bad) of the technology. I would agree that detractors are usually sacrificing the benefits of control and consistency at the alter of portability. Usually a worthy sacrifice but as mentioned, stored procedures definitely have their place. View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3927900#3927900 Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=3927900 ------------------------------------------------------- This SF.Net email is sponsored by xPML, a groundbreaking scripting language that extends applications into web and mobile media. Attend the live webcast and join the prime developer group breaking into this new coding territory! http://sel.as-us.falkag.net/sel?cmd=lnk&kid=110944&bid=241720&dat=121642 _______________________________________________ JBoss-user mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/jboss-user
