Win a copy of The Java Performance Companion this week in the Performance forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Database access through CMP, Setting Schema

 
Ram Raju
Greenhorn
Posts: 17
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic