Path: csiph.com!eternal-september.org!feeder.eternal-september.org!reader02.eternal-september.org!.POSTED!not-for-mail
From: Andreas Leitgeb <avl@logic.at>
Newsgroups: comp.lang.java.programmer
Subject: Re: Is there a SQL hashmap?
Date: Thu, 28 Jun 2018 15:52:54 -0000 (UTC)
Organization: A noiseless patient Spider
Lines: 16
Message-ID: <slrnpja12m.abg.avl@logic.at>
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>
Reply-To: avl@logic.at
Injection-Date: Thu, 28 Jun 2018 15:52:54 -0000 (UTC)
Injection-Info: reader02.eternal-september.org; posting-host="57178f4c5ab280505eaee322bbf97db3"; logging-data="16330"; mail-complaints-to="abuse@eternal-september.org";	posting-account="U2FsdGVkX19gZTCXvkuwpsOyvkN+BBj0"
User-Agent: slrn/1.0.3 (Linux)
Cancel-Lock: sha1:stsgpSYLDKDljIebGeOj9NXIuOw=
Xref: csiph.com comp.lang.java.programmer:38447

Eric Douglas <e.d.programmer@gmail.com> wrote:
> So JDBC can access both but as far as I know cannot join both in the
> same select statement.

Further approaches:

- adding another table to a database shouldn't really interfere much
    with the 3rd party software accessing it.

- maybe the database already has a simple table of two string columns,
    where you could add the key-value pairs as extra rows, maybe aug-
    menting the keys to not interfere with other entries of that table

- maybe it is possible to create temporary tables and fill them with
    your mappings just when you need it...