• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

Does CMP create temp tables in database

 
Ranch Hand
Posts: 189
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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.
 
Ranch Hand
Posts: 172
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
    Number of slices to send:
    Optional 'thank-you' note:
  • 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.
 
Consider Paul's rocket mass heater.
reply
    Bookmark Topic Watch Topic
  • New Topic