ORA-01858: a non-numeric character was found where a numeric was expected

OS: Solaris 10
JVM Container: WAS 8.0

Problem:

[16/07/15 8:59:58:235 EDT] 00000016 BusinessExcep E   CNTR0020E: EJB threw an unexpected (non-declared) exception during invocation of method "init" on bean "BeanId". Exception data: <openjpa-2.1.2-SNAPSHOT-r422266:1333100 fatal general error> org.apache.openjpa.persistence.PersistenceException: ORA-01858: a non-numeric character was found where a numeric was expected

Solution:

Set Environment Variable LC_ALL to en_US.UTF-8
echo "Set Locale to use en_US.UTF-8"

LC_ALL=en_US.UTF-8; export LC_ALL

locale