com.hardcode.gdbms.driver.postgresql
Class PostgreSQLDriver

java.lang.Object
  com.hardcode.gdbms.driver.postgresql.PostgreSQLDriver

All Implemented Interfaces:

com.hardcode.driverManager.Driver, AlphanumericDBDriver, DBDriver, GDBMSDriver, ReadAccess, TypeConverter, ValueWriter

public class PostgreSQLDriver
extends java.lang.Object
implements AlphanumericDBDriver

Field Summary

protected JDBCSupport

jdbcSupport

Fields inherited from interface com.hardcode.gdbms.engine.values.ValueWriter

internalValueWriter

Constructor Summary

PostgreSQLDriver()

Method Summary

java.lang.String	check(Field field, Value value) Checks if a given value is suitable for the specified field
void	close() Free any resource reserved in the open method
void	createSource(DBSource source, DriverMetadata driverMetadata) Creates a new table.
void	execute(java.sql.Connection con, java.lang.String sql) Executes an instruction against the server
java.lang.String[]	getAvailableTypes() Gets a string identificator for each type a field can have
java.sql.Connection	getConnection(java.lang.String host, int port, java.lang.String dbName, java.lang.String user, java.lang.String password) DOCUMENT ME!
DriverMetadata	getDriverMetadata() Gets the driver specific metadata
java.util.HashMap	getDriverProperties()
int	getFieldCount() DOCUMENT ME!
java.lang.String	getFieldName(int fieldId) DOCUMENT ME!
int	getFieldType(int i) DOCUMENT ME!
Value	getFieldValue(long rowIndex, int fieldId) DOCUMENT ME!
java.sql.ResultSetMetaData	getMetadata()
java.lang.String	getName()
java.lang.String	getNullStatementString() Gets the string of the binary param as it would appear in a SQL statement
java.lang.String[]	getParameters(java.lang.String driverType) Gets the parameters used in creating the type
long	getRowCount() DOCUMENT ME!
java.lang.String	getStatementString(boolean b) Gets the string of the binary param as it would appear in a SQL statement
java.lang.String	getStatementString(byte[] binary) Gets the string of the binary param as it would appear in a SQL statement
java.lang.String	getStatementString(java.sql.Date d) Gets the string of the param as it would appear in a SQL statement
java.lang.String	getStatementString(double d, int sqlType) Gets the string of the d param as it would appear in a SQL statement
java.lang.String	getStatementString(Geometry g) Gets the string representation of the geometry as it would appear in a SQL statement
java.lang.String	getStatementString(int i, int sqlType) Gets the string of the i param as it would appear in a SQL statement
java.lang.String	getStatementString(long i) Gets the string of the i param as it would appear in a SQL statement
java.lang.String	getStatementString(java.lang.String str, int sqlType) Gets the string of the str param as it would appear in a SQL statement
java.lang.String	getStatementString(java.sql.Time t) Gets the string of the param as it would appear in a SQL statement
java.lang.String	getStatementString(java.sql.Timestamp ts) Gets the string of the param as it would appear in a SQL statement
int	getType(java.lang.String driverType) Gets the suitable GDBMS type for the given driver specific type
java.lang.String	getTypeInAddColumnStatement(java.lang.String driverType, java.util.HashMap<java.lang.String,java.lang.String> params) Gets a statement to create the specified field on the given table
boolean	isReadOnly(int i) Returns true if the specified field is read only
boolean	isValidParameter(java.lang.String driverType, java.lang.String paramName, java.lang.String paramValue) Returns if the given value (paramValue) for the parameter called paramName of the given driver specific type is valid or not
void	open(java.sql.Connection con, java.lang.String tableName, java.lang.String orderFieldName) Connects to the data source and reads the specified table in the specified order
void	setDataSourceFactory(DataSourceFactory dsf)

Methods inherited from class java.lang.Object

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

Field Detail

jdbcSupport

protected JDBCSupport jdbcSupport

Constructor Detail

PostgreSQLDriver

public PostgreSQLDriver()

Method Detail

getConnection

public java.sql.Connection getConnection(java.lang.String host,
                                         int port,
                                         java.lang.String dbName,
                                         java.lang.String user,
                                         java.lang.String password)
                                  throws java.sql.SQLException

DOCUMENT ME!

Specified by:

getConnection in interface DBDriver

Parameters:

host - DOCUMENT ME!

port - DOCUMENT ME!

dbName - DOCUMENT ME!

user - DOCUMENT ME!

password - DOCUMENT ME!

Returns:

DOCUMENT ME!

Throws:

java.sql.SQLException

java.lang.RuntimeException - DOCUMENT ME!

See Also:

com.hardcode.gdbms.engine.data.driver.DBDriver#connect(java.lang.String)

getName

public java.lang.String getName()

Specified by:

getName in interface com.hardcode.driverManager.Driver

See Also:

Driver.getName()

open

public void open(java.sql.Connection con,
                 java.lang.String tableName,
                 java.lang.String orderFieldName)
          throws DriverException

