com.hardcode.gdbms.driver.hsqldb
Class HSQLDBDriver

java.lang.Object
  com.hardcode.gdbms.driver.hsqldb.HSQLDBDriver

All Implemented Interfaces:

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

Direct Known Subclasses:

HSQLDBTransactionalDriver

public class HSQLDBDriver
extends java.lang.Object
implements AlphanumericDBDriver

DOCUMENT ME!

Author:

Fernando González Cortés

Field Summary

protected JDBCSupport

jdbcSupport

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

internalValueWriter

Constructor Summary

HSQLDBDriver()

Method Summary

java.lang.String	check(Field f, 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) Método mediante el cual el driver surte de conexiones a la base de datos.
DriverMetadata	getDriverMetadata() Gets the driver specific metadata
java.util.HashMap	getDriverProperties()
int	getFieldCount()
java.lang.String	getFieldName(int fieldId)
int	getFieldType(int i)
Value	getFieldValue(long rowIndex, int fieldId) Obtiene el valor que se encuentra en la fila y columna indicada
java.sql.ResultSetMetaData	getMetadata()
java.lang.String	getName()
java.lang.String	getNullStatementString() DOCUMENT ME!
java.lang.String[]	getParameters(java.lang.String driverType) Gets the parameters used in creating the type
long	getRowCount() Obtiene el número de registros del DataSource
java.lang.String	getStatementString(boolean b) DOCUMENT ME!
java.lang.String	getStatementString(byte[] binary) DOCUMENT ME!
java.lang.String	getStatementString(java.sql.Date d) DOCUMENT ME!
java.lang.String	getStatementString(double d, int sqlType) DOCUMENT ME!
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) DOCUMENT ME!
java.lang.String	getStatementString(long i) DOCUMENT ME!
java.lang.String	getStatementString(java.lang.String str, int sqlType) DOCUMENT ME!
java.lang.String	getStatementString(java.sql.Time t) DOCUMENT ME!
java.lang.String	getStatementString(java.sql.Timestamp ts) DOCUMENT ME!
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

HSQLDBDriver

public HSQLDBDriver()

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

Description copied from interface: DBDriver

Método mediante el cual el driver surte de conexiones a la base de datos.

Specified by:

getConnection in interface DBDriver

Parameters:

host - nombre o dirección IP del host al que se quiere conectar

port - puerto al que se quiere conectar. -1 si es el puerto por defecto

dbName - Nombre de la base de datos a la que se quiere conectar

user - Usuario de la conexión

password - Password del usuario

Returns:

Connection

Throws:

java.sql.SQLException - Si se produce algún error

See Also:

DBDriver.getConnection(java.lang.String, int, java.lang.String, java.lang.String, java.lang.String)

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#open(java.sql.Connection, java.lang.String, com.hardcode.gdbms.engine.data.HasProperties)

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)

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()

getFieldValue

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

Description copied from interface: ReadAccess

Obtiene el valor que se encuentra en la fila y columna indicada

Specified by:

getFieldValue in interface ReadAccess

Parameters:

rowIndex - fila

fieldId - columna

Returns:

subclase de Value con el valor del origen de datos. Never null (use ValueFactory.createNullValue() instead)

Throws:

DriverException - Si se produce un error accediendo al DataSource

See Also:

ReadAccess.getFieldValue(long, int)

getFieldCount

public int getFieldCount()
                  throws DriverException

Throws:

DriverException

See Also:

com.hardcode.gdbms.engine.data.driver.ReadAccess#getFieldCount()

getFieldName

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

Throws:

DriverException

See Also:

com.hardcode.gdbms.engine.data.driver.ReadAccess#getFieldName(int)

getRowCount

public long getRowCount()
                 throws DriverException

Description copied from interface: ReadAccess

Obtiene el número de registros del DataSource

Specified by:

getRowCount in interface ReadAccess

Returns:

Throws:

DriverException - Si se produce algún error accediendo al DataSource

See Also:

ReadAccess.getRowCount()

getFieldType

public int getFieldType(int i)
                 throws DriverException

Throws:

DriverException

See Also:

com.hardcode.gdbms.engine.data.driver.ReadAccess#getFieldType(int)

getName

public java.lang.String getName()

Specified by:

getName in interface com.hardcode.driverManager.Driver

See Also:

Driver.getName()

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)

getNullStatementString

public java.lang.String getNullStatementString()

DOCUMENT ME!

Specified by:

getNullStatementString in interface ValueWriter

Returns:

DOCUMENT ME!

getStatementString

public java.lang.String getStatementString(boolean b)

DOCUMENT ME!

Specified by:

getStatementString in interface ValueWriter

Parameters:

b - DOCUMENT ME!

Returns:

DOCUMENT ME!

getStatementString

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

DOCUMENT ME!

Specified by:

getStatementString in interface ValueWriter

Parameters:

binary - DOCUMENT ME!

Returns:

DOCUMENT ME!

getStatementString

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

DOCUMENT ME!

Specified by:

getStatementString in interface ValueWriter

Parameters:

d - DOCUMENT ME!

Returns:

DOCUMENT ME!

getStatementString

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

DOCUMENT ME!

Specified by:

getStatementString in interface ValueWriter

Parameters:

d - DOCUMENT ME!

sqlType - DOCUMENT ME!

Returns:

DOCUMENT ME!

getStatementString

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

DOCUMENT ME!

Specified by:

getStatementString in interface ValueWriter

Parameters:

i - DOCUMENT ME!

sqlType - DOCUMENT ME!

Returns:

DOCUMENT ME!

getStatementString

public java.lang.String getStatementString(long i)

DOCUMENT ME!

Specified by:

getStatementString in interface ValueWriter

Parameters:

i - DOCUMENT ME!

Returns:

DOCUMENT ME!

getStatementString

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

DOCUMENT ME!

Specified by:

getStatementString in interface ValueWriter

Parameters:

str - DOCUMENT ME!

sqlType - DOCUMENT ME!

Returns:

DOCUMENT ME!

getStatementString

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

DOCUMENT ME!

Specified by:

getStatementString in interface ValueWriter

Parameters:

t - DOCUMENT ME!

Returns:

DOCUMENT ME!

getStatementString

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

DOCUMENT ME!

Specified by:

getStatementString in interface ValueWriter

Parameters:

ts - DOCUMENT ME!

Returns:

DOCUMENT ME!

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:

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 f,
                              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: