File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes EJB and other Java EE Technologies and the fly likes Problem on Oracle8i with J2SDKEE Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of JavaScript Promises Essentials this week in the JavaScript forum!
JavaRanch » Java Forums » Java » EJB and other Java EE Technologies
Bookmark "Problem on Oracle8i with J2SDKEE" Watch "Problem on Oracle8i with J2SDKEE" New topic
Author

Problem on Oracle8i with J2SDKEE

Venkataramu Pendiyala
Greenhorn

Joined: May 16, 2001
Posts: 25
I have developed a CMP bean with Oracle8i as backend.
While deploying the bean via J2SDKEE deploytool I selected the option "Create Table On Deploy".
The bean works correctly without any problem, but when I check the Oracle8i database the Table name is present but when I give the query "Select * from table_name" it gives the message "Table or view does not exist".
But the tables are created with DB2 as the backend.
Is there any other setting which needs to be done in CMP with respect to Oracle8i so that the Table actually gets created!!

SCJP
Desai Sandeep
Ranch Hand

Joined: Apr 02, 2001
Posts: 1157
Venkataramu,
The answer is very funny but when you use the J2EE Reference Implementation, with Oracle8i, it creates a table with a name as "TableName" (note the quotes) .
So you need to say select * from "TableName".
Hope this helps,
Sandeep
Venkataramu Pendiyala
Greenhorn

Joined: May 16, 2001
Posts: 25
Originally posted by Desai Sandeep:
Venkataramu,
The answer is very funny but when you use the J2EE Reference Implementation, with Oracle8i, it creates a table with a name as "TableName" (note the quotes) .
So you need to say select * from "TableName".
Hope this helps,
Sandeep

Thanks for the solution.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Problem on Oracle8i with J2SDKEE