Forum:

Struts

Servlet action not available

Ranch Hand

Posts: 40

posted 14 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

Hiii all....

I am developing simple struts-database access using struts-config.xml file with MySql database. I have written code as

index.jsp

selectBook.jsp

<%@ taglib uri="http://jakarta.apache.org/struts/tags-logic" prefix="logic" %>
<%@ taglib uri="http://jakarta.apache.org/struts/tags-bean" prefix="bean" %>

<html>
    <head>
        <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
        <title>Struts - Database Access Using struts-config.xml</title>
    </head>
    <body>
        
        <h1>Struts - Database Access Using struts-config.xml</h1>
        
        <logic:notPresent name = "allBookList">
            <h2>Data source not bound in the scope!</h2>
        </logic:notPresent>
        
        <logic:present name = "allBookList">
            <logic:empty name = "allBookList">
                <h2>No data found!</h2>
            </logic:empty>
        </logic:present>
        
        <logic:present name = "allBookList">
            <p>Bookstore list:</p>
            <table border="1">
                <thead>
                    <tr>
                        <th>ID</th>
                        <th>Author</th>
                        <th>Title</th>
                        <th>Publisher</th>
                    </tr>
                </thead>
                <tbody>
                    <logic:iterate id="book" name="allBookList">
                        <tr>
                            <td><bean:write name="book" property="bookID" /></td>
                            <td><bean:write name="book" property="bookAuthor" /></td>
                            <td><bean:write name="book" property="bookTitle" /></td>
                            <td><bean:write name="book" property="bookPublisher" /></td>
                        </tr>
                    </logic:iterate>
                </tbody>
            </table>
        </logic:present>
        
    </body>
</html>

SelectBookActionForm.java

/*
 * SelectBookActionForm.java
 *
 * Created on March 22, 2010, 11:27 AM
 */

package com.abhijit.struts;

import javax.servlet.http.HttpServletRequest;
import org.apache.struts.action.ActionErrors;
import org.apache.struts.action.ActionMapping;
import org.apache.struts.action.ActionMessage;
/**
 *
 * @author abhijit
 * @version
 */
public class SelectBookActionForm extends org.apache.struts.action.ActionForm {
    
    public SelectBookActionForm() {
        super();
        // TODO Auto-generated constructor stub
    }
    
    public ActionErrors validate(ActionMapping mapping, HttpServletRequest request) {
        // this is where you code your validation logic.
        // since not using it within this tutorial, i will comment it and return null as no error found.
        
        /*
        ActionErrors errors = new ActionErrors();
        if (getName() == null || getName().length() < 1) {
            errors.add("name", new ActionMessage("error.name.required"));
            // TODO: add 'error.name.required' key to your resources
            return errors;
        }
         */
        return null;
    }
}

SelectBookAction.java

/*
 * SelectBookAction.java
 *
 * Created on March 22, 2010, 11:28 AM
 */

package com.abhijit.struts;

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

import org.apache.struts.action.Action;
import org.apache.struts.action.ActionForm;
import org.apache.struts.action.ActionMapping;
import org.apache.struts.action.ActionForward;

import javax.servlet.http.HttpSession;
import java.util.ArrayList;
import java.sql.*;
import javax.sql.*;

/**
 *
 * @author abhijit
 * @version
 */
public class SelectBookAction extends Action {
    
    private final static String showBook = "showBook";
    private DataSource dataSource;
    public ArrayList bookList = new ArrayList();
    
    public ActionForward execute(ActionMapping mapping, ActionForm  form,
            HttpServletRequest request, HttpServletResponse response)
            throws Exception {
        
        HttpSession session = request.getSession();
        
        /** Here the method that connects to the datasource is called: */
        bookList = getCustomers() ;
        
        /** Here we put the bookList in scope, so that we can use it in the JSP page: */
        if(bookList  != null){
            session.setAttribute("allBookList", bookList);
        }
        return (mapping.findForward(showBook));
    }
    
    private ArrayList getCustomers(){
        Connection conn = null;
        Statement  stmt = null;
        PreparedStatement prpStmt = null;
        ResultSet rs = null;
        StringBuffer  resultString ;
        
        bookList.clear();
        
        try{
            /** Here 'dbSource' maps to the datasource key defined in struts-config.xml: */
            dataSource = (DataSource)servlet.getServletContext().getAttribute("dbSource");
            
            conn = dataSource.getConnection();
            String sqlQuery = "SELECT bookID, bookTitle, bookAuthor, bookPublisher FROM book";
            prpStmt = conn.prepareStatement(sqlQuery);
            rs = prpStmt.executeQuery();
            
            /** Here we put the resultset in the bookList: */
            while (rs.next()) {
                bookList.add(new Book(rs.getString(1), rs.getString(2), rs.getString(3), rs.getString(4)));
            }
            rs.close();
            
        } catch ( SQLException e ) {
            System.err.println("SQL Exception occured while accessing the table" );
            e.printStackTrace();
            return null;
            
        } catch ( Exception e ) {
            e.printStackTrace();
            return null;
        }
        
        return bookList;
        
    }
}

Book.java

struts-config.xml

<?xml version="1.0" encoding="UTF-8" ?>

