Document Tables in Derby DB

hgonzalez_
Confirmed Champ
Confirmed Champ

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.

1 ACCEPTED ANSWER

Not applicable

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.

View answer in original post

2 REPLIES 2

Benjamin_Jalon1
Elite Collaborator
Elite Collaborator

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

Not applicable

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.