AO.delete(db[ ]) is not working

[Vikash Kumar]

I am trying to delete all the records from active object table in my confluence plugin. But because of some reason the records are not being deleted.

Confluence verison: 5.6

Ao plugin version: 0.22.2

MyDB myDB[] = ao.find(MyDB.class);
ao.delete(MyDB);
ao.flushAll();

Other way around 

ao.deleteWithSQL(MyDB.class, "ID > ?", 0);

then I check my db data still exists.

I did write the code snippet inside executeInTransaction but no luck.

Please help !!

Thanks,

Vikash

[Saurabh Gupta]

Use something like 

ao.delete(MyDB[0]);

[Jobin Kuruvilla [Adaptavist]]

Code looks fine.

While DB are you using? If you are using something like HSQL for dev work, you will have to shut down Confluence before checking the data in DB.

[Vikash Kumar]

Yes, I do shut down confluence before checking data in db.