com.jdbwc.util
Class PgSQLTypes

java.lang.Object
  extended by com.jdbwc.util.PgSQLTypes

public class PgSQLTypes
extends java.lang.Object

PostgtreSQL types.

Version:
2008-05-29
Author:
Tim Gall (Oz-DevWorX)

Field Summary
static int BIT
           
static int BIT_ARRAY
           
static int BOOL
           
static int BOOL_ARRAY
           
static int BPCHAR
           
static int BPCHAR_ARRAY
           
static int BYTEA
           
static int BYTEA_ARRAY
           
static int CHAR
           
static int CHAR_ARRAY
           
static int DATE
           
static int DATE_ARRAY
           
static int FLOAT4
           
static int FLOAT4_ARRAY
           
static int FLOAT8
           
static int FLOAT8_ARRAY
           
static int INT2
           
static int INT2_ARRAY
           
static int INT4
           
static int INT4_ARRAY
           
static int INT8
           
static int INT8_ARRAY
           
static int INTERVAL
           
static int INTERVAL_ARRAY
           
protected static long LENGTH_BLOB
           
protected static long LENGTH_LONGBLOB
           
protected static long LENGTH_MEDIUMBLOB
           
protected static long LENGTH_TINYBLOB
           
protected static int MAX_ROWS
           
static int MONEY
           
static int MONEY_ARRAY
           
static int NAME
           
static int NAME_ARRAY
           
protected static int NO_CHARSET_INFO
          Used to indicate that the server sent no field-level character set information, so the driver should use the connection-level character encoding instead.
static int NUMERIC
           
static int NUMERIC_ARRAY
           
static int OID
           
static int OID_ARRAY
           
protected static byte OPEN_CURSOR_FLAG
           
static int TEXT
           
static int TEXT_ARRAY
           
static int TIME
           
static int TIME_ARRAY
           
static int TIMESTAMP
           
static int TIMESTAMP_ARRAY
           
static int TIMESTAMPTZ
           
static int TIMESTAMPTZ_ARRAY
           
static int TIMETZ
           
static int TIMETZ_ARRAY
           
static int UNSPECIFIED
           
static int VARBIT
           
static int VARBIT_ARRAY
           
static int VARCHAR
           
static int VARCHAR_ARRAY
           
static int VOID
           
 
Constructor Summary
PgSQLTypes()
           
 
Method Summary
static java.lang.String pgsqlNameToJdbcName(java.lang.String pgsqlType)
           
static int pgsqlNameToType(java.lang.String pgsqlType)
          Maps the given PgSQL type name to the correct PgSQL type.
static int pgsqlToJavaType(int pgsqlType)
          Maps the given PgSQL type to the correct JDBC type.
static int pgsqlToJavaType(java.lang.String pgsqlType)
          Maps the given MySQL type to the correct JDBC type.
static java.lang.String pgSqlTypeToJavaTypeName(int pgsqlType)
           
static java.lang.String typeToName(int pgsqlType)
           
 
Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait
 

Field Detail

UNSPECIFIED

public static final int UNSPECIFIED
See Also:
Constant Field Values

INT2

public static final int INT2
See Also:
Constant Field Values

INT2_ARRAY

public static final int INT2_ARRAY
See Also:
Constant Field Values

INT4

public static final int INT4
See Also:
Constant Field Values

INT4_ARRAY

public static final int INT4_ARRAY
See Also:
Constant Field Values

INT8

public static final int INT8
See Also:
Constant Field Values

INT8_ARRAY

public static final int INT8_ARRAY
See Also:
Constant Field Values

TEXT

public static final int TEXT
See Also:
Constant Field Values

TEXT_ARRAY

public static final int TEXT_ARRAY
See Also:
Constant Field Values

NUMERIC

public static final int NUMERIC
See Also:
Constant Field Values

NUMERIC_ARRAY

public static final int NUMERIC_ARRAY
See Also:
Constant Field Values

FLOAT4

public static final int FLOAT4
See Also:
Constant Field Values

FLOAT4_ARRAY

public static final int FLOAT4_ARRAY
See Also:
Constant Field Values

FLOAT8

public static final int FLOAT8
See Also:
Constant Field Values

FLOAT8_ARRAY

public static final int FLOAT8_ARRAY
See Also:
Constant Field Values

BOOL

public static final int BOOL
See Also:
Constant Field Values

BOOL_ARRAY

public static final int BOOL_ARRAY
See Also:
Constant Field Values

DATE

public static final int DATE
See Also:
Constant Field Values

