Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

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

Re: Is there a SQL hashmap?

Path csiph.com!news.mixmin.net!news.albasani.net!.POSTED!not-for-mail
From Martin Gregorie <martin@mydomain.invalid>
Newsgroups comp.lang.java.programmer
Subject Re: Is there a SQL hashmap?
Date Fri, 29 Jun 2018 12:30:18 +0000 (UTC)
Organization albasani.net
Lines 33
Message-ID <ph58oq$md4$1@news.albasani.net> (permalink)
References <031dadbc-3c27-4021-9b1d-8cb860c5e9f6@googlegroups.com> <fpfmegF9ol2U1@mid.individual.net> <34af17f0-0d59-4b87-8af0-01ce37deb5cb@googlegroups.com> <ph19nj$126q$1@gioia.aioe.org> <1d1add22-1fd4-45b1-964f-9501db447c91@googlegroups.com> <dc101d7c-a259-4364-b905-9c1346420149@googlegroups.com> <448e760f-e34d-4129-8ca6-5a699023789f@googlegroups.com> <slrnpja12m.abg.avl@logic.at> <ph3e0o$tu6$2@news.albasani.net> <ph3nqc$12e1$2@gioia.aioe.org> <ph3qfc$67p$2@news.albasani.net> <76690c5f-8ceb-46ce-ba14-9d14d3c4608d@googlegroups.com>
Mime-Version 1.0
Content-Type text/plain; charset=UTF-8
Content-Transfer-Encoding 8bit
X-Trace news.albasani.net jv9yj8wprHMgv0SXOpMWJNzyzKxho7wd2Gm8UtjMOpdUrvzTYGXSvCdRIo9XoN7pWq6ZMvEjYzhIk09HWXBRw/xpVpiL5e4TNvMfTb6ERcGOeEIs+mHkmy0yiTtCO0l2
NNTP-Posting-Date Fri, 29 Jun 2018 12:30:18 +0000 (UTC)
Injection-Info news.albasani.net; logging-data="e1Ojv1gACnJv4vGrMfFb2gDR1RAGbfwdk31E6dyclv31tkl28TyXFOp2haOm5RW1Ilg9juSTyBGjzh/kRdZ8I2dRqQnw8AOt5jGi4eabMgIgaZEfJB8XlvRWhGlZcUwg"; mail-complaints-to="abuse@albasani.net"
User-Agent Pan/0.145 (Duplicitous mercenary valetism; d7e168a git.gnome.org/pan2)
Cancel-Lock sha1:z2pqkat1eM35rAmndZbqY6xymzk=
Xref csiph.com comp.lang.java.programmer:38456

Show key headers only | View raw

On Fri, 29 Jun 2018 05:11:45 -0700, Eric Douglas wrote:

> On Thursday, June 28, 2018 at 7:20:20 PM UTC-4, Martin Gregorie wrote:
>> >> ...or use a view (if SQL Server supports views)
>> > 
>> > It does.
>> > 
>> > But the view need to be on something.
>> > 
>> I thought Eric was saying that the stuff he needed to join was in two
>> or more parallel tables, in which case a view should solve his problem
>> with little impact on the existing database.
>> 
>> 
> Not sure what you mean by parallel, related tables - one to many
> relationship.
> It looks like you can connect one JDBC to multiple instances as
> server:port,server:port in the connection string, apparently if both
> have the same credentials.  It only appears to allow one username, one
> password.

Yes, I'm not sure why I said 'parallel'. What I meant was that, if I 
understood you correctly, you could do what you need by building a new 
table and populating it by joining existing tables. All I was suggesting 
that, rather than creating the new table, you use a view instead. For 
your purpose it can be treated as another table. However, it does not 
carry any maintenance overheads because its best thought of as being a 
virtual table that only exists when its queried.   


-- 
Martin    | martin at
Gregorie  | gregorie dot org

Back to comp.lang.java.programmer | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll thread

Thread

Is there a SQL hashmap? Eric Douglas <e.d.programmer@gmail.com> - 2018-06-26 09:03 -0700
  Re: Is there a SQL hashmap? Arne Vajhøj <arne@vajhoej.dk> - 2018-06-26 12:23 -0400
  Re: Is there a SQL hashmap? Robert Klemme <shortcutter@googlemail.com> - 2018-06-26 22:36 +0200
    Re: Is there a SQL hashmap? Eric Douglas <e.d.programmer@gmail.com> - 2018-06-26 14:02 -0700
      Re: Is there a SQL hashmap? Arne Vajhøj <arne@vajhoej.dk> - 2018-06-27 20:22 -0400
        Re: Is there a SQL hashmap? firstsql@gmail.com - 2018-06-27 20:53 -0700
        Re: Is there a SQL hashmap? Eric Douglas <e.d.programmer@gmail.com> - 2018-06-28 05:03 -0700
          Re: Is there a SQL hashmap? Eric Douglas <e.d.programmer@gmail.com> - 2018-06-28 06:49 -0700
            Re: Is there a SQL hashmap? Eric Douglas <e.d.programmer@gmail.com> - 2018-06-28 07:38 -0700
              Re: Is there a SQL hashmap? Andreas Leitgeb <avl@logic.at> - 2018-06-28 15:52 +0000
                Re: Is there a SQL hashmap? Martin Gregorie <martin@mydomain.invalid> - 2018-06-28 19:47 +0000
                Re: Is there a SQL hashmap? Arne Vajhøj <arne@vajhoej.dk> - 2018-06-28 18:34 -0400
                Re: Is there a SQL hashmap? Martin Gregorie <martin@mydomain.invalid> - 2018-06-28 23:20 +0000
                Re: Is there a SQL hashmap? Arne Vajhøj <arne@vajhoej.dk> - 2018-06-28 20:07 -0400
                Re: Is there a SQL hashmap? Eric Douglas <e.d.programmer@gmail.com> - 2018-06-29 05:11 -0700
                Re: Is there a SQL hashmap? Martin Gregorie <martin@mydomain.invalid> - 2018-06-29 12:30 +0000
                Re: Is there a SQL hashmap? Eric Douglas <e.d.programmer@gmail.com> - 2018-06-29 06:11 -0700
                Re: Is there a SQL hashmap? Martin Gregorie <martin@mydomain.invalid> - 2018-06-29 13:43 +0000
                Re: Is there a SQL hashmap? Robert Klemme <shortcutter@googlemail.com> - 2018-06-29 23:20 +0200
                Re: Is there a SQL hashmap? Martin Gregorie <martin@mydomain.invalid> - 2018-06-29 22:34 +0000
                Re: Is there a SQL hashmap? Arne Vajhøj <arne@vajhoej.dk> - 2018-06-30 16:36 -0400
                Re: Is there a SQL hashmap? Martin Gregorie <martin@mydomain.invalid> - 2018-06-30 23:00 +0000
              Re: Is there a SQL hashmap? Robert Klemme <shortcutter@googlemail.com> - 2018-06-29 23:34 +0200
            Re: Is there a SQL hashmap? Arne Vajhøj <arne@vajhoej.dk> - 2018-06-30 17:51 -0400
              Re: Is there a SQL hashmap? Eric Douglas <e.d.programmer@gmail.com> - 2018-07-03 07:13 -0700

csiph-web