1. How can I retrieve a JDBC NUMERIC column value that may be NULL, without incurring a conversion cost? stackoverflow.comI have a simple query using JDBC of an Oracle database which is proving slow to retrieve, even though the query itself doesn't seem to be the problem. A profiler reveals ... |
2. Identify not null columns coderanch.com |
3. null columns coderanch.comHi, I think the problem is not in your query, but in your INSERT or UPDATE statements. Example: sqlStr = new StringBuffer("UPDATE test SET "); sqlStr.append("first_name = '" + getFirstName() + "', "); sqlStr.append("last_name = '" + getLastName() + "' "); sqlStr.append(" where id = " + getId()); With the above code, the value in the database is stored as a ... |