Unanswered: An sql error couldn't be caught and exit gracefully
have a select statement embedded in java code. This select statement queries out a bunch of records and then does string concatenation on a certain field. And due to one record having more than 4000+ chars on that field, the query failed on this record after returning a few good records in sqlplus. The error is : "ORA-01489: result of string concatenation is too long".
When integrated with JDBC, it turns out no exception was thrown out and the program was just stuck in there
Here is a few line of code:
2. ResultSet rs=statement.executeQuery(select);
5. //do something
8. catch (Exception e)
10. //handle it.
The program seems to hang at line 3 without exception thrown up when it gets the bad record. Anyone has any idea how to catch this type of error? thanks...