reset password
Author Message
ljuster2
Posts: 19
Posted 17:30 May 08, 2014 |

I want to ensure that my sql files run without error for hw4. When I run them on my local sql editor, everything works and populates, etc., but I got marked off on hw3 because it didn't create a hibernate_sequence. 

When I drop tables, and then run my create-sql with "create sequence hibernate_sequence" as my last line, it says I already have a hibernate sequence defined. When I remove this last line, everything works fine. 

I'm not sure whether to keep "create sequence hibernate_sequence" as my last line in sql-create or delete it.....

xytian
Posts: 70
Posted 17:32 May 08, 2014 |

You need to drop the sequence in ttt-drop.sql.