ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Jan Vissers <Jan.Viss...@cumquat.nl>
Subject Re: Oracle scheme
Date Wed, 31 Aug 2005 14:11:16 GMT
"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, MRaedle@t-online.de <MRaedle@t-online.de>:
>  
>
>>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

Jan.Vissers@cumquat.nl
M +31 6 5 11 169 556



Mime
View raw message