Re: jdbc driver - NumberFormatException

On Tue, 17 Jun 2003 11:22:23 +0300, Pavel Zlatarev <pavel.zlatarev_at_sap.com> wrote:

>Hi,
>
>I'm using Oracle9i 9.2.0.3 JDBC Driver - classes12.zip from http://download.oracle.com/otn/utilities_drivers/jdbc/9203/classes12.zip
>with Additional RowSet support - ocrs12.zip from http://download.oracle.com/otn/utilities_drivers/jdbc/9203/ocrs12.zip
>
>I execute "create table test (value NCLOB)" and it finishes correctly.
>Then "select * from test" returns a ResultSet and
>
>resultSet.getMetaData().getPrecision(1) throws
>
>java.lang.NumberFormatException: 4294967295
> at java.lang.Integer.parseInt(Integer.java:435)
> at java.lang.Integer.parseInt(Integer.java:472)
> at oracle.jdbc.driver.OracleResultSetMetaData.getPrecision(OracleResultSetMetaData.java:331)
>
>Does anyone know the right place to report it?
>I tried http://otn.oracle.com/forums/sqlj_jdbc.html with no response.
>
>Thanks

I don't think this should be reported at all. Your column has the *National* Character Large Object datatype, and you are returning it as an int. Are you surprised you are getting exceptions? If there is character data in the column, you will run into the above exception. What You See Is What You Get!

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Tue Jun 17 2003 - 12:01:58 CDT