aspose file tools*
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
Author

Apache Derby Sql

Amandeep Singh
Ranch Hand

Joined: Jul 17, 2008
Posts: 844
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- http://rkydesigns.blogspot.com
Christophe Verré
Sheriff

Joined: Nov 24, 2005
Posts: 14687
    
  16

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


[My Blog]
All roads lead to JavaRanch
 
 
subject: Apache Derby Sql