Description copied from interface: AlphanumericDBDriver

Connects to the data source and reads the specified table in the specified order

Specified by:

open in interface AlphanumericDBDriver

Parameters:

con - Connection to use

tableName - Name of the table where the data is in

orderFieldName - Name of the order field. Can be null

Throws:

DriverException

See Also:

com.hardcode.gdbms.engine.data.driver.DBDriver#executeSQL(java.sql.Connection, java.lang.String)

getFieldCount

public int getFieldCount()
                  throws DriverException

DOCUMENT ME!

Returns:

DOCUMENT ME!

Throws:

DriverException - DOCUMENT ME!

getFieldName

public java.lang.String getFieldName(int fieldId)
                              throws DriverException

DOCUMENT ME!

Parameters:

fieldId - DOCUMENT ME!

Returns:

DOCUMENT ME!

Throws:

DriverException - DOCUMENT ME!

getFieldType

public int getFieldType(int i)
                 throws DriverException

DOCUMENT ME!

Parameters:

i - DOCUMENT ME!

Returns:

DOCUMENT ME!

Throws:

DriverException - DOCUMENT ME!

getFieldValue

public Value getFieldValue(long rowIndex,
                           int fieldId)
                    throws DriverException

DOCUMENT ME!

Specified by:

getFieldValue in interface ReadAccess

Parameters:

rowIndex - DOCUMENT ME!

fieldId - DOCUMENT ME!

Returns:

DOCUMENT ME!

Throws:

DriverException - DOCUMENT ME!

getRowCount

public long getRowCount()
                 throws DriverException

DOCUMENT ME!

Specified by:

getRowCount in interface ReadAccess

Returns:

DOCUMENT ME!

Throws:

DriverException - DOCUMENT ME!

close

public void close()
           throws DriverException

Description copied from interface: DBDriver

Free any resource reserved in the open method

Specified by:

close in interface DBDriver

Throws:

DriverException

See Also:

DBDriver.close()

getDriverProperties

public java.util.HashMap getDriverProperties()

See Also:

com.hardcode.gdbms.engine.data.driver.DriverCommons#getDriverProperties()

setDataSourceFactory

public void setDataSourceFactory(DataSourceFactory dsf)

Specified by:

setDataSourceFactory in interface GDBMSDriver

See Also:

com.hardcode.gdbms.engine.data.driver.DriverCommons#setDataSourceFactory(com.hardcode.gdbms.engine.data.DataSourceFactory)

execute

public void execute(java.sql.Connection con,
                    java.lang.String sql)
             throws java.sql.SQLException

Description copied from interface: DBDriver

Executes an instruction against the server

Specified by:

execute in interface DBDriver

Parameters:

con - Connection used to execute the instruction

sql - Instruction to execute

Throws:

java.sql.SQLException - If the execution fails

See Also:

com.hardcode.gdbms.engine.data.driver.DBDriver#execute(java.sql.Connection, java.lang.String, com.hardcode.gdbms.engine.data.HasProperties)

getStatementString

public java.lang.String getStatementString(long i)

Description copied from interface: ValueWriter

Gets the string of the i param as it would appear in a SQL statement

Specified by:

getStatementString in interface ValueWriter

Parameters:

i - long to format

Returns:

String

See Also:

ValueWriter.getStatementString(long)

getStatementString

public java.lang.String getStatementString(int i,
                                           int sqlType)

Description copied from interface: ValueWriter

Gets the string of the i param as it would appear in a SQL statement

Specified by:

getStatementString in interface ValueWriter

Parameters:

i - integer to format

sqlType - SQL type of the parameter. Any of the following java.sql.Types constants: INTEGER, SMALLINT, TINYINT

Returns:

String

See Also:

ValueWriter.getStatementString(int, int)

getStatementString

public java.lang.String getStatementString(double d,
                                           int sqlType)

Description copied from interface: ValueWriter

Gets the string of the d param as it would appear in a SQL statement

Specified by:

getStatementString in interface ValueWriter

Parameters:

d - double to format

sqlType - SQL type of the parameter. Any of the following java.sql.Types constants: DOUBLE, FLOAT, REAL, NUMERIC, DECIMAL

Returns:

String

See Also:

ValueWriter.getStatementString(double, int)

getStatementString

public java.lang.String getStatementString(java.lang.String str,
                                           int sqlType)

Description copied from interface: ValueWriter

Gets the string of the str param as it would appear in a SQL statement

Specified by:

getStatementString in interface ValueWriter

Parameters:

str - string to format

sqlType - SQL type of the parameter. Any of the following java.sql.Types constants: CHAR, VARCHAR, LONGVARCHAR

Returns:

String

See Also:

ValueWriter.getStatementString(java.lang.String, int)

getStatementString

public java.lang.String getStatementString(java.sql.Date d)

Description copied from interface: ValueWriter

Gets the string of the param as it would appear in a SQL statement

Specified by:

getStatementString in interface ValueWriter

Parameters:

d - Date to format

Returns:

String

See Also:

