my dog learned polymorphism*
The moose likes EJB Certification (SCBCD/OCPJBCD) and the fly likes Can somebody help me please? :( Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Certification » EJB Certification (SCBCD/OCPJBCD)
Bookmark "Can somebody help me please? :(" Watch "Can somebody help me please? :(" New topic
Author

Can somebody help me please? :(

Joanne Thompson
Greenhorn

Joined: Mar 03, 2005
Posts: 2
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

Joined: Mar 03, 2005
Posts: 2
Hi,

Need help on this one


Cheers,
Joanne T.
david chen
Ranch Hand

Joined: Nov 30, 2001
Posts: 44
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
Leena Diwan
Ranch Hand

Joined: Jun 18, 2001
Posts: 351
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


[SCJP2, SCWCD1.3, SCBCD]
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Can somebody help me please? :(
 
Similar Threads
won't create tables with jaws.xml
findByPrimaryKey() returns null
J2EE RI Cloudscape DB Password
Entity Bean
How to find tables created by container?