0027378: Openbravo detects that there are database changes when it should not due to session configuration in ORACLE

Anonymous | Login

Project:

News | My View | View Issues | Roadmap | Summary

View Revisions: Issue #27378		[ All Revisions ] [ Back to Issue ]
Summary	0027378: Openbravo detects that there are database changes when it should not due to session configuration in ORACLE

Revision	2014-08-19 20:42 by jecharri
Steps To Reproduce	-execute function select ad_db_modified('N') from dual; in database --> you will receive N -login as system in the ERP and execute the same function --> you will receive 'Y' It seems that problem is the database configuration and line bbdd.sessionConfig=alter session set NLS_DATE_FORMAT='DD-MM-YYYY' NLS_SORT='BINARY' NLS_NUMERIC_CHARACTERS='.,' <- client configuration in file Openbravo.properties. If you execute statement alter session set NLS_DATE_FORMAT='DD-MM-YYYY' NLS_SORT='BINARY' NLS_NUMERIC_CHARACTERS='.,' in database, you will receive also a 'Y' value when you execute function "ad_db_modified".

Revision	2014-08-19 20:41 by jecharri
Steps To Reproduce	-execute function select ad_db_modified('N') from dual; in database --> you will receive N -login as system in the ERP and execute the same function --> you will receive 'Y' It seems that problem is the database configuration and line bbdd.sessionConfig=alter session set NLS_DATE_FORMAT='DD-MM-YYYY' NLS_SORT='BINARY' NLS_NUMERIC_CHARACTERS='.,' <- client configuration in file Openbravo.properties. If you execute statement alter session set NLS_DATE_FORMAT='DD-MM-YYYY' NLS_SORT='BINARY' NLS_NUMERIC_CHARACTERSS='.,'; in database, you will receive also a 'Y' value when you execute function "ad_db_modified".

Revision	2014-08-19 20:40 by jecharri
Steps To Reproduce	-execute function select ad_db_modified('N') from dual; in database --> you will receive N -login as system in the ERP and execute the same function --> you will receive 'Y' It seems that problem is the database configuration and line bbdd.sessionConfig=alter session set NLS_DATE_FORMAT='DD-MM-YYYY' NLS_SORT='BINARY' NLS_NUMERIC_CHARACTERSS='.,'; <- client configuration in file Openbravo.properties. If you execute statement alter session set NLS_DATE_FORMAT='DD-MM-YYYY' NLS_SORT='BINARY' NLS_NUMERIC_CHARACTERSS='.,'; in database, you will receive also a 'Y' value when you execute function "ad_db_modified".