RDBPROD: Error With Date/Time Assignment in Java (Doc ID 338830.1)

Last updated on AUGUST 12, 2016

Applies to:

Oracle Rdb Server on OpenVMS - Version 7.1 and later
Oracle JDBC for Rdb - Version 7.1.1 and later
HP OpenVMS Alpha
HP OpenVMS Itanium

Symptoms

The following executeUpdate fails if the JDBC for Rdb driver is used to connect to an Rdb database:

stmt.executeUpdate("INSERT INTO MYTABLE (COL1) VALUES (CURRENT_TIMESTAMP)");

COL1 is a DATE VMS field. The following exception is shown:

java.sql.SQLException: in <rdbjdbcsrv:prepare_stmt>
%SQL-F-UNSDATASS, Unsupported date/time assignment from <Source> to COL1@rdb.client.PrepareStmt

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms