Trying to set up Connection Pooling using Glassfish

[Susan Smith]

Hello,

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
Status: Enabled

2.) Then just for testing, I put this in a JSP:

Context initCtx = new InitialContext();
Context envCtx = (Context) initCtx.lookup("java:comp/env");
DataSource ds = (DataSource)envCtx.lookup("mysqlsource");
Connection connection = ds.getConnection();
Statement stmt = connection.createStatement();
ResultSet resultSet = stmt.executeQuery("SELECT * From ....");
while ( resultSet.next() )
{
String description = resultSet.getString("description");
out.println("Description:" + description);
}

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.

[Susan Smith]

Hello,

Just wondering if anyone has any suggestion.

Thank you in advance for all the help.

[Siva Masilamani]

Usually the DataSource is expected under the sub context jdbc.

Try changing the JNDI name as jdbc/mysqlsource

 Context initCtx = new InitialContext();  
Context envCtx = (Context) initCtx.lookup("java:comp/env");  
DataSource ds = (DataSource)envCtx.lookup("jdbc/mysqlsource");   

[Bhavik patel]

hi

Context initCtx = new InitialContext();
            
Object mydatasource = initCtx.lookup("mysqlsource");

or
//in my case

Context initCtx = new InitialContext();
            
Object mydatasource = initCtx.lookup("msdb");

This should work for you. Because jndiname you provided on admin console is global jndi name.

Glassfish Consulting service is available at http://www.jmatrix.in