Win a copy of Murach's Python Programming this week in the Jython/Python forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic

Does CMP create temp tables in database  RSS feed

 
Raj Puri
Ranch Hand
Posts: 189
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I was reading below on onjava:
Auto-creating table: create table work_ejb_WorkHours (email
VARCHAR2(255) not null, monthEnding DATE not null, workHours
double precision null, trainingHours double precision null,
vacationHours double precision null, otherHours double precision
null, primary key (email, monthEnding))

Is it right that deploying CMP on an application server menas that containre will create temp tables in database where all sql is done
before data is written to real tables. Not read this anywher except when
I saw above extract from onjava on example to deploy CMP EJB.

Please clarify.
 
Annie Smith
Ranch Hand
Posts: 172
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
AFAIK, if the tables are not already created, a CMP entity bean would create them first before performing any further operations.
 
Raj Puri
Ranch Hand
Posts: 189
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
No. I have database tables already. I was trying to understand how CMP does DML's. In CMP implemetations we do not write JDBC, so does container create any temp tables in the the database internally to do its SQL job. My questions is more to find will CMP need more space on database than just normal database table spaces.
 
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!