Skip to main content

!!!Urgent!!! - I get eror when I ping the defined connection pool -oracle-

1 reply [Last post]
Joined: 2008-12-29

Hi all,

I defined a connection pool, type oracle from the glassfish web admin console. Set the properties
Resource Type: javax.sql.DataSource
Datasource Classname:oracle.jdbc.pool.OracleDataSource
and name it oraclepool.
From the additional properties page I Set
• ServiceName: XE
• User: ****
• Password: ****
• ServerName: localhost
• PortNumber: 1521
• URL: jdbc:oracle:thin:@localhost:1521:XE

from the JDBC resources
I defined the pool.
JNDI Name: jdbc/oraclepool
Pool Name: oraclepool Status: Enabled

Under domain1\lib directory I copy the ojdbc6.jar.

My Locale is set to Turkish. tr_TR.

When I ping the pool I get error
"ORA-00604: error occurred at recursive SQL level 1 ORA-12705: Cannot access NLS data files or invalid environment specified "

I know that my oracle works fine. I could easily tnsping my service. And I can connect from TOAD to oracle. It seem to me its something like regional problems. I attach the server.log and regsitry settings of my oracle.

Please don't say to me uninstall oracle XE and reinstall. I do that recently.

And my oracle version is

Oracle Database 10g Express Edition Release - Product
PL/SQL Release - Production
CORE Production
TNS for 32-bit Windows: Version - Production
NLSRTL Version - Production

I also try the link below

Please help I'm stucked.

Reply viewing options

Select your preferred way to display the comments and click "Save settings" to activate your changes.
Joined: 2008-03-11


here are two links that might help:

The latter link mentions something about incompatibilities on locale settings.