Hi,
I'm getting java.sql.SQLException: Stream has already been closed.
Below is the table and code I'm using.
I'd mentioned the place where I'm getting the error, in the code shown below.
Table Name: contents
Fields:
Name Type
-----------------------------------------
POEMID NUMBER(4)
FIRSTLINE VARCHAR2(100)
POEM VARCHAR2(4000)
MEANING LONG
Table Name: paragraph
Fields:
Name Type
--------------- ---------------
POEMID NUMBER(4)
POEMPARA VARCHAR2(4000)
<%@ page import="java.sql.*" %>
<%@ page import="java.io.*" %>
<%@ page import="oracle.jdbc.driver.*" %>
<%@ page import="oracle.sql.*" %>
<%@ page import="java.util.*" %>
<%@ page import="java.net.*" %>
<%
String str = request.getParameter("id");
int i=Integer.parseInt(str);
int poemid=0;
int paraid=0;
String mean="";
String t,poem="";
String poempara="";
Connection con1;
Statement st1;ResultSet rs1;
Statement st2;ResultSet rs2;
try{
Class.forName("oracle.jdbc.driver.OracleDriver");
con1=DriverManager.getConnection("jdbc:oracle:thin:@192.168.8.70:1521:bio","scott","tiger");
System.out.println("connection established");
%>
<html><head><title>1</title></head>
<body>
<div>
<table border=0 cellpadding=3 cellspacing=3>
<tr>
<td align=left><img src=mug.jpg border=0></td>
<td align=right><img src=tho.jpg border=0></td>
</tr>
<%
st2=con1.createStatement();
rs2=st2.executeQuery("select * from paragraph where poemid=2");
st1=con1.createStatement();
rs1=st1.executeQuery("select * from contents where poemid=2");
if(rs2.next())
{
poempara=rs2.getString(2);
out.println("hai in if");
out.print("<tr><td align=left>");
out.println(poempara);
out.println("</td></tr>");
while(rs1.next())
{
mean=rs1.getString(4);
poemid=rs1.getInt(1);
poem=rs1.getString(3);
out.println("<tr><td>");
out.println(poemid);
out.println("</td></tr>");
out.println("<tr><td>");
out.println(poem);
out.println("</td></tr>");
out.println("<tr><td>");
out.println(mean);
out.println("</td></tr>");
}
}
else
{
if(!(rs2.next()))
{
out.println("done");
while(rs1.next())
{
out.println("done");
out.println("Second");
out.println("<tr><td>");
out.println(rs1.getString("poemid"));
out.println("</td></tr>");
out.println("<tr><td>");
out.println(rs1.getString("poem"));
out.println("</td></tr>");
out.println("<tr><td>");
//Getting error at the below line
//i.e when trying to access the long data type.
out.println(rs1.getString("meaning"));
out.println("</td></tr>");
}
}
}
out.println("</table>");
%>
</div>
<table border=0 width=100%>
<tr>
<td align=left><img src=pp.jpg border=0></td>
<td align=center><img src=mel.jpg border=0></td>
<td align=right><img src=np.jpg border=0></td>
</tr>
</table>
</body></html>
<%
}
catch(Exception e)
{
System.out.println("connection error in retneri.java:"+e);
}
%>
Please respond me immediately as it's very urgent.
Thanks & with regards,
Selva Kumar.