Friday, November 16, 2012

java.sql.SQLException: Table 'myschema.EVENT doesn't exist

So I am trying to test my new app locally using GPE with JPA configured to use my Cloud SQL instance.When I try running it I get the following exception:

[EL Info]: 2012-11-16 22:33:53.613--ServerSession(1682847419)--EclipseLink, version: Eclipse Persistence Services - 2.4.1.v20121003-ad44345
[EL Info]: connection: 2012-11-16 22:33:55.609--ServerSession(1682847419)--file:/C:/workspace/MyWebApp/war/WEB-INF/classes/_User1 login successful
[EL Warning]: 2012-11-16 22:33:56.668--UnitOfWork(1692389875)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.4.1.v20121003-ad44345): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: Table 'myschema.EVENT' doesn't exist
Error Code: 1146
Call: SELECT MAX(EVENTDATE) FROM EVENT
Query: ReportQuery(referenceClass=Event sql="SELECT MAX(EVENTDATE) FROM EVENT")


I can execute the same query using the Google APIs Console. I can also see the schema and table using the Data Source Explorer in Eclipse so I know they exist.

Any ideas as to what is wrong?

Thanks in advance for your help.

-Tony

No comments:

Post a Comment