Esatto!
Thanks a lot Giovanni for being my "commit reminder".
I wish, at least, this post will be a reminder for all "head in the clouds" 
people as somtimes I am.

Bye.

Giovanni Cuccu ha scritto:
ciao Andrea,
 did you try to issue the same commands (select ....) from a command
line sqplus?
Perhaps it's a simple problem of uncommited data i.e. did you commited
your data after inserting into the table?
(I ask for these because it's one of the more frequest mistakes I do)
Giovanni


On Mon, Jul 7, 2008 at 11:21 AM, Andrea Colleoni
<[EMAIL PROTECTED]> wrote:
Hi all,
this is my first post. I'm quite new to iBatis ad I'm facing a strange
problem.
I've recently changed the underlying schema of my DB (Oracle XE) and changed
a VIEW to a TABLE (dropped the view and created the table, then populated
the table). Table and view have the same name and the same column set.
The problem is that after this change it seems that iBatis cannot find any
record in the new table; it gives me no exceptions. I can issue the same
query (copied from the log) to the DB via Squirrel using the same driver and
I get the expected results (some records). Before the change all was OK.
For debugging purposes (trying to avoid the influence of my sqlMap) I've
also tried a SELECT COUNT(*), but it still gives me 0 record and no
excpetion instead of the over 400 expected.
Can anyone tell me what to check to get this working?

----------------
I'm using:
----------------
- ibatis-2.3.0.677
- spring-framework-2.5.3 (to inject sqlMapConfig)
- integrated support for JUnit in Eclipse Version: 3.3.2 (to test my
queries)
----------------

Thanks in advance.

Bye.

--
Andrea Colleoni
skype: andreacolleoni






--
Andrea Colleoni
skype: andreacolleoni

Reply via email to