PreparedStatement setNull(..)

by

but watch out for this….

Long nullLong = null;

preparedStatement.setLong( nullLong );

-thows null pointer exception-

because the protype is

setLong( long )

NOT

setLong( Long )

nice one to catch you out eh.

More Related Contents:

  1. PreparedStatement IN clause alternatives?
  2. PreparedStatement with list of parameters in a IN clause [duplicate]
  3. Using setDate in PreparedStatement
  4. Java: Insert multiple rows into MySQL with PreparedStatement
  5. How can I get the SQL of a PreparedStatement?
  6. Using “like” wildcard in prepared statement
  7. Get query from java.sql.PreparedStatement [duplicate]
  8. How does a PreparedStatement avoid or prevent SQL injection?
  9. Variable column names using prepared statements
  10. Reusing a PreparedStatement multiple times
  11. Where’s my invalid character (ORA-00911)
  12. Getting java.sql.SQLException: Operation not allowed after ResultSet closed
  13. right syntax to use near ‘?’
  14. How does Java’s PreparedStatement work?
  15. Does the preparedStatement avoid SQL injection? [duplicate]
  16. mysql prepared statement error: MySQLSyntaxErrorException
  17. Oracle’s RETURNING INTO usage in Java (JDBC, Prepared Statement)
  18. How to use prepared statement for select query in Java?
  19. JDBC Prepared Statement . setDate(….) doesn’t save the time, just the date.. How can I save the time as well?
  20. PreparedStatement and setTimestamp in oracle jdbc
  21. com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure
  22. Show JDBC ResultSet in HTML in JSP page using MVC and DAO pattern
  23. Solving a “communications link failure” with JDBC and MySQL [duplicate]
  24. How to establish a connection pool in JDBC?
  25. Why does autoReconnect=true not seem to work?
  26. How does Class.forName() work?
  27. JDBC returning MySQLSyntaxError Exception with correct statement
  28. Adding jdbc driver to classpath
  29. Connection cannot be cast to oracle.jdbc.OracleConnection
  30. Performance of MySQL Insert statements in Java: Batch mode prepared statements vs single insert with multiple values

Leave a Comment