tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "David De Graff" <tom...@awarehouse.com>
Subject Re: Problem with JNDI Datasource HOW-TO MySQL Example
Date Fri, 31 Oct 2003 08:54:17 GMT
Excellent! That worked on the first try, and it turns out that the test JNDI
datasource also works.

It's strange that the need to put class files in a directory of their
package name isn't mentioned in the O'Reilly Tomcat book (diagram on p. 71
shows class file in the WEB-INF/classes directory). Or maybe only some class
files need to be in a package subdirectory?

In any case, thanks much for the help!

Dave

----- Original Message -----
From: "Antony Paul" <antonypaul24@hotmail.com>
To: "Tomcat Users List" <tomcat-user@jakarta.apache.org>
Sent: Friday, October 31, 2003 12:42 AM
Subject: Re: Problem with JNDI Datasource HOW-TO MySQL Example


> simple suggestion.
> put the class file in webapps/DBTest/WEB-INF/classes/foo.
>
> Antony.
>
> ---- Original Message -----
> From: "David De Graff" <tomcat@awarehouse.com>
> To: <tomcat-user@jakarta.apache.org>
> Sent: Friday, October 31, 2003 1:55 PM
> Subject: Problem with JNDI Datasource HOW-TO MySQL Example
>
>
> > I'm new to Java but have installed Tomcat a couple of times, and am now
> > trying to configure a JNDI datasource (to use with the OpenReports
> database
> > reporting package - see http://sourceforge.net/projects/oreports for
info
> on
> > that).
> >
> > Before configuring a datasource for db reporting, I'm trying to set up
the
> > test datasource described on the JNDI Datasource HOW-TO at
> >
>
http://jakarta.apache.org/tomcat/tomcat-4.1-doc/jndi-datasource-examples-how
> > to.html, under the section "MySQL DBCP Example".
> >
> > I've edited the conf/server.xml and webapps/DBTest/WEB-INF/web.xml files
> as
> > indicated in the HOW-TO. When deploying the code in this sample webapp
> with
> > Tomcat 4.1.27, I either get a 404 or an error that includes the
following:
> >
> > " An error occurred at line: 6 in the jsp file: /test.jsp
> >
> > Generated servlet error:
> >     [javac] Compiling 1 source file
> >
> >
>
/home/ddegraff/packages/openreports-tomcat/work/Standalone/localhost/DBTest/
> > test_jsp.java:48: package foo does not exist
> >     foo.DBTest tst = new foo.DBTest();"
> >
> > The above error occurs if the jsp file and class file are in the
> > $CATALINA_HOME/webapps/DBTest directory together. If I put the compiled
> > class file (DBTest.class) in webapps/DBTest/WEB-INF/classes, I get a 404
> > when trying to access the jsp.
> >
> > The jsp file and class file source is copied below. Any insight would be
> > much appreciated.
> >
> > Best,
> >
> > Dave De Graff
> >
> > JSP file text:
> > <html>
> >   <head>
> >     <title>DB Test</title>
> >   </head>
> >   <body>
> >
> >   <%
> >     foo.DBTest tst = new foo.DBTest();
> >     tst.init();
> >   %>
> >
> >   <h2>Results</h2>
> >     Foo <%= tst.getFoo() %><br/>
> >     Bar <%= tst.getBar() %>
> >
> >   </body>
> > </html>
> > ----------------------------------
> > DBTest.java file text:
> > package foo;
> > import javax.naming.*;import javax.sql.*;import java.sql.*;
> > public class DBTest {
> >   String foo = "Not Connected";  int bar = -1;      public void init()
> > {    try{      Context ctx = new InitialContext();      if(ctx == null )
> > throw new Exception("Boom - No Context");
> >       DataSource ds =             (DataSource)ctx.lookup(
> > "java:comp/env/jdbc/TestDB");
> >       if (ds != null) {        Connection conn = ds.getConnection();
> > if(conn != null)  {            foo = "Got Connection "+conn.toString();
> > Statement stmt = conn.createStatement();            ResultSet rst =
> > stmt.executeQuery(                  "select id, foo, bar from
testdata");
> > if(rst.next()) {               foo=rst.getString(2);
> > bar=rst.getInt(3);            }
> >         conn.close();        }      }    }catch(Exception e) {
> > e.printStackTrace();    } }
> >  public String getFoo() { return foo; } public int getBar() { return
> bar;}}
> >
> >
> >
> >
> > ---------------------------------------------------------------------
> > To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org
> > For additional commands, e-mail: tomcat-user-help@jakarta.apache.org
> >
> >
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: tomcat-user-help@jakarta.apache.org
>
>



---------------------------------------------------------------------
To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: tomcat-user-help@jakarta.apache.org


Mime
View raw message