jQuery in Action, 2nd edition*
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


Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
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
 
Consider Paul's rocket mass heater.
 
subject: Apache Derby Sql
 
Similar Threads
Hibernate newbie - Data sequence
Cloudscape Create Sequence
apache derby default CacheManager
cant read the contents of the printed string
JPQL String Function