aspose 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 Spring in Action this week in the Spring 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.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Problem on Oracle8i with J2SDKEE