From mboxrd@z Thu Jan  1 00:00:00 1970
X-Spam-Checker-Version: SpamAssassin 3.4.4 (2020-01-24) on polar.synack.me
X-Spam-Level: 
X-Spam-Status: No, score=-0.9 required=5.0 tests=BAYES_00,FORGED_GMAIL_RCVD,
	FREEMAIL_FROM autolearn=no autolearn_force=no version=3.4.4
X-Google-Thread: a07f3367d7,4ef7e3d0c7ac8809
X-Google-Attributes: gida07f3367d7,public,usenet
X-Google-NewGroupId: yes
X-Google-Language: ENGLISH,ASCII-7-bit
Path: 
 g2news2.google.com!postnews.google.com!k14g2000pre.googlegroups.com!not-for-mail
From: Emmanuel Briot <briot.emmanuel@gmail.com>
Newsgroups: comp.lang.ada
Subject: Re: Many Database Connections
Date: Thu, 27 Jan 2011 13:37:19 -0800 (PST)
Organization: http://groups.google.com
Message-ID: 
 <88b03959-0d74-487b-9fcc-ab3a0dc6eab9@k14g2000pre.googlegroups.com>
References: 
 <99d20061-de06-4383-8675-e1abd9803b0d@o10g2000vbg.googlegroups.com>
NNTP-Posting-Host: 88.181.126.208
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
X-Trace: posting.google.com 1296164239 21985 127.0.0.1 (27 Jan 2011 21:37:19
 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Thu, 27 Jan 2011 21:37:19 +0000 (UTC)
Complaints-To: groups-abuse@google.com
Injection-Info: k14g2000pre.googlegroups.com; posting-host=88.181.126.208;
 posting-account=6yLzewoAAABoisbSsCJH1SPMc9UrfXBH
User-Agent: G2/1.0
X-HTTP-UserAgent: Mozilla/5.0 (X11; U; Linux x86_64; en-US) AppleWebKit/534.10
 (KHTML, like Gecko) Chrome/8.0.552.237 Safari/534.10,gzip(gfe)
Xref: g2news2.google.com comp.lang.ada:17720
Date: 2011-01-27T13:37:19-08:00
List-Id: <comp.lang.ada>

> To clarify this, imagine that I have 2 Databases, DB1 and DB2. I have
> 2 Gnatcoll databases connectors pointing to each one, lets say DB1_Con
> for the connector to DB1, and DB2_Con for the other. I execute the
> query on DB1 by calling Execute (DB1_Con, "INSERT t1 ...."), then call
> the procedure Execute (DB2_Con, "INSERT t2..."). The second call to
> Execute will fail because it tried to insert in DB1 and since DB1 does
> not have a t2 table, it fails!!!

Please provide an actual reproducer, since it all depends how you
create
the connections. For instance, we need to see what you use for the
factory
in Get_Task_Connection (or maybe you do not use that to create the
connection)

Emmanuel