Hi all, This is kinda dumb and I am not even sure if this is the place to post this. When I access the database it appends the schema name to the table name. So if I am logged in with a different user name other than schema name, I am in trouble. Now in plain SQL I can use a set schema to set the default schema but how do I do it when I am not writing the sql, like say in a CMP EJB.
subject: Database access through CMP, Setting Schema