eu.slipo.athenarc.triplegeo.db

Class OracleDbConnector

java.lang.Object

eu.slipo.athenarc.triplegeo.db.OracleDbConnector

All Implemented Interfaces:

DbConnector

public class OracleDbConnector
extends java.lang.Object
implements DbConnector

Oracle implementation of DbConnector class.

Version:

2.0

Author:

Kostas Patroumpas

Field Summary

Fields

Modifier and Type	Field and Description
private java.sql.Connection	connection
private java.lang.String	dbName
private java.lang.String	encoding
private java.lang.String	host
private java.lang.String	password
private int	port
private java.lang.String	username

Constructor Summary

Constructors

Constructor and Description
OracleDbConnector(java.lang.String host, int port, java.lang.String dbName, java.lang.String username, java.lang.String password, java.lang.String encoding) Constructor of DbConnector implementation class for establishing a connection to an Oracle Spatial database.

Method Summary

Modifier and Type	Method and Description
void	closeConnection() Closes the connection to an Oracle Spatial database.
java.sql.ResultSet	executeQuery(java.lang.String query) Returns the result of the SQL query executed against the Oracle Spatial database.
java.lang.String	getDatabaseUrl() Returns the Database URL.
private java.sql.Connection	openConnection() Establishes a connection to an Oracle Spatial database.

Methods inherited from class java.lang.Object

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

Field Detail

host

private java.lang.String host

port

private int port

dbName

private java.lang.String dbName

username

private java.lang.String username

password

private java.lang.String password

encoding

private java.lang.String encoding

connection

private java.sql.Connection connection

Constructor Detail

OracleDbConnector

public OracleDbConnector(java.lang.String host,
                         int port,
                         java.lang.String dbName,
                         java.lang.String username,
                         java.lang.String password,
                         java.lang.String encoding)

Constructor of DbConnector implementation class for establishing a connection to an Oracle Spatial database.

Parameters:

host - The IP of the machine where the database is hosted.

port - The port where the database is listening.

dbName - The name of the database to connect to.

username - The user name credential to access the database.

password - The password credential to access the database.

encoding - The character encoding used in the database.

Method Detail

getDatabaseUrl

public java.lang.String getDatabaseUrl()

Returns the Database URL.

Specified by:

getDatabaseUrl in interface DbConnector

Returns:

databaseUrl with the URL of the Oracle Spatial database.

executeQuery

public java.sql.ResultSet executeQuery(java.lang.String query)

Returns the result of the SQL query executed against the Oracle Spatial database.

Specified by:

executeQuery in interface DbConnector

Parameters:

query - A SQL command for the SELECT query.

Returns:

Resultset with all results of the query.

closeConnection

public void closeConnection()

Closes the connection to an Oracle Spatial database.

Specified by:

closeConnection in interface DbConnector

openConnection

private java.sql.Connection openConnection()

Establishes a connection to an Oracle Spatial database.

Returns:

Connection to the database.