Error when running JSP on AS400 -- JAVA400-L

× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.

>
Can anyone help?
Just wrote my first JSP on the 400 (see below) and I get the error:

Error getting compiled page.
I/O Exception reported when
compiling /QIBM/ProdData/IBMWebAS/servlets/pagecompile/_dscjava/_Query2_xjsp.jav
a:  javac: not found.

**** listing of program  ******
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">

<html>
<head>
        <title>SAMPLEJSP SQL</title>
</head>

<body>

<%@ import="java.sql.*" %>
<% Connection con = null;%>

<%!
public Connection getConnection() {
           if (con != null) {return con;}
           try {
                   Class.forName("com.ibm.as400.access.AS400JDBCDriver");
                   con = DriverManager.getConnection (
                   "jdbc:as400://XXXXXXX","ASCC","XXXXXX");
                   } catch( Exception e) {
                   System.out.println("Error retrieving connection:" + e);
                   return null;
                   }
%>

<%
                   con = getConnection();
                   if (con == null) {
                   out.println("Sorry database not available.");
                   return;
                   }
                   try {
                   Statement stmt = con.createStatement();
                   ResultSet rs = stmt.executeQuery(
                   "SELECT * FROM QGPL.XDSPMSTR ORDER BY DSRNO")
%>
<table border=1 cellpadding=5>
           <th>DSR NUM</th>
           <th>USER NAME</th>
           <th>DSR TITLE</th>
<% while (rs.next()) { %>
<tr>
        <td><%= rs.getString("DSRNO")%></td>
        <td><%= rs.getString("UNAME")%></td>
        <td><%= rs.getString("TITLE")%></td>
</tr>
<% } %>
</table>

<%
  rs.close();
  stmt.close();
  } catch (SQLException e) {
  out.println("SQL error : " + e);
  }
  out.flush();
%>
</body></html>
</body>
</html>

---------------------------------------------
This message was sent using MHO WebMail.
http://www.mho.net

This mailing list archive is Copyright 1997-2025 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.