In your other posting you said that you are using the JDBC-ODBC-bridge. Some
time ago I had the same problem with the bridge. It was even worse with
another servlet engine. Since I am using a native driver the problem is not
there any longer.
Kind regards
Sven Spreier
-----Urspr�ngliche Nachricht-----
Von: "Islam, Saidul" <[EMAIL PROTECTED]>
An: "JRun-Talk" <[EMAIL PROTECTED]>
Gesendet: Freitag, 19. Januar 2001 20:53
Betreff: SQLException and JRun
> 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
