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]
