"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)"
This looks pretty ugly and rather "expensive". Why would you want to do
this?
Fabio Insaccanebbia wrote:
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, [EMAIL PROTECTED] <[EMAIL PROTECTED]>:
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
