I hate this problem... please help!
I have:
GlassFish v3 (build 74.2)
Windows 7 Pro english
Oracle XE 10.2.0
settings:
SQL> select * from nls_database_parameters;
PARAMETER VALUE
------------------------------ ----------------------------------------
NLS_LANGUAGE AMERICAN
NLS_TERRITORY AMERICA
NLS_CURRENCY $
NLS_ISO_CURRENCY AMERICA
NLS_NUMERIC_CHARACTERS .,
NLS_CHARACTERSET WE8MSWIN1252
NLS_CALENDAR GREGORIAN
NLS_DATE_FORMAT DD-MON-RR
NLS_DATE_LANGUAGE AMERICAN
NLS_SORT BINARY
NLS_TIME_FORMAT HH.MI.SSXFF AM
NLS_TIMESTAMP_FORMAT DD-MON-RR HH.MI.SSXFF AM
NLS_TIME_TZ_FORMAT HH.MI.SSXFF AM TZR
NLS_TIMESTAMP_TZ_FORMAT DD-MON-RR HH.MI.SSXFF AM TZR
NLS_DUAL_CURRENCY $
NLS_COMP BINARY
NLS_LENGTH_SEMANTICS BYTE
NLS_NCHAR_CONV_EXCP FALSE
NLS_NCHAR_CHARACTERSET AL16UTF16
NLS_RDBMS_VERSION 10.2.0.1.0
20 rows selected.
SQL> HOST ECHO %NLS_LANG%
AMERICAN_AMERICA.WE8MSWIN1252
NLS_LANG in registry is AMERICAN_AMERICA.WE8MSWIN1252
ORACLE_HOME in registry is C:\oraclexe\app\oracle\product\10.2.0\server
I am creating Connection pool in Glassfish admin web GUI, When I trying to ping I get this error in log:
[#|2010-05-15T23:19:26.958+0400|WARNING|glassfishv3.0|
javax.enterprise.resource.resourceadapter.com.sun.enterprise.connectors.service|
_ThreadID=29;_ThreadName=Thread-1;|
RAR8054: Exception while creating an unpooled [test] connection for pool [ phut ],
Connection could not be allocated because:
ORA-00604: error occurred at recursive SQL level 1
ORA-12705: Cannot access NLS data files or invalid environment specified
|#]
HOW TO FIX??