http://www.theserverside.com Most recent forum messages en Jive Forums Silver 5.5.30 (www.jivesoftware.com) Wed, 22 May 2013 05:36:16 -0400 http://www.theserverside.com/discussions/thread.tss?thread_id=39969 Tue, 02 May 2006 22:24:19 -0400 Tue, 02 May 2006 22:24:19 -0400 Tue, 02 May 2006 22:24:19 -0400 May 2, 2006 Joe Schweickart 0 http://www.theserverside.com/discussions/thread.tss?thread_id=39969
I guess you...]]> Mon, 01 May 2006 14:42:35 -0400 Mon, 01 May 2006 14:42:35 -0400 Mon, 01 May 2006 14:42:35 -0400 May 1, 2006 Billy Newport 1 http://www.theserverside.com/discussions/thread.tss?thread_id=39969
Interesting comment. As discussed in my blog, http://db360.blogspot.com/2006/03/stored-procedure-as-database.html#links, stored procedure...]]> Sun, 30 Apr 2006 02:35:37 -0400 Sun, 30 Apr 2006 02:35:37 -0400 Sun, 30 Apr 2006 02:35:37 -0400 Apr 30, 2006 Kuassi Mensah 0 http://www.theserverside.com/discussions/thread.tss?thread_id=39969
Knowing why and how to use stored procedures between Java apps and RDBMSs is still a minority among Java developers. These developers usually have deep knowledge and plenty experience in RDBMSs. They have...]]> Sun, 30 Apr 2006 02:18:25 -0400 Sun, 30 Apr 2006 02:18:25 -0400 Sun, 30 Apr 2006 02:18:25 -0400 Apr 30, 2006 Han Zhang 0 http://www.theserverside.com/discussions/thread.tss?thread_id=39969
Business logic layer is quite easy to scale horizontaly (app servers clusters).
Scaling db layer horizontaly is not that easy in general. And scaling it...]]> Sat, 29 Apr 2006 08:22:07 -0400 Sat, 29 Apr 2006 08:22:07 -0400 Sat, 29 Apr 2006 08:22:07 -0400 Apr 29, 2006 A. M. 1 http://www.theserverside.com/discussions/thread.tss?thread_id=39969 Is there any way to use stored procedures in OO pattern?
Yes. Even when you prefer pure OO aproach to persistence, you can use stored procedures that return cursors. In that case stored procedure doesn't perform any business...]]> Sat, 29 Apr 2006 08:00:59 -0400 Sat, 29 Apr 2006 08:00:59 -0400 Sat, 29 Apr 2006 08:00:59 -0400 Apr 29, 2006 A. M. 0 http://www.theserverside.com/discussions/thread.tss?thread_id=39969 Fri, 28 Apr 2006 17:00:11 -0400 Fri, 28 Apr 2006 17:00:11 -0400 Fri, 28 Apr 2006 17:00:11 -0400 Apr 28, 2006 Kuassi Mensah 2 http://www.theserverside.com/discussions/thread.tss?thread_id=39969 Fri, 28 Apr 2006 15:21:11 -0400 Fri, 28 Apr 2006 15:21:11 -0400 Fri, 28 Apr 2006 15:21:11 -0400 Apr 28, 2006 Sergiu Rata 3 http://www.theserverside.com/discussions/thread.tss?thread_id=39969 Is there any way to use stored procedures in OO pattern?
IMO stored procedures belong to the category of "SQL intrusive" persistence but as you already know, OR mapping frameworks let you map stored procedures as...]]> Fri, 28 Apr 2006 13:39:48 -0400 Fri, 28 Apr 2006 13:39:48 -0400 Fri, 28 Apr 2006 13:39:48 -0400 Apr 28, 2006 Kuassi Mensah 0 http://www.theserverside.com/discussions/thread.tss?thread_id=39969 Another thing Fowler always accentuates is importance of "domain model" - a proper OO design that involves persistence.Putting a lot of business logic into stored procedures results in a functional decomposition style with all its...]]> Fri, 28 Apr 2006 03:09:41 -0400 Fri, 28 Apr 2006 03:09:41 -0400 Fri, 28 Apr 2006 03:09:41 -0400 Apr 28, 2006 chang wei 2 http://www.theserverside.com/discussions/thread.tss?thread_id=39969 Fri, 28 Apr 2006 01:08:53 -0400 Fri, 28 Apr 2006 01:08:53 -0400 Fri, 28 Apr 2006 01:08:53 -0400 Apr 28, 2006 carfield 0 http://www.theserverside.com/discussions/thread.tss?thread_id=39969 http://www.amazon.com/gp/product/1555583296/, Java stored procedures give you the best of both worlds -- i.e., portability across RDBMSes (Oracle Db2 UDB,...]]> Thu, 27 Apr 2006 17:21:10 -0400 Thu, 27 Apr 2006 17:21:10 -0400 Thu, 27 Apr 2006 17:21:10 -0400 Apr 27, 2006 Kuassi Mensah 0 http://www.theserverside.com/discussions/thread.tss?thread_id=39969
Regardless of what paradigms you may use (OO, Structured, etc.), a key factor for handling complexity and change is separating the system into modules with...]]> Thu, 27 Apr 2006 15:37:38 -0400 Thu, 27 Apr 2006 15:37:38 -0400 Thu, 27 Apr 2006 15:37:38 -0400 Apr 27, 2006 DavidLathrop 1 http://www.theserverside.com/discussions/thread.tss?thread_id=39969 Tue, 25 Apr 2006 19:22:42 -0400 Tue, 25 Apr 2006 19:22:42 -0400 Tue, 25 Apr 2006 19:22:42 -0400 Apr 25, 2006 Sergey Naftulin 2 http://www.theserverside.com/discussions/thread.tss?thread_id=39969 Putting a lot of business logic into stored procedures results in a functional decomposition style with all its...]]> Tue, 25 Apr 2006 13:10:56 -0400 Tue, 25 Apr 2006 13:10:56 -0400 Tue, 25 Apr 2006 13:10:56 -0400 Apr 25, 2006 A. M. 3