topic Re: Document Tables in Derby DB in Nuxeo Forum

Document Tables in Derby DB

hgonzalez_ — Fri, 13 Apr 2012 11:28:12 GMT

I am using Nuxeo DM 5.5 with default derby db. How can I see in Derby DB the documents I have created? I am using SQuirreL SQL Client and the documentsLists table is empty.

Re: Document Tables in Derby DB

Benjamin_Jalon1 — Fri, 13 Apr 2012 11:41:59 GMT

The main table for document is the hierarchy table. To understand the database structure, see here. I didn't know that there was a SQL Client to parse the derby database.

Thanks,

Benjamin JALON

Re: Document Tables in Derby DB

Mon, 17 Jun 2013 11:37:11 GMT

I have had success using SQuirreL SQL Client http://www.squirrelsql.org. I used the Apache Embedded Derby driver and create an alias( SQuirrelL talk for db driver mapping) pointing to .../nxserver/data/derby/nuxeo/ data base in a standard download of Nuxeo.