Checking for table existence before findBy

Hi All,

I am executing a findBy method of my Entity bean as below:

Collection data = getSmsNotificationDataHome().findByCorrelator(correlator,service,requester);

But i am gettig an javax.ejb.EJBException if the table is droped from the database.

I am using websphere application server v6 and the exception message doesnt describe the cause of the exception.

I tried to print the cause of the exception by using e.getCausedByException() it prints the below line:

The exception is caused by: com.ibm.ws.ejbpersistence.utilpm.PersistenceManagerException: PMGR6022E: Error using adapter to create or execute an Interaction. com.ibm.ws.rsadapter.cci.WSInteractionImpl@52785278

Can somebody give any light on it. Is there any way by which i can check for the existence of the table before i execute my find by method. Or is there any way by which i can catch the correct exception and tell the user that the table doesnt exists.

Please help me !!!!!111

Thanks & Regards

-Sandeep

[1044 byte] By [km-sandeepa] at [2007-10-3 9:42:06]
# 1
Why would someone drop the table so frequently?
aniseeda at 2007-7-15 4:58:15 > top of Java-index,Enterprise & Remote Computing,Enterprise Technologies...