I am writing a custom plugin using Drive 126.96.36.199. For the most part, my plugin is working well. Occasionally, however, it looks like the Drive cache is not consistent with state of the content in my CMS. When this happens, I notice the wrong context menu items will be enabled in Finder/Explorer (e.g., "Check In..." vs. "Cancel Check Out..."), and the Drive icon in InDesign does not contain a checkmark or a pencil. When I look in the logs, I will often see exceptions like "FileSystemException: Invalid Handle" or "ModelObjectNotFoundException: Cannot find class com.adobe.drive.data.internal.model.Asset with id='144'".
I assume this is due to me sending inconsistent information to Drive via the UpdateRecipe. However, since Drive is a black box and this is happening intermittently, it makes it extremely difficult to debug issues like these. Is there any way to open the hsqldb database so that I can try to understand the current state of the Drive cache? I have downloaded hsqldb, but don't have the password to get into the database.
The database files of Adobe Drive are under the following folder:
To browse database, execute the following command to launch hsqldb util.
A 'Connect' dialog will appear. Input the following info In 'Connect' dialog to open the database.
After successfully connect to the database, you can input sql to browse database content.