Please, I just developed an app with Netbeans 8.1 called "Group Manager". It is working well on my pc through Netbeans
IDE, but now i want to deploy it to another pc with Glassfish server 4.1. I have searched for how to setup
JDBC connection pool and JDBC Resources on several websites and I got the following settings below which I have implemented but getting the error message indicated below after I have tried it several time. Please, help resolve this. Thanks for your quick response.
JDBC connection pool
Resource Type: javax.sql.DataSource
Datasource Classname: org.apache.derby.jdbc.ClientDataSource40
Initial and Minimum Pool Size: 8
Maximum Pool Size: 32
Pool Resize Quantity: 2
Idle Timeout: 300
Max Wait Time: 6000
TraceFileAppend: false
SecurityMechanism: 4
ConnectionAttributes: create=true
User: web
DatabaseName: group_manager_db
RetrieveMessageText: true
ServerName: localhost
PortNumber: 1527
Password: web
JDBC Resources
JNDI Name: jdbc/group_manager_db
Pool Name: group_manager_db
ERROR:
An error has occurred. Ping Connection Pool failed for group_manager_db. Connection could not be allocated because: Connection authentication failure occurred. Reason: Userid or password invalid. Please check the server.log for more details.