You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-dev@db.apache.org by Daniel John Debrunner <dj...@apache.org> on 2006/03/28 22:33:59 UTC
JDBC ResultSets from DatabaseMetaData
I known I've seen a statement somewhere that listed the ResultSet
attributes for ResultSets returned from DatabaseMetaData methods.
It stated that such ResultSets were forward only etc.
Now I can't find that statement in JDBC 4.0/3.0 spec or the javadoc.Does
anyone remember where this statement is?
Thanks,
Dan.
Re: JDBC ResultSets from DatabaseMetaData
Posted by "Lance J. Andersen" <La...@Sun.COM>.
the default holdability is always implementation defined but that seems
reasonable if that is what u do by default anyways with derby
Daniel John Debrunner wrote:
> Lance J. Andersen wrote:
>
>
>> It is not in the spec.
>>
>> However, it should be TYPE_FORWARD_ONLY, CONCUR_READ_ONLY given the
>> design was done during the JDBC 1.0 timeframe for DatabaseMetaData and
>> ResultSetMetaData.
>>
>
> So holdability should be CLOSE_CURSORS_AT_COMMIT?
>
>
>> i will look to clarify for JDBC 4
>>
>
> Thanks,
> Dan.
>
>
>
Re: JDBC ResultSets from DatabaseMetaData
Posted by Daniel John Debrunner <dj...@apache.org>.
Lance J. Andersen wrote:
> It is not in the spec.
>
> However, it should be TYPE_FORWARD_ONLY, CONCUR_READ_ONLY given the
> design was done during the JDBC 1.0 timeframe for DatabaseMetaData and
> ResultSetMetaData.
So holdability should be CLOSE_CURSORS_AT_COMMIT?
> i will look to clarify for JDBC 4
Thanks,
Dan.
Re: JDBC ResultSets from DatabaseMetaData
Posted by "Lance J. Andersen" <La...@Sun.COM>.
It is not in the spec.
However, it should be TYPE_FORWARD_ONLY, CONCUR_READ_ONLY given the
design was done during the JDBC 1.0 timeframe for DatabaseMetaData and
ResultSetMetaData.
i will look to clarify for JDBC 4
-lance
Daniel John Debrunner wrote:
> I known I've seen a statement somewhere that listed the ResultSet
> attributes for ResultSets returned from DatabaseMetaData methods.
>
> It stated that such ResultSets were forward only etc.
>
> Now I can't find that statement in JDBC 4.0/3.0 spec or the javadoc.Does
> anyone remember where this statement is?
>
> Thanks,
> Dan.
>
>
Re: JDBC ResultSets from DatabaseMetaData
Posted by "Lance J. Andersen" <La...@Sun.COM>.
That's because it is not there in the public copy, just my working
copy. Will be there in the PFD as well as the javadocs for these
interfaces.
It will be in the DatabaseMetaData chapter and ResultSet chapter in the
ResultSetMetaData section.
regards
lance
Daniel John Debrunner wrote:
> Lance J. Andersen wrote:
>
>
>> This has been clarified in the JDBC 4.0 spec.
>>
>
> Great, I couldn't see anything related to this in the JDBC 4.0 proposed
> final draft, do you have a section number?
>
> Thanks,
> Dan.
>
>
>
Re: JDBC ResultSets from DatabaseMetaData
Posted by Daniel John Debrunner <dj...@apache.org>.
Lance J. Andersen wrote:
> This has been clarified in the JDBC 4.0 spec.
Great, I couldn't see anything related to this in the JDBC 4.0 proposed
final draft, do you have a section number?
Thanks,
Dan.
Re: JDBC ResultSets from DatabaseMetaData
Posted by "Lance J. Andersen" <La...@Sun.COM>.
This has been clarified in the JDBC 4.0 spec.
Again and i cannot say this often enough the tutorial and reference is
not to be deemed the end-all when it comes to JDBC. The spec consists
of the JDBC API javadocs and the PDF spec.
I am trying to correct as many issues that i can for JDBC 4.0. There
are things in the tutorial that are wrong and there are some that are
more correct. I am addressing them as i find them.
regards
lance
Fernanda Pizzorno wrote:
> I just came accross that in the book "JDBC API Tutorial and Reference,
> Third Edition". In the last paragraph of section "27.1.19 Queries That
> Produce Updatable Result Sets" (p.715) it stands:
>
> "Result sets created by means other than the execution of a query,
> such as those returned by several methods in the DatabaseMetaData
> interface, are not scrollable or updatable, nor are they required to be."
>
> Fernanda
>
> Daniel John Debrunner wrote:
>
>> I known I've seen a statement somewhere that listed the ResultSet
>> attributes for ResultSets returned from DatabaseMetaData methods.
>>
>> It stated that such ResultSets were forward only etc.
>>
>> Now I can't find that statement in JDBC 4.0/3.0 spec or the javadoc.Does
>> anyone remember where this statement is?
>>
>> Thanks,
>> Dan.
>>
>>
>>
>
Re: JDBC ResultSets from DatabaseMetaData
Posted by Daniel John Debrunner <dj...@apache.org>.
Fernanda Pizzorno wrote:
> I just came accross that in the book "JDBC API Tutorial and Reference,
> Third Edition". In the last paragraph of section "27.1.19 Queries That
> Produce Updatable Result Sets" (p.715) it stands:
>
> "Result sets created by means other than the execution of a query, such
> as those returned by several methods in the DatabaseMetaData interface,
> are not scrollable or updatable, nor are they required to be."
Thanks Fernanda, I thought I was losing my mind, I even looked in that
book & couldn't find it.
Thanks for restoring my sanity!
Dan.
Re: JDBC ResultSets from DatabaseMetaData
Posted by Fernanda Pizzorno <Fe...@Sun.COM>.
I just came accross that in the book "JDBC API Tutorial and Reference,
Third Edition". In the last paragraph of section "27.1.19 Queries That
Produce Updatable Result Sets" (p.715) it stands:
"Result sets created by means other than the execution of a query, such
as those returned by several methods in the DatabaseMetaData interface,
are not scrollable or updatable, nor are they required to be."
Fernanda
Daniel John Debrunner wrote:
>I known I've seen a statement somewhere that listed the ResultSet
>attributes for ResultSets returned from DatabaseMetaData methods.
>
>It stated that such ResultSets were forward only etc.
>
>Now I can't find that statement in JDBC 4.0/3.0 spec or the javadoc.Does
>anyone remember where this statement is?
>
>Thanks,
>Dan.
>
>
>