Path: csiph.com!aioe.org!.POSTED!not-for-mail From: =?UTF-8?Q?Arne_Vajh=c3=b8j?= Newsgroups: comp.lang.java.programmer Subject: Re: Is there a SQL hashmap? Date: Thu, 28 Jun 2018 18:34:53 -0400 Organization: Aioe.org NNTP Server Lines: 26 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> 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.8.0 X-Notice: Filtered by postfilter v. 0.8.3 Content-Language: en-US Xref: csiph.com comp.lang.java.programmer:38451 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. Arne