Release 10.1A: OpenEdge Development:
Java Open Clients

> ## Temp-table field data type conversion

> When the `get` `DataType``()` method you use to get the value of a temp-table field does not match the default Java data type of the field (Table C–1), a valid conversion occurs as long as the `get` `DataType``()` method corresponds to the Progress data type, as shown in Table C–6. Otherwise, an exception is thrown with a message explaining that the conversion is not supported. For example, if the temp-table field is defined as `LOGICAL`, you can use any of `getString()`, `getInt()`, or `getBoolean()` to retrieve the field value.

> Table C–6: ProResultSet type conversions for temp-table fields
> Progress data type | Valid Java data type accessor methods
> --- | ---
>     BLOB
>     byte[] getBytes()
>     java.sql.Blob getBlob()
>     CHARACTER
>     java.lang.String getString()
>     CLOB
>     java.lang.String getString()
>     java.sql.Clob getClob()
>     COM-HANDLE
>     java.lang.String getString()
>     int getInt()
>     long getLong()
>     DATE
>     java.lang.String getString()
>     java.sql.Date getDate()
>     java.util.GregorianCalendar getGregorianCalendar()
>     DATETIME
>     java.lang.String getString()
>     java.sql.Timestamp getTimeStamp()
>     java.util.GregorianCalendar getGregorianCalendar()
>     DATETIME-TZ
>     java.lang.String getString()
>     java.util.GregorianCalendar getGregorianCalendar()
>     DECIMAL
>     java.lang.String getString()
>     int getInt()
>     long getLong()
>     double getDouble()
>     java.math.BigDecimal getBigDecimal()
>     INTEGER
>     java.lang.String getString()
>     int getInt()
>     long getLong()
>     double getDouble()
>     java.math.BigDecimal getBigDecimal()
>     LOGICAL
>     java.lang.String getString()
>     int getInt()
>     boolean getBoolean()
>     RAW
>     byte[] getBytes()
>     RECID
>     java.lang.String getString()
>     int getInt()
>     long getLong()
>     ROWID
>     byte[] getBytes()
>     WIDGET-HANDLE
>     java.lang.String getString()
>     int getInt()
>     long getLong()

Copyright © 2005 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095