org.jooq.util.postgres
Class PostgresFactory

java.lang.Object
  org.jooq.impl.Factory
      org.jooq.util.postgres.PostgresFactory

All Implemented Interfaces:

Serializable, Configuration, FactoryOperations

public class PostgresFactory
extends Factory

A SQLDialect.POSTGRES specific factory

Author:

Lukas Eder

See Also:

Serialized Form

Constructor Summary

PostgresFactory()
Create a connection-less factory Without a connection, this factory cannot execute queries.

PostgresFactory(Connection connection)
Create a factory with connection

PostgresFactory(Connection connection, SchemaMapping mapping)
Deprecated. - 2.0.5 - Use PostgresFactory(Connection, Settings) instead

PostgresFactory(Connection connection, Settings settings)
Create a factory with connection and a settings configured

PostgresFactory(DataSource dataSource)
Create a factory with a data source

PostgresFactory(DataSource dataSource, Settings settings)
Create a factory with a data source and a settings configured

PostgresFactory(Settings settings)
Create a factory with settings configured Without a connection, this factory cannot execute queries.

Method Summary

Methods inherited from class org.jooq.impl.Factory

abs, abs, acos, acos, ascii, ascii, asin, asin, atan, atan, atan2, atan2, atan2, atan2, attach, attach, avg, avgDistinct, batch, batch, batch, batchStore, batchStore, bind, bindContext, bitAnd, bitAnd, bitAnd, bitAnd, bitCount, bitCount, bitLength, bitLength, bitNand, bitNand, bitNand, bitNand, bitNor, bitNor, bitNor, bitNor, bitNot, bitNot, bitOr, bitOr, bitOr, bitOr, bitXNor, bitXNor, bitXNor, bitXNor, bitXor, bitXor, bitXor, bitXor, cast, cast, cast, castNull, castNull, castNull, ceil, ceil, charLength, charLength, coalesce, coalesce, commit, concat, concat, condition, condition, condition, connectByIsCycle, connectByIsLeaf, connectByRoot, cos, cos, cosh, cosh, cot, cot, coth, coth, count, count, countDistinct, cube, cumeDist, currentDate, currentTime, currentTimestamp, currentUser, currval, dateAdd, dateAdd, dateDiff, dateDiff, dateDiff, dateDiff, day, day, decode, decode, decode, decode, decode, deg, deg, delete, deleteQuery, denseRank, e, escape, escape, execute, execute, execute, executeDelete, executeDelete, executeDelete, executeDelete, executeDeleteOne, executeDeleteOne, executeInsert, executeInsert, executeUpdate, executeUpdate, executeUpdate, executeUpdate, executeUpdateOne, executeUpdateOne, exists, exp, exp, extract, extract, falseCondition, fetch, fetch, fetch, fetch, fetch, fetch, fetchAny, fetchFromCSV, fetchFromCSV, fetchLazy, fetchLazy, fetchLazy, fetchLazy, fetchMany, fetchMany, fetchMany, fetchOne, fetchOne, fetchOne, fetchOne, fetchOne, field, field, field, field, field, field, field, field, field, fieldByName, fieldByName, fieldByName, firstValue, floor, floor, function, function, getAutoCommit, getConnection, getData, getData, getDataSource, getDataType, getDialect, getHoldability, getSchemaMapping, getSettings, getTransactionIsolation, greatest, greatest, groupConcat, groupConcatDistinct, grouping, groupingId, groupingSets, groupingSets, groupingSets, hour, hour, inline, inline, inline, inline, inline, inline, inline, insertInto, insertInto, insertInto, insertInto, insertQuery, lag, lag, lag, lag, lastID, lastValue, lead, lead, lead, lead, least, least, length, length, level, listAgg, listAgg, literal, literal, literal, ln, ln, loadInto, log, log, lower, lower, lpad, lpad, lpad, lpad, lpad, ltrim, ltrim, max, maxDistinct, median, mergeInto, mergeInto, mergeInto, min, minDistinct, minute, minute, month, month, name, newRecord, newRecord, newRecord, nextval, not, notExists, ntile, nullif, nullif, nullif, nullif, nullSafe, nullSafe, nullSafeDataType, nvl, nvl, nvl, nvl, nvl2, nvl2, nvl2, nvl2, octetLength, octetLength, one, param, param, param, param, percentRank, pi, position, position, position, position, power, power, power, power, prior, query, query, query, rad, rad, rand, rank, releaseSavepoint, render, renderContext, renderInlined, renderNamedParams, repeat, repeat, repeat, repeat, replace, replace, replace, replace, resultQuery, resultQuery, resultQuery, rollback, rollback, rollup, round, round, round, round, rowNumber, rpad, rpad, rpad, rpad, rpad, rtrim, rtrim, second, second, select, select, selectCount, selectDistinct, selectDistinct, selectFrom, selectOne, selectQuery, selectQuery, selectZero, setAutoCommit, setConnection, setData, setDataSource, setHoldability, setSavepoint, setSavepoint, setTransactionIsolation, shl, shl, shl, shl, shr, shr, shr, shr, sign, sign, sin, sin, sinh, sinh, sqrt, sqrt, stddevPop, stddevSamp, substring, substring, substring, substring, sum, sumDistinct, sysConnectByPath, table, table, table, table, table, table, table, tableByName, tan, tan, tanh, tanh, timestampAdd, timestampAdd, timestampDiff, timestampDiff, timestampDiff, timestampDiff, toString, trim, trim, trueCondition, trunc, trunc, trunc, trunc, trunc, truncate, two, unnest, unnest, unnest, unnest, update, updateQuery, upper, upper, use, use, val, val, val, val, vals, value, value, value, value, varPop, varSamp, year, year, zero

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, wait, wait, wait

Constructor Detail

PostgresFactory

@Deprecated
public PostgresFactory(Connection connection,
                                  SchemaMapping mapping)

Deprecated. - 2.0.5 - Use PostgresFactory(Connection, Settings) instead

Create a factory with connection and a schema mapping configured

Parameters:

connection - The connection to use with objects created from this factory

mapping - The schema mapping to use with objects created from this factory

PostgresFactory

public PostgresFactory(Connection connection,
                       Settings settings)

Create a factory with connection and a settings configured

Parameters:

connection - The connection to use with objects created from this factory

settings - The runtime settings to apply to objects created from this factory

PostgresFactory

public PostgresFactory(DataSource dataSource,
                       Settings settings)

Create a factory with a data source and a settings configured

Parameters:

dataSource - The data source to use with objects created from this factory

settings - The runtime settings to apply to objects created from this factory

PostgresFactory

public PostgresFactory(Connection connection)

Create a factory with connection

Parameters:

connection - The connection to use with objects created from this factory

PostgresFactory

public PostgresFactory(DataSource dataSource)

Create a factory with a data source

Parameters:

dataSource - The data source to use with objects created from this factory

PostgresFactory

public PostgresFactory(Settings settings)

Create a factory with settings configured

Without a connection, this factory cannot execute queries. Use it to render SQL only.

Parameters:

settings - The runtime settings to apply to objects created from this factory

PostgresFactory

public PostgresFactory()

Create a connection-less factory

Without a connection, this factory cannot execute queries. Use it to render SQL only.