wood burning stoves 2.0*
The moose likes JDBC and the fly likes derby database in NetBeans does not have identity keyword Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Spring in Action this week in the Spring forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "derby database in NetBeans does not have identity keyword" Watch "derby database in NetBeans does not have identity keyword" New topic
Author

derby database in NetBeans does not have identity keyword

Lokendra Shekhawat
Ranch Hand

Joined: Jun 08, 2009
Posts: 40
Hi friends, i wanted to generate values in table automatically in the derby database. but the identity keyword is not working, is there any other keyword which perform the same functionality. how to generate values automatically in derby database. Please advice.


SCJP5 93%. SCWCD 98%.

Visit my website http://www.rajasthan4tourism.com for information about rajasthan tourist places and much more.....!!!
Jan Cumps
Bartender

Joined: Dec 20, 2006
Posts: 2503
    
    8

Lokendra Shekhawat wrote:Hi friends, i wanted to generate values in table automatically in the derby database. but the identity keyword is not working, is there any other keyword which perform the same functionality. how to generate values automatically in derby database. Please advice.
Hi. Does (GENERATED BY DEFAULT AS IDENTITY) help?


OCUP UML fundamental and ITIL foundation
youtube channel
Lokendra Shekhawat
Ranch Hand

Joined: Jun 08, 2009
Posts: 40
Thank you it surely help me very much.

now i am going to use it, before i was using MS SQL server.

where the derby database file get stored, does it store with in the project folder or somewhere else.

when i deploy the war file will i have to upload database differently or it will go with war file.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: derby database in NetBeans does not have identity keyword