Mailing-List: contact commons-dev-help@jakarta.apache.org; run by ezmlm
Precedence: bulk
Reply-To: "Jakarta Commons Developers List" <commons-dev@jakarta.apache.org>
From: bugzilla@apache.org
To: commons-dev@jakarta.apache.org
Subject: DO NOT REPLY [Bug 33477]  -
    [dbutils] Stored Procedure Runner and Bean Reuse Handler code submission
Message-Id: <20050729164505.2C88EE1@ajax.apache.org>
Date: Fri, 29 Jul 2005 18:45:05 +0200 (CEST)

DO NOT REPLY TO THIS EMAIL, BUT PLEASE POST YOUR BUG�
RELATED COMMENTS THROUGH THE WEB INTERFACE AVAILABLE AT
<http://issues.apache.org/bugzilla/show_bug.cgi?id=33477>.
ANY REPLY MADE TO THIS MESSAGE WILL NOT BE COLLECTED AND�
INSERTED IN THE BUG DATABASE.

http://issues.apache.org/bugzilla/show_bug.cgi?id=33477


------- Additional Comments From k@kylemiller.com  2005-07-29 18:45 -------
BeanReuseHandler:

I only used this for a single object, but I was trying to add the ability to use it for a list as well.  The 
queue functionality should probably be removed from this class and re implemented in a 
BeanReuseListHandler or something if it is deemed appropriate.  This would make the reuse handler 
very simple, and decrease the chance for bugs.  

Use Case:

I had a web app that was used to query for data, and the data logically belonged in the same object.  
However some of the data was in a tradtionally RDBMS while the rest of the data was in stored in 
Mainframe ISAM files.  There was a COBOL program that contained years of business logic that they did 
not what to re write, so they made a COBOL stored procedure in DB2 on the mainframe that would call 
the program to retreive the data.  So I could've had two objects and written a routine to merge the data, 
but after looking at the DBUtils code it was very easy to write it just reuse the existing object.  Also I 
thought having a framework to help with stored procedures would be useful for others.  Granted stored 
procedures are devil, I'm sure there have been others with similar legacy problems.

Stored Proc Handler:

The fact that you don't like stored procedures doesn't mean people don't use them.  This is a jdbc 
helper frame work and I think having support for stored procedures would round it out.  My 
implementation may not be exactly what you are looking for, and I will make the suggested changes, 
but I do think that DBUtils should have this functionality.

-- 
Configure bugmail: http://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug, or are watching the assignee.

---------------------------------------------------------------------
To unsubscribe, e-mail: commons-dev-unsubscribe@jakarta.apache.org
For additional commands, e-mail: commons-dev-help@jakarta.apache.org