My Oracle Support Banner

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

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Cause
Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.