Belive it or not, I have the chapter 16 example working with Apache Tomcat/5.0.16 - sort of.

Everything loads fine. I get a front page and I can access all the other pages. Struts appears to be working fine and the j_security stuff is.. well it's decent enough to make the application work.

The only problem I have is with the add (or i guess its actually the create) function. I can update and delete books just fine, but I can't add new ones. I added books to test via mysql control center.. right now im having trouble trying to create booknews items with it so i havent tested that, but i assume it works the same way (update and remove, but no create).

When I do try to add a new book this is what i get:

HTTP Status 500 - Dispatch[/book/aud] to method add returned an exception

type Status report

message Dispatch[/book/aud] to method add returned an exception

description The server encountered an internal error (Dispatch[/book/aud] to method add returned an exception) that prevented it from fulfilling this request.
Apache Tomcat/5.0.16


I can't find anything wrong with the java classes, but I can't imagine it's a problem with the jsps either. I've looked a ton of places for help, but I can't find anything. It's difficult to catch exceptions with all these seperate files. Any ideas?

Let me know what file source I can post if this will help.
Thanks
JC

AHH! I found the problem. I had to look around on here a bit harder, but the magic for making this work lies in the struts-legacy.jar as i learned from this post:

http://p2p.wrox.com/topic.asp?TOPIC_ID=5160

In the GenericConnection class I replaced


    public CallableStatement prepareCall(String sql, int resultSetType,
                 int resultSetConcurrency,
                 int resultSetHoldability) throws SQLException {
        throw new UnsupportedOperationException();
    }

    public PreparedStatement prepareStatement(String sql, int autoGeneratedKeys)
    throws SQLException {
        throw new UnsupportedOperationException();
    }

    public PreparedStatement prepareStatement(String sql, int columnIndexes[])
    throws SQLException {
        throw new UnsupportedOperationException();
    }


with this:


    public CallableStatement prepareCall(String sql, int resultSetType,
                 int resultSetConcurrency,
                 int resultSetHoldability) throws SQLException {
        throw new UnsupportedOperationException();
    }


    public PreparedStatement prepareStatement(String sql, int autoGeneratedKeys)
        throws SQLException
    {
        if (closed) throw new SQLException(SQLEXCEPTION_CLOSED);

        return (conn.prepareStatement(sql, autoGeneratedKeys));

    }



    public PreparedStatement prepareStatement(String sql, int columnIndexes[])
    throws SQLException {
        throw new UnsupportedOperationException();
    }


Then I compiled that and the GenericDataSource class and put them in a jar and everything ran nice and smooth

Thanks a bundle to whoever figured that out.

I'm new to JSP and Java. Would you mind sending me the new struts-legacy.jar? Thanks.

How did you compile these? I keep running into errors when I tried compiling. I just have GenericConnection.java and GenericDataSource.java.