Hi,
I'm a bit puzzled by "The problem is that under "webtest" more than one
databases could managed". Do you mean that you can manage data in tables
belonging to a different user/schema residing in the same database
instance, or in an actual different database instance?
If the former is true, than VIBSCANNER is in fact a user/schema residing
in the same database instance and in that case a synonym for
T_ALARM_BAND would be the way to go. As far as I can digest from your
post, VIBSCANNER already has granted select privileges to cm_ora_test,
because prefixing already works for you. If you don't want to prefix than
execute the following SQL statement (using SQL*Plus or something) while
connected to the database as VITBSCANNER:
create synonym T_ALARM_BAND for VIBSCANNER.T_ALARM_BAND;
From there on you don't need to use prefixes in your sqlMaps.
Hope this helps.
[EMAIL PROTECTED] wrote:
Hello all,
I use iBATIS to access ORACLE, MS SQL and other databases (with the
same SQL maps).
To access ORACLE databases I have following connection URL:
Connection URL: jdbc:oracle:thin:@cm_ora_test:1521:webtest
"webtest" indicates the SID of the ORACLE database.
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 name such like this:
"select * from VIBSCANNER.T_ALARM_BAND ..." (VIBSCANNER is the
database name).
For MS Access, MY SQL, ... I couldn't take the same SQL maps and that
is not nice.
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>)?
Regards
Manuel
--
Cumquat Information Technology
De Dreef 19
3706 BR Zeist
T +31 (0)30 - 6940490
F +31 (0)10 - 6940499
http://www.cumquat.nl
[EMAIL PROTECTED]
M +31 6 5 11 169 556
