tomcat and macromedia ultra dev 4.0
Title: tomcat and macromedia ultra dev 4.0
Hi everbody,
I want to run macromedia ultra dev 4.0 generated jsp code under tomcat , but i got a lot of error messages( i paste an example above ) when i tried to run my pages
, is there any body can say me what version of tomcat , jdk and apache i must use together for running macromedia generated jsp pages,
and in addition i can't find a document how can i configure tomcat 4.0 on windows 2000 with apache.
sincerely,
Mehmet Ugur Kuzu
This login.jsp page generates error after submit the form,
%@page contentType=text/html; charset=iso-8859-1 language=java import=java.sql.*%
%@ include file=Connections/DENEME.jsp %
%
Driver DriverRecordset1 = (Driver)Class.forName(MM_DENEME_DRIVER).newInstance();
Connection ConnRecordset1 = DriverManager.getConnection(MM_DENEME_STRING,MM_DENEME_USERNAME,MM_DENEME_PASSWORD);
PreparedStatement StatementRecordset1 = ConnRecordset1.prepareStatement(SELECT * FROM USERS);
ResultSet Recordset1 = StatementRecordset1.executeQuery();
boolean Recordset1_isEmpty = !Recordset1.next();
boolean Recordset1_hasData = !Recordset1_isEmpty;
Object Recordset1_data;
int Recordset1_numRows = 0;
%
%
// *** Validate request to log in to this site.
String MM_LoginAction = request.getRequestURI();
if (request.getQueryString() != null request.getQueryString().length() 0) MM_LoginAction += ? + request.getQueryString();
String MM_valUsername=request.getParameter(textfield2);
if (MM_valUsername != null) {
String MM_fldUserAuthorization=;
String MM_redirectLoginSuccess=Next.gif;
String MM_redirectLoginFailed=Last.gif;
String MM_redirectLogin=MM_redirectLoginFailed;
Driver MM_driverUser = (Driver)Class.forName(MM_DENEME_DRIVER).newInstance();
Connection MM_connUser = DriverManager.getConnection(MM_DENEME_STRING,MM_DENEME_USERNAME,MM_DENEME_PASSWORD);
String MM_pSQL = SELECT USERNAME, USERPASSWORD;
if (!MM_fldUserAuthorization.equals()) MM_pSQL += , + MM_fldUserAuthorization;
MM_pSQL += FROM USERS WHERE USERNAME=' + MM_valUsername + ' AND USERPASSWORD=' + request.getParameter(textfield) + ';
PreparedStatement MM_statementUser = MM_connUser.prepareStatement(MM_pSQL);
ResultSet MM_rsUser = MM_statementUser.executeQuery();
boolean MM_rsUser_isNotEmpty = MM_rsUser.next();
if (MM_rsUser_isNotEmpty) {
// username and password match - this is a valid user
session.putValue(MM_Username, MM_valUsername);
if (!MM_fldUserAuthorization.equals()) {
session.putValue(MM_UserAuthorization, MM_rsUser.getString(MM_fldUserAuthorization).trim());
} else {
session.putValue(MM_UserAuthorization, );
}
if ((request.getParameter(accessdenied) != null) false) {
MM_redirectLoginSuccess = request.getParameter(accessdenied);
}
MM_redirectLogin=MM_redirectLoginSuccess;
}
MM_rsUser.close();
MM_connUser.close();
response.sendRedirect(response.encodeRedirectURL(MM_redirectLogin));
}
%
html
head
titleUntitled Document/title
meta http-equiv=Content-Type content=text/html; charset=iso-8859-1
/head
body bgcolor=#FF text=#00
form name=form1 method=post action=%=MM_LoginAction%
input type=text name=textfield2
input type=text name=textfield
input type=submit name=Submit value=Submit
/form
pnbsp;/p
/body
/html
after submit, this error generated,
Internal Servlet Error:
javax.servlet.ServletException: General error
at org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:459)
at ULTRADEVWORKS._0002fULTRADEVWORKS_0002flogin_0002ejsplogin_jsp_9._jspService(_0002fULTRADEVWORKS_0002flogin_0002ejsplogin_jsp_9.java:143)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:119)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at org.apache.jasper.servlet.JspServlet$JspServletWrapper.service(JspServlet.java:177)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:318)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:391)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at org.apache.tomcat.core.ServletWrapper.doService(ServletWrapper.java:404)
at org.apache.tomcat.core.Handler.service(Handler.java:286)
at org.apache.tomcat.core.ServletWrapper.service(ServletWrapper.java:372)
at org.apache.tomcat.core.ContextManager.internalService(ContextManager.java:797)
at org.apache.tomcat.core.ContextManager.service(ContextManager.java:743)
at org.apache.tomcat.service.connector.Ajp12ConnectionHandler.processConnection(Ajp12ConnectionHandler.java:166)
at org.apache.tomcat.service.TcpWorkerThread.runIt(PoolTcpEndpoint.java:416)
at org.apache.tomcat.util.ThreadPool$ControlRunnable.run(ThreadPool.java:498)
at java.lang.Thread.run(Thread.java:484)
Root cause:
java.sql.SQLException: General error
at sun.jdbc.odbc.JdbcOdbc.throwGenericSQLException(JdbcOdbc.java:6160)
at sun.jdbc.odbc.JdbcOdbc.SQLFreeEnv(JdbcOdbc.java:2742)
at sun.jdbc.odbc.JdbcOdbcDriver.closeConnection(JdbcOdbcDriver.java:842)
at
RE: tomcat and macromedia ultra dev 4.0
Title: tomcat and macromedia ultra dev 4.0
Hi
David and other members,
sorry
for my message to this list,
i
apologize from all of you ,
however i want to say that i achieve some pages and
some not,
i will
send my message to user list,
sorry
again...
-Original Message-From: David M Johnson
[mailto:[EMAIL PROTECTED]]Sent: Thursday, May 24, 2001 6:28
PMTo: [EMAIL PROTECTED]Subject: RE: tomcat
and macromedia ultra dev 4.0
This
mailing list is really for developers working on the Tomcat servlet
container.
You
will have a better chance of getting a useful response on the Tomcat user
mailing list.
It
looks like your problem involves some sort of database connection
failure.
You
might want to trycreating a very simple 'Hello World' type JSP page with
MacroMedia and then see if that works on Tomcat
before you try to run a more
complex page like your 'login.jsp'
page.
-
Dave
-Original Message-From: Mehmet Ugur Kuzu
(LinkPlus) [mailto:[EMAIL PROTECTED]]Sent: Thursday, May
24, 2001 10:38 AMTo:
[EMAIL PROTECTED]Subject: tomcat and macromedia ultra
dev 4.0
Hi everbody,
I want to run macromedia ultra dev 4.0
generated jsp code under tomcat , but i got a lot of error messages( i
paste an example above ) when i tried to run my pages
, is there any body can say me what
version of tomcat , jdk and apache i must use together for running
macromedia generated jsp pages,
and in addition i can't find a document how
can i configure tomcat 4.0 on windows 2000 with apache.
sincerely, Mehmet Ugur Kuzu
This login.jsp page generates error after
submit the form,
%@page contentType="text/html;
charset=iso-8859-1" language="java" import="java.sql.*"%
%@ include
file="Connections/DENEME.jsp" % % Driver
DriverRecordset1 =
(Driver)Class.forName(MM_DENEME_DRIVER).newInstance(); Connection ConnRecordset1 =
DriverManager.getConnection(MM_DENEME_STRING,MM_DENEME_USERNAME,MM_DENEME_PASSWORD);
PreparedStatement
StatementRecordset1 = ConnRecordset1.prepareStatement("SELECT * FROM
USERS"); ResultSet Recordset1
= StatementRecordset1.executeQuery(); boolean Recordset1_isEmpty =
!Recordset1.next(); boolean
Recordset1_hasData = !Recordset1_isEmpty; Object Recordset1_data; int Recordset1_numRows = 0; % % // *** Validate
request to log in to this site. String MM_LoginAction = request.getRequestURI(); if (request.getQueryString() != null
request.getQueryString().length() 0) MM_LoginAction += "?" +
request.getQueryString();
String
MM_valUsername=request.getParameter("textfield2"); if (MM_valUsername != null) { String
MM_fldUserAuthorization=""; String MM_redirectLoginSuccess="Next.gif"; String
MM_redirectLoginFailed="Last.gif"; String MM_redirectLogin=MM_redirectLoginFailed;
Driver MM_driverUser =
(Driver)Class.forName(MM_DENEME_DRIVER).newInstance(); Connection MM_connUser =
DriverManager.getConnection(MM_DENEME_STRING,MM_DENEME_USERNAME,MM_DENEME_PASSWORD);
String MM_pSQL = "SELECT
USERNAME, USERPASSWORD"; if (!MM_fldUserAuthorization.equals("")) MM_pSQL += "," +
MM_fldUserAuthorization; MM_pSQL += " FROM USERS WHERE USERNAME='" + MM_valUsername +
"' AND USERPASSWORD='" + request.getParameter("textfield") + "'";
PreparedStatement
MM_statementUser = MM_connUser.prepareStatement(MM_pSQL); ResultSet MM_rsUser =
MM_statementUser.executeQuery(); boolean MM_rsUser_isNotEmpty = MM_rsUser.next();
if (MM_rsUser_isNotEmpty)
{ //
username and password match - this is a valid user
session.putValue("MM_Username", MM_valUsername); if
(!MM_fldUserAuthorization.equals("")) {
session.putValue("MM_UserAuthorization",
MM_rsUser.getString(MM_fldUserAuthorization).trim()); } else {
session.putValue("MM_UserAuthorization", ""); } if
((request.getParameter("accessdenied") != null) false) {
MM_redirectLoginSuccess = request.getParameter("accessdenied");
}
MM_redirectLogin=MM_redirectLoginSuccess; } MM_rsUser.close(); MM_connUser.close();
response.sendRedirect(response.encodeRedirectURL(MM_redirectLogin));
} % html head titleUntitled Document/title meta http-equiv="Content-Type"
content="text/html; charset=iso-8859-1" /head body bgcolor="#FF"
text="#00" form
name="form1" method="post" action="%=MM_LoginAction%"
input type="text"
name="textfield2"
input type=&q
