openjpa-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Oliver Bayer (JIRA)" <>
Subject [jira] Created: (OPENJPA-1698) SchemaAction=deleteTableContents throws error if table doesn't exist
Date Sat, 12 Jun 2010 16:40:13 GMT
SchemaAction=deleteTableContents throws error if table doesn't exist

                 Key: OPENJPA-1698
             Project: OpenJPA
          Issue Type: Bug
          Components: jdbc
    Affects Versions: 2.0.0
         Environment: Win XP, Postgres 8.4, OpenJPA 2.0.0
            Reporter: Oliver Bayer


I want to set up my project during development so that all table contents are deleted with
the following property in persistence.xml:
<property name="openjpa.jdbc.SynchronizeMappings" value="buildSchema(SchemaAction=add,SchemaAction=deleteTableContents)"/>

If I start up with an empty database I get the following error:
org.apache.openjpa.persistence.PersistenceException: ERROR: Relation >>openjpa_sequence_table<<
doesn't exist.

This error is raised because of the following sql statement: DELETE FROM OPENJPA_SEQUENCE_TABLE.

My suggested solution would be to modify DBDictionary.getDeleteTableContentsSQL so that it
only deletes content from a table if the table exists.

DBDictionary: Line 2183
change: deleteSQL.add("DELETE FROM " + toDBName(tables[i].getFullIdentifier()));
to: deleteSQL.add("DELETE FROM " + toDBName(tables[i].getFullIdentifier()) + " IF EXISTS");

What do you mean: Is this a valid bugfix? I'm looking forward to your responses.

Greets Oli

This message is automatically generated by JIRA.
You can reply to this email to add a comment to the issue online.

View raw message