You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@ibatis.apache.org by "Clinton Begin (JIRA)" <ib...@incubator.apache.org> on 2005/02/13 00:21:15 UTC

[jira] Closed: (IBATIS-43) Oracle Schema switching and SQLMaps

     [ http://issues.apache.org/jira/browse/IBATIS-43?page=history ]
     
Clinton Begin closed IBATIS-43:
-------------------------------

     Assign To: Clinton Begin
    Resolution: Invalid


This is unsupported behaviour.  Switching schemas in Oracle is as drastic as switching databases at runtime.  We don't support either.  Use a separate instance of SqlMapClient for each database or schema.

> Oracle Schema switching and SQLMaps
> -----------------------------------
>
>          Key: IBATIS-43
>          URL: http://issues.apache.org/jira/browse/IBATIS-43
>      Project: iBatis for Java
>         Type: Wish
>   Components: Documentation, SQL Maps
>     Versions: 2.0.9
>     Reporter: Peter Köhler
>     Assignee: Clinton Begin
>     Priority: Critical

>
> Hi to everyone at the iBatis team,
> i ran into a problem related to schema switching in oracle.
> We have an application where you have a kind of single application / multiple data (i.e. db-schemata).
> We had "ORA-01007: variable not in select list" errors after switching the schema.
> The problem was that the two tables in our schemata were not absolutely identical (one numeric column in one table was not deleted). 
> SQL Maps remembered the mapping of the table in schema1 when querying schema2.
> This should be mentioned in the docs because it seems obvious that 
>   select * from schema1.table behaves the same as 
>   select * from schema2.table 
> when your application does not use the unnecessary column in schema2.table.
> But it does not behave the same and produces a very nasty bug.
> Greetings from Frankfurt
> Peter Köhler
> P.S.: Did You change the behaviour in 2.0.9?

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
   http://issues.apache.org/jira/secure/Administrators.jspa
-
If you want more information on JIRA, or have a bug to report see:
   http://www.atlassian.com/software/jira