javax.naming.NameNotFoundException: Name comp is not bound in this Context

Ranch Hand

Posts: 49

posted 13 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

Hi,
I'm trying to access mysql using Tomcat 6 and connection pool.I have placed the required jars (mysql-connector-java-5.1.10-bin.jar,commons-collections-3.2.jar,tomcat-dbcp.jar)in catalina-home/lib .I've placed TomConn.xml file in catalina-home\conf\Catalina\localhost.
TomConn.xml

web.xml

I'm trying to access the dbase from index.jsp

<%@page contentType="text/html" pageEncoding="UTF-8"%>
<%@page import="java.sql.*,javax.sql.*,javax.naming.*"%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
   "http://www.w3.org/TR/html4/loose.dtd">

<html>
    <head>
        <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
        <title>JSP Page</title>
    </head>
    <body>
        <h2>Hello World!</h2>
        <%
        Connection conn = null ;
        Statement st = null ;
        ResultSet rs = null ;
        String value ;
        try
                {
                    Context initctx = new InitialContext() ;
                    Context envctx = (Context)initctx.lookup("java:comp/env") ;
                    if(envctx == null ) 
                                throw new Exception("Boom - No Environment Context");
                    DataSource ds = (DataSource) envctx.lookup("jdbc/test");
                    conn = ds.getConnection() ;
                    st = conn.createStatement() ;
                    rs = st.executeQuery("Select * from users where username='Poonam'") ;
                    while(rs.next())
                        {
                        value = rs.getString(2) ;
                    
                        %>
                        Hello <%=value%>
                        <%
                        }

}
        catch(Exception ex)
                {
                    System.out.println("Exception Ocurred") ;
                    ex.printStackTrace() ;
                }
        
        %>
    </body>
</html>

When i run the code i get the following exception
INFO: Undeploying context [/TomConn]
May 25, 2010 9:46:50 PM org.apache.catalina.core.NamingContextListener lifecycleEvent
SEVERE: Creation of the naming context failed: javax.naming.NamingException: Context is read only
May 25, 2010 9:47:55 PM org.apache.catalina.core.NamingContextListener lifecycleEvent
SEVERE: Creation of the naming context failed: javax.naming.NamingException: Context is read only
Exception Ocurred
javax.naming.NameNotFoundException: Name comp is not bound in this Context
at org.apache.naming.NamingContext.lookup(NamingContext.java:770)
at org.apache.naming.NamingContext.lookup(NamingContext.java:153)
at org.apache.naming.SelectorContext.lookup(SelectorContext.java:137)
at javax.naming.InitialContext.lookup(InitialContext.java:392)
at org.apache.jsp.index_jsp._jspService(index_jsp.java:79)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:374)
.....

There are lot of discussions on the internet...but still none could solve my problem

.
Kindly advice.
Regards,
Poonam.

Tim Holloway

Saloon Keeper

Posts: 27253

193

I like...

posted 13 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

-1 for not placing braces on the "if" statement's predicate. I can't count the number of times I've slipped a line of code in on a 1-line "if" and had the whole thing blow on me. Braces are cheap insurance.

I'd be happier if I knew for certain which line in the sample code line the exception actually occurred on. And incidentally, if you must do database access on a JSP, I think you can find a tag that will do the necessary connection stuff for you - including JNDI lookup.

However, the top line of your message says Undeploying context. What's going on there? It appears to be shutting down the application.

The secret of how to be miserable is to constantly expect things are going to happen the way that they are "supposed" to happen.

You can have faith, which carries the understanding that you may be disappointed. Then there's being a willfully-blind idiot, which virtually guarantees it.

Misha Ver

Ranch Hand

Posts: 470

posted 13 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

Poonam Kadu wrote:I'm trying to access mysql using Tomcat 6 and connection pool.I have placed the required jars (mysql-connector-java-5.1.10-bin.jar,commons-collections-3.2.jar,tomcat-dbcp.jar)in catalina-home/lib .I've placed TomConn.xml file in catalina-home\conf\Catalina\localhost

What do mean by catalina-home? Is it $CATALINA_HOME ?

With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.