my dog learned polymorphism*
The moose likes Other Java Products and Servers and the fly likes Trying to set up Connection Pooling using Glassfish Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Products » Other Java Products and Servers
Bookmark "Trying to set up Connection Pooling using Glassfish" Watch "Trying to set up Connection Pooling using Glassfish" New topic
Author

Trying to set up Connection Pooling using Glassfish

Susan Smith
Ranch Hand

Joined: Oct 13, 2007
Posts: 224
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:


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
Ranch Hand

Joined: Oct 13, 2007
Posts: 224
Hello,

Just wondering if anyone has any suggestion.

Thank you in advance for all the help.
Siva Masilamani
Ranch Hand

Joined: Sep 19, 2008
Posts: 385
Usually the DataSource is expected under the sub context jdbc.

Try changing the JNDI name as jdbc/mysqlsource



SCJP 6,SCWCD 5,SCBCD 5

Failure is not an option.
Bhavik patel
Ranch Hand

Joined: Feb 20, 2007
Posts: 49
hi



or
//in my case





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


Bhavik Patel
Glassfish Consultancy service At http://www.jmatrix.in
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Trying to set up Connection Pooling using Glassfish
 
Similar Threads
EJB 2.1 JDBC resource references
jdbc 2.0 connection pooling
making connection pool in Glassfish v3
Connection Pool
JNDI in entry in context.xml and web.xml