<!DOCTYPE struts-config PUBLIC
          "-//Apache Software Foundation//DTD Struts Configuration 1.2//EN"
          "http://jakarta.apache.org/struts/dtds/struts-config_1_2.dtd">

<struts-config>
    
    <data-sources>
        <data-source type="org.apache.commons.dbcp.BasicDataSource" key="dbSource">
            <set-property property="driverClassName" value="com.mysql.jdbc.Driver" />
            <set-property property="url" value="jdbc:mysql://localhost:3306/mydb" />
            <set-property property="username" value="root" />
            <set-property property="password" value="" />
        </data-source>
    </data-sources>
    
    <form-beans>
    <form-bean name="allBookList" type="com.abhijit.struts.SelectBookActionForm"/>
    </form-beans>
    
    <global-exceptions>
    
    </global-exceptions>

<global-forwards>
        <forward name="welcome"  path="/Welcome.do"/>
    </global-forwards>

<action-mappings>
        <action input="/index.jsp" name="allBookList" path="/select" scope="session" type="com.abhijit.struts.SelectBookAction">
        <forward name="showBook" path="/selectBook.jsp" redirect="true"/>
        </action>
    </action-mappings>
    
    <controller processorClass="org.apache.struts.tiles.TilesRequestProcessor"/>

<message-resources parameter="com/myapp/struts/ApplicationResource"/>    
<plug-in className="org.apache.struts.tiles.TilesPlugin" >
        <set-property property="definitions-config" value="/WEB-INF/tiles-defs.xml" />      
        <set-property property="moduleAware" value="true" />
    </plug-in>
    
    
    <plug-in className="org.apache.struts.validator.ValidatorPlugIn">
        <set-property
            property="pathnames"
            value="/WEB-INF/validator-rules.xml,/WEB-INF/validation.xml"/>
    </plug-in>
  
</struts-config>

Also I have properly written web.xml file. I also have cerated table in mydb database in my system. But when I try to run this it displaying first page that is index.jsp but when I click begin button it is giving following error:

HTTP Status 404 - Servlet action is not available
ype Status report

message Servlet action is not available

description The requested resource (Servlet action is not available) is not available.
Apache Tomcat/5.5.17

I am not able to find where I am commiting mistake. Can anyone please help me.

Thanks & Regards,
Abhijit

prakash pawar

Ranch Hand

Posts: 42

posted 14 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

Hi ,

In the index.jsp , where are you mapping that on click of begin link which action should be called ??

Regards,
Prakash Pawar.

Abhijit Kangale

Ranch Hand

Posts: 40

posted 14 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

Hiii Prakash...

For that I have written following action mapping in struts-config.xml file.

That is it has to go to selectBook.jsp and display the contents of table according to query written. Is there any thing wrong in that...?

Regards,
Abhijit

Jan Cumps

Bartender

Posts: 2661

I like...

posted 14 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

I thought that Struts has deprecated data source support?
From How to Access a Database

The DataSource manager is being retained in Struts 1.x for backward compatibility but may not be retained in Struts 2.x or later.

I think that your problems are not database related, but a Struts issue.
If you want, I can move it to our Struts forum.

OCUP UML fundamental and ITIL foundation

wang lei

Greenhorn

Posts: 12

posted 14 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

i hava a idea that can you try to change code segment in the page of index.jsp,such as the following codes:

<html:link action="/select">Begin</html:link>

it is just a suggest and i am not make sure that will be work correct.

Regards,
Abhijit

Abhijit Kangale

Ranch Hand

Posts: 40

posted 14 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

Hiiii...

I have already tried this <html:link action="/select">Begin</html:link>

but it wont work....

you can move to struts forum jan no proble....

Regards,
Abhijit

Jan Cumps

Bartender

Posts: 2661

I like...

posted 14 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

Abhijit Kangale wrote:...you can move to struts forum jan no proble....

I moved it. Good luck with getting this resolved.
Regards, Jan

OCUP UML fundamental and ITIL foundation

Abhijit Kangale

Ranch Hand

Posts: 40

posted 14 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

thanks Jan.. I hope I get solution soon in new forum...

David Newton

Author

Posts: 12617

I like...

posted 14 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

The issue is happening long before you're getting to a page.

Check the log for startup errors.

Abhijit Kangale

Ranch Hand

Posts: 40

posted 14 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

sorry David...
i am not getting you... could you please ellobarate something...

Jan Cumps

Bartender

Posts: 2661

I like...

posted 14 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

Abhijit Kangale wrote:sorry David...
i am not getting you... could you please ellobarate something...

David asks you to check your Tomcat logs.

They most likely list startup errors related to your application.
The error you get is that "something" is not available. This is probably because your application did not initialize (startup) properly.
You will find these application initialization errors in your Tomcat log. They will show the real underlying error.

Regards, Jan

OCUP UML fundamental and ITIL foundation

Abhijit Kangale

Ranch Hand

Posts: 40

posted 14 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

thanks Jan for your valuable answer....

The airline is called "Virgin"? Don't you want a plane to go all the way? This tiny ad will go all the way:

a bit of art, as a gift, the permaculture playing cards

https://gardener-gift.com