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

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	Cecil Westerhof <Cecil@decebal.nl>
Newsgroups	comp.lang.java.programmer
Subject	Re: Testing the functionality of sub classes
Date	Sun, 20 Aug 2017 15:36:56 +0200
Organization	Decebal Computing
Lines	31
Message-ID	<87valie4xz.fsf@munus.decebal.nl> (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>
Mime-Version	1.0
Content-Type	text/plain
Injection-Info	mx02.eternal-september.org; posting-host="a3233d099e71e24d901953f13bac9801"; logging-data="13260"; mail-complaints-to="abuse@eternal-september.org"; posting-account="U2FsdGVkX1+EXWDWHwc5O05LEilMvNPbgKi7NnfpjwQ="
User-Agent	Gnus/5.13 (Gnus v5.13) Emacs/24.5 (gnu/linux)
X-Homepage	http://www.decebal.nl/
Cancel-Lock	sha1:pgO3UtUdfSlJzAggUOHM8C6vuUI= sha1:NEnJYK/lhdMfvHpdX0JlflsLvYg=
Xref	csiph.com comp.lang.java.programmer:37314

Show key headers only | View raw

Cecil Westerhof <Cecil@decebal.nl> writes:

> 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.

With a H2 database I get:
    stat0
    rs0: null
    rs1: org.h2.result.LocalResult@1bc6a36e columns: 1 rows: 1 pos: -1

-- 
Cecil Westerhof
Senior Software Engineer
LinkedIn: http://www.linkedin.com/in/cecilwesterhof

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