This week's book giveaway is in the Servlets forum.
We're giving away four copies of Murach's Java Servlets and JSP and have Joel Murach on-line!
See this thread for details.
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 Murach's Java Servlets and JSP this week in the Servlets 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
 
Similar Threads
VisualAge CMP EJB - BLOB and Sybase
won't create tables with jaws.xml
Entity EJB CMP question in WSAD
Changing schema in DB2
CMP EJB - BLOB - VisualAge - Sybase