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 > > > >
