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

Re: Is there a SQL hashmap?

Newsgroups	comp.lang.java.programmer
Date	2018-06-28 06:49 -0700
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>
Message-ID	<dc101d7c-a259-4364-b905-9c1346420149@googlegroups.com> (permalink)
Subject	Re: Is there a SQL hashmap?
From	Eric Douglas <e.d.programmer@gmail.com>

Show all headers | View raw

On Thursday, June 28, 2018 at 8:03:41 AM UTC-4, Eric Douglas wrote:
> On Wednesday, June 27, 2018 at 8:22:23 PM UTC-4, Arne Vajhøj wrote:
> > > I don't think the SQL can join tables from 2 different databases but would be nice if it can, needs researched.
> > 
> > Generally you can't.
> > 
> > Usually you can.
> > 
> > You can in MS SQLServer
> > 
> > Just refer to the tables as somedatabasename.dbo.sometablename and it 
> > should work.
> > 
> > Arne
> 
> but I am using java.sql.DriverManager.getConnection() which requires a connect string which includes the database name - ?

I see, that works only on other level...
Currently we're using connect string = jdbc:sqlserver://servername:port;databasename
Then we can do select * from tablename

The other option is to update every reference:
connect string = jdbc:sqlserver://servername:port
Then select * from databasename.dbo.tablename

This second format is only required if you need to connect tables from multiple databases and looks uglier the more tables you join.  To switch from one to the other gets really ugly if you're changing the connect string for a common connection method that already has a bunch of sql statements which aren't referencing the database name.

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