Skip navigation
Currently Being Moderated

Debugging Drive Cache

Jan 11, 2012 8:46 AM

Tags: #hsqldb

I am writing a custom plugin using Drive 3.0.1.104.  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.

 

Thanks,

Rich

 
Replies
  • Currently Being Moderated
    Jan 13, 2012 12:45 AM   in reply to Rich Schafer

    The database files of Adobe Drive are under the following folder:

     

    • Win XP: C:\Documents and Settings\[current-machine-user]\Application Data\Adobe\CS5ServiceManager\database
    • Win 7: C:\Users\[current-machine-user]\AppData\Roaming\Adobe\CS5ServiceManag er\database
    • Mac: /Users/[current-machine-user]/Library/Application Support/Adobe/CS5ServiceManager\database

     

    To browse database, execute the following command to launch hsqldb util.

    • java -cp [path-to-hsqldb.jar] org.hsqldb.util.DatabaseManagerSwing

    A 'Connect' dialog will appear. Input the following info In 'Connect' dialog to open the database.

    • Type: HSQL Database Engine Standalone
    • URL: jdbc:hsqldb:file:[path-to-database, above shows the details]/adrive-db
    • User: SA
    • Password:[no password, leave it blank]

     

    After successfully connect to the database, you can input sql to browse database content.

     
    |
    Mark as:

More Like This

  • Retrieving data ...

Bookmarked By (0)

Answers + Points = Status

  • 10 points awarded for Correct Answers
  • 5 points awarded for Helpful Answers
  • 10,000+ points
  • 1,001-10,000 points
  • 501-1,000 points
  • 5-500 points