Course of circle of data DERBY of NUXEO DM

[jiveforums-ecm]

Having installed NUXEO DM application and having seen made some manipulations on interface, I had curiosity to go to see where was my database and what it contained.
I saw that, by default, it is DERBY which is used and I made essentials to be able to consult it.
Having installed and defined the small motor SGBDR Apache Derby, I opened a window BACK, by putting me on the good directory in this case "Nuxeo-dm-5.2.0\server\default\data\derby"; once having thrown the tool IJ, I would say that from this instant my troubles begin.
In effect I am first connected to the database as follows " connect ' jdbc:derby:nuxeo; create=false '; " then I want to see the present tables by order " shows tables " and the console list 85 tables among which the following

.......
SA |JBPM_POOLEDACTOR |
SA |JBPM_PROCESSDEFINITION |
SA |JBPM_PROCESSINSTANCE |
SA |JBPM_RUNTIMEACTION |
SA |JBPM_SWIMLANE |
SA |JBPM_SWIMLANEINSTANCE |
SA |JBPM_TASK |
SA |JBPM_TASKACTORPOOL |
SA |JBPM_TASKCONTROLLER |
SA |JBPM_TASKINSTANCE |
SA |JBPM_TOKEN |
SA |JBPM_TOKENVARIABLEMAP |
SA |JBPM_TRANSITION |
SA |JBPM_VARIABLEACCESS |
SA |JBPM_VARIABLEINSTANCE |
SA |JENA_G1T0_REIF |
SA |JENA_G1T1_STMT |
SA |JENA_G2T0_REIF |
SA |JENA_G2T1_STMT |
SA |JENA_G3T0_REIF |
SA |JENA_G3T1_STMT |
SA |JENA_G4T0_REIF |
SA |JENA_G4T1_STMT |
SA |JENA_GRAPH |
SA |JENA_LONG_LIT |
SA |JENA_LONG_URI |
SA |JENA_PREFIX |
SA |JENA_SYS_STMT |
SA |LOCALTHEMECONFIG |
SA |NXP_LOGS |
SA |NXP_LOGS_EXTINFO |
SA |NXP_LOGS_MAPEXTINFOS |
SA |NXP_WEBWIDGETS_DATA |
SA |NXP_WEBWIDGETS_WIDGET |
SA |NXP_WEBWIDGETS_WIDGET_PREFERE&|
SA |UID_SEQUENCE |
SA |USERSUBSCRIPTION |
SA |continent |
SA |country |
SA |documentsLists |
SA |group2group |
SA |groups |
SA |relation_inverse_predicates |
SA |relation_predicates |
SA |search_operators |
SA |sort_order |
SA |subject |
SA |subtopic |
SA |topic |
SA |user2group |
SA |users |

As a result I try to go through the one who should contain my documents " documentsLists " with order " *select * from SA.documentsLists * " and it gives me as error " ERROR 42X05: The table / view ' SA.DOCUMENTSLISTS ' does not exist. ".
Even in uppercase letter result is the same. What is strange it is I succeed in seeing the contents of a table as "USERSUBSCRIPTION" as all the others in UPPERCASE LETTERS but not those in LOWER CASES. I turn in a circle for day. If somebody had resolution this would be brilliant.

Thank you in advance.
--
Posted by "laponse" at Nuxeo Discussions <http://nuxeo.org/discussions>
View the complete thread: <http://www.nuxeo.org/discussions/thread.jspa?threadID=2584#7278>
_______________________________________________
ECM mailing list
ECM@...
http://lists.nuxeo.com/mailman/listinfo/ecm
To unsubscribe, go to http://lists.nuxeo.com/mailman/options/ecm

[jiveforums-ecm]

Use standard SQL identifiers quoting:
  SELECT * FROM "documentsLists"
--
Posted by "fguillaume" at Nuxeo Discussions <http://nuxeo.org/discussions>
View the complete thread: <http://www.nuxeo.org/discussions/thread.jspa?threadID=2584#7285>
_______________________________________________
ECM mailing list
ECM@...
http://lists.nuxeo.com/mailman/listinfo/ecm
To unsubscribe, go to http://lists.nuxeo.com/mailman/options/ecm

[jiveforums-ecm]

I tried and really it is necessary to use quotes. On the contrary I would top up that it is necessary to add the name of the schema in front of the table as follows

select * from sa."documentsLists";

Thanks a lot.
--
Posted by "laponse" at Nuxeo Discussions <http://nuxeo.org/discussions>
View the complete thread: <http://www.nuxeo.org/discussions/thread.jspa?threadID=2584#7288>
_______________________________________________
ECM mailing list
ECM@...
http://lists.nuxeo.com/mailman/listinfo/ecm
To unsubscribe, go to http://lists.nuxeo.com/mailman/options/ecm