POOL DE CONEXIONES

El pool de conexiones de Acceso Cabal, está basado en el driver de Tomcat.

Ejemplo de configuración:

<GlobalNamingResources>
         <Resource 
           name="jdbc/commercePortalDB"
           auth="Container"
           factory="oracle.ucp.jdbc.PoolDataSourceImpl"
           type="oracle.ucp.jdbc.PoolDataSource"
           description="Commerce portal data source"
           connectionFactoryClassName="oracle.jdbc.pool.OracleDataSource"
           initialPoolSize="2"
           minPoolSize="2"
           maxPoolSize="4"
           inactiveConnectionTimeout="5"
           user="portal"
           password="portal"
           url="jdbc:oracle:thin:@10.5.2.16:1521:BAPY"
           connectionPoolName="ComercePortalPol"
           validateConnectionOnBorrow="true"
           sqlForValidateConnection="select 1 from DUAL" />

       </GlobalNamingResources>
<Context>
        <ResourceLink name="jdbc/commercePortalDB" global="jdbc/commercePortalDB" type="javax.sql.DataSource" />
      </Context>

 Links importantes:

http://redmine.cabal.coop.py/projects/dpto-informaticb/wiki/Pool_de_conexiones 


Configuración de NLS

http://clemente.pamplona.name/dba/tag/nls_lang/
http://orabliss.blogspot.com/2014/06/setting-nlsenv-for-dbmsjobs_82.html
http://www.thatjeffsmith.com/archive/2014/09/30-sql-developer-tips-in-30-days-day-2-nls-parameters/
https://docs.oracle.com/database/121/REFRN/GUID-04243CDA-43CA-4AF8-B59D-6FB841B307BE.htm#REFRN10127
https://docs.oracle.com/cd/B28359_01/server.111/b28298/ch3globenv.htm

Setting Up a Globalization Support Environment
(https://docs.oracle.com/cd/B28359_01/server.111/b28298/ch3globenv.htm#i1006280)

Conversión de LANG a LANGUAGE. Tabla completa
https://community.oracle.com/thread/327124?start=0&tstart=0
https://docs.oracle.com/cd/E11882_01/server.112/e10729/applocaledata.htm#NLSPG581

Configure lang and region Tomcat
http://knowm.org/set-tomcats-default-locale/

USERENV
https://docs.oracle.com/cd/B12037_01/server.101/b10759/functions193.htm

Funciones que utilizan los parámetros NLS
https://books.google.com.py/books?id=dGm6ppeU1-oC&lpg=PT162&ots=Q2kFCn7KQo&dq=funciones%20que%20dependen%20de%20NLS%20oracle&hl=es&pg=PT162#v=onepage&q&f=true
TO_CHAR, TO_DATE, TO_NUMBER, NLS_UPPER, NLS_LOWER, NLS_INITCAP, NLSSORT

Configurar NLS en Windows
Configurar NLS en Windows

Configurar NLS en linux
http://www.ibm.com/support/knowledgecenter/SS4QMC_9.3.0/com.ibm.help.sbi.implement.doc/c_nls_lang_oracle_database.html?lang=es

Ejemplo de distintas configuraciones. Se consideró como correcta, la del servidor de aplicaciones (COBOL)

//WS
PORTAL_COMERCIO PR_AUTHLOGIN 23983755 LANGUAGE: LATIN AMERICAN SPANISH_AMERICA.WE8ISO8859P1 05/17/2016 15:45:42

//Servidor de aplicaciones (COBOL)
PORTAL_COMERCIO PR_AUTHLOGIN 23983761 LANGUAGE: AMERICAN_AMERICA.WE8ISO8859P1 05/17/2016 16:06:26

OBSERVACIONES

En CABALPY la configuración por defecto del NLS es la sgte: (Utilizados mayormente por los JOBs durante la generación automática)

ALTER SESSION SET NLS_LANGUAGE = 'SPANISH';
ALTER SESSION SET NLS_TERRITORY='SPAIN' ;
ALTER SESSION SET NLS_CURRENCY='¿';
ALTER SESSION SET NLS_ISO_CURRENCY='SPAIN';
ALTER SESSION SET NLS_NUMERIC_CHARACTERS=',.';
ALTER SESSION SET NLS_DATE_FORMAT='DD/MM/RR';
ALTER SESSION SET NLS_DATE_LANGUAGE='SPANISH';
ALTER SESSION SET NLS_SORT='SPANISH';

-- Para realizar el seteo del NLS como parte de la codificacion de un PROCEDIMIENTO ALMACENADO O FUNCION
begin
  dbms_session.set_nls('NLS_LANGUAGE',            chr(39) || 'SPANISH'    || chr(39));
  dbms_session.set_nls('NLS_TERRITORY',           chr(39) || 'SPAIN'      || chr(39));
  dbms_session.set_nls('NLS_CURRENCY',            chr(39) || '¿'          || chr(39));
  dbms_session.set_nls('NLS_ISO_CURRENCY',        chr(39) || 'SPAIN'      || chr(39));
  dbms_session.set_nls('NLS_NUMERIC_CHARACTERS',  chr(39) || ',.'         || chr(39));
  dbms_session.set_nls('NLS_DATE_FORMAT',         chr(39) || 'DD/MM/RR'   || chr(39));
  dbms_session.set_nls('NLS_DATE_LANGUAGE',       chr(39) || 'SPANISH'    || chr(39));
  dbms_session.set_nls('NLS_SORT',                chr(39) || 'SPANISH'    || chr(39));
end;