1
votes

I create Connection pool with this parameters:

введите сюда описание изображения

введите сюда описание изображения

I try to ping in glassfish web-interface and I have got this exceprion:

Ping Connection Pool failed for MyPool. Connection could not be allocated because: ORA-00604: error occurred at recursive SQL level 1 ORA-12705: Cannot access NLS data files or invalid environment specified Please check the server.log for more details. An error has occurred Ping Connection Pool failed for MyPool. Connection could not be allocated because: ORA-00604: error occurred at recursive SQL level 1 ORA-12705: Cannot access NLS data files or invalid environment specified Please check the server.log for more details.

I add ojdbc6.jar(download from official oracle web site) in C:\glassfish5\glassfish\domains\domain1\lib\ext (I have Oracle Database Express Edition 11g Release 2)

1

1 Answers

0
votes

1) Please try by changing : Resource Type to javax.sql.ConnectionPoolDataSource and Database driver vender to oracle.jdbc.pool.OracleConnectionPoolDataSource

2) Try again a Ping