I'm trying to set up connection pooling in my web app.
I'm pretty new in Glassfish and connection pooling so I apologize in advance if this is a newbie question.
Here are the steps I do:
1.) I follow example from this tutorial: http://blogs.sun.com/JagadishPrasath/entry/creating_jdbc_connection_pool_resource
Using "Admin Console"
- I create a JDBC Pool. I successfully ping it
JNDI Name: mysqlPool
Resource Type: javax.sql.DataSource
Datasource Classname: com.mysql.jdbc.jdbc2.optional.MysqlDataSource
- Create JDBC resource to associate with the connection pool
JNDI name: mysqlsource
2.) Then just for testing, I put this in a JSP:
3.) But I got this error message:
Couldn't open connection to database: No object bound to name java:comp/env/mysqlsource
I'm not sure what steps I'm missing. Can someone please advise?
Thanks in advance for all the help.