Groups > comp.lang.java.programmer > #37312

Re: Testing the functionality of sub classes

Path	csiph.com!eternal-september.org!feeder.eternal-september.org!news.eternal-september.org!.POSTED!not-for-mail
From	Andreas Leitgeb <avl@logic.at>
Newsgroups	comp.lang.java.programmer
Subject	Re: Testing the functionality of sub classes
Date	Sun, 20 Aug 2017 11:50:34 -0000 (UTC)
Organization	A noiseless patient Spider
Lines	19
Message-ID	<slrnopiu4a.o2q.avl@logic.at> (permalink)
References	<87fucnh2wu.fsf@munus.decebal.nl> <subclasses-20170819193036@ram.dialup.fu-berlin.de> <87y3qffim5.fsf@munus.decebal.nl> <ona7tq$igi$1@dont-email.me> <87pobrf855.fsf@munus.decebal.nl>
Reply-To	avl@logic.at
Injection-Date	Sun, 20 Aug 2017 11:50:34 -0000 (UTC)
Injection-Info	mx02.eternal-september.org; posting-host="cd31f327af7298cb41a335016b661fc8"; logging-data="10185"; mail-complaints-to="abuse@eternal-september.org"; posting-account="U2FsdGVkX1/Zg410GzpbCTgucjl+1KaC"
User-Agent	slrn/1.0.2 (Linux)
Cancel-Lock	sha1:2u2+GbM4iddj7aSEJ65s4OCF6Ck=
Xref	csiph.com comp.lang.java.programmer:37312

Show key headers only | View raw

Cecil Westerhof <Cecil@decebal.nl> wrote:
> For example: when creating a new ResultSet through a Statement the
> previous generated should be closed. With the JDBC driver I use for
> SQLite3 the old ResultSet is not closed, but becomes a copy from the
> last generated.

Are you sure about the "copy"? I'd rather expect(*) that the driver 
re-uses the particular ResultSet instance and returns the same ref
again.  (*: that is: based on your posted observations. Usually, 
instance re-use is frowned upon, like premature optimisation, but then
again, DB driver vendors might have optimised it "well-maturely".)

To verify (or disprove) it, you could run it in e.g. eclipse, and see
if the same (or a new) "id" appears when you execute another query on
the same Statement.

Even without a debugger, you could print out the System.identityHashCode 
for the "two" returned ResultSet references.

Thread

Testing the functionality of sub classes Cecil Westerhof <Cecil@decebal.nl> - 2017-08-19 19:40 +0200
  Re: Testing the functionality of sub classes Cecil Westerhof <Cecil@decebal.nl> - 2017-08-19 21:44 +0200
    Re: Testing the functionality of sub classes Eric Sosman <esosman@comcast-dot-net.invalid> - 2017-08-19 16:47 -0400
      Re: Testing the functionality of sub classes Cecil Westerhof <Cecil@decebal.nl> - 2017-08-20 01:30 +0200
        Re: Testing the functionality of sub classes Andreas Leitgeb <avl@logic.at> - 2017-08-20 11:50 +0000
          Re: Testing the functionality of sub classes Cecil Westerhof <Cecil@decebal.nl> - 2017-08-20 14:49 +0200
            Re: Testing the functionality of sub classes Cecil Westerhof <Cecil@decebal.nl> - 2017-08-20 15:36 +0200
              Re: Testing the functionality of sub classes Arne Vajhøj <arne@vajhoej.dk> - 2017-08-20 09:46 -0400
                Re: Testing the functionality of sub classes Andreas Leitgeb <avl@logic.at> - 2017-08-20 14:33 +0000
                Re: Testing the functionality of sub classes Arne Vajhøj <arne@vajhoej.dk> - 2017-08-20 11:14 -0400
                Re: Testing the functionality of sub classes Cecil Westerhof <Cecil@decebal.nl> - 2017-08-20 16:35 +0200
                Re: Testing the functionality of sub classes Arne Vajhøj <arne@vajhoej.dk> - 2017-08-20 11:17 -0400
                Re: Testing the functionality of sub classes Cecil Westerhof <Cecil@decebal.nl> - 2017-08-20 18:13 +0200
                Re: Testing the functionality of sub classes Arne Vajhøj <arne@vajhoej.dk> - 2017-08-20 12:28 -0400
                Re: Testing the functionality of sub classes Arne Vajhøj <arne@vajhoej.dk> - 2017-08-20 13:06 -0400
                Re: Testing the functionality of sub classes Cecil Westerhof <Cecil@decebal.nl> - 2017-08-20 19:07 +0200
            Re: Testing the functionality of sub classes Arne Vajhøj <arne@vajhoej.dk> - 2017-08-20 11:21 -0400
              Re: Testing the functionality of sub classes Cecil Westerhof <Cecil@decebal.nl> - 2017-08-20 18:17 +0200
          Re: Testing the functionality of sub classes v_borchert@despammed.com (Volker Borchert) - 2017-08-21 19:53 +0000
    Re: Testing the functionality of sub classes v_borchert@despammed.com (Volker Borchert) - 2017-08-19 21:15 +0000
      Re: Testing the functionality of sub classes Cecil Westerhof <Cecil@decebal.nl> - 2017-08-20 01:36 +0200
    Re: Testing the functionality of sub classes Cecil Westerhof <Cecil@decebal.nl> - 2017-08-20 01:22 +0200

csiph-web