| Package | Description | 
|---|---|
| org.jooq | The  org.jooqpackage contains jOOQ's public API. | 
| org.jooq.impl | The  org.jooq.implpackage contains jOOQ's implementation classes. | 
| org.jooq.tools | The  org.jooq.toolspackage contains jOOQ's public utilities. | 
| Modifier and Type | Class and Description | 
|---|---|
| class  | Converters<T,U>A chain of converters. | 
| Modifier and Type | Method and Description | 
|---|---|
| Converter<T,U> | Binding. converter()A converter that can convert between the database type and the custom
 type. | 
| Converter<?,T> | SelectField. getConverter()The field's underlying  Converter. | 
| Converter<?,T> | Parameter. getConverter()The parameter's underlying  Converter. | 
| Converter<?,T> | Field. getConverter()The field's underlying  Converter. | 
| Converter<?,T> | DataType. getConverter()Get the converter associated with this data type. | 
| static <T> Converter<T,T> | Converters. identity(Class<T> type)Create an identity converter. | 
| static <T,U> Converter<U,T> | Converters. inverse(Converter<T,U> converter)Inverse a converter. | 
| static <T,U> Converter<T,U> | Converters. of()Create an identity converter. | 
| static <T,U> Converter<T,U> | Converters. of(Converter<T,U> converter)Create a single converter. | 
| static <T,X1,U> Converter<T,U> | Converters. of(Converter<T,X1> c1,
  Converter<X1,U> c2)Chain two converters. | 
| static <T,X1,X2,U> | Converters. of(Converter<T,X1> c1,
  Converter<X1,X2> c2,
  Converter<X2,U> c3)Chain three converters. | 
| static <T,X1,X2,X3,U> | Converters. of(Converter<T,X1> c1,
  Converter<X1,X2> c2,
  Converter<X2,X3> c3,
  Converter<X3,U> c4)Chain four converters. | 
| <T,U> Converter<T,U> | ConverterProvider. provide(Class<T> tType,
       Class<U> uType)Deprecated.  Provide a converter that can convert between  <T>and<U>types. | 
| Modifier and Type | Method and Description | 
|---|---|
| <U> DataType<U> | DataType. asConvertedDataType(Converter<? super T,U> converter)Retrieve the data type for a given converter. | 
| <T> BindingSQLContext<T> | BindingSQLContext. convert(Converter<T,U> converter)Create a new context from this one using a converter. | 
| <T> BindingSetStatementContext<T> | BindingSetStatementContext. convert(Converter<T,U> converter)Create a new context from this one using a converter. | 
| <T> BindingSetSQLOutputContext<T> | BindingSetSQLOutputContext. convert(Converter<T,U> converter)Create a new context from this one using a converter. | 
| <T> BindingRegisterContext<T> | BindingRegisterContext. convert(Converter<T,U> converter)Create a new context from this one using a converter. | 
| <T> BindingGetStatementContext<T> | BindingGetStatementContext. convert(Converter<T,U> converter)Create a new context from this one using a converter. | 
| <T> BindingGetSQLInputContext<T> | BindingGetSQLInputContext. convert(Converter<T,U> converter)Create a new context from this one using a converter. | 
| <T> BindingGetResultSetContext<T> | BindingGetResultSetContext. convert(Converter<T,U> converter)Create a new context from this one using a converter. | 
| <T,U> List<U> | ResultQuery. fetch(Field<T> field,
     Converter<? super T,U> converter)Execute the query and return all values for a field from the generated
 result. | 
| <U> List<U> | ResultQuery. fetch(int fieldIndex,
     Converter<?,U> converter)Execute the query and return all values for a field index from the
 generated result. | 
| <U> List<U> | ResultQuery. fetch(Name fieldName,
     Converter<?,U> converter)Execute the query and return all values for a field name from the
 generated result. | 
| <U> List<U> | ResultQuery. fetch(String fieldName,
     Converter<?,U> converter)Execute the query and return all values for a field name from the
 generated result. | 
| <T,U> U | ResultQuery. fetchAny(Field<T> field,
        Converter<? super T,U> converter)Execute the query and return at most one resulting value for a
 field from the generated result. | 
| <U> U | ResultQuery. fetchAny(int fieldIndex,
        Converter<?,U> converter)Execute the query and return at most one resulting value for a
 field index from the generated result. | 
