JDBC Oracle driver

From: Marcos Scriven <marcosscriven_at_eurobell.co.uk>
Date: 2000/02/16
Message-ID: <88f621$qcs$1@slrn.eurobell.net>#1/1

Hi all

I have a couple of queries:

Is there a way to tell the JDBC.thin driver to map particular sized NUMBER data types to specific Java types? At the moment, everything from NUMBER(30,15) to NUMBER(2) is mapped to a double?! I realise they can be explicitly cast - but I really need to be able to do what is possible in Sybase i.e. read Sybase INTs as java ints etc.
In Sybase I can do a getSQLState() and getSQLCode() - does anyone know of a comprehensive list of these codes and states for Oracle, and their associated meanings?

Thanks

Marcos

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Wed Feb 16 2000 - 00:00:00 CST

JDBC Oracle driver - HELP!!