The strings that you have declared X1 and Y1 exist in the scope of the if
statement only. once out of the if statement these variables no longer
exist. if you did a println on those variables out of the if clause, you
wouldn't see them.
A solution is to define those strings as class variables. Read in the values
from the database and assign to those variables. That way you should be
able to see them in the jsp
Irfan
-----Original Message-----
From: john doucette [mailto:[EMAIL PROTECTED]]
Sent: Saturday, June 03, 2000 3:04 AM
To: [EMAIL PROTECTED]
Subject: beanless connection problem
Does anyone see where I'm screwing this up?
I've tried several examples, to no avail.
Any help would be great!
Using:
Apache on Solaris 2.6
Oracle 8i(8.1.6)
Jdk 1.2.2
Jrun 2.3.3
Oracle is on the same machine as the webserver
//Begin Code
<%@ page import="java.sql.*" %>
<%@ page import="java.io.*"%>
<%@ page import="java.util.*"%>
<%@ page import="java.sql.*"%>
<%@ page import="javax.servlet.*"%>
<%@ page import="javax.servlet.http.*"%>
<%
try{
Class.forName("oracle.jdbc.driver.OracleDriver");
String url = "jdbc:oracle:[EMAIL PROTECTED]:1521:ora1";
String query = "Select * from STATUS";
Connection con = DriverManager.getConnection(url, "usernm",
"paswd");
Statement stmt = con.createStatement();
ResultSet results = stmt.executeQuery(query);
if (results.next()){
String X1 = results.getString("sor_status");
String Y1 = results.getString("SDefinition");
}
String X1 = "OW";
String Y1 = "dat hurt";
con.close();
}
catch (ClassNotFoundException e) {
System.err.println("no driver");
}
catch (SQLException e) {
System.err.println("no db connection");
}
finally {
try { if (con != null) con.close(); }
catch (SQLException e) {}
}
%>
<HTML>
<BODY>
type:<%=X1%> Definied:<%=Y1%><BR><BR>
</BODY>
</HTML>
John Doucette - 818.865.1310
----------------------------------------------------
internet development
sdr technologies
===========================================================================
To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff
JSP-INTEREST".
Some relevant FAQs on JSP/Servlets can be found at:
http://java.sun.com/products/jsp/faq.html
http://www.esperanto.org.nz/jsp/jspfaq.html
http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets
===========================================================================
To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST".
Some relevant FAQs on JSP/Servlets can be found at:
http://java.sun.com/products/jsp/faq.html
http://www.esperanto.org.nz/jsp/jspfaq.html
http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets
