Skip to main content

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

1 reply [Last post]
btasdemir
Offline
Joined: 2008-12-29
Points: 0

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

After,
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 10.2.0.1.0 - Product
PL/SQL Release 10.2.0.1.0 - Production
CORE 10.2.0.1.0 Production
TNS for 32-bit Windows: Version 10.2.0.1.0 - Production
NLSRTL Version 10.2.0.1.0 - Production

I also try the link below

http://technology.amis.nl/blog/1276/configuring-a-oracle-datasource-on-g...

Please help I'm stucked.

Reply viewing options

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

Hi,

here are two links that might help:

http://ora-12705.ora-code.com/
http://kr.forums.oracle.com/forums/thread.jspa?threadID=581376

The latter link mentions something about incompatibilities on locale settings.

Cheers
Chris.