com.hfg.sql.jdbc.postgresql

Class PostgreSQL

java.lang.Object

com.hfg.sql.jdbc.RDBMS

com.hfg.sql.jdbc.postgresql.PostgreSQL

public class PostgreSQL
extends RDBMS

Home for PostgreSQL-specific RDBMS info.

Field Summary

Fields inherited from class com.hfg.sql.jdbc.RDBMS

PostgreSQL

Method Summary

Modifier and Type	Method and Description
DatabaseSequence	allocateSequence(java.lang.String inName)
PostgreSQLConnectionPool	establishConnectionPool(JDBCServer inServer, java.lang.String inDatabaseName, LoginCredentials inCredentials, JDBCConnectionPoolSettings inPoolSettings)
PostgreSQLConnection	getConnection(JDBCServer inServer, java.lang.String inDatabaseName, LoginCredentials inCredentials)
java.lang.String	getConnectString(JDBCServer inServer, java.lang.String inDatabaseName)
java.lang.String	getConnectString(JDBCServer inServer, java.lang.String inDatabaseName, JDBCConnectionSettings inSettings)
SQLQuery	getConnTestQuery()
static PostgreSQL	getInstance()
java.lang.Long	getLastGeneratedId(java.sql.Connection inConn, DatabaseCol inIdCol)
java.text.DateFormat	getSQLDateFormat(int inSQLType) Deprecated.
java.time.format.DateTimeFormatter	getSQLDateFormatter(int inSQLType)
PostgreSQL	setMaxInClauseArgs(int inValue) Since PostgreSQL doesn't have a hard limit for the number of in-clause arguments, the user is allowed to set a desired limit.
boolean	tableExists(java.sql.Connection inConn, Schema inSchema, java.lang.String inTablename)

Methods inherited from class com.hfg.sql.jdbc.RDBMS

getDefaultPort, getDriverClassName, getMaxIdentifierLength, getMaxInClauseArgs, name, setDefaultPort, setDriverClassName, setMaxIdentifierLength, toString

Methods inherited from class java.lang.Object

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

Method Detail

setMaxInClauseArgs

public PostgreSQL setMaxInClauseArgs(int inValue)

Since PostgreSQL doesn't have a hard limit for the number of in-clause arguments, the user is allowed to set a desired limit.

Overrides:

setMaxInClauseArgs in class RDBMS

Parameters:

inValue - the limit to use when generating SQL.

Returns:

this PostgreSQL object

getInstance

public static PostgreSQL getInstance()

getConnectString

public java.lang.String getConnectString(JDBCServer inServer,
                                         java.lang.String inDatabaseName)

Specified by:

getConnectString in class RDBMS

getConnectString

public java.lang.String getConnectString(JDBCServer inServer,
                                         java.lang.String inDatabaseName,
                                         JDBCConnectionSettings inSettings)

Specified by:

getConnectString in class RDBMS

establishConnectionPool

public PostgreSQLConnectionPool establishConnectionPool(JDBCServer inServer,
                                                        java.lang.String inDatabaseName,
                                                        LoginCredentials inCredentials,
                                                        JDBCConnectionPoolSettings inPoolSettings)

Specified by:

establishConnectionPool in class RDBMS

getConnection

public PostgreSQLConnection getConnection(JDBCServer inServer,
                                          java.lang.String inDatabaseName,
                                          LoginCredentials inCredentials)
                                   throws JDBCException

Throws:

JDBCException

getSQLDateFormat

@Deprecated
public java.text.DateFormat getSQLDateFormat(int inSQLType)

Deprecated.

Specified by:

getSQLDateFormat in class RDBMS

getSQLDateFormatter

public java.time.format.DateTimeFormatter getSQLDateFormatter(int inSQLType)

Specified by:

getSQLDateFormatter in class RDBMS

allocateSequence

public DatabaseSequence allocateSequence(java.lang.String inName)

Specified by:

allocateSequence in class RDBMS

getLastGeneratedId

public java.lang.Long getLastGeneratedId(java.sql.Connection inConn,
                                         DatabaseCol inIdCol)
                                  throws java.sql.SQLException

Specified by:

getLastGeneratedId in class RDBMS

Throws:

java.sql.SQLException

getConnTestQuery

public SQLQuery getConnTestQuery()

Specified by:

getConnTestQuery in class RDBMS

tableExists

public boolean tableExists(java.sql.Connection inConn,
                           Schema inSchema,
                           java.lang.String inTablename)
                    throws java.sql.SQLException

Specified by:

tableExists in class RDBMS

Throws:

java.sql.SQLException