Mailing-List: contact user-java-help@ibatis.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user-java@ibatis.apache.org
Received-SPF: pass (asf.osuosl.org: domain of finsaccanebbia@gmail.com
 designates 66.249.82.201 as permitted sender)
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws;
        s=beta; d=gmail.com;
        h=received:message-id:date:from:to:subject:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references;
        b=bLA6pW+CeBHLmaZwwnzjkhcGC3P5W59k1yvZ7z5iOLCti8CAwMo+20xfeAV5PnARaHa617XbMJWqWHx7+q1+EqN/kWMm9Bz7EXpHijEbvPNtzhG6z+g2Glqubf34IQikiEqI/4DnYpQiD/8WfFSZpB0VFUp3zhadSGi/4JLOEMo=
Message-ID: <a02a048805083106151ee22956@mail.gmail.com>
Date: Wed, 31 Aug 2005 15:15:07 +0200
From: Fabio Insaccanebbia <finsaccanebbia@gmail.com>
To: user-java@ibatis.apache.org
Subject: Re: Oracle scheme
In-Reply-To: <1EASAT-06deDI0@fwd35.aul.t-online.de>
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline
References: <1EASAT-06deDI0@fwd35.aul.t-online.de>

In Oracle "user" and "schema" are almost synonyms..

Configure iBatis to connect with VIBSCANNER user and you won't need to
prefix the tables with the user name.

If you don't want to connect with VIBSCANNER, you could create
synonyms for the schema of the user you connect with.

A better approach could be to create a "login trigger" for the user
you connect with. The trigger should then change the session to use
another schema (VIBSCANNER)

Hope it helps,
Fabio

2005/8/31, MRaedle@t-online.de <MRaedle@t-online.de>:
> Hello all,
>=20
> I use iBATIS to access ORACLE, MS SQL and other databases (with the same =
SQL
> maps).
>=20
> To access ORACLE databases I have following connection URL:
>=20
> Connection URL: jdbc:oracle:thin:@cm_ora_test:1521:webtest
>=20
> "webtest" indicates the SID of the ORACLE database.=20
>=20
> The problem is that under "webtest" more than one databases could managed=
.
> So for each db query I must put the database name in front of the table n=
ame
> such like this:
>=20
> "select * from VIBSCANNER.T_ALARM_BAND ..." (VIBSCANNER is the database
> name).
>=20
> For MS Access, MY SQL, ... I couldn't take the same SQL maps and that is =
not
> nice.
>=20
> Can you tell me, how I could resolve this problem, e.g. indicate also a
> scheme in the connection URL
> (jdbc:oracle:thin:@cm_ora_test:1521:webtest</scheme>)?
>=20
> Regards
>=20
> Manuel
>=20
>=20
>=20
>