Re: Using Tomcat with MSAccess
I can't see any errors in the Tomcat DOS window so I'm assuming they have scrolled off the screen. The only error I see is the HTML generated by the "else" clause if the insertIntoDB method doesn't run successfully. I'm running Win98 and the Access DB file access properties are only set to Archive. Jeff - Original Message - From: "Bojan Smojver" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, August 03, 2001 10:23 PM Subject: Re: Using Tomcat with MSAccess > What's the actual error message? > > Maybe you can print out the SQL statement to see if the syntax is OK. It > could be invalid SQL. Are you running this under Windows NT/2000 or > 9x/ME? Maybe the user Tomcat runs under doesn't have access rights on > this database? > > I don't really use Access, I'm just trying to apply my PostgreSQL > experiences... > > And maybe you can have a look at JBoss or similar EJB container. No more > SQL... > > Bojan > > Jeffrey Worst wrote: > > > > I'm writing an applet using Tomcat to register new members for a library. > > Everything works fine until I get to the part where the new information is > > being inserted into the MSAccess DB. I have commented below where the error > > occurs. Any help would be appreciated. > > > > Thanks, > > > > Jeff >
Using Tomcat with MSAccess
I'm writing an applet using Tomcat to register new members for a library.
Everything works fine until I get to the part where the new information is
being inserted into the MSAccess DB. I have commented below where the error
occurs. Any help would be appreciated.
Thanks,
Jeff
--
//New member registration
import java.io.*;
import javax.servlet.*;
import javax.servlet.http.*;
import java.util.*;
import java.sql.*;
public class NewMember extends HttpServlet {
private Statement statement = null;
private Connection connection = null;
String url = "jdbc:odbc:NewMember";
String username="";
String password="";
public void init( ServletConfig config )
throws ServletException
{
super.init( config );
try {
Class.forName( "sun.jdbc.odbc.JdbcOdbcDriver" );
connection =
DriverManager.getConnection( url, username, password );
}
catch ( Exception e ) {
e.printStackTrace();
connection = null;
}
}
public void doPost( HttpServletRequest req,
HttpServletResponse res )
throws ServletException, IOException
{
String passwd, member_type, fname, mname, lname, address1,
address2, city, zip, country, home_phone, work_phone, email,
member_since, remarks;
passwd= req.getParameter( "passwd" );
member_type = req.getParameter( "member_type" );
fname = req.getParameter( "fname" );
mname = req.getParameter( "mname" );
lname = req.getParameter( "lname" );
address1 = req.getParameter( "address1" );
address2 = req.getParameter( "address2" );
city = req.getParameter( "city" );
zip = req.getParameter( "zip" );
country = req.getParameter( "country" );
home_phone = req.getParameter( "home_phone" );
work_phone = req.getParameter( "work_phone" );
email = req.getParameter( "email" );
member_since = req.getParameter( "member_since" );
remarks = req.getParameter( "remarks" );
PrintWriter output = res.getWriter();
res.setContentType( "text/html" );
if ( passwd.equals( "" ) ||
fname.equals( "" ) ||
lname.equals( "" ) ) {
output.println( " Please click the back " +
"button and fill in all " +
"fields." );
output.close();
return;
}
//Below is where the problem occurs. I get the HTML message below of "An
error occured..."
//I think the insertIntoDB method is not working. It's being inserted
into a MSAccess DB
//which has been registered.
boolean success = insertIntoDB("'" + passwd + "','" + member_type +
"','" + fname + "','" +
mname + "','" + lname + "','" + address1 + "','" + address2 + "','" +
city + "','" + zip + "','" +
country + "','" + home_phone + "','" + work_phone + "','" + email +
"','" + member_since +
"','" + remarks + "'" );
if ( success )
output.print( "Thank you " + fname +
" for registering." );
else
output.print( "An error occurred. " +
"Please try again later." );
output.close();
}
private boolean insertIntoDB( String stringtoinsert )
{
try {
statement = connection.createStatement();
statement.execute(
"INSERT INTO NewMember values (" +
stringtoinsert + ");" );
statement.close();
}
catch ( Exception e ) {
System.err.println(
"ERROR: Problems with adding new entry" );
e.printStackTrace();
return false;
}
return true;
}
public void destroy()
{
try {
connection.close();
}
catch( Exception e ) {
System.err.println( "Problem closing the database" );
}
}
}
File Not Found Error
I keep getting an HTTP 404 file not found error when I try to run a servlet. My servlet class file is at C:\tomcat\Servlet\Ex197.class. Hopefully the html code below will show what I'm doing wrong: Thanks, Jeff Ex 19.7 http://localhost:8080/tomcat/Servlet/Ex197";> What is your favorite pet? Dog Cat Bird Snake None
Re: Simple (I think) Running Tomcat Question
Very true. Let me go back and think this thing through some more so I can post a more thoughtful question. Thanks, Jeff W. - Original Message - From: "Matt Read" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, July 25, 2001 12:37 PM Subject: Re: Simple (I think) Running Tomcat Question > Hello World is a servlet, not an applet - a world of difference. > > Exactly how are you trying to run it? > > Matt. > > ----- Original Message - > From: "Jeffrey Worst" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: 25 July 2001 16:54 > Subject: Simple (I think) Running Tomcat Question > > > > I believe I now have Tomcat running successfully. But... > > > > After starting Tomcat I get the following screen: > > 01-07-25 11:37:26 - ContextManager: Adding context Ctx( ) > > 01-07-25 11:37:26 - ContextManager: Adding context Ctx( /test ) > > 01-07-25 11:37:29 - PoolTcpConnector: Starting HttpConnectionHandler on > 8080 > > 01-07-25 11:37:29 - PoolTcpConnector: Starting Ajp12ConnectionHandler on > > 8007 > > > > > > I then tried to run the Hello World applet. When I successfully compile > and > > then try to run an applet, I get this error message: > > Exception in thread "main" java.lang.NoSuchMethodError: main > > > > Any ideas why? > > > > Jeff W. > > > > > > - Original Message - > > From: "Jim Cheesman" <[EMAIL PROTECTED]> > > To: <[EMAIL PROTECTED]> > > Sent: Wednesday, July 25, 2001 7:49 AM > > Subject: Re: Simple Tomcat Install on Win98 > > > > > > > At 01:30 PM 25/07/01, you wrote: > > > In html, which is horrible! Please sort it out! > > > > > > > > > >I'm having problems installing Tomcat on my Win98Se machine. Below are > > > >the directions from Jakarta for installing Tomcat. I've commented what > I > > > >don't understand. > > > > > > > > > > > > > > > > > > > > > > > >Change directory to "jakarta-tomcat-3.2.1" and set a new environment > > > >variable (TOMCAT_HOME) to point to the root directory of your Tomcat > > hierarchy. > > > >This I don t understand. Are they talking about doing this in > > > >autoexec.bat or in the tomcat.bat file? > > > > > > In autoexec.bat > > > > > > > > > > > > > >On Win32 you should type: > > > >"set TOMCAT_HOME=foo\jakarta-tomcat-3.2.1" > > > >Again, are they talking about within autoexec.bat or someplace > > else? > > > > > > In autoexec.bat > > > > > > > > > > > > > > Set the environment variable JAVA_HOME to point to the root directory > > of > > > > your JDK hierarchy... > > > >Where is the environment variable JAVA HOME located? > > > > > > In autoexec.bat > > > > > > > > > > > then add the Java interpreter to your PATH environment variable. > > > >How does one do this? > > > > > > In autoexec.bat (!) > > > > > > The basic syntax: > > > set MY_ENVIRONMENT_VARIABLE=c:\path\to\whatever > > > > > > and to add to the previously set variable > > > > > > set > MY_ENVIRONMENT_VARIABLE=%MY_ENVIRONMENT_VARIABLE%;c:\path\to\whatever > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > -- > > > > > >* Jim Cheesman * > > > Trabajo: > > > [EMAIL PROTECTED] - (34)(91) 724 9200 x 2360 > > > I keep telling > > > myself that I am a pathological > > > liar, but I am not sure if > > > I believe it. > > > > > > > > > > > >
Simple (I think) Running Tomcat Question
I believe I now have Tomcat running successfully. But... After starting Tomcat I get the following screen: 01-07-25 11:37:26 - ContextManager: Adding context Ctx( ) 01-07-25 11:37:26 - ContextManager: Adding context Ctx( /test ) 01-07-25 11:37:29 - PoolTcpConnector: Starting HttpConnectionHandler on 8080 01-07-25 11:37:29 - PoolTcpConnector: Starting Ajp12ConnectionHandler on 8007 I then tried to run the Hello World applet. When I successfully compile and then try to run an applet, I get this error message: Exception in thread "main" java.lang.NoSuchMethodError: main Any ideas why? Jeff W. - Original Message - From: "Jim Cheesman" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, July 25, 2001 7:49 AM Subject: Re: Simple Tomcat Install on Win98 > At 01:30 PM 25/07/01, you wrote: > In html, which is horrible! Please sort it out! > > > >I'm having problems installing Tomcat on my Win98Se machine. Below are > >the directions from Jakarta for installing Tomcat. I've commented what I > >don't understand. > > > > > > > > > >Change directory to "jakarta-tomcat-3.2.1" and set a new environment > >variable (TOMCAT_HOME) to point to the root directory of your Tomcat hierarchy. > >This I don t understand. Are they talking about doing this in > >autoexec.bat or in the tomcat.bat file? > > In autoexec.bat > > > > > >On Win32 you should type: > >"set TOMCAT_HOME=foo\jakarta-tomcat-3.2.1" > >Again, are they talking about within autoexec.bat or someplace else? > > In autoexec.bat > > > > > > Set the environment variable JAVA_HOME to point to the root directory of > > your JDK hierarchy... > >Where is the environment variable JAVA HOME located? > > In autoexec.bat > > > > > then add the Java interpreter to your PATH environment variable. > >How does one do this? > > In autoexec.bat (!) > > The basic syntax: > set MY_ENVIRONMENT_VARIABLE=c:\path\to\whatever > > and to add to the previously set variable > > set MY_ENVIRONMENT_VARIABLE=%MY_ENVIRONMENT_VARIABLE%;c:\path\to\whatever > > > > > > > > > > > > -- > >* Jim Cheesman * > Trabajo: > [EMAIL PROTECTED] - (34)(91) 724 9200 x 2360 > I keep telling > myself that I am a pathological > liar, but I am not sure if > I believe it. > > >
Simple Tomcat Install on Win98
I'm having problems installing Tomcat on my Win98Se machine. Below are the directions from Jakarta for installing Tomcat. I've commented what I don't understand. Thanks, Jeff W.-How Do I Install the Binary Version of Tomcat?Very simple. You should: Download the zip/tar.gz/whatever file from http://jakarta.apache.org/downloads/binindex.html.I’ve done this and everything went fine. Unpack the file into some directory (say foo). This should create a new subdirectory named "jakarta-tomcat-3.2.1". If it's not where you want it, move this directory to the desired location.///Did this and it went fine also./ Change directory to "jakarta-tomcat-3.2.1" and set a new environment variable (TOMCAT_HOME) to point to the root directory of your Tomcat hierarchy.This I don’t understand. Are they talking about doing this in autoexec.bat or in the tomcat.bat file? On Win32 you should type: "set TOMCAT_HOME=foo\jakarta-tomcat-3.2.1" Again, are they talking about within autoexec.bat or someplace else? Set the environment variable JAVA_HOME to point to the root directory of your JDK hierarchy...Where is the “environment variable” JAVA HOME located? then add the Java interpreter to your PATH environment variable.How does one do this?
