• 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

Can somebody help me please? :(

 
Greenhorn
Posts: 2
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Hello,

I was able to create my first CMP2.0 Entity Bean, StudentBean. I am using J2EE RI server. When I deployed my EJB, and clicked on "Generate Default SQL..." (under Deployment Settings), various SQL statments were generated. These are SQL statements for createTable/createRow/etc methods; these SQL statements used "StudentBeanTable" as the table name.

Questions:

1. I created a "Student" table using Cloudscape ISQL, is there a way to tell RI to use this "Student" table instead, or RI automatically uses "<bean class>Table" (eg, StudentBeanTable) as the table name? Is this a limiation of RI?

2. I understand that <abstract-schema-name> is used/referenced within EJB-QL. I entered "StudentTest" in <abstract-schema-name>, I wonder why my application still worked.

3. I changed the deployment setting such that "Delete table on undeploy" is unchecked. After successfully creating an entity in StudentBeanTable, I went to Cloudscape ISQL, tried querying this table, but this table doesn't even exist.

Can somebody provide assistance? Thank you.

Regards,
Joanne T.
[ March 08, 2005: Message edited by: Joanne Thompson ]
 
Joanne Thompson
Greenhorn
Posts: 2
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Hi,

Need help on this one


Cheers,
Joanne T.
 
Ranch Hand
Posts: 44
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
I haven't used RI before, but I think this is a limitation of the product. What do you guys think about this?

- David
SCJP, SCWCD, IBM OOAD
 
Ranch Hand
Posts: 351
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator

Originally posted by Joanne Thompson:

2. I understand that <abstract-schema-name> is used/referenced within EJB-QL. I entered "StudentTest" in <abstract-schema-name>, I wonder why my application still worked.

3. I changed the deployment setting such that "Delete table on undeploy" is unchecked. After successfully creating an entity in StudentBeanTable, I went to Cloudscape ISQL, tried querying this table, but this table doesn't even exist.


I do not really know for sure but a few hints--

2. Just try a server re-start is needed for this. Did you try it already?
3. Did you let the transaction complete and then check? It depends on the container when it actually puts the data in the database.

Did you use 'search'? Few ranchers have posted queries regarding Cloudscape. So search on it and other relevant phrases and you might find some thread that helps you.

Regards,
Leena
reply
    Bookmark Topic Watch Topic
  • New Topic