ValueWriter.getStatementString(java.sql.Date)

getStatementString

public java.lang.String getStatementString(java.sql.Time t)

Description copied from interface: ValueWriter

Gets the string of the param as it would appear in a SQL statement

Specified by:

getStatementString in interface ValueWriter

Parameters:

t - Time to format

Returns:

String

See Also:

ValueWriter.getStatementString(java.sql.Time)

getStatementString

public java.lang.String getStatementString(java.sql.Timestamp ts)

Description copied from interface: ValueWriter

Gets the string of the param as it would appear in a SQL statement

Specified by:

getStatementString in interface ValueWriter

Parameters:

ts - timestamp to format

Returns:

String

See Also:

ValueWriter.getStatementString(java.sql.Timestamp)

getStatementString

public java.lang.String getStatementString(byte[] binary)

Description copied from interface: ValueWriter

Gets the string of the binary param as it would appear in a SQL statement

Specified by:

getStatementString in interface ValueWriter

Parameters:

binary - byte array to format

Returns:

String

See Also:

ValueWriter.getStatementString(byte[])

getStatementString

public java.lang.String getStatementString(boolean b)

Description copied from interface: ValueWriter

Gets the string of the binary param as it would appear in a SQL statement

Specified by:

getStatementString in interface ValueWriter

Parameters:

b - byte array to format

Returns:

String

See Also:

ValueWriter.getStatementString(boolean)

getNullStatementString

public java.lang.String getNullStatementString()

Description copied from interface: ValueWriter

Gets the string of the binary param as it would appear in a SQL statement

Specified by:

getNullStatementString in interface ValueWriter

Returns:

String

See Also:

ValueWriter.getNullStatementString()

getMetadata

public java.sql.ResultSetMetaData getMetadata()
                                       throws java.sql.SQLException

Throws:

java.sql.SQLException

See Also:

com.hardcode.gdbms.engine.data.driver.DBDriver#getMetadata()

getStatementString

public java.lang.String getStatementString(Geometry g)

Description copied from interface: ValueWriter

Gets the string representation of the geometry as it would appear in a SQL statement

Specified by:

getStatementString in interface ValueWriter

Parameters:

g - Geometry

Returns:

String

See Also:

ValueWriter.getStatementString(com.hardcode.gdbms.engine.spatial.Geometry)

getDriverMetadata

public DriverMetadata getDriverMetadata()
                                 throws DriverException

Description copied from interface: GDBMSDriver

Gets the driver specific metadata

Specified by:

getDriverMetadata in interface GDBMSDriver

Returns:

Throws:

DriverException

See Also:

GDBMSDriver.getDriverMetadata()

getType

public int getType(java.lang.String driverType)

Description copied from interface: TypeConverter

Gets the suitable GDBMS type for the given driver specific type

Specified by:

getType in interface TypeConverter

Returns:

See Also:

TypeConverter.getType(java.lang.String)

getTypeInAddColumnStatement

public java.lang.String getTypeInAddColumnStatement(java.lang.String driverType,
                                                    java.util.HashMap<java.lang.String,java.lang.String> params)

Description copied from interface: DBDriver

Gets a statement to create the specified field on the given table

Specified by:

getTypeInAddColumnStatement in interface DBDriver

Returns:

getAvailableTypes

public java.lang.String[] getAvailableTypes()
                                     throws DriverException

Description copied from interface: GDBMSDriver

Gets a string identificator for each type a field can have

Specified by:

getAvailableTypes in interface GDBMSDriver

Returns:

Throws:

DriverException

getParameters

public java.lang.String[] getParameters(java.lang.String driverType)
                                 throws DriverException

Description copied from interface: GDBMSDriver

Gets the parameters used in creating the type

Specified by:

getParameters in interface GDBMSDriver

Returns:

Throws:

DriverException

createSource

public void createSource(DBSource source,
                         DriverMetadata driverMetadata)
                  throws DriverException

Description copied from interface: AlphanumericDBDriver

Creates a new table. The source argument provides information about the name of the table to be created and the host, port and database where the table has to be created

Specified by:

createSource in interface AlphanumericDBDriver

Throws:

DriverException - TODO

check

public java.lang.String check(Field field,
                              Value value)
                       throws DriverException

Description copied from interface: GDBMSDriver

Checks if a given value is suitable for the specified field

Specified by:

check in interface GDBMSDriver

Returns:

Throws:

DriverException

isReadOnly

public boolean isReadOnly(int i)
                   throws DriverException

Description copied from interface: GDBMSDriver

Returns true if the specified field is read only

Specified by:

isReadOnly in interface GDBMSDriver

Returns:

Throws:

DriverException

isValidParameter

public boolean isValidParameter(java.lang.String driverType,
                                java.lang.String paramName,
                                java.lang.String paramValue)

Description copied from interface: GDBMSDriver

Returns if the given value (paramValue) for the parameter called paramName of the given driver specific type is valid or not

Specified by:

isValidParameter in interface GDBMSDriver

paramValue - null if the parameter is not specified

Returns: