DataSource Error on a Shared Tomcat Java host

Greenhorn

Posts: 15

posted 17 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

Hello everyone,
I use a Shared Tomcat Java hosting to host my site and have below error message:

But there is no problem to run on my local computer (I use Tomcat 5.5.25), and my site runs well on the local computer.

The host provider sent me a piece of messages in server log file, it said:

I have checked the web.xml, it is there under '/WEB-INF/'. How can it be missing? And they said, 'You should also install log4j to have your own Tomcat log to debug your application.'. I do have log4j log file inside the application. But I think that the error is on tomcat server starting. How can I log these kind of messages into my application log file?
I uploaded a small java class and jsp file to the server to test the db connection (see the below). I get same error message on the screen:

Does anyone know how I can fix the problem and what I can do next? Thanks in advance.

Related files are below.

A part of web.xml

Java test class:

package com.test;
 
import javax.naming.*;
import javax.sql.*;
import java.sql.*;
 
public class DBTest 
{
  String foo = "Not working";
  String errorMsg = "";
    
  public void init() {
    try{
        Connection conn = null;
        Statement stmt = null;
        Context initContext = new InitialContext();
        foo = "after initContext";
        if(initContext == null ) 
        {
        foo = "after initContext == null";
        throw new Exception("Boom - No Context");
        }
        Context envCtx = (Context)initContext.lookup("java:comp/env");
        foo = "after env";
        DataSource ds = (DataSource) envCtx.lookup("jdbc/myDataSource");
        foo = "after ds";
       
        
      if (ds == null)
      foo = "ds == null";
      else
      {
    foo = "before conn";
        conn = ds.getConnection();
        foo = "after conn";      
        if(conn != null)  
        {
            foo = "Got Connection "+conn.toString();
            stmt = conn.createStatement();
            foo = "after stmt";
            ResultSet rst = stmt.executeQuery("select CATEGORY_NAME from link_category "+
            "where CATEGORY_ID =103");
            foo = "after rst";
            if(rst.next()) 
            {
               foo=rst.getString("CATEGORY_NAME");
            }
            conn.close();
        }
        else
        foo = "conn == null";
      }
            
    }catch(Exception e) 
    {
      e.printStackTrace();
      //foo = e.toString();
      errorMsg = e.toString();
    }
 }
 
 public String getFoo() { return foo; }
 public String getErrorMsg() { return errorMsg; }
 
}

test.jsp

Consider Paul's rocket mass heater.