The login trigger is executed once for connection and most of the cases it means it is rarely used (example: connection pool).
If the number of objects you want to access is large (50+) you'd probably prefer to create a single trigger rather than having to create and "mantain" 50+ synonyms.. I guess it's a matter of taste.. I should have added IMHO :-) Disclaimer: probably there are better ways to achieve this effect in iBatis.. I was talking only as an Oracle/JDBC guy Bye, Fabio 2005/8/31, Jan Vissers <[EMAIL PROTECTED]>: > "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 > > >
