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 Android Security Essentials Live Lessons this week in the Android 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

<b>Sandeep</b> <br /> <br /><b>Sun Certified Programmer for Java 2 Platform</b><br /> <br /><b>Oracle Certified Solution Developer - JDeveloper</b><br /><b>-- Oracle JDeveloper Rel. 3.0 - Develop Database Applications with Java </b><br /><b>-- Object-Oriented Analysis and Design with UML</b><br /> <br /><b>Oracle Certified Enterprise Developer - Oracle Internet Platform</b><br /><b>-- Enterprise Connectivity with J2EE </b><br /><b>-- Enterprise Development on the Oracle Internet Platform </b>
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.
 
Don't get me started about those stupid light bulbs.
 
subject: Problem on Oracle8i with J2SDKEE
 
Similar Threads
How to set a boolean CMP field?
BMP and Data Source Mapping in WSAD 5.0?
problem with composite primary key---URGENT
More WSAD5..0 moaning...
Problem in running a CMP URGENT