Description Michael OBrien 2008-07-04 09:13:16 EDT

CreateSchema - Fails on deleteAll.
We may want to make delete non-terminal in this example, I was able to proceed further by commenting 45:deleteAll(em) temporarily.
However I fail later when populating the database - we may need an expanded wiki section.


[EL Fine]: Connection(7318012)--DELETE FROM GEO_POINT
Exception in thread "main" javax.persistence.PersistenceException: Exception [EclipseLink-4002] (Eclipse Persistence Services - 1.0 (Build SNAPSHOT - 20080703)): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.BatchUpdateException: error occurred during batching: ORA-00942: table or view does not exist

Error Code: 17081
	at org.eclipse.persistence.internal.jpa.EntityManagerImpl.flush(EntityManagerImpl.java:382)
	at org.eclipse.persistence.internal.jpa.EJBQueryImpl.performPreQueryFlush(EJBQueryImpl.java:936)
	at org.eclipse.persistence.internal.jpa.EJBQueryImpl.executeUpdate(EJBQueryImpl.java:427)
	at utils.CreateSchema.deleteAll(CreateSchema.java:99)
	at utils.CreateSchema.deleteAll(CreateSchema.java:114)
	at utils.CreateSchema.main(CreateSchema.java:45)
Caused by: Exception [EclipseLink-4002] (Eclipse Persistence Services - 1.0 (Build SNAPSHOT - 20080703)): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.BatchUpdateException: error occurred during batching: ORA-00942: table or view does not exist

>Fixed by commenting 45:deleteAll(em) temporarily in CreateSchema

LoadCanada - Fails
Exception in thread "main" java.lang.RuntimeException: Automatic download not yet supported
	at utils.load.TabSeparatedRowReader.verifyDataFile(TabSeparatedRowReader.java:52)
	at utils.load.TabSeparatedRowReader.<init>(TabSeparatedRowReader.java:37)
	at utils.load.FeatureLoader.load(FeatureLoader.java:31)
	at utils.PopulateMetadata.main(PopulateMetadata.java:39)

Error Code: 942
Call: SELECT NAME, OFFSET, DSTOFFSET FROM GEO_TIMEZZONE WHERE (NAME LIKE ?)
	bind => [America/%]
Query: ReadAllQuery(model.geonames.TimeZone)