ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Larry Meadors <larry.mead...@gmail.com>
Subject Re: Oracle scheme
Date Wed, 31 Aug 2005 15:29:21 GMT
One way would be to use $prefix$tablename in stead of just tablename.

For oracle, prefix would be set to your schema name, for all others,
it would be blank.

Larry

On 8/31/05, MRaedle@t-online.de <MRaedle@t-online.de> 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
> 
> 
> 
>

Mime
View raw message