Win a copy of Think Java: How to Think Like a Computer Scientist this week in the Java in General forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Problem on Oracle8i with J2SDKEE

 
Venkataramu Pendiyala
Greenhorn
Posts: 25
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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!!
 
Desai Sandeep
Ranch Hand
Posts: 1157
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 25
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic