Using Netbean 6.8 to create a Servlet app that queries a database

Using Netbean 6.8 to create a Servlet app that queries a database but fails with a

HTTP Status 404
The requested resource (/TechOpsTools/) is not available.

The code that I'm using is

package com.techops.tools;

import java.io.IOException;
import java.io.PrintWriter;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import org.apache.log4j.Logger;

@SuppressWarnings("serial")
public class SearchServlet extends HttpServlet{
	/**
	 *
	 */
	//private static final long serialVersionUID = 1L;
	private static final Logger logger = Logger.getLogger(SearchServlet.class);
@Override
public void doPost(HttpServletRequest request, HttpServletResponse response)
        throws ServletException, IOException{
		doGet(request,response);
    }
@Override
    public void doGet(HttpServletRequest request, HttpServletResponse response)
        throws ServletException, IOException{

// get the DSP_Id and CATALOG_KY from request
    	String dsp = (String) request.getParameter("DSP_ID");
    	String catKey = (String) request.getParameter("CATALOG_KY");

// set the content type of response.
    	response.setContentType("text/html");

// get a handle on the print writer of response.
    	PrintWriter out=response.getWriter();

// generate response.
     	out.println("<HTML>");
    	out.println("<HEAD>");
    	out.println("<TITLE>");
    	out.println("Search For Offers");
    	out.println("</TITLE>");
    	out.println("</HEAD>");
    	out.println("<BODY>");
    	if (dsp==null && catKey==null ){
    		logger.debug("Search criteria missing");
	    	out.println("<H3>You did not specify any serach criteria</H3>");
	    	out.println("<H3>Please Enter a DSP and Catalog Key</H3>");
	    	out.println("</BODY>");
	    	out.println("</HTML>");
	    	return;
    	}
    	if (dsp==null){
    		logger.debug("DSP ID is missing");
	    	out.println("<H3>You did not provide a DSP ID</H3>");
	    	out.println("</BODY>");
	    	out.println("</HTML>");
	    	return;
    	}
    	if (catKey==null){
    		logger.debug("CATALOG KEY is missing");
	    	out.println("<H3>You did not provide a CATALOG KEY</H3>");
	    	out.println("</BODY>");
	    	out.println("</HTML>");
	    	return;
    	}
    	Connection con = null;
    	Statement query = null;
    	ResultSet offers = null;
    	try{

logger.debug("Loading driver");
    		// load the driver class.
    		Class.forName("oracle.jdbc.driver.OracleDriver");

// string url database.
    		String url = "jdbc:oracle:oci8:@data";

logger.debug("Connecting to the database...");
    		// connect to the database.
    		con = DriverManager.getConnection(url, "User1", "USER123");

// create a statement.
    		query = con.createStatement();

logger.debug("Executing sql...");
    		// execute a query using the statement.
    		// this will return a resultset.
    		offers = query.executeQuery("SELECT ip.catalog_ky, ip.side_sequence, ip.track_sequence, ps.* FROM packaging_status ps, intellectual_property ip  WHERE ps.dsp_id in ('" + dsp + "')   AND ps.Intellectual_Property_Id = ip.Intellectual_Property_Id   AND ip.business_unit_id = 1   AND ip.Is_Deleted_Fl = 'N'   and ip.catalog_ky in ('" + catKey +"') AND ps.packaging_status_level_id = 9 order by ps.date_modified,   ip.catalog_ky,    ip.side_sequence,          ip.track_sequence,          ps.packaging_status_level_id");

// move from BOF to the first record.
    		// if the resultset is empty - print a message.
    		if (!offers.next()){
        		logger.debug("No match found");
	    		out.println("<H3>There is no offers for product " + catKey + "under DSP ID:" + dsp + "</H3>");
	    		return;
    		}
    		out.println("<H3>Here are the offers for product: " + catKey + "under DSP ID:" + dsp + "</H3>");
    		out.println("<TABLE BORDER=1>");
    		out.println("<TR>");
    		out.println("<TH>SIDE_SEQUENCE</TH>");
    		out.println("<TH>TRACK_SEQUENCE</TH>");
    		out.println("<TH>INTELLECTUAL_PROPERTY_ID</TH>");
    		out.println("<TH>PACKAGING_STATUS_ID</TH>");
      		out.println("<TH>PACKAGING_STATUS_LEVEL_ID</TH>");
    		out.println("<TH>CONVERSION_START_DT</TH>");
    		out.println("<TH>CONVERSION_FINISH_DT</TH>");
    		out.println("<TH>PACKAGING_START_DT</TH>");
    		out.println("<TH>PACKAGING_FINISH_DT</TH>");
    		out.println("<TH>DELIVERY_START_DT</TH>");
    		out.println("<TH>DELIVERY_FINISH_DT</TH>");
    		out.println("<TH>PACKAGER_VERSION</TH>");
    		out.println("<TH>PACKAGING_STATUS_TYPE_ID</TH>");
    		out.println("<TH>PACKAGING_ERROR_CD</TH>");
    		out.println("<TH>STATUS_MESSAGE</TH>");
    		out.println("<TH>EOM_OFFER_ID</TH>");
    		out.println("<TH>PRIORITY</TH>");
    		out.println("<TH>GROUP_NUM</TH>");
    		out.println("<TH>DATE_CREATED</TH>");
    		out.println("</TR>");

//loop through all the items.
    		do {
        		logger.debug("DSP ID: " + offers.getString("DSP_ID") + "Product: " + offers.getString("CATALOG_KY"));
    			out.println("<TR>");
    			out.println("<TD>" + offers.getInt("SIDE_SEQUENCE") + "</TD>");
    			out.println("<TD>" + offers.getInt("TRACK_SEQUENCE") + "</TD>");
    			out.println("<TD>" + offers.getDouble("INTELLECTUAL_PROPERTY_ID") + "</TD>");
    			out.println("<TD>" + offers.getDouble("PACKAGING_STATUS_ID") + "</TD>");
    			out.println("<TD>" + offers.getInt("PACKAGING_STATUS_LEVEL_ID") + "</TD>");
    			out.println("<TD>" + offers.getDate("CONVERSION_START_DT") + "</TD>");
    			out.println("<TD>" + offers.getDate("CONVERSION_FINISH_DT") + "</TD>");
    			out.println("<TD>" + offers.getDate("PACKAGING_START_DT") + "</TD>");
    			out.println("<TD>" + offers.getDate("PACKAGING_FINISH_DT") + "</TD>");
    			out.println("<TD>" + offers.getDate("DELIVERY_START_DT") + "</TD>");
    			out.println("<TD>" + offers.getDate("DELIVERY_FINISH_DT") + "</TD>");
    			out.println("<TD>" + offers.getInt("PACKAGER_VERSION") + "</TD>");
    			out.println("<TD>" + offers.getInt("PACKAGING_STATUS_TYPE_ID") + "</TD>");
    			out.println("<TD>" + offers.getInt("PACKAGING_ERROR_CD") + "</TD>");
    			out.println("<TD>" + offers.getString("STATUS_MESSAGE") + "</TD>");
    			out.println("<TD>" + offers.getDouble("EOM_OFFER_ID") + "</TD>");
    			out.println("<TD>" + offers.getInt("PRIORITY") + "</TD>");
    			out.println("<TD>" + offers.getDouble("GROUP_NUM") + "</TD>");
    			out.println("<TD>" + offers.getDate("DATE_CREATED") + "</TD>");
    			out.println("</TR>");
    		} while (offers.next());

out.println("</TABLE>");
    	}
    	catch(SQLException e){
			logger.error("Exception", e);
			while (e != null){
				logger.error("Message:		" + e.getMessage());
				logger.error("SQLState:		" + e.getSQLState());
				logger.error("Vendor ErrorCode:	" + e.getErrorCode());
				e = e.getNextException();
			}
    	}
    	catch(ClassNotFoundException e){
    		logger.error("Exception", e);
    	}
    	finally{
    		logger.debug("In finally");
    		out.println("</BODY>");
    		out.println("</HTML>");
    		// since close methods throw sqlexception - catch 'em.
    		try{
        		logger.debug("Closing connection");
        		if (offers!=null){
        			offers.close();
        		}
        		if (query!=null){
        			query.close();
        		}
        		if ((con!=null) && (!con.isClosed())){
        			con.close();
        		}
    		}
    		catch(Exception e){
    			logger.error("Exception", e);
    		}

}
    }
}

I also attached the xml files that I'm using for the tomcat setup (I'm using Tomcat 6.0.20 that came with netbeans 6.8)

also the server.xml file

<?xml version="1.0" encoding="UTF-8"?>
<!--
  Licensed to the Apache Software Foundation (ASF) under one or more
  contributor license agreements.  See the NOTICE file distributed with
  this work for additional information regarding copyright ownership.
  The ASF licenses this file to You under the Apache License, Version 2.0
  (the "License"); you may not use this file except in compliance with
  the License.  You may obtain a copy of the License at

http://www.apache.org/licenses/LICENSE-2.0

Unless required by applicable law or agreed to in writing, software
  distributed under the License is distributed on an "AS IS" BASIS,
  WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
  See the License for the specific language governing permissions and
  limitations under the License.
-->

<Server port="8005" shutdown="SHUTDOWN">
  
  <Listener SSLEngine="on" className="org.apache.catalina.core.AprLifecycleListener"/>
  
  <Listener className="org.apache.catalina.core.JasperListener"/>
  
  <Listener className="org.apache.catalina.mbeans.ServerLifecycleListener"/>
  <Listener className="org.apache.catalina.mbeans.GlobalResourcesLifecycleListener"/>
  
  <GlobalNamingResources>
    
    <Resource auth="Container" description="User database that can be updated and saved" factory="org.apache.catalina.users.MemoryUserDatabaseFactory" name="UserDatabase" pathname="conf/tomcat-users.xml" type="org.apache.catalina.UserDatabase"/>
  </GlobalNamingResources>
  
  <Service name="Catalina">
    
    
    
    <Connector URIEncoding="utf-8" connectionTimeout="20000" port="8089" protocol="HTTP/1.1" redirectPort="8443"/>
    
    
    
    
    
    <Connector port="8009" protocol="AJP/1.3" redirectPort="8443"/>
    
    
    <Engine defaultHost="localhost" name="Catalina">
      
      
      
      
      
      <Realm className="org.apache.catalina.realm.UserDatabaseRealm" resourceName="UserDatabase"/>
      
      <Host appBase="webapps" autoDeploy="false" name="localhost" unpackWARs="true" xmlNamespaceAware="false" xmlValidation="false">
        
        
        
        
      </Host>
    </Engine>
  </Service>
</Server>

Please help me.

Emmanuel Constant wrote:Using Netbean 6.8 to create a Servlet app that queries a database but fails with a

HTTP Status 404
The requested resource (/TechOpsTools/) is not available.

You didn't mention URL you are trying to access. Look at http://faq.javaranch.com/java/TellTheDetails

THE url is http://localhost:8089/TechOpsTools/

also this is what I get in the log when I start and restart:

Using CATALINA_BASE: C:\Documents and Settings\econsta\.netbeans\6.8\apache-tomcat-6.0.20_base
Using CATALINA_HOME: C:\Program Files\NetBeans 6.8\Apache Software Foundation\Apache Tomcat 6.0.20
Using CATALINA_TMPDIR: C:\Documents and Settings\econsta\.netbeans\6.8\apache-tomcat-6.0.20_base\temp
Using JRE_HOME: C:\Program Files\Java\jdk1.6.0_18
Apr 26, 2010 9:35:35 AM org.apache.catalina.core.AprLifecycleListener init
INFO: The APR based Apache Tomcat Native library which allows optimal performance in production environments was not found on the java.library.path: C:\Program Files\Java\jdk1.6.0_18\bin;.;C:\WINDOWS\Sun\Java\bin;C:\WINDOWS\system32;C:\WINDOWS;C:\Program Files\Java\jdk1.6.0_18\bin;.C:\OracleClient\product\11.1.0\client_2\bin;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\Program Files\Wave Systems Corp\Dell Preboot Manager\Access Client\v5\;C:\Program Files\Admin Tools\;C:\Program Files\Sybase\Sybase Central\win32\;C:\Sybase\dll\;C:\Sybase\asep\;C:\Sybase\bin\;C:\WINDOWS\system32\WindowsPowerShell\v1.0;C:\Program Files\ATI Technologies\ATI.ACE\Core-Static;C:\Program Files\SSH Communications Security\SSH Tectia\SSH Tectia AUX;C:\Program Files\SSH Communications Security\SSH Tectia\SSH Tectia AUX/Support binaries;C:\Program Files\SSH Communications Security\SSH Tectia\SSH Tectia Broker;C:\Program Files\SSH Communications Security\SSH Tectia\SSH Tectia Client;C:\Program Files\IDM Computer Solutions\UltraEdit-32;C:\Program Files\QuickTime\QTSystem\;c:\python25\;C:\Program Files\IDM Computer Solutions\UltraCompare
Apr 26, 2010 9:35:36 AM org.apache.coyote.http11.Http11Protocol init
INFO: Initializing Coyote HTTP/1.1 on http-8089
Apr 26, 2010 9:35:36 AM org.apache.catalina.startup.Catalina load
INFO: Initialization processed in 2883 ms
Apr 26, 2010 9:35:36 AM org.apache.catalina.core.StandardService start
INFO: Starting service Catalina
Apr 26, 2010 9:35:36 AM org.apache.catalina.core.StandardEngine start
INFO: Starting Servlet Engine: Apache Tomcat/6.0.20
Apr 26, 2010 9:35:38 AM org.apache.coyote.http11.Http11Protocol start
INFO: Starting Coyote HTTP/1.1 on http-8089
Apr 26, 2010 9:35:39 AM org.apache.jk.common.ChannelSocket init
INFO: JK: ajp13 listening on /0.0.0.0:8009
Apr 26, 2010 9:35:39 AM org.apache.jk.server.JkMain start
INFO: Jk running ID=0 time=0/63 config=null
Apr 26, 2010 9:35:39 AM org.apache.catalina.startup.Catalina start
INFO: Server startup in 2943 ms

Emmanuel Constant wrote:THE url is http://localhost:8089/TechOpsTools/

Why do you think your application would respond to this URL? What did you do for that?

I changed the port from being 8080 to 8089.

The TechOpsTools is the name a the war file when I deploy.

Check the log files once more time, perhaps there were an issues with deployment. The log file you have provided has no information about TechOpsTools.war deployment.

This is what I get when I do a clean and rebuild:

init:
undeploy-clean:
deps-clean:
do-clean:
Deleting directory C:\Documents and Settings\econsta\My Documents\NetBeansProjects\TechOpsTools\build
Deleting directory C:\Documents and Settings\econsta\My Documents\NetBeansProjects\TechOpsTools\dist
check-clean:
clean:
init:
deps-module-jar:
deps-ear-jar:
deps-jar:
Created dir: C:\Documents and Settings\econsta\My Documents\NetBeansProjects\TechOpsTools\build\web\WEB-INF\classes
Created dir: C:\Documents and Settings\econsta\My Documents\NetBeansProjects\TechOpsTools\build\web\META-INF
Copying 1 file to C:\Documents and Settings\econsta\My Documents\NetBeansProjects\TechOpsTools\build\web\META-INF
Copying 2 files to C:\Documents and Settings\econsta\My Documents\NetBeansProjects\TechOpsTools\build\web
library-inclusion-in-archive:
Copying 1 file to C:\Documents and Settings\econsta\My Documents\NetBeansProjects\TechOpsTools\build\web\WEB-INF\lib
Copying 1 file to C:\Documents and Settings\econsta\My Documents\NetBeansProjects\TechOpsTools\build\web\WEB-INF\lib
Copying 1 file to C:\Documents and Settings\econsta\My Documents\NetBeansProjects\TechOpsTools\build\web\WEB-INF\lib
library-inclusion-in-manifest:
Created dir: C:\Documents and Settings\econsta\My Documents\NetBeansProjects\TechOpsTools\build\empty
Compiling 1 source file to C:\Documents and Settings\econsta\My Documents\NetBeansProjects\TechOpsTools\build\web\WEB-INF\classes
compile:
compile-jsps:
Created dir: C:\Documents and Settings\econsta\My Documents\NetBeansProjects\TechOpsTools\dist
Building jar: C:\Documents and Settings\econsta\My Documents\NetBeansProjects\TechOpsTools\dist\TechOpsTools.war
do-dist:
dist:
BUILD SUCCESSFUL (total time: 13 seconds)

This is what I get when I deploy:

Using CATALINA_BASE:   C:\Documents and Settings\econsta\.netbeans\6.8\apache-tomcat-6.0.20_base
Using CATALINA_HOME:   C:\Program Files\NetBeans 6.8\Apache Software Foundation\Apache Tomcat 6.0.20
Using CATALINA_TMPDIR: C:\Documents and Settings\econsta\.netbeans\6.8\apache-tomcat-6.0.20_base\temp
Using JRE_HOME:        C:\Program Files\Java\jdk1.6.0_18
Apr 26, 2010 2:30:36 PM org.apache.catalina.core.AprLifecycleListener init
INFO: The APR based Apache Tomcat Native library which allows optimal performance in production environments was not found on the java.library.path: C:\Program Files\Java\jdk1.6.0_18\bin;.;C:\WINDOWS\Sun\Java\bin;C:\WINDOWS\system32;C:\WINDOWS;C:\Program Files\Java\jdk1.6.0_18\bin;.C:\OracleClient\product\11.1.0\client_2\bin;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\Program Files\Wave Systems Corp\Dell Preboot Manager\Access Client\v5\;C:\Program Files\Admin Tools\;C:\Program Files\Sybase\Sybase Central\win32\;C:\Sybase\dll\;C:\Sybase\asep\;C:\Sybase\bin\;C:\WINDOWS\system32\WindowsPowerShell\v1.0;C:\Program Files\ATI Technologies\ATI.ACE\Core-Static;C:\Program Files\SSH Communications Security\SSH Tectia\SSH Tectia AUX;C:\Program Files\SSH Communications Security\SSH Tectia\SSH Tectia AUX/Support binaries;C:\Program Files\SSH Communications Security\SSH Tectia\SSH Tectia Broker;C:\Program Files\SSH Communications Security\SSH Tectia\SSH Tectia Client;C:\Program Files\IDM Computer Solutions\UltraEdit-32;C:\Program Files\QuickTime\QTSystem\;c:\python25\;C:\Program Files\IDM Computer Solutions\UltraCompare
Apr 26, 2010 2:30:36 PM org.apache.coyote.http11.Http11Protocol init
INFO: Initializing Coyote HTTP/1.1 on http-8089
Apr 26, 2010 2:30:36 PM org.apache.catalina.startup.Catalina load
INFO: Initialization processed in 645 ms
Apr 26, 2010 2:30:36 PM org.apache.catalina.core.StandardService start
INFO: Starting service Catalina
Apr 26, 2010 2:30:36 PM org.apache.catalina.core.StandardEngine start
INFO: Starting Servlet Engine: Apache Tomcat/6.0.20
Apr 26, 2010 2:30:37 PM org.apache.coyote.http11.Http11Protocol start
INFO: Starting Coyote HTTP/1.1 on http-8089
Apr 26, 2010 2:30:37 PM org.apache.jk.common.ChannelSocket init
INFO: JK: ajp13 listening on /0.0.0.0:8009
Apr 26, 2010 2:30:37 PM org.apache.jk.server.JkMain start
INFO: Jk running ID=0 time=0/47  config=null
Apr 26, 2010 2:30:37 PM org.apache.catalina.startup.Catalina start
INFO: Server startup in 805 ms
Apr 26, 2010 2:30:37 PM org.apache.catalina.core.StandardContext start
INFO: Container org.apache.catalina.core.ContainerBase.[Catalina].[localhost].[/TechOpsTools] has already been started

Check the context path in context.xml

I got it to work cuz I was using the wrong url.

I'm using this URL now:

http://localhost:8089/TechOpsTools/SearchServlet?dsp=VEV&catKey=G010001916075F

but I get this error for the log4j:

log4j:WARN No appenders could be found for logger (com.techops.tools.SearchServlet).
log4j:WARN Please initialize the log4j system properly.

my log4j properties file is in the source directory under the package com.techops.tools and it looks like this:

ok I got the server running but i get this error

type Exception report

message

description The server encountered an internal error () that prevented it from fulfilling this request.

exception

javax.servlet.ServletException: Servlet execution threw an exception
	org.netbeans.modules.web.monitor.server.MonitorFilter.doFilter(MonitorFilter.java:390)

root cause

java.lang.UnsatisfiedLinkError: no ocijdbc11 in java.library.path
	java.lang.ClassLoader.loadLibrary(ClassLoader.java:1734)
	java.lang.Runtime.loadLibrary0(Runtime.java:823)
	java.lang.System.loadLibrary(System.java:1028)
	oracle.jdbc.driver.T2CConnection$1.run(T2CConnection.java:3171)
	java.security.AccessController.doPrivileged(Native Method)
	oracle.jdbc.driver.T2CConnection.loadNativeLibrary(T2CConnection.java:3167)
	oracle.jdbc.driver.T2CConnection.logon(T2CConnection.java:233)
	oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:490)
	oracle.jdbc.driver.T2CConnection.<init>(T2CConnection.java:133)
	oracle.jdbc.driver.T2CDriverExtension.getConnection(T2CDriverExtension.java:53)
	oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:465)
	java.sql.DriverManager.getConnection(DriverManager.java:582)
	java.sql.DriverManager.getConnection(DriverManager.java:185)
	com.techops.tools.SearchServlet.doGet(SearchServlet.java:88)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:617)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
	org.netbeans.modules.web.monitor.server.MonitorFilter.doFilter(MonitorFilter.java:390)

note The full stack trace of the root cause is available in the Apache Tomcat/6.0.20 logs.

can I get some assistance

This means that you are missing a driver ocijdbc11.dll in the Java library path. In general it would be better to use Oracle thin driver instead of the oci driver