No
Biren
On Mon, 8 May 2000, SUDESH PALEKAR wrote:
> Hi!
> are there any error message details.
>
> Sudesh Palekar
> Systems Manager
> Middleware group
> Wipro Infotech Ltd.
> ----- Original Message -----
> From: Biren Patnaik <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Saturday, May 06, 2000 3:15 PM
> Subject: Help on JSP and BEANS
>
>
> > Hi All,
> > I m getting "Error: 500 Unable to compile class for JSP" error messages
> > while executing a jsp program.
> > My aim is to execute a query from user input.
> > I m using 3 programs for that.2 for jsp and 1 bean program.
> >
> > list1x.jsp is my main program which calls list3x.jsp,which in fact calls
> > DbBean1 class.
> > I have saved list1x.jsp and list3x.jsp
> > in d:\java\jswdk-1.0.1\examples\jsp and DbBean1.class in
> > d:\java\jswdk-1.0.1\examples\web-inf\jsp\beans\com\wrox\jspexamples
> > directory.
> > My programs are
> >
> > list1x.jsp
> >
> > <html>
> > <head>
> > <title>
> > Executing a query
> > </title>
> > </head>
> > <body>
> >
> > <%@ page language="java" errorPage="ErrorPage.jsp" %>
> >
> > <%@ include file="Header.html" %>
> >
> > Choose database:
> >
> > <form method="GET"
> > action="http://147.0.1.41:8080/examples/jsp/list3x.jsp">
> >
> > Input SQL if you know your query:
> >
> > <p>
> >
> > <input type=text name=inputSQL size=40>
> >
> > <p>
> >
> > <input type=submit>
> >
> > </form>
> > </body>
> > </html>
> >
> >
> > list3x.jsp
> >
> > <html>
> > <head>
> > <title>
> > Database Search
> > </title>
> > </head>
> > <body>
> >
> > <%@ page language="java" import="java.sql.*" errorPage="ErrorPage.jsp" %>
> >
> > <%@ include file="Header.html" %>
> >
> > <jsp:useBean id="db" scope="request" class="com.wrox.jspexamples.DbBean1"
> > />
> >
> > <jsp:setProperty name="db" property="*" />
> >
> > <%! int numColumns;
> > ResultSet rs = null;
> > ResultSetMetaData rsmd = null;
> > %>
> >
> > <center>
> > <h2>Results from</h2>
> > <h2><%= request.getParameter("inputSQL") %></h2>
> > <hr>
> > <br><br>
> > <table border="1" bgcolor="#cccc99" bordercolor="#003366">
> > <tr>
> >
> > <%
> > String sql = request.getParameter("inputSQL");
> >
> > try {
> > db.connect();
> > } catch (ClassNotFoundException e) {
> > throw new ServletException("Database drivers not available", e);
> > } catch (SQLException e) {
> > throw new ServletException("Database URL is wrong", e);
> > }
> >
> > try {
> > rs = db.execSQL(sql);
> > } catch (SQLException e) {
> > throw new ServletException("Your query isn't working. " +
> > "Do you want to browse the database? " +
> > "If so, leave the SQL input empty", e);
> > }
> >
> > try {
> > rsmd = rs.getMetaData();
> > numColumns = rsmd.getColumnCount();
> >
> > for (int column = 1; column <= numColumns; column++) {
> > %>
> >
> > <th><%= rsmd.getColumnName(column) %></th>
> >
> > <%
> > }
> > %>
> >
> > </tr>
> >
> > <%
> > while (rs.next()) {
> > %>
> >
> > <tr>
> >
> > <%
> > for (int column = 1; column <= numColumns; column++) {
> > %>
> >
> > <td><%= rs.getString(column) %></td>
> >
> > <% } %>
> >
> > </tr>
> >
> > <% }
> > rs.close();
> > db.close();
> > } catch (SQLException e) {
> > throw new ServletException("Database error. The query worked, " +
> > "but the display didn't", e);
> > }
> > %>
> >
> > </table>
> > </center>
> > </body>
> > </html>
> >
> > DbBean1.java is
> >
> > package com.wrox.jspexamples;
> >
> > import java.sql.*;
> > import java.io.*;
> >
> > public class DbBean1 {
> >
> > String dbURL;
> > String dbDriver = "sun.jdbc.odbc.JdbcOdbcDriver";
> > private Connection dbCon;
> >
> > public DbBean1() {
> > super();
> > }
> >
> > public boolean connect() throws ClassNotFoundException, SQLException {
> > Class.forName(this.getDbDriver());
> > dbCon = DriverManager.getConnection(this.getDbURL());
> > return true;
> > }
> >
> > public void close() throws SQLException {
> > dbCon.close();
> > }
> >
> > public ResultSet execSQL(String sql) throws SQLException {
> > Statement s = dbCon.createStatement();
> > ResultSet r = s.executeQuery(sql);
> > return (r == null) ? null : r;
> > }
> >
> > public String getDbDriver() {
> > return this.dbDriver;
> > }
> >
> > public void setDbDriver(String newValue) {
> > this.dbDriver = newValue;
> > }
> >
> > public String getDbURL() {
> > return this.dbURL;
> > }
> >
> > public void setDbURL(String newValue) {
> > this.dbURL = newValue;
> > }
> > }
> >
> > Any one who can help me.. to save my valuable time
> > Thanx in advance
> > Biren
> >
> >
> ___________________________________________________________________________
> > To unsubscribe, send email to [EMAIL PROTECTED] and include in the
> body
> > of the message "signoff SERVLET-INTEREST".
> >
> > Archives: http://archives.java.sun.com/archives/servlet-interest.html
> > Resources: http://java.sun.com/products/servlet/external-resources.html
> > LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
> >
>
> ___________________________________________________________________________
> To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
> of the message "signoff SERVLET-INTEREST".
>
> Archives: http://archives.java.sun.com/archives/servlet-interest.html
> Resources: http://java.sun.com/products/servlet/external-resources.html
> LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
>
___________________________________________________________________________
To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
of the message "signoff SERVLET-INTEREST".
Archives: http://archives.java.sun.com/archives/servlet-interest.html
Resources: http://java.sun.com/products/servlet/external-resources.html
LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
