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-glassfish
Please help I'm stucked.
[Message sent by forum member 'btasdemir' (btasdemir)]
http://forums.java.net/jive/thread.jspa?messageID=349540