Are you connecting to the mydemo schema in both situations?
Originally posted by vijay nivas:
Yes, I am executing the query with the same username in both.
The main drawback is that it is not possible by default to connect to the database from outside your application. As a result you cannot check the contents of the database with external tools such as Database Manager while your application is running.