Hi Augusto,
Your merge of DS Based Tables has caused this failure. Could you take a
look please?
Regards,
PL
On Mon, May 13, 2013 at 11:53 AM, <[email protected]> wrote:
> int-inc-oracle - Build # 5973 - Failure:
>
> Check console output at
> http://builds.openbravo.com/job/int-inc-oracle/5973/ to view the results.
>
>
> Committers since last success:
>
> Changes for Build #5973
>
> Augusto Mauch <[email protected]>
> [DS Based Tables] Merge with pi
>
> Augusto Mauch <[email protected]>
> [DS Based Tables] Fixed AD_TABLE_TRG trigger to support Oracle
> src-db/database/model/triggers/AD_TABLE_TRG.xml
>
> Augusto Mauch <[email protected]>
> [DS Based Tables] Fixes database inconsistency
> src-db/database/sourcedata/OBUISEL_SELECTOR_FIELD.xml
>
> Augusto Mauch <[email protected]>
> [DS Based Tables] Merge with pi
>
> Augusto Mauch <[email protected]>
> [DS Based Tables] Updates the Copyright date of files modified in this
> project
>
> modules/org.openbravo.client.application/src/org/openbravo/client/application/ApplicationConstants.java
>
> modules/org.openbravo.client.application/src/org/openbravo/client/application/templates/ob-pick-and-execute-grid.js.ftl
>
> modules/org.openbravo.client.application/src/org/openbravo/client/application/templates/ob-view-tab.js.ftl
>
> modules/org.openbravo.client.application/src/org/openbravo/client/application/window/FormInitializationComponent.java
>
> modules/org.openbravo.client.application/src/org/openbravo/client/application/window/OBViewGridComponent.java
>
> modules/org.openbravo.client.kernel/src/org/openbravo/client/kernel/KernelUtils.java
>
> modules/org.openbravo.client.kernel/src/org/openbravo/client/kernel/reference/UIDefinitionController.java
>
> modules/org.openbravo.client.kernel/src/org/openbravo/client/kernel/templates/application-js.ftl
>
> modules/org.openbravo.service.datasource/src/org/openbravo/service/datasource/DataSourceServiceProvider.java
> src-db/database/model/triggers/AD_TABLE_TRG.xml
> src/org/openbravo/base/gen/GenerateEntitiesTask.java
> src/org/openbravo/base/model/Entity.java
> src/org/openbravo/base/model/ModelProvider.java
> src/org/openbravo/base/model/Table.hbm.xml
> src/org/openbravo/base/model/Table.java
> src/org/openbravo/dal/core/DalMappingGenerator.java
> src/org/openbravo/dal/core/DalUtil.java
> src/org/openbravo/service/system/DatabaseValidator.java
>
> Augusto Mauch <[email protected]>
> [DS Based Tables] Updated trigger to use name column as table name
> src-db/database/model/triggers/AD_TABLE_TRG.xml
>
> Augusto Mauch <[email protected]>
> [DS Based Tables] Support for SQL filter clause and SQL order by clause
>
> modules/org.openbravo.client.application/src/org/openbravo/client/application/templates/ob-pick-and-execute-grid.js.ftl
>
> modules/org.openbravo.client.application/src/org/openbravo/client/application/window/OBViewGridComponent.java
>
> modules/org.openbravo.client.application/web/org.openbravo.client.application/js/grid/ob-grid.js
>
> modules/org.openbravo.client.application/web/org.openbravo.client.application/js/process/ob-pick-and-execute-grid.js
>
> modules/org.openbravo.client.kernel/src/org/openbravo/client/kernel/templates/application-js.ftl
>
> Augusto Mauch <[email protected]>
> [DS Based Tables] Set the entity of the datasource
>
> modules/org.openbravo.service.datasource/src/org/openbravo/service/datasource/DataSourceServiceProvider.java
>
> Augusto Mauch <[email protected]>
> [DS Based Tables] In P&E grids, do not send all rows unless they are
> cached
>
> modules/org.openbravo.client.application/web/org.openbravo.client.application/js/process/ob-parameter-window-view.js
>
> Augusto Mauch <[email protected]>
> [DS Based Tables] Uses String constants for "Datasource" and "Table"
> src/org/openbravo/base/model/Entity.java
> src/org/openbravo/base/model/ModelProvider.java
>
> Augusto Mauch <[email protected]>
> [DS Based Tables] Use constants for "Datasource" and "Table" data
> origin
>
> modules/org.openbravo.client.application/src/org/openbravo/client/application/ApplicationConstants.java
>
> modules/org.openbravo.client.application/src/org/openbravo/client/application/event/TableDataOriginEventHandler.java
>
> modules/org.openbravo.client.application/src/org/openbravo/client/application/window/FormInitializationComponent.java
>
> modules/org.openbravo.client.application/src/org/openbravo/client/application/window/OBViewTab.java
>
> modules/org.openbravo.client.kernel/src/org/openbravo/client/kernel/KernelUtils.java
>
> modules/org.openbravo.service.datasource/src/org/openbravo/service/datasource/DataSourceServiceProvider.java
>
> modules/org.openbravo.userinterface.selector/src/org/openbravo/userinterface/selector/reference/FKSelectorUIDefinition.java
> src/org/openbravo/base/model/Entity.java
> src/org/openbravo/base/model/ModelProvider.java
> src/org/openbravo/service/system/DatabaseValidator.java
>
> Augusto Mauch <[email protected]>
> [DS Based Tables] Prevents NPE if datasource table does not have id
> column
>
> modules/org.openbravo.client.application/web/org.openbravo.client.application/js/main/ob-standard-view.js
>
> Augusto Mauch <[email protected]>
> [DS Based tables] Retrieves entity differently depending on table data
> origin
>
> In the KernelUtils class, entity for table based tables are retrieved
> using entity =
> ModelProvider.getInstance().getEntityByTableName(tab.getTable().getDBTableName());
> Entities for datasource based tables are retrieved using entity =
> ModelProvider.getInstance().getEntityByTableId(tab.getTable().getId());
>
> modules/org.openbravo.client.kernel/src/org/openbravo/client/kernel/KernelUtils.java
>
> Augusto Mauch <[email protected]>
> [DS Based Tables] Adapts UIDefinitions to support datasource based
> tables
>
> - UIDefinitionController: Computes the UIDefinitions of columns of both
> table based tables and dasource based tables
> - FKSelectorUIDefinition: Retrieve the properties differently depending on
> the data origin of the table:
> * Table based table -> property = DalUtil.getProperty(tableName,
> columnName);
> * Datasource based table -> property =
> DalUtil.getPropertyByTableId(tableId, columnName);
>
> modules/org.openbravo.client.kernel/src/org/openbravo/client/kernel/reference/UIDefinitionController.java
>
> modules/org.openbravo.userinterface.selector/src/org/openbravo/userinterface/selector/reference/FKSelectorUIDefinition.java
>
> Augusto Mauch <[email protected]>
> [DS Based Tables] Added isDataSourceBased attribute to Entity class
>
> This attribute will be true is the table associated with the entity is
> based on a datasource. This attribute will be used in the ModelProvider,
> DalMappingGenerator and GenerateEntitiesTask classes.
> src/org/openbravo/base/model/Entity.java
>
> Augusto Mauch <[email protected]>
> [DS Based Tables] Updated ModelProvider to support datasource based
> tables
>
> Several changes have been done to the ModelProvider class to support
> datasource based tables:
> - Table based tables are stored in the already existing tablesByTableName
> attribute, while datasource based tables are stored in the new attribute
> dataSourcesTablesByName.
> - Don't check if mandatory columns in the database are defined as
> mandatory in the application dictionary for the columns of datasource based
> tables.
> - The method createPropertyInParentEntity does not have to be called with
> datasource based entities. This method is in charge of creating properties
> in the referenced entities.
> - Do not check missing primary key columns for datasource based tables
> src/org/openbravo/base/model/ModelProvider.java
>
> Augusto Mauch <[email protected]>
> [DS Based Tables] Avoid mapping in hibernate datasource based tables
> src/org/openbravo/dal/core/DalMappingGenerator.java
>
> Augusto Mauch <[email protected]>
> [DS Based Tables] Adds getPropertyByTableId method to the DalUtil class
>
> Datasource based tables does not necessaraly have a database table name,
> because it does not need a table in the database. DalUtil provides a method
> to retrieve a property based on a table name and a column name, so it could
> not be used for datasource based tables. A new method has been created that
> uses the table id instead of the table name to retrieve the property.
> src/org/openbravo/dal/core/DalUtil.java
>
> Augusto Mauch <[email protected]>
> [DS Based Tables] Added dataOrigin property to Table hibernate mapping
>
> The dataOrigin property has been added to the Table hibernate mapping so
> that it can be used in the ModelProvider class.
> src/org/openbravo/base/model/Table.hbm.xml
> src/org/openbravo/base/model/Table.java
>
> Augusto Mauch <[email protected]>
> [DS Based Tables] Java files are not generated for datasource based
> tables
> src/org/openbravo/base/gen/GenerateEntitiesTask.java
>
> Augusto Mauch <[email protected]>
> [DS Based Tables] Fixes mistake in AD_TABLE_TRG trigger
>
> The reference to the record being created was not proper, 'new' was being
> used instead of ':new'
> src-db/database/model/triggers/AD_TABLE_TRG.xml
>
> Augusto Mauch <[email protected]>
> [DS Based Tables] DataSourceServiceProvider return the proper
> datasource
>
> The getDataSource method of the DataSourceServiceProvider class return a
> datasource (instance of DataSourceService) based on a name. The logic of
> the method used to be like this:
> 1 - Check if a datasource has been saved with that name in the list of
> chached datasource. If it has, returns it.
> 2 - If not, check if there is a datasource with dataSourceId = provided
> name. If it exists, returns it.
> 3 - If not, returns an instance of the DefaultDataSourceService class
>
> This logic has been changed to take into account the datasource based
> tables. Now there is a new check between points 2 and 3:
> 2.5 - Check if it exists a table with tableId = provided name. If it
> exists and it is a datasource based table, return its associated datasource.
>
> modules/org.openbravo.service.datasource/src/org/openbravo/service/datasource/DataSourceServiceProvider.java
>
> Augusto Mauch <[email protected]>
> [DS Based Tables] OBViewTab returns the proper dataSourceId
>
> The getDataSourceId method of OBViewTab used to return always the name of
> the table. This has been changed, and not if the table is based on a
> datasource it will return its associated datasource id.
>
> A new method, public boolean isDataSourceTable(), has been defined to be
> used in ob-view-tab.js.ftl.
>
> modules/org.openbravo.client.application/src/org/openbravo/client/application/window/OBViewTab.java
>
> Augusto Mauch <[email protected]>
> [DS Based Tables] Updates the FIC to support datasource based tables
>
> The FormInitializationComponent has been changed to support datasource
> based tables:
> - The datasource based tables are not associated to BaseOBObjects, so the
> attribute BaseOBObject row will not be used.
> - Datasource based tables do not define tables in the database, so the FIC
> does not have to try to initialize the row values using the database.
>
> modules/org.openbravo.client.application/src/org/openbravo/client/application/window/FormInitializationComponent.java
>
> Augusto Mauch <[email protected]>
> [DS Based Tables] Updates ftls to support datasource based tables
>
> Two ftls, ob-pick-and-execute-view-tab.js.ftl and ob-view-tab.js.ftl,
> have been updated to support datasource based tables. Now, the fields
> related to the key property of the tab (only available in table based
> tables) will not be fetched if the tab is associated with a datasource
> based table.
>
> modules/org.openbravo.client.application/src/org/openbravo/client/application/templates/ob-pick-and-execute-view-tab.js.ftl
>
> modules/org.openbravo.client.application/src/org/openbravo/client/application/templates/ob-view-tab.js.ftl
>
> Augusto Mauch <[email protected]>
> [DS Based Tables] Applies the new TableBasedTable selector in two
> columns
>
> The new selector, which allows to select only table based tables, has been
> been applied in the following columns:
> - obuisel_selector.ad_table_id
> - ad_ref_table.ad_table_id
>
> This way, it will not be possible to create a reference based on a
> datasource based table.
>
> modules/org.openbravo.userinterface.selector/src-db/database/sourcedata/AD_COLUMN.xml
> src-db/database/sourcedata/AD_COLUMN.xml
>
> Augusto Mauch <[email protected]>
> [DS Based Tables] New selector for Table Based Tables
>
> A new Table reference has been created to select only Table based Tables.
> This selector should be used in those columns that reference AD_TABLE in
> which the datasource based tables can not be applied.
> src-db/database/sourcedata/AD_REFERENCE.xml
> src-db/database/sourcedata/AD_REF_TABLE.xml
>
> Augusto Mauch <[email protected]>
> [DS Based Tables] Do not validate datasource based tables
>
> In the DatabaseValidator class some table validations are done (primary
> keys, model object names, presence of table in the database, etc). There is
> no need to do this validations for Da
> tasource based tables.
> src/org/openbravo/service/system/DatabaseValidator.java
>
> Augusto Mauch <[email protected]>
> [DB Based Tables] Updates AD_TABLE_TRG trigger to support datasource
> tables.
>
> There is a validation in the AD_TABLE_TRG trigger that checks that the
> table name starts with the module's DBprefix. This check should not be done
> if the table is based in a datasource.
> src-db/database/model/triggers/AD_TABLE_TRG.xml
>
> Augusto Mauch <[email protected]>
> [DS Based Tables] Added flag to tell a datasource is used as table
> data origin
>
> A new boolean column has been added to the OBSERDS_DATASOURCE table. This
> flag indicates whether this datasource is used as a data origin in the
> definition of a Table. Only datasources with this flag checked will be
> shown in the new Datasource selector used in the Datasource column of the
> Table table.
>
> If a datasource has this new flaw checked, the subtab Datasource Fields
> will not be shown. This tab is hidden to avoid confusion, because the
> columns returned by the datasource that is used as a data origin are
> defined in the Columns tab of the Tables and Columns window.
>
> modules/org.openbravo.client.application/src-db/database/sourcedata/OBSERDS_DATASOURCE.xml
>
> modules/org.openbravo.client.querylist/src-db/database/sourcedata/OBSERDS_DATASOURCE.xml
>
> modules/org.openbravo.service.datasource/src-db/database/model/tables/OBSERDS_DATASOURCE.xml
>
> modules/org.openbravo.service.datasource/src-db/database/sourcedata/AD_COLUMN.xml
>
> modules/org.openbravo.service.datasource/src-db/database/sourcedata/AD_ELEMENT.xml
>
> modules/org.openbravo.service.datasource/src-db/database/sourcedata/AD_FIELD.xml
>
> modules/org.openbravo.service.datasource/src-db/database/sourcedata/AD_TAB.xml
>
> modules/org.openbravo.userinterface.selector/src-db/database/sourcedata/OBSERDS_DATASOURCE.xml
> src-db/database/sourcedata/AD_COLUMN.xml
> src-db/database/sourcedata/AD_ELEMENT.xml
> src-db/database/sourcedata/AD_FIELD.xml
> src-db/database/sourcedata/AD_REFERENCE.xml
> src-db/database/sourcedata/OBUISEL_SELECTOR.xml
> src-db/database/sourcedata/OBUISEL_SELECTOR_FIELD.xml
>
> Augusto Mauch <[email protected]>
> [DS Based Tables] Added event handler con control handling of new
> fields
>
> An event handler has been added to control that:
> - If the data origin is 'Table', the Table Name and Java Class Name fields
> are entered
> - If the data origin is 'Datasource', the Datasource field is entered
>
> modules/org.openbravo.client.application/src/org/openbravo/client/application/event/TableDataOriginEventHandler.java
> src-db/database/sourcedata/AD_MESSAGE.xml
>
> Augusto Mauch <[email protected]>
> [DS based Tables] Added new fields to AD_TABLE
>
> The following fields have been added to AD_TABLE:
> - Data origin: Combo to select the data origin of the table {Table |
> Datasource}
> - Datasource: The datasource that will be used to feed the table.
>
> Additionally, the table_name and java_class columns are now not mandatory,
> and are only shown if the Table option is selected in the Data origin combo.
>
> modules/org.openbravo.advpaymentmngt/src-db/database/sourcedata/AD_TABLE.xml
>
> modules/org.openbravo.client.application/src-db/database/sourcedata/AD_TABLE.xml
>
> modules/org.openbravo.client.kernel/src-db/database/sourcedata/AD_TABLE.xml
>
> modules/org.openbravo.client.myob/src-db/database/sourcedata/AD_TABLE.xml
>
> modules/org.openbravo.client.querylist/src-db/database/sourcedata/AD_TABLE.xml
>
> modules/org.openbravo.service.datasource/src-db/database/sourcedata/AD_TABLE.xml
>
> modules/org.openbravo.service.integration.google/src-db/database/sourcedata/AD_TABLE.xml
>
> modules/org.openbravo.service.integration.openid/src-db/database/sourcedata/AD_TABLE.xml
>
> modules/org.openbravo.userinterface.selector/src-db/database/sourcedata/AD_TABLE.xml
> src-db/database/model/tables/AD_TABLE.xml
> src-db/database/sourcedata/AD_COLUMN.xml
> src-db/database/sourcedata/AD_ELEMENT.xml
> src-db/database/sourcedata/AD_FIELD.xml
> src-db/database/sourcedata/AD_REFERENCE.xml
> src-db/database/sourcedata/AD_REF_LIST.xml
> src-db/database/sourcedata/AD_TABLE.xml
>
>
>
>
> Last 20 lines of the console output:
>
> [...truncated 278 lines...]
> [java] at
> oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3576)
> [java] at
> oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3657)
> [java] at
> oracle.jdbc.driver.OraclePreparedStatementWrapper.executeUpdate(OraclePreparedStatementWrapper.java:1350)
> [java] at
> org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
> [java] at
> org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
> [java] at
> org.apache.ddlutils.platform.oracle.Oracle8Platform.enableAllFK(Oracle8Platform.java:179)
> [java] ... 3 more
>
> BUILD FAILED
> /srv/hudson/workspace/int-inc-oracle/build.xml:384: The following error
> occurred while executing this line:
> /srv/hudson/workspace/int-inc-oracle/build.xml:417: The following error
> occurred while executing this line:
> /srv/hudson/workspace/int-inc-oracle/build.xml:734: The following error
> occurred while executing this line:
> /srv/hudson/workspace/int-inc-oracle/src-db/database/build.xml:80: Java
> returned: 1
>
> Total time: 3 minutes 19 seconds
> Build step 'Invoke Ant' marked build as failure
> Checking WARN|ERROR|SQL Command failed with:
> Email was triggered for: Failure
> Sending email for trigger: Failure
>
>
> ------------------------------------------------------------------------------
> Learn Graph Databases - Download FREE O'Reilly Book
> "Graph Databases" is the definitive new guide to graph databases and
> their applications. This 200-page book is written by three acclaimed
> leaders in the field. The early access version is available now.
> Download your free book today! http://p.sf.net/sfu/neotech_d2d_may
> _______________________________________________
> Openbravo-builds mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/openbravo-builds
>
>
------------------------------------------------------------------------------
Learn Graph Databases - Download FREE O'Reilly Book
"Graph Databases" is the definitive new guide to graph databases and
their applications. This 200-page book is written by three acclaimed
leaders in the field. The early access version is available now.
Download your free book today! http://p.sf.net/sfu/neotech_d2d_may
_______________________________________________
Openbravo-builds mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/openbravo-builds
