Demos and Usage of java.sql.ResultSet.getArray(int i)

   1: import java.sql.Types;
   2: import java.sql.ResultSet;
   3: import oracle.sql.ARRAY;
   4:         ...
   5:     PreparedStatement pstmt = null;
   6:     ResultSet rset = null;
   7:     try
   8:         ...
   9:       {
  10:         Array array = rset.getArray(1);
  11:         _doUseGetArray( array );
  12:         ...
  13:     System.out.println("In _doUseResultSet");
  14:     ResultSet rset = null;

   1: import java.sql.PreparedStatement;
   2: import java.sql.ResultSet;
   3: import oracle.sql.ArrayDescriptor;
   4:         ...
   5:     PreparedStatement pstmt = null;
   6:     ResultSet rset = null;
   7:     ARRAY array = null;
   8:         ...
   9:       {
  10:         array = (ARRAY) rset.getArray(1);
  11:       }
  12:         ...
  13:     int numOfRecordsRetrieved = 0;
  14:     ResultSet rset = null;

   1: import java.sql.PreparedStatement;
   2: import java.sql.ResultSet;
   3: import oracle.sql.ARRAY;
   4:         ...
   5:     PreparedStatement pstmt = null;
   6:     ResultSet rset = null;
   7:     ARRAY array = null;
   8:         ...
   9:       {
  10:         array = (ARRAY) rset.getArray(1);
  11:       }
  12:         ...
  13:     int numOfRecordsRetrieved = 0;
  14:     ResultSet rset = null;

   1: import java.sql.Ref;
   2: import java.sql.ResultSet;
   3: import java.sql.ResultSetMetaData;
   4:         ...
   5: 
   6: public abstract class FilterResultSet implements ResultSet
   7: {
   8:         ...
   9:     protected ResultSet inner;
  10:     
  11:         ...
  12:     public Array getArray(String a) throws SQLException
  13:     { return inner.getArray(a); }

   1: import java.sql.Ref;
   2: import java.sql.ResultSet;
   3: import java.sql.ResultSetMetaData;
   4:         ...
   5: 
   6: public abstract class SynchronizedFilterResultSet implements ResultSet
   7: {
   8:         ...
   9:     protected ResultSet inner;
  10:     
  11:         ...
  12:     public synchronized Array getArray(String a) throws SQLException
  13:     { return inner.getArray(a); }

   1: import java.sql.Ref;
   2: import java.sql.ResultSet;
   3: import java.sql.ResultSetMetaData;
   4:         ...
   5: 
   6: public class ResultSetWrapper implements ResultSet {
   7: 
   8:         ...
   9:     private ResultSet rs;
  10:     private ColumnNameCache columnNameCache;
  11:         ...
  12:     public Array getArray(String colName) throws SQLException {
  13:         return rs.getArray( findColumn(colName) );

   1: import java.sql.Ref;
   2: import java.sql.ResultSet;
   3: import java.sql.ResultSetMetaData;
   4:         ...
   5: 
   6: abstract class C3P0ResultSet implements ResultSet, ClosableResource
   7: {
   8:         ...
   9:     ResultSet inner;
  10: 
  11:         ...
  12:     {
  13:         return inner.getArray(a);

   1: import java.sql.Ref;
   2: import java.sql.ResultSet;
   3: import java.sql.ResultSetMetaData;
   4:         ...
   5: 
   6: abstract class C3P0ResultSet implements ResultSet, ClosableResource
   7: {
   8:         ...
   9:     ResultSet inner;
  10: 
  11:         ...
  12:     {
  13:         return inner.getArray(a);

   1: import java.sql.Ref;
   2: import java.sql.ResultSet;
   3: import java.sql.ResultSetMetaData;
   4:         ...
   5: 
   6: public class NtEResultSet implements ResultSet {
   7: 
   8:         ...
   9: 
  10:     private ResultSet resultSet;
  11: 
  12:         ...
  13:     public Array getArray(int i) throws SQLException {
  14:         return resultSet.getArray(i);

   1: 
   2: public abstract class ExtendedResultSet implements java.sql.ResultSet {
   3: 
   4:         ...
   5:     private class UnderlyingColumn extends Calculator {
   6:         private ResultSet m_rs;
   7:         private int m_origIdx;
   8:         ...
   9:         
  10:         public UnderlyingColumn(ResultSet rs, int idx, int origIdx, ResultSetMetaData md) throws SQLException {
  11:             super(idx, md.getColumnName(origIdx));
  12:         ...
  13:         public java.sql.Array getArray() throws java.sql.SQLException {
  14:             return m_rs.getArray(m_origIdx);

   1: public final class ResultSetWrapper
   2:   implements ResultSet
   3: {
   4:         ...
   5:   private final ProfilerPoint _profilerPoint;
   6:   private final ResultSet _resultSet;
   7: 
   8:         ...
   9:   public ResultSetWrapper(ProfilerPoint profilerPoint, ResultSet resultSet)
  10:   {
  11:         ...
  12:     try {
  13:       return _resultSet.getArray(i);

   1: import java.sql.Ref;
   2: import java.sql.ResultSet;
   3: import java.sql.SQLException;
   4:         ...
   5: 
   6:     public static Object getObjectFromColumn(ResultSet rs, Integer jdbcType, int columnId)
   7:             throws SQLException
   8:         ...
   9: 
  10:     private static Object getObjectFromColumn(ResultSet rs, CallableStatement stmt, Integer jdbcType, String columnName, int columnId)
  11:             throws SQLException
  12:         ...
  13:         {
  14:             return stmt.getArray(columnIndex);

   1: 
   2: public class ResultSetImpl implements ResultSet {
   3:   private static final Logger log
   4:         ...
   5:   private UserQuery _userQuery;
   6:   private ResultSet _rs;
   7:   private ArrayList<FromItem> _fromList;
   8:         ...
   9: 
  10:   public void setResultSet(ResultSet rs)
  11:     throws SQLException
  12:         ...
  13:   {
  14:     return _rs.getArray(getColumn(column));