Hello,

I can not create a connection to a local Oracle XE database
Error occurs.

Error encountered

[ART.118.5042] Adapter Runtime (Connection): Unable to enable connection resource kz_primesource_jdbcAdapters: wmdb.
[ART.118.5036] Adapter Runtime (Connection): Unable to configure connection manager.
[ADA.1.204] Can not connect to the database with the DataSource class “oracle.jdbc.xa.client.OracleXADataSource”.
ORA-00604: error occurred at recursive SQL level 1
ORA-12705: Can not access NLS data files or invalid environment specified

Windows 7, SoftwareAG webMethods Integration Server 10.1

Hi,

what is the driverType specified in the otherProperties field?

Any other settings related to language?

Regards,
Holger

JDBC Connection settings

Connection Type webMethods Adapter for JDBC Connection
Package Name testpackage1
Connection Properties
Transaction Type XA_TRANSACTION
DataSource Class oracle.jdbc.xa.client.OracleXADataSource
serverName localhost
user wmdb
password ******
databaseName XE
portNumber 1521
networkProtocol
Other Properties driverType=thin
Connection Management Properties
Enable Connection Pooling true
Minimum Pool Size 1
Maximum Pool Size 10
Pool Increment Size 1
Block Timeout (msec) 1000
Expire Timeout (msec) 1000
Startup Retry Count 0
Startup Backoff Timeout (sec) 10

A similar problem was in version 10 and it was recommended to add user.langauge = en and user.location = US in the JAVA_OPTS server.
I added user.langauge = en and user.location = US to these settings, but that does not work.