File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes JDBC and the fly likes not able to use identity attribute in oracle Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "not able to use identity attribute in oracle" Watch "not able to use identity attribute in oracle" New topic
Author

not able to use identity attribute in oracle

sameer kumar
Greenhorn

Joined: Jan 06, 2006
Posts: 17
hello,

i dont have any primary key in the table. so i decided to use IDENTITY columns instead. i used the following query in oracle 9i:

create table kbtable (RELATEDTO VARCHAR2(100) NOT NULL,
GENERALSUBTYPE VARCHAR2(200) NOT NULL,
ISSUEOPENDATE DATE NOT NULL,
ISSUESTATUS VARCHAR2(7) NOT NULL,
ISSUE VARCHAR2(1000) NOT NULL,
UPDATEGIVENBY VARCHAR2(100),
ADDEDBY VARCHAR2(2) NOT NULL,
ADDEDONDATE DATE NOT NULL,
LASTMODIFIED DATE ,
LASTMODIFIEDBY VARCHAR2(2),
ISSUE_ID INT IDENTITY PRIMARY KEY )

but i am getting an error:

missing or invalid option

Please help

regards
sameer
 
With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.
 
subject: not able to use identity attribute in oracle
 
Similar Threads
how to use rowid to update records in oracle database
update while doing save in hibernate
unable to use identity columns
Alter Unique Index