db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From dag.wan...@oracle.com (Dag H. Wanvik)
Subject Re: Update sequence
Date Tue, 01 Feb 2011 20:38:57 GMT
Brett Wooldridge <brett.wooldridge@gmail.com> writes:

> We are currently using Hibernate with a table managed sequence scheme
> (javax.persistence.GenerationType.TABLE), but now that Derby supports
> Sequences we are considering migrating to real sequences
> (javax.persistence.GenerationType.SEQUENCE).
>
> One question we have is, is it possible to ALTER a sequence?  From
> what I've seen, the answer is currently no, but I thought I would ask
> here just in case.

It is not supported. You would have to do a DROP + a new CREATE. Note
that a new sequence can take a START WITH value, though.

Thanks,
Dag

Mime
View raw message