Hibernate version: 2.1.7C

Mapping documents:

<class name="ReclamoModel"
table="RECLAMOS">

<!-- Common id property. -->
<id name="id"
type="long"
column="ID"
unsaved-value="null">
<generator class="sequence">
<param name="sequence">reclamos_seq</param>
</generator>
</id>

</class>

The error: Relation reclamos_seq does not exist.

Name and version of the database you are using: Postgresql 8.0

The generated SQL (show_sql=true): select nextval('reclamos_seq')

When I save the Entity Bean I get this error, but if I execute the same sql directly into the database, I receive the correct value.

I'm trying to get a sequence number generated for a column before inserting the values in the table.

I use select nextval('sequence_name') and use this query to read the result into a result set but I get a "relation "sequence_name" does not exist" error.

I'm using postgres 8.1. Any ideas how I can get around this?

Thanks.

I'm trying to get a sequence number generated for a column before inserting the values in the table.

I use select nextval('sequence_name') and use this query to read the result into a result set but I get a "relation "sequence_name" does not exist" error.

I'm using postgres 8.1. When I create the same the database it works. But not through java/hibernate code.
Any ideas how I can get around this?

Thanks.