I think it is ok.
----- Original Message -----
From: "Steven Caswell" <[EMAIL PROTECTED]>
To: "'Juozas Baliuka'" <[EMAIL PROTECTED]>; "'Jakarta Commons Developers
List'" <[EMAIL PROTECTED]>
Sent: Wednesday, March 12, 2003 1:31 AM
Subject: RE: [dbutils] propose adding getResultSetMetaData to
DbUtils.ResultSetHandler
> OK, here is a proposal:
>
> Create new interface ResultSetMetaDataHandler:
>
> public interface ResultSetMetaDataHandler {
> public void handle(ResultSetMetaData rsmd) throws SQLException;
> }
>
> Modify DbUtils.executeQuery to accept an optional instance of
> ResultSetMetaDataHandler. executeQuery would call the
> ResultSetMetaDataHandler.handle operation after executing the query and
> before calling the ResultSetHandler.handle method.
>
> Thoughts?
>
> Steven Caswell
> [EMAIL PROTECTED]
> a.k.a Mungo Knotwise of Michel Delving
> "One ring to rule them all, one ring to find them..."
>
>
> > -----Original Message-----
> > From: Juozas Baliuka [mailto:[EMAIL PROTECTED]
> > Sent: Tuesday, March 11, 2003 1:16 AM
> > To: [EMAIL PROTECTED]; 'Jakarta Commons Developers List'
> > Subject: Re: [dbutils] propose adding getResultSetMetaData to
> > DbUtils.ResultSetHandler
> >
> >
> > One of ways is to add "optional" parameter to "executeQuery"
> > (it can be some
> > datastructure) and copy
> > RSMD to this dastructure, if not null.
> >
> > ----- Original Message -----
> > From: "Steven Caswell" <[EMAIL PROTECTED]>
> > To: "'Juozas Baliuka'" <[EMAIL PROTECTED]>; "'Jakarta
> > Commons Developers List'" <[EMAIL PROTECTED]>
> > Sent: Monday, March 10, 2003 11:32 PM
> > Subject: RE: [dbutils] propose adding getResultSetMetaData to
> > DbUtils.ResultSetHandler
> >
> >
> > > So is there an alterative proposal floating around out there?
> > >
> > >
> > > Steven Caswell
> > > [EMAIL PROTECTED]
> > > a.k.a Mungo Knotwise of Michel Delving
> > > "One ring to rule them all, one ring to find them..."
> > >
> > >
> > > > -----Original Message-----
> > > > From: Juozas Baliuka [mailto:[EMAIL PROTECTED]
> > > > Sent: Monday, March 10, 2003 1:05 AM
> > > > To: [EMAIL PROTECTED]; 'Jakarta Commons Developers List'
> > > > Subject: Re: [dbutils] propose adding getResultSetMetaData to
> > > > DbUtils.ResultSetHandler
> > > >
> > > >
> > > >
> > > > I do not likemore than one method in callback interface
> > and RSMD is
> > > > invalidated after close (possible it is not true on some driver
> > > > implementation). It is usefull to have RSMD after "handle", but I
> > > > prefer to find some better solution to retrieve it.
> > > >
> > > > ----- Original Message -----
> > > > From: "Steven Caswell" <[EMAIL PROTECTED]>
> > > > To: "'Juozas Baliuka'" <[EMAIL PROTECTED]>; "'Jakarta Commons
> > > > Developers List'" <[EMAIL PROTECTED]>
> > > > Sent: Monday, March 10, 2003 1:51 AM
> > > > Subject: RE: [dbutils] propose adding getResultSetMetaData to
> > > > DbUtils.ResultSetHandler
> > > >
> > > >
> > > > But that would be up to the class implementing ResultSetHandler.
> > > > Having the operation in the interface would simply allow
> > a caller to
> > > > get an instance of some ResultSetMetaData, however the
> > implementing
> > > > class handler choses to provide it. In the test I wrote, I had the
> > > > implementing class grab the RSMD instance from the RS as the
> > > > first thing done in the handle method, and the instance of
> > > > RSMD returned by the RS was intact after the RS was closed.
> > > >
> > > >
> > > > Steven Caswell
> > > > [EMAIL PROTECTED]
> > > > a.k.a Mungo Knotwise of Michel Delving
> > > > "One ring to rule them all, one ring to find them..."
> > > >
> > > >
> > > > > -----Original Message-----
> > > > > From: Juozas Baliuka [mailto:[EMAIL PROTECTED]
> > > > > Sent: Sunday, March 09, 2003 5:25 PM
> > > > > To: Jakarta Commons Developers List; [EMAIL PROTECTED]
> > > > > Subject: Re: [dbutils] propose adding getResultSetMetaData to
> > > > > DbUtils.ResultSetHandler
> > > > >
> > > > >
> > > > > I am not sure it will work on closed resultsetm, It is
> > better to
> > > > > return custom metadata object and value as result from
> > > > handler. I have
> > > > > changed "handle" signature it will have "params" from prepared
> > > > > statement.
> > > > >
> > > > > ----- Original Message -----
> > > > > From: "Steven Caswell" <[EMAIL PROTECTED]>
> > > > > To: "Jakarta Commons Developers List"
> > > > <[EMAIL PROTECTED]>
> > > > > Sent: Sunday, March 09, 2003 7:07 PM
> > > > > Subject: [dbutils] propose adding getResultSetMetaData to
> > > > > DbUtils.ResultSetHandler
> > > > >
> > > > >
> > > > > As the subject says, I'd like to modify
> > DbUtils.ResultSetHandler
> > > > > to add a getResultSetMetaData operation. This would provide a
> > > > callback to
> > > > > allow an application using DbUtils.execute to get the column
> > > > > descriptions from the handler. Proposed signature:
> > > > >
> > > > > public ResultSetMetaData getResultSetMetaData();
> > > > >
> > > > >
> > > > > Steven Caswell
> > > > > [EMAIL PROTECTED]
> > > > > "In our own native land, in defense of the freedom that is our
> > > > > birthright, and which we ever enjoyed till the late
> > > > violation of it --
> > > > > for the protection of our property, acquired solely by
> > the honest
> > > > > industry of our fore-fathers and ourselves, against
> > > > violence actually
> > > > > offered, we have taken up arms. We shall lay them down when
> > > > > hostilities shall cease on the part of the aggressors, and
> > > > all danger
> > > > > of their being renewed shall be removed, and not
> > before." - Thomas
> > > > > Jefferson
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > >
> > > >
> > > >
> > >
> > >
> >
> >
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
