Project:
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". |
Copyright © 2000 - 2009 MantisBT Group |