[Info-vax] 2 Rdb JDBC questions

[Arne Vajhøj]

On 11/4/2023 5:05 PM, Arne Vajhøj wrote:
> 1) Are there a driver newer than:
> 
> Oracle JDBC for Rdb Thin Driver Release 7.3.5.0.3
> 
> ?
> 
> 2) Anyone ever gotten column with IDENTITY working with
> PreparedStatement getGeneratedKeys()?
> 
> I get a result set back, I am expecting either
> an int or a long value, but I actually get a
> SQL CHAR(8) Java byte[] length 8 back with some
> values that I cannot match with the actual
> generated id. SELCT of tablename.CURRVAL works
> fine.

Re 2)

I guess I cannot complain too much.

DatabaseMetaData supportsGetGeneratedKeys() returns
false, so the driver is not claiming to support
PreparedStatement getGeneratedKeys().

Just weird that it actually does return "something" instead
of throwing a "this is not supported" type of exception.

Arne