| <U> U | ResultQuery. fetchAny(Name fieldName,
        Converter<?,U> converter)Execute the query and return at most one resulting value for a
 field name from the generated result. | 
| <U> U | ResultQuery. fetchAny(String fieldName,
        Converter<?,U> converter)Execute the query and return at most one resulting value for a
 field name from the generated result. | 
| <T,U> U[] | ResultQuery. fetchArray(Field<T> field,
          Converter<? super T,U> converter)Execute the query and return all values for a field from the generated
 result. | 
| <U> U[] | ResultQuery. fetchArray(int fieldIndex,
          Converter<?,U> converter)Execute the query and return all values for a field index from the
 generated result. | 
| <U> U[] | ResultQuery. fetchArray(Name fieldName,
          Converter<?,U> converter)Execute the query and return all values for a field name from the
 generated result. | 
| <U> U[] | ResultQuery. fetchArray(String fieldName,
          Converter<?,U> converter)Execute the query and return all values for a field name from the
 generated result. | 
| <T,U> U | ResultQuery. fetchOne(Field<T> field,
        Converter<? super T,U> converter)Execute the query and return at most one resulting value for a
 field from the generated result. | 
| <U> U | ResultQuery. fetchOne(int fieldIndex,
        Converter<?,U> converter)Execute the query and return at most one resulting value for a
 field index from the generated result. | 
| <U> U | ResultQuery. fetchOne(Name fieldName,
        Converter<?,U> converter)Execute the query and return at most one resulting value for a
 field name from the generated result. | 
| <U> U | ResultQuery. fetchOne(String fieldName,
        Converter<?,U> converter)Execute the query and return at most one resulting value for a
 field name from the generated result. | 
| <T,U> Optional<U> | ResultQuery. fetchOptional(Field<T> field,
             Converter<? super T,U> converter)Execute the query and return at most one resulting value for a
 field from the generated result. | 
| <U> Optional<U> | ResultQuery. fetchOptional(int fieldIndex,
             Converter<?,U> converter)Execute the query and return at most one resulting value for a
 field index from the generated result. | 
| <U> Optional<U> | ResultQuery. fetchOptional(Name fieldName,
             Converter<?,U> converter)Execute the query and return at most one resulting value for a
 field name from the generated result. | 
| <U> Optional<U> | ResultQuery. fetchOptional(String fieldName,
             Converter<?,U> converter)Execute the query and return at most one resulting value for a
 field name from the generated result. | 
| <T,U> Set<U> | ResultQuery. fetchSet(Field<T> field,
        Converter<? super T,U> converter)Execute the query and return all values for a field from the generated
 result. | 
| <U> Set<U> | ResultQuery. fetchSet(int fieldIndex,
        Converter<?,U> converter)Execute the query and return all values for a field index from the
 generated result. | 
| <U> Set<U> | ResultQuery. fetchSet(Name fieldName,
        Converter<?,U> converter)Execute the query and return all values for a field name from the
 generated result. | 
| <U> Set<U> | ResultQuery. fetchSet(String fieldName,
        Converter<?,U> converter)Execute the query and return all values for a field name from the
 generated result. | 
| <T,U> U | Record. getValue(Field<T> field,
        Converter<? super T,U> converter)Get a converted value from this Record, providing a field. | 
