Path: csiph.com!news.mixmin.net!news.albasani.net!.POSTED!not-for-mail From: Martin Gregorie Newsgroups: comp.lang.java.programmer Subject: Re: Is there a SQL hashmap? Date: Thu, 28 Jun 2018 23:20:12 +0000 (UTC) Organization: albasani.net Lines: 35 Message-ID: References: <031dadbc-3c27-4021-9b1d-8cb860c5e9f6@googlegroups.com> <34af17f0-0d59-4b87-8af0-01ce37deb5cb@googlegroups.com> <1d1add22-1fd4-45b1-964f-9501db447c91@googlegroups.com> <448e760f-e34d-4129-8ca6-5a699023789f@googlegroups.com> Mime-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 8bit X-Trace: news.albasani.net KJ+ppQJ2Hy6OVEPBeaYvveqad0P5P/ta2gkctwpnNzO2kGiWJYQkERZP5mkUsPbAzfNsT9bk6GSh4NowMpSe0g== NNTP-Posting-Date: Thu, 28 Jun 2018 23:20:12 +0000 (UTC) Injection-Info: news.albasani.net; logging-data="bsL4wstTZf0/wR+FBn6Ivc9rKp1KX4/LlzuRSHxsqFQjbCt05QccjwwGXX3s9C9sO/EGqdxewaQEfOkGPFHqvvzrxx2C0d1a31uf1vGg5bRT0w0Ud/mKV7WvRks0yOXp"; mail-complaints-to="abuse@albasani.net" User-Agent: Pan/0.145 (Duplicitous mercenary valetism; d7e168a git.gnome.org/pan2) Cancel-Lock: sha1:f3CF92wEpIzyxv6O4hYmv2s4fpo= Xref: csiph.com comp.lang.java.programmer:38453 On Thu, 28 Jun 2018 18:34:53 -0400, Arne Vajhøj wrote: > On 6/28/2018 3:47 PM, Martin Gregorie wrote: >> On Thu, 28 Jun 2018 15:52:54 +0000, Andreas Leitgeb wrote: >>> Eric Douglas 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... >> >> ...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. -- Martin | martin at Gregorie | gregorie dot org