Set NLS_DATE_FORMAT in adapter

, ,
1

We are strarting using Oracle.

I want to set a specific NLS_DATE_FORMAT to use in Oracle JDBC adapter inside Integration Server.

Reading driver information I verified that even if the driver is thin or OCI it will generate different nls_session_parameters and I am not able to change this.

I have tried doing “ALTER SESSION SET NLS_DATE_FORMAT=‘YYYY-MM-DD HH24:MI:SS’” and everything worked ok. But I need to find another solution that guarantees working with “Connection Pooling” inside Integration Server.

I tried to set Environment Variables in Windows but without Sucess.

Any suggestions ?

João Caseiro

2

I’ve found it easiest to not try to interact with Oracle date columns using strings. Instead, I use java.util.Date objects both for read and write. Then I have helper services to format to strings when needed when mapping to/from target/source systems. Perhaps such an approach would be appropriate for your environment?