Difference Between 12c JDBC Driver and 11g JDBC Driver for Getting a Number Type Value (Doc ID 2006661.1)

Last updated on MAY 19, 2017

Applies to:

JDBC - Version 11.2.0.1.0 and later
Information in this document applies to any platform.

Goal

After upgrading the Oracle JDBC Thin driver from 11g to 12c, a different behavior is noticed in the ResultSet.getString() to get a value of Number type:

Result with JDBC 11g:  .111
Result with JDBC 12c:  0.111

 

Is there a way to obtain the same behavior as in 11g?



Solution

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