Try OpenEdge Now
skip to main content
Java Open Clients
Using SmartDataObjects from Java Clients : Working with SDOResultSet objects : Getting SDOResultSet column values

Getting SDOResultSet column values

These methods return data from a specified column on an SDOResultSet according to the specified data type. All column access methods in SDOResultSet use the flat model (see OpenEdge Development: Open Client Introduction and Programming. The column is specified by name (columnName) or number (columnIndex), as follows:
*BigDecimal getBigDecimal(int columnName)
*BigDecimal getBigDecimal(String columnName )
*boolean getBoolean(int columnName )
*boolean getBoolean(String columnName )
*byte[] getBytes(int columnName )
*byte[] getBytes(String columnName )
*double getDouble(int columnName )
*double getDouble(String columnName )
*int getInt(int columnName )
*int getInt(String columnName )
*java.sql.Blob getBlob(int columnName)
*java.sql.Blob getBlob(String columnName )
*java.sql.Clob getClob(int columnName )
*java.sql.Clob getClob(String columnName )
*java.sql.Date getDate(int columnName )
*java.sql.Date getDate(String columnName )
*java.sql.Timestamp getTimestamp(int columnName )
*java.sql.Timestamp getTimestamp(String columnName )
*long getLong(int columnName )
*long getLong(String columnName )
*Object getObject(int columnName )
*Object getObject(String columnName )
*String getString(int columnName )
*String getString(String columnName )
Some java.util.Date and java.sql.Date methods are being deprecated by JavaSoft in favor of using the more robust java.util.GregorianCalendar. These are the methods that get column values for instances of this class:
*java.util.GregorianCalendar getGregorianCalendar(String columnName ) [Extension]
*java.util.GregorianCalendar getGregorianCalendar(int columnIndex ) [Extension]
For more information on the mapping between ABL and Java data types, see the sections on data type mapping for temp-table fields and passing OUTPUT TABLE parameters in Passing parameters.