DATE_ARRAY

public static final int DATE_ARRAY
See Also:
Constant Field Values

TIME

public static final int TIME
See Also:
Constant Field Values

TIME_ARRAY

public static final int TIME_ARRAY
See Also:
Constant Field Values

TIMETZ

public static final int TIMETZ
See Also:
Constant Field Values

TIMETZ_ARRAY

public static final int TIMETZ_ARRAY
See Also:
Constant Field Values

TIMESTAMP

public static final int TIMESTAMP
See Also:
Constant Field Values

TIMESTAMP_ARRAY

public static final int TIMESTAMP_ARRAY
See Also:
Constant Field Values

TIMESTAMPTZ

public static final int TIMESTAMPTZ
See Also:
Constant Field Values

TIMESTAMPTZ_ARRAY

public static final int TIMESTAMPTZ_ARRAY
See Also:
Constant Field Values

BYTEA

public static final int BYTEA
See Also:
Constant Field Values

BYTEA_ARRAY

public static final int BYTEA_ARRAY
See Also:
Constant Field Values

VARCHAR

public static final int VARCHAR
See Also:
Constant Field Values

VARCHAR_ARRAY

public static final int VARCHAR_ARRAY
See Also:
Constant Field Values

OID

public static final int OID
See Also:
Constant Field Values

OID_ARRAY

public static final int OID_ARRAY
See Also:
Constant Field Values

BPCHAR

public static final int BPCHAR
See Also:
Constant Field Values

BPCHAR_ARRAY

public static final int BPCHAR_ARRAY
See Also:
Constant Field Values

MONEY

public static final int MONEY
See Also:
Constant Field Values

MONEY_ARRAY

public static final int MONEY_ARRAY
See Also:
Constant Field Values

NAME

public static final int NAME
See Also:
Constant Field Values

NAME_ARRAY

public static final int NAME_ARRAY
See Also:
Constant Field Values

BIT

public static final int BIT
See Also:
Constant Field Values

BIT_ARRAY

public static final int BIT_ARRAY
See Also:
Constant Field Values

VOID

public static final int VOID
See Also:
Constant Field Values

INTERVAL

public static final int INTERVAL
See Also:
Constant Field Values

INTERVAL_ARRAY

public static final int INTERVAL_ARRAY
See Also:
Constant Field Values

CHAR

public static final int CHAR
See Also:
Constant Field Values

CHAR_ARRAY

public static final int CHAR_ARRAY
See Also:
Constant Field Values

VARBIT

public static final int VARBIT
See Also:
Constant Field Values

VARBIT_ARRAY

public static final int VARBIT_ARRAY
See Also:
Constant Field Values

LENGTH_BLOB

protected static final long LENGTH_BLOB
See Also:
Constant Field Values

LENGTH_LONGBLOB

protected static final long LENGTH_LONGBLOB
See Also:
Constant Field Values

LENGTH_MEDIUMBLOB

protected static final long LENGTH_MEDIUMBLOB
See Also:
Constant Field Values

LENGTH_TINYBLOB

protected static final long LENGTH_TINYBLOB
See Also:
Constant Field Values

MAX_ROWS

protected static final int MAX_ROWS
See Also:
Constant Field Values

NO_CHARSET_INFO

protected static final int NO_CHARSET_INFO
Used to indicate that the server sent no field-level character set information, so the driver should use the connection-level character encoding instead.

See Also:
Constant Field Values

OPEN_CURSOR_FLAG

protected static final byte OPEN_CURSOR_FLAG
See Also:
Constant Field Values
Constructor Detail

PgSQLTypes

public PgSQLTypes()
Method Detail

pgsqlNameToJdbcName

public static java.lang.String pgsqlNameToJdbcName(java.lang.String pgsqlType)

pgsqlNameToType

public static int pgsqlNameToType(java.lang.String pgsqlType)
Maps the given PgSQL type name to the correct PgSQL type.


pgsqlToJavaType

public static int pgsqlToJavaType(int pgsqlType)
Maps the given PgSQL type to the correct JDBC type.


pgsqlToJavaType

public static int pgsqlToJavaType(java.lang.String pgsqlType)
Maps the given MySQL type to the correct JDBC type.


typeToName

public static java.lang.String typeToName(int pgsqlType)
Parameters:
pgsqlType - numeric type index
Returns:
String - the types name

pgSqlTypeToJavaTypeName

public static java.lang.String pgSqlTypeToJavaTypeName(int pgsqlType)
Parameters:
pgsqlType - numeric type index
Returns:
java Type name