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
