NULL « column « Java Database Q&A





1. How can I retrieve a JDBC NUMERIC column value that may be NULL, without incurring a conversion cost?    stackoverflow.com

I 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.com

Hi, 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 ...