PreparedStatement and setTimestamp in oracle jdbc

by

To set a timestamp value in a PreparedStatement in UTC timezone one should use 

stmt.setTimestamp(1, t, Calendar.getInstance(TimeZone.getTimeZone("UTC")))

The Timestamp value is always UTC, but not always the jdbc driver can automatically sent it correctly to the server. The third, Calendar, parameter helps the driver to correctly prepare the value for the server.

More Related Contents:

  1. Using setDate in PreparedStatement
  2. Where’s my invalid character (ORA-00911)
  3. Oracle’s RETURNING INTO usage in Java (JDBC, Prepared Statement)
  4. having an exception when saving oracle type object in some entity
  5. PreparedStatement IN clause alternatives?
  6. PreparedStatement with list of parameters in a IN clause [duplicate]
  7. java.sql.SQLException: – ORA-01000: maximum open cursors exceeded
  8. Java: Insert multiple rows into MySQL with PreparedStatement
  9. Get query from java.sql.PreparedStatement [duplicate]
  10. How does a PreparedStatement avoid or prevent SQL injection?
  11. Reusing a PreparedStatement multiple times
  12. Handling MySQL datetimes and timestamps in Java
  13. Why do I get java.lang.AbstractMethodError when trying to load a blob in the db?
  14. How to call oracle stored procedure which include user-defined type in java?
  15. java.sql.SQLException: Exhausted Resultset
  16. How to enable logging for SQL statements when using JDBC
  17. Difference between Oracle jdbc driver classes?
  18. Does the preparedStatement avoid SQL injection? [duplicate]
  19. Getting output from dbms_output.get_lines using JDBC
  20. JDBC ResultSet get columns with table alias
  21. How to write / update Oracle blob in a reliable way?
  22. Getting an exception ORA-00942: table or view does not exist – when inserting into an existing table
  23. mysql prepared statement error: MySQLSyntaxErrorException
  24. ‘0000-00-00 00:00:00’ can not be represented as java.sql.Timestamp error
  25. Call an Oracle function from Java
  26. PreparedStatement setNull(..)
  27. ojdbc14.jar vs. ojdbc6.jar
  28. Connection cannot be cast to oracle.jdbc.OracleConnection
  29. How to use prepared statement for select query in Java?
  30. The Network Adapter could not establish the connection when connecting with Oracle DB

Leave a Comment