Well thanks for the tip - I'm in progress of trying it. Although I didn't understand the comment -
If your web application isn't the schema owner, you likely need to include schema name in your table references.
I mean, Jboss is giving me a pure JDBC connection to this schema anyway. Once I have the connection, using a CallableStatment, I should able to invoke a stored procedure inside the same schema, without explicitly referring to it by name.
This the code I'm using to call it:
To answer your other question - yes, the schema name, username and password are all the same
string for us [since we are still within systems
testing on UAT environments]. When I login to TOAD, I login as the schema owner.