Examples of java.sql.Ref

java.sql.Ref
The mapping in the Java programming language of an SQL REF value, which is a reference to an SQL structured type value in the database.
SQL REF values are stored in a table that contains instances of a referenceable SQL structured type, and each REF value is a unique identifier for one instance in that table. An SQL REF value may be used in place of the SQL structured type it references, either as a column value in a table or an attribute value in a structured type.
Because an SQL REF value is a logical pointer to an SQL structured type, a Ref object is by default also a logical pointer. Thus, retrieving an SQL REF value as a Ref object does not materialize the attributes of the structured type on the client.
A Ref object can be stored in the database using the PreparedStatement.setRef method.
All methods on the Ref interface must be fully implemented if the JDBC driver supports the data type. @see Struct @since 1.2

    }


    @Override
    public Ref getRef(int columnIndex) throws SQLException {
        FilterChainImpl chain = createChain();
        Ref value = chain.resultSet_getRef(this, columnIndex);
        recycleFilterChain(chain);
        return value;
    }

View Full Code Here

    }


    @Override
    public Ref getRef(String columnLabel) throws SQLException {
        FilterChainImpl chain = createChain();
        Ref value = chain.resultSet_getRef(this, columnLabel);
        recycleFilterChain(chain);
        return value;
    }

View Full Code Here

    }


    @Override
    public Ref getRef(int columnIndex) throws SQLException {
        FilterChainImpl chain = createChain();
        Ref value = chain.resultSet_getRef(this, columnIndex);
        recycleFilterChain(chain);
        return value;
    }

View Full Code Here

    }


    @Override
    public Ref getRef(String columnLabel) throws SQLException {
        FilterChainImpl chain = createChain();
        Ref value = chain.resultSet_getRef(this, columnLabel);
        recycleFilterChain(chain);
        return value;
    }

View Full Code Here

    }
    return obj;
  }


  public Ref readRef() throws SQLException {
    Ref ref = (Ref) getNextAttribute();
    if (ref == null) {
      lastValueWasNull = true;
      return null;
    } else {
      lastValueWasNull = false;

View Full Code Here

    checkIndex(i);
    checkCursor();
    if (RowSetMD.getColumnType(i) != 2006)
      throw new SQLException("Datatype Mismatch");
    setLastValueNull(false);
    Ref ref = (Ref) getCurrentRow().getColumnObject(i);
    if (ref == null) {
      setLastValueNull(true);
      return null;
    } else {
      return ref;

View Full Code Here

                case 11:{Date v=rs.getDate(col);o=v; break;}
                case 12:{double v=rs.getDouble(col);o=new Double(v);break;}
                case 13:{float v=rs.getFloat(col);o=new Float(v);break;}
                case 14:{int v=rs.getInt(col);o=new Integer(v);break;}
                case 15:{long v=rs.getLong(col);o=new Long(v);break;}
                case 16:{Ref v=rs.getRef(col);o=v;break;}
                case 17:{short v=rs.getShort(col);o=new Short(v);break;}
                case 18:{String v=rs.getString(col);o=v;break;}
                case 19:{Time v=rs.getTime(col);o=v;break;}
                case 20:{Timestamp v=rs.getTimestamp(col);o=v;break;}
//        case 21:{URL v=rs.getURL(col);o=v;break;}
                default: return null;
            }
            // fixup if it contains classname (remove "random" part after @)
            String v = o.toString();
            if (v.indexOf('@') != -1) { // non standard java object.
                s += "Object'   \t: "+prettyType(o);
            } else {
                // default stringifier...
                s += "'"+v+"'    \t: "+o.getClass().getName();
            }

View Full Code Here

   * @see java.sql.CallableStatement#getRef(int)
   */
  public synchronized Ref getRef(int parameterIndex) throws SQLException {
    ResultSetInternalMethods rs = getOutputParameters(parameterIndex);


    Ref retValue = rs
        .getRef(mapOutputParameterIndexToRsIndex(parameterIndex));


    this.outputParamWasNull = rs.wasNull();


    return retValue;

View Full Code Here

   */
  public synchronized Ref getRef(String parameterName) throws SQLException {
    ResultSetInternalMethods rs = getOutputParameters(0); // definitely not going to be
    // from ?=


    Ref retValue = rs.getRef(fixParameterName(parameterName));


    this.outputParamWasNull = rs.wasNull();


    return retValue;
  }

View Full Code Here

   * @see java.sql.CallableStatement#getRef(int)
   */
  public synchronized Ref getRef(int parameterIndex) throws SQLException {
    ResultSetInternalMethods rs = getOutputParameters(parameterIndex);


    Ref retValue = rs
        .getRef(mapOutputParameterIndexToRsIndex(parameterIndex));


    this.outputParamWasNull = rs.wasNull();


    return retValue;

View Full Code Here

0 1 2 3 4

TOP

Related Classes of java.sql.Ref

com.alibaba.druid.proxy.jdbc.ResultSetProxyImpl

com.bleujin.framework.db.rowset.CachedRowSet

com.bleujin.framework.db.rowset.SQLInputImpl

com.ipc.oce.jdbc.OCEResultSet

com.jolbox.bonecp.TestPoolUtil

com.mysql.jdbc.CallableStatement

net.sourceforge.squirrel_sql.plugins.dbcopy.util.DBUtil

org.apache.commons.dbutils.wrappers.SqlNullCheckedResultSetTest

org.apache.derby.client.am.ClientCallableStatement

org.apache.derby.client.am.ClientResultSet

All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.