commons-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From bugzi...@apache.org
Subject DO NOT REPLY [Bug 33477] - [dbutils] Stored Procedure Runner and Bean Reuse Handler code submission
Date Fri, 29 Jul 2005 16:45:05 GMT
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


Mime
View raw message