Greetings Everyone,
I have a very annoying problem and can't seem to solve it for 3 days now.
Any help from you guys would
be greatly appreciated. I think I am having this problem because one of
tables has a column called CRDESC of datatype LONG.
I used "oracle.jdbc.driver.OracleStatement ostmt =
(oracle.jdbc.driver.OracleStatement)stmt;
ostmt.defineColumnType(2,Types.VARCHAR);" but it is giving me all
kinds of problem. I put in a debug statement
inside called " System.out.println("inside");" and have learned that it
doesn't get further than that. It never print out another
debug statement I put in called "System.out.println("full_crdesc: "
+full_crdesc);" So suspect there is a problem with
the getString? Please help....thanks.
Tyla
==================================please see program
below=====================================
try {
int i = 0;
int i_total = 0;
String full_rel = "";
rs = stmt.executeQuery("SELECT
release,platform,status,to_char(fixdate,'Mon dd,yyyy')fixdate,
to_char(clsdate,'Mon dd,yyyy')
clsdate,clsby,fldrelease,urgency from scars.strstat where strnr=" +strnum
+"order by release");
while(rs.next()) {
release[i] = rs.getString("release");
platform[i] = rs.getString("platform");
status[i] = rs.getString("status");
String fixdate = rs.getString("fixdate");
if(fixdate == null) {
fixdate=" ";
}
}//end while
for (i_counter = 0; i_counter < i_total; i_counter++) {
try {
rs = stmt.executeQuery("SELECT crseqnum from
scars.strstat where strnr="+strnum +" and release="+"'"+release
[i_counter]+"'"+" and
platform="+"'"+platform[i_counter]+"'"+" and
status="+"'"+status[i_counter]+"'");
while(rs.next()){
crseqnum =rs.getInt(1);
}
}
catch (Exception ex) {
System.out.println("closing/routing error: "
+ex.toString());
}
full2_crdesc = " < Release # "+platform[i_counter]
+" "+release[i_counter]+" >";
out.print(full2_crdesc);
for(int cr = 1; cr <= crseqnum; cr++) {
oracle.jdbc.driver.OracleStatement ostmt =
(oracle.jdbc.driver.OracleStatement)stmt;
ostmt.defineColumnType(2,Types.VARCHAR);
rs= stmt.executeQuery("SELECT crdesc from
scars.closeroute where strnr="+strnum +"and crseqnum="+cr +"
and platform="+"'"+platform[i_counter]+"'"+"
and release="+"'"+release[i_counter]+"'");
while (rs.next()) {
full_crdesc = "";
System.out.println("inside");
String crdesc = rs.getString("CRDESC");
System.out.println("crdesc: " +crdesc);
full_crdesc = full_crdesc + "\n"+"\n"+crdesc;
System.out.println("full_crdesc: "
+full_crdesc);
out.print(full_crdesc);
}//end while
}//end for loop
out.print("\n");
out.print("_________________________________________________________________
______________");
out.print("\n");
}//end i_counter for loop
out.print("</textarea>");
out.print("<br>");
}//try
catch (Exception ex) {
System.out.println("full description error: " +ex.toString());
}
___________________________________________________________________________
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
