[IBATIS-43] Oracle Schema switching and SQLMaps

• Type: New Feature
• Status: Closed
• Priority: Critical
• Resolution: Invalid
• Affects Version/s: 2.0.9
• Component/s: Core, Documentation
• Assignee: Unassigned
• Reporter: Peter Köhler
• Created: 05/Jan/05 23:57
• Updated: 15/Aug/09 13:33
• Resolved: 13/Feb/05 08:17

Description

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?