File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes EJB Certification (SCBCD/OCPJBCD) and the fly likes Apache Derby Sql Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Certification » EJB Certification (SCBCD/OCPJBCD)
Bookmark "Apache Derby Sql " Watch "Apache Derby Sql " New topic

Apache Derby Sql

Amandeep Singh
Ranch Hand

Joined: Jul 17, 2008
Posts: 850
create sequence user_sequence start with 1 increment by 10

i want to create sequence in Apache Derby Database. Running this query give's me error-

Error: Syntax error: Encountered "sequence" at line 1, column 8.
SQLState: 42X01
ErrorCode: -1

Cananybody let me know proprer syntax query for Derby.

SCJP 1.4, SCWCD 5, SCBCD 5, OCPJWSD 5,SCEA-1, Started Assignment Part 2
My blog-
Christophe Verré

Joined: Nov 24, 2005
Posts: 14688

Derby does not support sequences like Oracle, but it supports identity columns.

[My Blog]
All roads lead to JavaRanch
I agree. Here's the link:
subject: Apache Derby Sql
It's not a secret anymore!