If you enable logging on "java.sql" you can see the SQL & the params being passed to the DB, and my (on Oracle) experience has been that they match. The whole point of iBatis is that there's not anything like that behind the scenes!
Are you 100% sure that you're using the same username on the DB connections, just to ensure there's not two different schemeas involved, but I think it's the next paragraph... You say "the queries run from ibatis only return results if they were inserted using ibatis" - Do you see the ibatis-inserts from sqlplus? I suspect that when you do inserts from isqlplus, you've not committing them - not sure of isqlplus but certainly sqlplus does not auto-commit. If you do an insert then select, you'll see it but it won't be there for others to see 'till committed, which ibatis will be doing for you. /Gwyn On 01/08/06, cmose <[EMAIL PROTECTED]> wrote:
Jeff thanks for the reply, I didn't really believe that there were phantom tables being created somewhere ;-) Trouble is that I have 0 caching configured anywhere and am not using explicit transactions anywhere, strictly using a simple data source that just connects to the database via jdbc and then using the sqlmapclient to call up queries from the mapping files so I'm rather at a loss to figure out where this problem is occuring. Albert, I'm not certain I follow what you mean; do you mean that an application running on a tomcat server was using ibatis and you had to restart tomcat before that application would see updates made via isql*plus or anything else other than the app? If so, I'm currently still testing this out so I'm just running a few classes directly from eclipse. I tried restarting eclipse, cleaning the project, shoot, I went so far as rebooting the workstation that the app was running on and all to no avail. I'm really quite stuck on this and I'm very very hesitant to put this into a production environment if i can't figure out what is causing this problem. thanks much for any insight! -- View this message in context: http://www.nabble.com/Phantom-data-results---tf2036087.html#a5604514 Sent from the iBATIS - User - Java forum at Nabble.com.
