db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Susan Cline <...@MeepZor.Com>
Subject Re: lastAutoincrementValue
Date Thu, 23 Dec 2004 17:02:14 GMT
Mag Gam wrote:
> I am trying to get the lastAutoincrementValue for a table and I am using
> the ij tool. I keep getting an error saying ConnectionInfo class not
> found.
> 
> Has anyone have any luck with this?
> 
> Reference:
> http://cermics.enpc.fr/~rl/cloudscape/doc/html/coredocs/sqlj17.htmlasti
> VALUES ConnectionInfo::lastAutoincrementValue(
>     'schemaName', 'tableName', 'columnName')

The document you are referencing is for Cloudscape 5.1.

Are you using Derby, or an older version of Cloudscape?  For the Derby
documentation refer to:

	http://incubator.apache.org/derby/manuals/index.html

Derby does not support the syntax you are attempting to use - you'll 
need to create an identity column and use the built in function, 
IDENTITY_VAL_LOCAL to retrieve the last value for that column.

See

http://incubator.apache.org/derby/manuals/reference/sqlj82.html#HDRIDENTITYVALLOCAL

for the details.

Susan





Mime
View raw message