aspose file tools*
The moose likes EJB and other Java EE Technologies and the fly likes Database access through CMP, Setting Schema Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Soft Skills this week in the Jobs Discussion forum!
JavaRanch » Java Forums » Java » EJB and other Java EE Technologies
Bookmark "Database access through CMP, Setting Schema" Watch "Database access through CMP, Setting Schema" New topic
Author

Database access through CMP, Setting Schema

Ram Raju
Greenhorn

Joined: Mar 11, 2003
Posts: 17
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.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Database access through CMP, Setting Schema