| <T,U> U | Record. getValue(Field<T> field,
        Converter<? super T,U> converter,
        U defaultValue)Deprecated. 
 - 3.3.0 - [#2878] - This method will be removed in jOOQ 4.0 | 
| <U> U | Record. getValue(int index,
        Converter<?,U> converter)Get a converted value from this record, providing a field index. | 
| <U> U | Record. getValue(int index,
        Converter<?,U> converter,
        U defaultValue)Deprecated. 
 - 3.3.0 - [#2878] - This method will be removed in jOOQ 4.0 | 
| <U> U | Record. getValue(Name fieldName,
        Converter<?,U> converter)Get a converted value from this Record, providing a field name. | 
| <U> U | Record. getValue(String fieldName,
        Converter<?,U> converter)Get a converted value from this Record, providing a field name. | 
| <U> U | Record. getValue(String fieldName,
        Converter<?,U> converter,
        U defaultValue)Deprecated. 
 - 3.3.0 - [#2878] - This method will be removed in jOOQ 4.0 | 
| <T,U> List<U> | Result. getValues(Field<T> field,
         Converter<? super T,U> converter)Convenience method to fetch all values for a given field. | 
| <U> List<U> | Result. getValues(int fieldIndex,
         Converter<?,U> converter)Convenience method to fetch all values for a given field. | 
| <U> List<U> | Result. getValues(Name fieldName,
         Converter<?,U> converter)Convenience method to fetch all values for a given field. | 
| <U> List<U> | Result. getValues(String fieldName,
         Converter<?,U> converter)Convenience method to fetch all values for a given field. | 
| <T,U> U[] | Result. intoArray(Field<T> field,
         Converter<? super T,U> converter)Return all values for a field from the result. | 
| <U> U[] | Result. intoArray(int fieldIndex,
         Converter<?,U> converter)Return all values for a field index from the result. | 
| <U> U[] | Result. intoArray(Name fieldName,
         Converter<?,U> converter)Return all values for a field name from the result. | 
| <U> U[] | Result. intoArray(String fieldName,
         Converter<?,U> converter)Return all values for a field name from the result. | 
| <T,U> Set<U> | Result. intoSet(Field<T> field,
       Converter<? super T,U> converter)Return all values for a field from the result. | 
| <U> Set<U> | Result. intoSet(int fieldIndex,
       Converter<?,U> converter)Return all values for a field index from the result. | 
| <U> Set<U> | Result. intoSet(Name fieldName,
       Converter<?,U> converter)Return all values for a field name from the result. | 
| <U> Set<U> | Result. intoSet(String fieldName,
       Converter<?,U> converter)Return all values for a field name from the result. | 
| static <T,U> Converter<U,T> | Converters. inverse(Converter<T,U> converter)Inverse a converter. | 
| static <T,U> Converter<T,U> | Converters. of(Converter<T,U> converter)Create a single converter. | 
| static <T,X1,U> Converter<T,U> | Converters. of(Converter<T,X1> c1,
  Converter<X1,U> c2)Chain two converters. | 
| static <T,X1,U> Converter<T,U> | Converters. of(Converter<T,X1> c1,
  Converter<X1,U> c2)Chain two converters. | 
| static <T,X1,X2,U> | Converters. of(Converter<T,X1> c1,
  Converter<X1,X2> c2,
  Converter<X2,U> c3)Chain three converters. | 
| static <T,X1,X2,U> | Converters. of(Converter<T,X1> c1,
  Converter<X1,X2> c2,
  Converter<X2,U> c3)Chain three converters. | 
| static <T,X1,X2,U> | Converters. of(Converter<T,X1> c1,
  Converter<X1,X2> c2,
  Converter<X2,U> c3)Chain three converters. | 
| static <T,X1,X2,X3,U> | Converters. of(Converter<T,X1> c1,
  Converter<X1,X2> c2,
  Converter<X2,X3> c3,
  Converter<X3,U> c4)Chain four converters. | 
| static <T,X1,X2,X3,U> | Converters. of(Converter<T,X1> c1,
  Converter<X1,X2> c2,
  Converter<X2,X3> c3,
  Converter<X3,U> c4)Chain four converters. | 
| static <T,X1,X2,X3,U> | Converters. of(Converter<T,X1> c1,
  Converter<X1,X2> c2,
  Converter<X2,X3> c3,
  Converter<X3,U> c4)Chain four converters. | 
| static <T,X1,X2,X3,U> | Converters. of(Converter<T,X1> c1,
  Converter<X1,X2> c2,
  Converter<X2,X3> c3,
  Converter<X3,U> c4)Chain four converters. | 
| <T,U> void | Record. setValue(Field<T> field,
        U value,
        Converter<T,? super U> converter)Set a value into this record. | 
| Modifier and Type | Class and Description | 
|---|---|
| class  | AbstractConverter<T,U> | 
| class  | EnumConverter<T,U extends Enum<U>>A base class for enum conversion. | 
| Modifier and Type | Method and Description | 
|---|---|
| Converter<Object,Node> | XMLasDOMBinding. converter() | 
| Converter<T,U> | DefaultBinding. converter() | 
| Converter<Timestamp,Timestamp> | DateAsTimestampBinding. converter() | 
| Converter<String,String> | ClobBinding. converter() | 
| Converter<byte[],byte[]> | BlobBinding. converter() | 
| Converter<Object,T> | AbstractXMLasObjectBinding. converter() | 
| Converter<?,T> | DefaultDataType. getConverter() | 
| <T,U> Converter<T,U> | DefaultConverterProvider. provide(Class<T> tType,
       Class<U> uType)Deprecated.  | 
| Modifier and Type | Method and Description | 
|---|---|
| <T,U> void | DefaultConverterProvider. add(Converter<T,U> converter)Deprecated.  | 
| <U> DataType<U> | DefaultDataType. asConvertedDataType(Converter<? super T,U> converter) | 
| protected static <R extends UDTRecord<R>,T,U> | UDTImpl. createField(String name,
           DataType<T> type,
           UDT<R> udt,
           String comment,
           Converter<T,U> converter)Subclasses may call this method to create  UDTFieldobjects that
 are linked to this table. | 
| protected static <R extends UDTRecord<R>,T,X,U> | UDTImpl. createField(String name,
           DataType<T> type,
           UDT<R> udt,
           String comment,
           Converter<X,U> converter,
           Binding<T,X> binding)Subclasses may call this method to create  UDTFieldobjects that
 are linked to this table. | 
| protected static <T,U> Parameter<U> | AbstractRoutine. createParameter(String name,
               DataType<T> type,
               boolean isDefaulted,
               Converter<T,U> converter)Subclasses may call this method to create  UDTFieldobjects that
 are linked to this table. | 
| protected static <T,X,U> Parameter<U> | AbstractRoutine. createParameter(String name,
               DataType<T> type,
               boolean isDefaulted,
               Converter<X,U> converter,
               Binding<T,X> binding)Subclasses may call this method to create  UDTFieldobjects that
 are linked to this table. | 
| Constructor and Description | 
|---|
| AbstractRoutine(String name,
               Schema schema,
               DataType<X> type,
               Converter<X,T> converter) | 
| AbstractRoutine(String name,
               Schema schema,
               DataType<X> type,
               Converter<Y,T> converter,
               Binding<X,Y> binding) | 
| AbstractRoutine(String name,
               Schema schema,
               Package pkg,
               DataType<X> type,
               Converter<X,T> converter) | 
| AbstractRoutine(String name,
               Schema schema,
               Package pkg,
               DataType<X> type,
               Converter<Y,T> converter,
               Binding<X,Y> binding) | 
| ArrayRecordImpl(Schema schema,
               String name,
               DataType<X> type,
               Configuration configuration,
               Converter<X,T> converter)Deprecated. 
 - 3.4.0 - [#3126] - Use the
              ArrayRecordImpl.ArrayRecordImpl(Schema, String, DataType, Converter)constructor instead. | 
| ArrayRecordImpl(Schema schema,
               String name,
               DataType<X> type,
               Configuration configuration,
               Converter<Y,T> converter,
               Binding<X,Y> binding)Deprecated. 
 - 3.4.0 - [#3126] - Use the
              ArrayRecordImpl.ArrayRecordImpl(Schema, String, DataType, Converter)constructor instead. | 
| ArrayRecordImpl(Schema schema,
               String name,
               DataType<X> type,
               Converter<X,T> converter)Create an empty array record | 
| ArrayRecordImpl(Schema schema,
               String name,
               DataType<X> type,
               Converter<Y,T> converter,
               Binding<X,Y> binding)Create an empty array record | 
| DefaultBinding(Converter<T,U> converter) | 
| Modifier and Type | Method and Description | 
|---|---|
| static <U> List<U> | Convert. convert(Collection<?> collection,
       Converter<?,U> converter)Convert a collection of objects to a list of  T, usingConvert.convert(Object, Converter) | 
| static <U> U | Convert. convert(Object from,
       Converter<?,U> converter)Convert an object to a type. | 
| static <U> U[] | Convert. convertArray(Object[] from,
            Converter<?,U> converter)Convert an array into another one using a converter
 
 This uses  Convert.convertArray(Object[], Class)to convert the array to
 an array offromType()first, before converting that
 array again totoType() | 
Copyright © 2016. All Rights Reserved.