Why deploying java application on glassfish 3.1 returns exception?

[Mattias]

I was trying to run the pet catalog sample application which comes with Netbeans IDE 6.9.1 by the time I run it I get the following error message


HTTP Status 500 -

type Exception report

message

descriptionThe server encountered an internal error () that prevented it from fulfilling this request.

exception

javax.servlet.S ervletException

root cause

javax.ejb.EJBEx ception

root cause

Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.0.1.v20100213-r6600): org.eclipse.per sistence.except ions.DatabaseEx ception
Internal Exception: java.sql.SQLSyn taxErrorExcepti on: Table/View 'ITEM' does not exist.
Error Code: -1
Call: SELECT COUNT(ITEMID) FROM ITEM
Query: ReportQuery(ref erenceClass=Ite m sql="SELECT COUNT(ITEMID) FROM ITEM")

root cause

java.sql.SQLSyn taxErrorExcepti on: Table/View 'ITEM' does not exist.

root cause

org.apache.derb y.client.am.Sql Exception: Table/View 'ITEM' does not exist.

note The full stack traces of the exception and its root causes are available in the GlassFish Server Open Source Edition 3.0.1 logs.


-----------
The error says the table or view does not exist but I can access the database from the IDE

and I have also configured sun-resource.xml so I would appreciate your help

thanks