Biren,
I tried your code and it worked fine. I am using Tomcat and so I changed
some of the paths and the URL to my local database -
DriverManager.getConnection ("jdbc:odbc:POLite", "scott","tiger");
Not much help on why it did not work for you though.
John
----- Original Message -----
From: Biren Patnaik <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, May 08, 2000 4:26 PM
Subject: Re: Help on JSP and BEANS
> 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
>
___________________________________________________________________________
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
