See <https://qa.nuxeo.org/hudson/job/IT-nuxeo-5.3-tests-oracle/136/changes>

Changes:

[Julien Carsique <[email protected]>] NXBT-150 - fix nuxeo.conf path using

[Julien Carsique <[email protected]>] NXBT-150 - update tomcat base directory 
name

[Julien Carsique <[email protected]>] use bash, not sh

[Julien Carsique <[email protected]>] NXBT-150 - forget compliance with 5.2; 
use new 5.3 templates

[Julien Carsique <[email protected]>] NXBT-150 - use unique log directory 
instead of server specific ones (server/default/log/ or logs/)

[Julien Carsique <[email protected]>] NXBT-150 - keep scripts compliance with 
nuxeo 5.2

[Julien Carsique <[email protected]>] NXBT-150 - set execute mode on bin/*.sh 
and bin/*ctl

[Julien Carsique <[email protected]>] update nuxeo.conf

[Julien Carsique <[email protected]>] NXBT-150 - Align scripts on NXP-4953 
changes

------------------------------------------
[...truncated 140 lines...]
DROP TABLE  "THREAD" CASCADE CONSTRAINTS ;
DROP TABLE  "GADGET" CASCADE CONSTRAINTS ;
DROP TABLE  "CONTEXTUALLINK" CASCADE CONSTRAINTS ;
DROP TABLE  "DC_CONTRIBUTORS" CASCADE CONSTRAINTS ;
DROP TABLE  "PROPERTY" CASCADE CONSTRAINTS ;
DROP TABLE  "CONTENT" CASCADE CONSTRAINTS ;
DROP TABLE  "PICTURE" CASCADE CONSTRAINTS ;
DROP TABLE  "MAIL_RECIPIENTS" CASCADE CONSTRAINTS ;
DROP TABLE  "ADVANCED_SEARCH" CASCADE CONSTRAINTS ;
DROP TABLE  "SEARCH_SUBJECTS" CASCADE CONSTRAINTS ;
DROP TABLE  "WEBPAGE" CASCADE CONSTRAINTS ;
DROP TABLE  "LOCKS" CASCADE CONSTRAINTS ;
DROP TABLE  "VIEW" CASCADE CONSTRAINTS ;
DROP TABLE  "COMMENT" CASCADE CONSTRAINTS ;
DROP TABLE  "SEARCH_COVERAGE" CASCADE CONSTRAINTS ;
DROP TABLE  "CONTENT_ROOTS" CASCADE CONSTRAINTS ;
DROP TABLE  "COMMON" CASCADE CONSTRAINTS ;
DROP TABLE  "IMAGE_METADATA" CASCADE CONSTRAINTS ;
DROP TABLE  "PICTUREBOOK" CASCADE CONSTRAINTS ;
DROP TABLE  "BLOG" CASCADE CONSTRAINTS ;
DROP TABLE  "SPACE" CASCADE CONSTRAINTS ;
DROP TABLE  "QUERYNAV" CASCADE CONSTRAINTS ;
DROP TABLE  "PUBLISH_SECTIONS" CASCADE CONSTRAINTS ;
DROP TABLE  "DOMAIN" CASCADE CONSTRAINTS ;
DROP TABLE  "WEBCONTAINER" CASCADE CONSTRAINTS ;
DROP TABLE  "BLOGPOST" CASCADE CONSTRAINTS ;
DROP TABLE  "NOTE" CASCADE CONSTRAINTS ;
DROP TABLE  "FULLTEXT" CASCADE CONSTRAINTS ;
DROP TABLE  "DR$FULLTEXT_FULLTEXT_IDX$I" CASCADE CONSTRAINTS ;
DROP TABLE  "topic" CASCADE CONSTRAINTS ;
DROP TABLE  "subtopic" CASCADE CONSTRAINTS ;
DROP TABLE  "continent" CASCADE CONSTRAINTS ;
DROP TABLE  "country" CASCADE CONSTRAINTS ;
DROP TABLE  "JENA_LONG_LIT" CASCADE CONSTRAINTS ;
DROP TABLE  "JENA_SYS_STMT" CASCADE CONSTRAINTS ;
DROP TABLE  "JENA_LONG_URI" CASCADE CONSTRAINTS ;
DROP TABLE  "JENA_PREFIX" CASCADE CONSTRAINTS ;
DROP TABLE  "JENA_GRAPH" CASCADE CONSTRAINTS ;
DROP TABLE  "JENA_G1T6_REIF" CASCADE CONSTRAINTS ;
DROP TABLE  "JENA_G1T7_STMT" CASCADE CONSTRAINTS ;
DROP TABLE  "JENA_G2T6_REIF" CASCADE CONSTRAINTS ;
DROP TABLE  "JENA_G2T7_STMT" CASCADE CONSTRAINTS ;
DROP TABLE  "JENA_G3T6_REIF" CASCADE CONSTRAINTS ;
DROP TABLE  "JENA_G3T7_STMT" CASCADE CONSTRAINTS ;
DROP TABLE  "DR$FULLTEXT_FULLTEXT_IDX$N" CASCADE CONSTRAINTS ;
DROP TABLE  "DR$FULLTEXT_FULLTEXT_IDX$K" CASCADE CONSTRAINTS ;
  SQL: SQL: SQL:  SELECT 'DROP TABLE  "'|| table_name|| '" CASCADE CONSTRAINTS 
\;' FROM user_tables;
DROP TABLE  "DR$FULLTEXT_FULLTEXT_IDX$R" CASCADE CONSTRAINTS ;
DROP TABLE  "DUBLINCORE" CASCADE CONSTRAINTS ;
DROP TABLE  "MAIL" CASCADE CONSTRAINTS ;
DROP TABLE  "PROTOCOL" CASCADE CONSTRAINTS ;
DROP TABLE  "POST" CASCADE CONSTRAINTS ;
DROP TABLE  "MODERATORS" CASCADE CONSTRAINTS ;
DROP TABLE  "MISC" CASCADE CONSTRAINTS ;
DROP TABLE  "TYPE_TASK" CASCADE CONSTRAINTS ;
DROP TABLE  "VERSIONS" CASCADE CONSTRAINTS ;
DROP TABLE  "IPTC" CASCADE CONSTRAINTS ;
DROP TABLE  "PICTEMPLATE" CASCADE CONSTRAINTS ;
DROP TABLE  "TASKUSERS" CASCADE CONSTRAINTS ;
DROP TABLE  "ACLS" CASCADE CONSTRAINTS ;
DROP TABLE  "PROXIES" CASCADE CONSTRAINTS ;
DROP TABLE  "MAIL_CC_RECIPIENTS" CASCADE CONSTRAINTS ;
DROP TABLE  "NXP_TAGGING" CASCADE CONSTRAINTS ;
DROP TABLE  "users" CASCADE CONSTRAINTS ;
DROP TABLE  "groups" CASCADE CONSTRAINTS ;
DROP TABLE  "user2group" CASCADE CONSTRAINTS ;
DROP TABLE  "group2group" CASCADE CONSTRAINTS ;
DROP TABLE  "documentsLists" CASCADE CONSTRAINTS ;
DROP TABLE  "JENA_G4T6_REIF" CASCADE CONSTRAINTS ;
DROP TABLE  "JENA_G4T7_STMT" CASCADE CONSTRAINTS ;
DROP TABLE  "JENA_G5T6_REIF" CASCADE CONSTRAINTS ;
DROP TABLE  "JENA_G5T7_STMT" CASCADE CONSTRAINTS ;
DROP TABLE  "JENA_G6T6_REIF" CASCADE CONSTRAINTS ;
DROP TABLE  "JENA_G6T7_STMT" CASCADE CONSTRAINTS ;
DROP TABLE  "HIERARCHY" CASCADE CONSTRAINTS ;
DROP TABLE  "REPOSITORIES" CASCADE CONSTRAINTS ;
DROP TABLE  "UID" CASCADE CONSTRAINTS ;
DROP TABLE  "TAG" CASCADE CONSTRAINTS ;
DROP TABLE  "DC_SUBJECTS" CASCADE CONSTRAINTS ;
DROP TABLE  "UNIVERS" CASCADE CONSTRAINTS ;
DROP TABLE  "SEARCH_CURRENTLIFECYCLESTATES" CASCADE CONSTRAINTS ;
DROP TABLE  "FILE" CASCADE CONSTRAINTS ;
DROP TABLE  "THREAD" CASCADE CONSTRAINTS ;
DROP TABLE  "GADGET" CASCADE CONSTRAINTS ;
DROP TABLE  "CONTEXTUALLINK" CASCADE CONSTRAINTS ;
DROP TABLE  "DC_CONTRIBUTORS" CASCADE CONSTRAINTS ;
DROP TABLE  "PROPERTY" CASCADE CONSTRAINTS ;
DROP TABLE  "CONTENT" CASCADE CONSTRAINTS ;
DROP TABLE  "PICTURE" CASCADE CONSTRAINTS ;
DROP TABLE  "MAIL_RECIPIENTS" CASCADE CONSTRAINTS ;
DROP TABLE  "ADVANCED_SEARCH" CASCADE CONSTRAINTS ;
DROP TABLE  "SEARCH_SUBJECTS" CASCADE CONSTRAINTS ;
DROP TABLE  "WEBPAGE" CASCADE CONSTRAINTS ;
DROP TABLE  "LOCKS" CASCADE CONSTRAINTS ;
DROP TABLE  "VIEW" CASCADE CONSTRAINTS ;
DROP TABLE  "COMMENT" CASCADE CONSTRAINTS ;
DROP TABLE  "SEARCH_COVERAGE" CASCADE CONSTRAINTS ;
DROP TABLE  "CONTENT_ROOTS" CASCADE CONSTRAINTS ;
DROP TABLE  "COMMON" CASCADE CONSTRAINTS ;
DROP TABLE  "IMAGE_METADATA" CASCADE CONSTRAINTS ;
DROP TABLE  "PICTUREBOOK" CASCADE CONSTRAINTS ;
DROP TABLE  "BLOG" CASCADE CONSTRAINTS ;
DROP TABLE  "SPACE" CASCADE CONSTRAINTS ;
DROP TABLE  "QUERYNAV" CASCADE CONSTRAINTS ;
DROP TABLE  "PUBLISH_SECTIONS" CASCADE CONSTRAINTS ;
DROP TABLE  "DOMAIN" CASCADE CONSTRAINTS ;
DROP TABLE  "WEBCONTAINER" CASCADE CONSTRAINTS ;
DROP TABLE  "BLOGPOST" CASCADE CONSTRAINTS ;
DROP TABLE  "NOTE" CASCADE CONSTRAINTS ;
DROP TABLE  "FULLTEXT" CASCADE CONSTRAINTS ;
DROP TABLE  "DR$FULLTEXT_FULLTEXT_IDX$I" CASCADE CONSTRAINTS ;
DROP TABLE  "topic" CASCADE CONSTRAINTS ;
DROP TABLE  "subtopic" CASCADE CONSTRAINTS ;
DROP TABLE  "continent" CASCADE CONSTRAINTS ;
DROP TABLE  "country" CASCADE CONSTRAINTS ;
DROP TABLE  "JENA_LONG_LIT" CASCADE CONSTRAINTS ;
DROP TABLE  "JENA_SYS_STMT" CASCADE CONSTRAINTS ;
DROP TABLE  "JENA_LONG_URI" CASCADE CONSTRAINTS ;
DROP TABLE  "JENA_PREFIX" CASCADE CONSTRAINTS ;
DROP TABLE  "JENA_GRAPH" CASCADE CONSTRAINTS ;
DROP TABLE  "JENA_G1T6_REIF" CASCADE CONSTRAINTS ;
DROP TABLE  "JENA_G1T7_STMT" CASCADE CONSTRAINTS ;
DROP TABLE  "JENA_G2T6_REIF" CASCADE CONSTRAINTS ;
DROP TABLE  "JENA_G2T7_STMT" CASCADE CONSTRAINTS ;
DROP TABLE  "JENA_G3T6_REIF" CASCADE CONSTRAINTS ;
DROP TABLE  "JENA_G3T7_STMT" CASCADE CONSTRAINTS ;
DROP TABLE  "DR$FULLTEXT_FULLTEXT_IDX$N" CASCADE CONSTRAINTS ;
DROP TABLE  "DR$FULLTEXT_FULLTEXT_IDX$K" CASCADE CONSTRAINTS ;
SQL: DROP TABLE  "DR$FULLTEXT_FULLTEXT_IDX$R" CASCADE CONSTRAINTS ;
SQL: DROP TABLE  "DUBLINCORE" CASCADE CONSTRAINTS ;
SQL: DROP TABLE  "MAIL" CASCADE CONSTRAINTS ;
SQL: DROP TABLE  "PROTOCOL" CASCADE CONSTRAINTS ;
SQL: DROP TABLE  "POST" CASCADE CONSTRAINTS ;
SQL: DROP TABLE  "MODERATORS" CASCADE CONSTRAINTS ;
SQL: DROP TABLE  "MISC" CASCADE CONSTRAINTS ;
SQL: DROP TABLE  "TYPE_TASK" CASCADE CONSTRAINTS ;
SQL: DROP TABLE  "VERSIONS" CASCADE CONSTRAINTS ;
SQL: DROP TABLE  "IPTC" CASCADE CONSTRAINTS ;
SQL: DROP TABLE  "PICTEMPLATE" CASCADE CONSTRAINTS ;
SQL: DROP TABLE  "TASKUSERS" CASCADE CONSTRAINTS ;
SQL: DROP TABLE  "ACLS" CASCADE CONSTRAINTS ;
SQL: DROP TABLE  "PROXIES" CASCADE CONSTRAINTS ;
SQL: DROP TABLE  "MAIL_CC_RECIPIENTS" CASCADE CONSTRAINTS ;
SQL: DROP TABLE  "NXP_TAGGING" CASCADE CONSTRAINTS ;
SQL: DROP TABLE  "users" CASCADE CONSTRAINTS ;
SQL: DROP TABLE  "groups" CASCADE CONSTRAINTS ;
SQL: DROP TABLE  "user2group" CASCADE CONSTRAINTS ;
SQL: DROP TABLE  "group2group" CASCADE CONSTRAINTS ;
SQL: DROP TABLE  "documentsLists" CASCADE CONSTRAINTS ;
SQL: DROP TABLE  "JENA_G4T6_REIF" CASCADE CONSTRAINTS ;
SQL: DROP TABLE  "JENA_G4T7_STMT" CASCADE CONSTRAINTS ;
SQL: DROP TABLE  "JENA_G5T6_REIF" CASCADE CONSTRAINTS ;
SQL: DROP TABLE  "JENA_G5T7_STMT" CASCADE CONSTRAINTS ;
SQL: DROP TABLE  "JENA_G6T6_REIF" CASCADE CONSTRAINTS ;
SQL: DROP TABLE  "JENA_G6T7_STMT" CASCADE CONSTRAINTS ;
SQL: DROP TABLE  "HIERARCHY" CASCADE CONSTRAINTS ;
SQL: DROP TABLE  "REPOSITORIES" CASCADE CONSTRAINTS ;
SQL: DROP TABLE  "UID" CASCADE CONSTRAINTS ;
SQL: DROP TABLE  "TAG" CASCADE CONSTRAINTS ;
SQL: DROP TABLE  "DC_SUBJECTS" CASCADE CONSTRAINTS ;
SQL: DROP TABLE  "UNIVERS" CASCADE CONSTRAINTS ;
SQL: DROP TABLE  "SEARCH_CURRENTLIFECYCLESTATES" CASCADE CONSTRAINTS ;
SQL: DROP TABLE  "FILE" CASCADE CONSTRAINTS ;
SQL: DROP TABLE  "THREAD" CASCADE CONSTRAINTS ;
SQL: DROP TABLE  "GADGET" CASCADE CONSTRAINTS ;
SQL: DROP TABLE  "CONTEXTUALLINK" CASCADE CONSTRAINTS ;
SQL: DROP TABLE  "DC_CONTRIBUTORS" CASCADE CONSTRAINTS ;
SQL: DROP TABLE  "PROPERTY" CASCADE CONSTRAINTS ;
SQL: DROP TABLE  "CONTENT" CASCADE CONSTRAINTS ;
SQL: DROP TABLE  "PICTURE" CASCADE CONSTRAINTS ;
SQL: DROP TABLE  "MAIL_RECIPIENTS" CASCADE CONSTRAINTS ;
SQL: DROP TABLE  "ADVANCED_SEARCH" CASCADE CONSTRAINTS ;
SQL: DROP TABLE  "SEARCH_SUBJECTS" CASCADE CONSTRAINTS ;
SQL: DROP TABLE  "WEBPAGE" CASCADE CONSTRAINTS ;
SQL: DROP TABLE  "LOCKS" CASCADE CONSTRAINTS ;
SQL: DROP TABLE  "VIEW" CASCADE CONSTRAINTS ;
SQL: DROP TABLE  "COMMENT" CASCADE CONSTRAINTS ;
SQL: DROP TABLE  "SEARCH_COVERAGE" CASCADE CONSTRAINTS ;
SQL: DROP TABLE  "CONTENT_ROOTS" CASCADE CONSTRAINTS ;
SQL: DROP TABLE  "COMMON" CASCADE CONSTRAINTS ;
SQL: DROP TABLE  "IMAGE_METADATA" CASCADE CONSTRAINTS ;
SQL: DROP TABLE  "PICTUREBOOK" CASCADE CONSTRAINTS ;
SQL: DROP TABLE  "BLOG" CASCADE CONSTRAINTS ;
SQL: DROP TABLE  "SPACE" CASCADE CONSTRAINTS ;
SQL: DROP TABLE  "QUERYNAV" CASCADE CONSTRAINTS ;
SQL: DROP TABLE  "PUBLISH_SECTIONS" CASCADE CONSTRAINTS ;
SQL: DROP TABLE  "DOMAIN" CASCADE CONSTRAINTS ;
SQL: DROP TABLE  "WEBCONTAINER" CASCADE CONSTRAINTS ;
SQL: DROP TABLE  "BLOGPOST" CASCADE CONSTRAINTS ;
SQL: DROP TABLE  "NOTE" CASCADE CONSTRAINTS ;
SQL: DROP TABLE  "FULLTEXT" CASCADE CONSTRAINTS ;
SQL: DROP TABLE  "DR$FULLTEXT_FULLTEXT_IDX$I" CASCADE CONSTRAINTS ;
DROP TABLE  "DR$FULLTEXT_FULLTEXT_IDX$I" CASCADE CONSTRAINTS
            *
ERROR at line 1:
ORA-00942: table or view does not exist


SQL: DROP TABLE  "topic" CASCADE CONSTRAINTS ;
SQL: DROP TABLE  "subtopic" CASCADE CONSTRAINTS ;
SQL: DROP TABLE  "continent" CASCADE CONSTRAINTS ;
SQL: DROP TABLE  "country" CASCADE CONSTRAINTS ;
SQL: DROP TABLE  "JENA_LONG_LIT" CASCADE CONSTRAINTS ;
SQL: DROP TABLE  "JENA_SYS_STMT" CASCADE CONSTRAINTS ;
SQL: DROP TABLE  "JENA_LONG_URI" CASCADE CONSTRAINTS ;
SQL: DROP TABLE  "JENA_PREFIX" CASCADE CONSTRAINTS ;
SQL: DROP TABLE  "JENA_GRAPH" CASCADE CONSTRAINTS ;
SQL: DROP TABLE  "JENA_G1T6_REIF" CASCADE CONSTRAINTS ;
SQL: DROP TABLE  "JENA_G1T7_STMT" CASCADE CONSTRAINTS ;
SQL: DROP TABLE  "JENA_G2T6_REIF" CASCADE CONSTRAINTS ;
SQL: DROP TABLE  "JENA_G2T7_STMT" CASCADE CONSTRAINTS ;
SQL: DROP TABLE  "JENA_G3T6_REIF" CASCADE CONSTRAINTS ;
SQL: DROP TABLE  "JENA_G3T7_STMT" CASCADE CONSTRAINTS ;
SQL: DROP TABLE  "DR$FULLTEXT_FULLTEXT_IDX$N" CASCADE CONSTRAINTS ;
DROP TABLE  "DR$FULLTEXT_FULLTEXT_IDX$N" CASCADE CONSTRAINTS
            *
ERROR at line 1:
ORA-00942: table or view does not exist


SQL: DROP TABLE  "DR$FULLTEXT_FULLTEXT_IDX$K" CASCADE CONSTRAINTS ;
DROP TABLE  "DR$FULLTEXT_FULLTEXT_IDX$K" CASCADE CONSTRAINTS
            *
ERROR at line 1:
ORA-00942: table or view does not exist


SQL:  SPOOL OFF
not spooling currently
SQL: Disconnected from Oracle Database 10g Enterprise Edition Release 
10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
+ scp ora...@blackrock:/opt/oracle/10g/jdbc/lib/ojdbc14.jar 
<https://qa.nuxeo.org/hudson/job/IT-nuxeo-5.3-tests-oracle/ws/trunk/jboss/server/default/lib/>
+ cat
<https://qa.nuxeo.org/hudson/job/IT-nuxeo-5.3-tests-oracle/ws/trunk/integration-lib.sh>:
 line 291: <?xml version="1.0" encoding="UTF-8"?>
<datasources>
   <xa-datasource>
     <jndi-name>NuxeoDS</jndi-name>
     <track-connection-by-tx/>
     <no-tx-separate-pools/>
     <isSameRM-override-value>false</isSameRM-override-value>
     
<xa-datasource-class>oracle.jdbc.xa.client.OracleXADataSource</xa-datasource-class>
     <xa-datasource-property 
name="URL">jdbc:oracle:thin:@${nuxeo.db.host}:${nuxeo.db.port}:${nuxeo.db.name}</xa-datasource-property>
     <xa-datasource-property 
name="User">${nuxeo.db.user}</xa-datasource-property>
     <xa-datasource-property 
name="Password">${nuxeo.db.password}</xa-datasource-property>
   </xa-datasource>
</datasources>
: bad substitution
+ exit 1
Archiving artifacts

_______________________________________________
ECM-QA mailing list
[email protected]
http://lists.nuxeo.com/mailman/listinfo/ecm-qa

Reply via email to