JDBC Connection Pooling error

[jite eghagha]

Hi

I set up my connection pool as described in netbeans doc.

Then i tried to use, (in my own fashion) the Technics described in javaranch journal


But i get an error from the lines below :: javax.naming.NameNotFoundException: No object bound to name java:comp/env/jdbc/gameDataSource

        public dataAccess() {             
            try {
                Context envCtx = (Context) new InitialContext().lookup("java:comp/env");
                datasource = (DataSource) envCtx.lookup("jdbc/gameDataSource");
            } catch (NamingException ex) {
                 System.out.println(ex.toString());
            }
        }

I'd appreciate some help with that error.

I'm trying to read articles and documentation on InitialContext and Context, but so far everything I've found is rather "verbose"!

[jite eghagha]

I found the cause of the error ;

I had to include this couple of lines in my web.xml file:

    
<resource-ref>
 <res-ref-name>jdbc/sample</res-ref-name>
 <res-type>javax.sql.DataSource</res-type>
 <res-auth>Container</res-auth>
 <res-sharing-scope>Shareable</res-sharing-scope>
</resource-ref>

however, these lines are deleted when ever i build my application! But for now the error fixed

[Vijitha Kumara]

Which application server you are using? If any then check the documentation of that to see how to set up connection pooling.