How To Add Index to Pre-Existing ObjectStore In IndexedDB

Question

I know this questions has been asked several times . But I have not been able to find out the solution after getting error multiple times . this is the code of my indexed db

    request.onupgradeneeded = function(event) {
      var db = event.target.result;
   var upgradeTransaction = event.target.transaction;        
   var objectStore = db.createObjectStore("todostore", {keyPath: "timestamp"});     

UserFunction();     

     };

     function UserFunction(){
var ObjectStore = db.transaction("todostore").objectStore("todostore");
var index = ObjectStore.createIndex("ixName", "fieldName");
  }



Failed to execute 'createIndex' on 'IDBObjectStore': The database is not running a version change transaction.

I am calling this function of button click I want to add index with value when a button is clicked

<button onclick="UserFunction()">createIndex</button>

possible duplicate of stackoverflow.com/questions/11532935/… — Akshay Tilekar
– Akshay Tilekar, Commented Dec 11, 2016 at 13:39

Joshua Bell · Accepted Answer · 2016-12-12 17:04:06Z

0

You can only change the schema of the database during a version upgrade. Something like this is plausible:

function OnClick() {
  // assumes db is a previously opened connection
  var oldVersion = db.version; 
  db.close();

  // force an upgrade to a higher version
  var open = indexedDB.open(db.name, oldVersion + 1);
  open.onupgradeneeded = function() {
    var tx = open.transaction;
    // grab a reference to the existing object store
    var objectStore = tx.objectStore('todostore');
    // create the index
    var index = objectStore.createIndex('ixName', 'fieldName');
  };
  open.onsuccess = function() {
    // store the new connection for future use
    db = open.result;
  };
}

answered Dec 12, 2016 at 17:04

Joshua Bell

8,48531 silver badges34 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Jitendra Kumar Choudhary · Accepted Answer · 2016-12-11 14:51:57Z

-1

Code in UserFunction() call, is starting a new transaction, while already a transaction is going on in "upgradeneeded" listener.

So new transaction should be started, after objectStore.transaction completes.

Here is the JSFiddle : Solution is here

function UserFunction(){
    var request = window.indexedDB.open("MyTestDatabase", 3);

    request.onupgradeneeded = function(event) {
        var db = event.target.result;
        var upgradeTransaction = event.target.transaction;        
        var objectStore = db.createObjectStore("todostore", {keyPath: "timestamp"});            
        objectStore.transaction.oncomplete = function(event) {
        addIndex(db);
      };
    };
}

function addIndex(db){
    var ObjectStore = db.transaction("todostore").objectStore("todostore");
    var index = ObjectStore.createIndex("ixName", "fieldName");
}

answered Dec 11, 2016 at 14:51

Jitendra Kumar Choudhary

1

2 Comments

Jitendra Kumar Choudhary Over a year ago

Could you please share your exact code on JSFiddle, there we can refactor and resolve it easily.

Joshua Bell Over a year ago

You can only use createIndex during a versionchange transaction, i.e. as a result of opening with a higher version and performing an upgrade. You can't use createIndex within a transaction started with db.transaction()

Collectives™ on Stack Overflow

How To Add Index to Pre-Existing ObjectStore In IndexedDB

2 Answers 2

Comments

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related