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

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

Re: Is there a SQL hashmap?

Show all headers | View raw

On 6/28/2018 9:49 AM, Eric Douglas wrote:
> 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.
>>
>> 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.

My expectation was that you could

jdbc:sqlserver://servername:port;dbnam_1

to mean that:

tblnam is really dbnam.dbo.tblnam, but that you can still
refer to dbnam_2.dbo.tblnam explicit aka

tblnam1 JOIN dbnam_2.dbo.tblnam2

Arne

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