I have been following a strange behavior with JRun (ver 3.0 SP1) Server on
W2K. I am wondering if it happens only with the developer version or with
others too.
for my SQL I have the following
ResultSet rs = searchStatement.executeQuery( "SELECT * " + "FROM Product " +
"WHERE title_name LIKE '" + search_string + "%'");
when I loop thru the result set something like the following
while (rs.next()) { out.println( "" + "" + rs.getString("prname") + "" + ""
+ rs.getFloat("price") + "" + "" + rs.getInt("pr_id") + "" + "" ); } //End
of while loop CHECK rs.next()
where I mistyped a column name, instead of "prid" I typed in "pr_id". the
exception was caught fine. I checked the err log and it says "column name
not found". So everything is cool except after around 30 seconds JRun server
will die and of course I have to restart the server before I can call any
other servlets.
Now the real problem is anything can go wrong with any sql/db like db lock,
etc. in a production environment. Is there something funny going on with
JRun for some exceptions?
Saidul Islam
Sun Certified Java Programmer
Programmer Analyst, Tel:614.337.5515, Fax:614.337.5772
VICTORIA'S SECRET CATALOGUE
http://www.victoriasSecret.com
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
