Issue Details (XML | Word | Printable)

Key: FIRSTCUP-17
Type: Improvement Improvement
Status: Resolved Resolved
Resolution: Works as designed
Priority: Minor Minor
Assignee: Ian Evans
Reporter: TangYong
Votes: 0
Watchers: 0
Operations

If you were logged in you would be able to see more operations.
firstcup

SEQUENCE Table was not deleted automatically while undeploying firstcup-war

Created: 22/Aug/13 08:30 AM   Updated: 22/Aug/13 04:53 PM   Resolved: 22/Aug/13 04:53 PM
Component/s: examples
Affects Version/s: 7.0.1, 7.0.2
Fix Version/s: current

Time Tracking:
Not Specified

Environment:

GlassFish 4


Tags:
Participants: Ian Evans and TangYong


 Description  « Hide

1 asadmin deploy firstcup-war.war

2 asadmin undeploy firstcup-war

3 asadmin deploy firstcup-war.war

PER01003: Deployment encountered SQL Exceptions:
PER01000: Got SQLException executing statement "CREATE TABLE SEQUENCE (SEQ_NAME VARCHAR(50) NOT NULL, SEQ_COUNT DECIMAL(15), PRIMARY KEY (SEQ_NAME))": java.sql.SQLException: Table/View 'SEQUENCE' は、既に Schema 'APP' に存在します。
Command deploy completed with warnings.

The exception is not friendly and we should also delete SEQUENCE Table while undeploying firstcup-war.