ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Jeff Butler <jeffgbut...@gmail.com>
Subject Re: Oracle scheme
Date Wed, 31 Aug 2005 13:20:43 GMT
I'm definitely not an Oracle guy, but here's a thought...
 DB2 allows you to specify a default schema as one of the JDBC connection 
properties. Does Oracle support something like that?
 Jeff Butler

 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