Examples of org.hibernate.type.Type.nullSafeSet()

org.hibernate.type.Type.nullSafeSet()
Bind a value represented by an instance of the {@link #getReturnedClass() mapped class} to the JDBC preparedstatement, ignoring some columns as dictated by the 'settable' parameter. Implementors should handle the possibility of null values. A multi-column type should bind parameters starting from index. @param st The JDBC prepared statement to which to bind @param value the object to write @param index starting parameter bind index @param settable an array indicating which columns to bind/ignore @param session The originating session @throws HibernateException An error from Hibernate @throws SQLException An error from the JDBC driver

      PreparedStatement ps = session.getTransactionCoordinator()
          .getJdbcCoordinator()
          .getStatementPreparer()
          .prepareStatement( generateIdByUniqueKeySelectString( uniquePropertyName ) );
      try {
        propertyType.nullSafeSet( ps, key, 1, session );
        ResultSet rs = session.getTransactionCoordinator().getJdbcCoordinator().getResultSetReturn().extract( ps );
        try {
          //if there is no resulting row, return null
          if ( !rs.next() ) {
            return null;

View Full Code Here

        int loop = 0;
        for ( int idPosition : getNaturalIdentifierProperties() ) {
          final Object naturalIdValue = naturalIdValues[loop++];
          if ( naturalIdValue != null ) {
            final Type type = getPropertyTypes()[idPosition];
            type.nullSafeSet( ps, naturalIdValue, positions, session );
            positions += type.getColumnSpan( session.getFactory() );
          }
        }
        ResultSet rs = session.getTransactionCoordinator().getJdbcCoordinator().getResultSetReturn().extract( ps );
        try {

View Full Code Here

   */
  public int bind(PreparedStatement statement, QueryParameters qp, SessionImplementor session, int position) throws SQLException {
    Type type = qp.getPositionalParameterTypes()[hqlPosition];
    Object value = qp.getPositionalParameterValues()[hqlPosition];


    type.nullSafeSet( statement, value, position, session );
    return type.getColumnSpan( session.getFactory() );
  }


  public String renderDisplayInfo() {
    return "ordinal=" + hqlPosition + ", expectedType=" + getExpectedType();

View Full Code Here

        : queryParameters.getPositionalParameterTypes().length;
    int filterParamCount = filteredParamCount - nonfilteredParamCount;
    for ( int i = 0; i < filterParamCount; i++ ) {
      Type type = queryParameters.getFilteredPositionalParameterTypes()[i];
      Object value = queryParameters.getFilteredPositionalParameterValues()[i];
      type.nullSafeSet( st, value, position, session );
      position += type.getColumnSpan( getFactory() );
    }


    return position;
  }

View Full Code Here


                    // set REVEND = ?
                    final Number revisionNumber = auditCfg.getRevisionInfoNumberReader().getRevisionNumber(
                        revision
                    );
                    revisionInfoIdType.nullSafeSet(
                        preparedStatement, revisionNumber, index, sessionImplementor
                    );
                    index += revisionInfoIdType.getColumnSpan( sessionImplementor.getFactory() );


                    // set [, REVEND_TSTMP = ?]

View Full Code Here

                      final Object revEndTimestampObj = revisionTimestampGetter.get( revision );
                      final Date revisionEndTimestamp = convertRevEndTimestampToDate( revEndTimestampObj );
                      final Type revEndTsType = rootAuditedEntityQueryable.getPropertyType(
                          auditCfg.getAuditEntCfg().getRevisionEndTimestampFieldName()
                      );
                      revEndTsType.nullSafeSet(
                          preparedStatement, revisionEndTimestamp, index, sessionImplementor
                      );
                      index += revEndTsType.getColumnSpan( sessionImplementor.getFactory() );
                    }

View Full Code Here

                      index += revEndTsType.getColumnSpan( sessionImplementor.getFactory() );
                    }


                    // where (prod_ent_id) = ?
                    final Type idType = rootProductionEntityQueryable.getIdentifierType();
                    idType.nullSafeSet( preparedStatement, id, index, sessionImplementor );
                    index += idType.getColumnSpan( sessionImplementor.getFactory() );


                    // where REV <> ?
                    final Type revType = rootAuditedEntityQueryable.getPropertyType(
                        auditCfg.getAuditEntCfg().getRevisionNumberPath()

View Full Code Here


                    // where REV <> ?
                    final Type revType = rootAuditedEntityQueryable.getPropertyType(
                        auditCfg.getAuditEntCfg().getRevisionNumberPath()
                    );
                    revType.nullSafeSet( preparedStatement, revisionNumber, index, sessionImplementor );


                    // where REVEND is null
                    //     nothing to bind....


                    return sessionImplementor.getTransactionCoordinator()

View Full Code Here

      try {
        int positions = 1;
        int loop = 0;
        for ( int idPosition : getNaturalIdentifierProperties() ) {
          final Type type = getPropertyTypes()[idPosition];
          type.nullSafeSet( ps, naturalIdValues[loop++], positions, session );
          positions += type.getColumnSpan( session.getFactory() );
        }
        ResultSet rs = ps.executeQuery();
        try {
          // if there is no resulting row, return null

View Full Code Here

        : queryParameters.getPositionalParameterTypes().length;
    int filterParamCount = filteredParamCount - nonfilteredParamCount;
    for ( int i = 0; i < filterParamCount; i++ ) {
      Type type = queryParameters.getFilteredPositionalParameterTypes()[i];
      Object value = queryParameters.getFilteredPositionalParameterValues()[i];
      type.nullSafeSet( st, value, position, session );
      position += type.getColumnSpan( getFactory() );
    }


    return position;
  }

View Full Code Here

0 1 2 3 4 5 6 7 8 9

TOP

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.