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 [email protected] http://lists.nuxeo.com/mailman/listinfo/ecm To unsubscribe, go to http://lists.nuxeo.com/mailman/options/ecm
