db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Matthew Hauck <hauc...@us.ibm.com>
Subject Re: Updating Autoincrement values
Date Wed, 18 Jul 2012 00:40:44 GMT

Okay, I finally found this:
http://db.apache.org/derby/docs/10.6/ref/rrefsqlj81859.html

ALTER TABLE tauto ALTER COLUMN i RESTART WITH 6

--
Matt Hauck



From:	Matthew Hauck/San Francisco/IBM@IBMUS
To:	derby-user@db.apache.org,
Date:	07/17/2012 05:23 PM
Subject:	Updating Autoincrement values



I have an old database that I need to import into apache derby. This seemed
to be a pretty easy thing to do, except when I realized that my
autogenerated ID column is stuck thinking the next autoincrement value is
1. i.e. since my import statements from the old database included IDs
(which are important for foreign key associations), I do not allow (and
cannot allow) derby to autogenerate them. So, I need to find some way to
tell derby to update the next autogenerate value to the one more than the
maximum of the ID in each of my tables.

So, I looked up tableid from sys.systables, and matched it with referenceid
from sys.syscolumns, and was going to change autoincrementvalue to be this
number, then got the following error: java.sql.SQLSyntaxErrorException:
'SYS.SYSCOLUMNS' is a system table.  Users are not allowed to modify the
contents of this table.

Boo. Is there another way to do this? This seems like a pretty common thing
to do, but can't seem to find the standard way to do it...

--
Matt Hauck
Mime
View raw message