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
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
 
Similar Threads
CMP EJB - BLOB - VisualAge - Sybase
Changing schema in DB2
VisualAge CMP EJB - BLOB and Sybase
Entity EJB CMP question in WSAD
won't create tables with jaws.xml