Is there a way in spring jdbc to return a composite primary key when a row is inserted. this composite primary key is made up of values from separate sequences any help is greatly appreciated reg.... Primary key from inserted row jdbc? ask question. up vote 38 down vote favorite. 7. is there a cross database platform way to get the primary key of the record you have just inserted? i noted that this answer says that you can get it by calling select last_insert_id(). The update should only update a single row, but that can't be guaranteed. – nelson apr 14 '16 at 14:12 assuming item_id is not the primary key, you should go with batchupdate() rather than update as you said it could possibly affect multiple rows..
How to get primary key value (auto-generated keys) from inserted queries using jdbc? description: when we are inserting a record into the database table and the primary key is an auto-increment or auto-generated key, then the insert query will generate it dynamically.. Following is the example, which makes use of the resultset.concur_updatable and resultset.type_scroll_insensitive described in the result set tutorial. this example would explain insert, update and delete operation on a table. it should be noted that tables you are working on should have primary key set properly.. A primary key is a special case of an index -- specifically, a primary key is a unique identifier for an individual row in a table. in most cases, this is implemented using an indexing structure, which allows you to access that single row rapidly by using the primary key column(s) in a predicate..
0 comments:
Post a Comment
Note: Only a member of this blog may post a comment.