Error SchemaUpdate: Unsuccessful create sequence

mimi_tan1985 · **Posted:** Tue Jan 29, 2008 11:14 pm

Hi All, I'm developing a web application using hibernate, struts, spring, and velocity, and database PostgreSql 8.2

Everytime when starting the tomcat, I got these 2 lines of errors:

Code:

10:09:27,156 ERROR SchemaUpdate:155 - Unsuccessful: create sequence 
10:09:27,156 ERROR SchemaUpdate:156 - ERROR: syntax error at end of input

what does that errors mean?? How can I fix it?
Anyway, the application runs well and I can ignore that errors, but I'm confusing if they can caused problems (someday).

Thanks in advance

mimi_tan1985 · **Posted:** Wed Jan 30, 2008 4:46 am

I solved the problem. It's because in one of my hibernate hbm.xml file there is a class in which I forgot to put the sequence name (transaction_seq)

Code:

<id name="id" type="integer" column="transaction_id">
   <generator class="sequence">
      <param name="sequence">transaction_seq</param>
   </generator>
</id>