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

Re: Testing the functionality of sub classes

Path	csiph.com!news.redatomik.org!aioe.org!.POSTED!not-for-mail
From	Arne Vajhøj <arne@vajhoej.dk>
Newsgroups	comp.lang.java.programmer
Subject	Re: Testing the functionality of sub classes
Date	Sun, 20 Aug 2017 11:21:50 -0400
Organization	Aioe.org NNTP Server
Lines	31
Message-ID	<onc9ed$e1$1@gioia.aioe.org> (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> <slrnopiu4a.o2q.avl@logic.at> <87ziaue74o.fsf@munus.decebal.nl>
NNTP-Posting-Host	PBuS014lhzVyHjLbXmo/ZQ.user.gioia.aioe.org
Mime-Version	1.0
Content-Type	text/plain; charset=utf-8; format=flowed
Content-Transfer-Encoding	7bit
X-Complaints-To	abuse@aioe.org
User-Agent	Mozilla/5.0 (Windows NT 6.1; WOW64; rv:52.0) Gecko/20100101 Thunderbird/52.3.0
Content-Language	en-US
X-Notice	Filtered by postfilter v. 0.8.2
Xref	csiph.com comp.lang.java.programmer:37320

Show key headers only | View raw

On 8/20/2017 8:49 AM, Cecil Westerhof wrote:
> Just to satisfy my curiosity I executed (I do not like the formatting,
> but that is what Eclipse does):
>      try (
>              Statement stmt = conn.createStatement();
>              ResultSet rsOne = stmt.executeQuery("SELECT 12 AS twelve");
>              ResultSet rsTwo = stmt.executeQuery("SELECT 'Hello World!' AS message")
>              ) {
>          System.out.println(stmt);
>          System.out.println(rsOne);
>          System.out.println(rsTwo);
>      }
> 
> And this gives:
>      org.sqlite.jdbc4.JDBC4Statement@685f4c2e
>      org.sqlite.jdbc4.JDBC4ResultSet@7daf6ecc
>      org.sqlite.jdbc4.JDBC4ResultSet@7daf6ecc
> 
> So yes, it is like you said: the ResultSet is reused. Is also more
> logical. I jumped to a conclusion.

As soon as the second executeQuery is running then whatever rsOne
is pointing to is supposed to be toast.

So SQLite JDBC driver apparently decide to reuse the object for
the second executeQuery.

Maybe unexpected, but I believe it is OK per spec.

Arne

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