org.apache.ojb.broker.accesslayer
Class JdbcAccessImpl

java.lang.Object
  org.apache.ojb.broker.accesslayer.JdbcAccessImpl

All Implemented Interfaces:

JdbcAccess

public class JdbcAccessImpl

extends java.lang.Object

implements JdbcAccess

JdbcAccess is responsible for establishing performing SQL Queries against remote Databases. It hides all knowledge about JDBC from the BrokerImpl

Version:

$Id: JdbcAccessImpl.java 365204 2005-12-13 18:21:24Z arminw $

Author:

Thomas Mahler

Constructor Summary

JdbcAccessImpl(PersistenceBroker broker)
constructor is private, use getInstance to get the singleton instance of this class

Method Summary

void	executeDelete(ClassDescriptor cld, java.lang.Object obj) performs a DELETE operation against RDBMS.
void	executeDelete(Query query, ClassDescriptor cld) Performs a DELETE operation based on the given Query against RDBMS.
void	executeInsert(ClassDescriptor cld, java.lang.Object obj) performs an INSERT operation against RDBMS.
ResultSetAndStatement	executeQuery(Query query, ClassDescriptor cld) performs a SELECT operation against RDBMS.
ResultSetAndStatement	executeSQL(java.lang.String sqlStatement, ClassDescriptor cld, boolean scrollable) performs a SQL SELECT statement against RDBMS.
ResultSetAndStatement	executeSQL(java.lang.String sql, ClassDescriptor cld, ValueContainer[] values, boolean scrollable) performs a SQL SELECT statement against RDBMS.
void	executeUpdate(ClassDescriptor cld, java.lang.Object obj) performs an UPDATE operation against RDBMS.
int	executeUpdateSQL(java.lang.String sqlStatement, ClassDescriptor cld) performs a SQL UPDTE, INSERT or DELETE statement against RDBMS.
int	executeUpdateSQL(java.lang.String sqlStatement, ClassDescriptor cld, ValueContainer[] values1, ValueContainer[] values2) performs a SQL UPDTE, INSERT or DELETE statement against RDBMS.
java.lang.Object	materializeObject(ClassDescriptor cld, Identity oid) performs a primary key lookup operation against RDBMS and materializes an object from the resulting row.

Methods inherited from class java.lang.Object

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

Constructor Detail

JdbcAccessImpl

public JdbcAccessImpl(PersistenceBroker broker)

constructor is private, use getInstance to get the singleton instance of this class

Method Detail

executeDelete

public void executeDelete(ClassDescriptor cld,
                          java.lang.Object obj)
                   throws PersistenceBrokerException

performs a DELETE operation against RDBMS.

Specified by:

executeDelete in interface JdbcAccess

Parameters:

cld - ClassDescriptor providing mapping information.

obj - The object to be deleted.

Throws:

PersistenceBrokerException

executeDelete

public void executeDelete(Query query,
                          ClassDescriptor cld)
                   throws PersistenceBrokerException

Performs a DELETE operation based on the given Query against RDBMS.

Specified by:

executeDelete in interface JdbcAccess

Parameters:

query - the query string.

cld - ClassDescriptor providing JDBC information.

Throws:

PersistenceBrokerException

executeInsert

public void executeInsert(ClassDescriptor cld,
                          java.lang.Object obj)
                   throws PersistenceBrokerException

performs an INSERT operation against RDBMS.

Specified by:

executeInsert in interface JdbcAccess

Parameters:

obj - The Object to be inserted as a row of the underlying table.

cld - ClassDescriptor providing mapping information.

Throws:

PersistenceBrokerException

executeQuery

public ResultSetAndStatement executeQuery(Query query,
                                          ClassDescriptor cld)
                                   throws PersistenceBrokerException

performs a SELECT operation against RDBMS.

Specified by:

executeQuery in interface JdbcAccess

Parameters:

query - the query string.

cld - ClassDescriptor providing JDBC information.

Throws:

PersistenceBrokerException

executeSQL

public ResultSetAndStatement executeSQL(java.lang.String sqlStatement,
                                        ClassDescriptor cld,
                                        boolean scrollable)
                                 throws PersistenceBrokerException

Description copied from interface: JdbcAccess

performs a SQL SELECT statement against RDBMS.

Specified by:

executeSQL in interface JdbcAccess

Parameters:

sqlStatement - the query string.

cld - ClassDescriptor providing meta-information.

scrollable - Does this resultset need cursor control for operations like last, first and size

Throws:

PersistenceBrokerException

executeSQL

public ResultSetAndStatement executeSQL(java.lang.String sql,
                                        ClassDescriptor cld,
                                        ValueContainer[] values,
                                        boolean scrollable)
                                 throws PersistenceBrokerException

performs a SQL SELECT statement against RDBMS.

Specified by:

executeSQL in interface JdbcAccess

Parameters:

sql - the query string.

cld - ClassDescriptor providing meta-information.

values - The set of values to bind to the statement (may be null)

scrollable - Does this resultset need cursor control for operations like last, first and size

Throws:

PersistenceBrokerException

executeUpdateSQL

public int executeUpdateSQL(java.lang.String sqlStatement,
                            ClassDescriptor cld)
                     throws PersistenceBrokerException

Description copied from interface: JdbcAccess

performs a SQL UPDTE, INSERT or DELETE statement against RDBMS.

Specified by:

executeUpdateSQL in interface JdbcAccess

Parameters:

sqlStatement - the query string.

cld - ClassDescriptor providing meta-information.

Returns:

int returncode

Throws:

PersistenceBrokerException

executeUpdateSQL

public int executeUpdateSQL(java.lang.String sqlStatement,
                            ClassDescriptor cld,
                            ValueContainer[] values1,
                            ValueContainer[] values2)
                     throws PersistenceBrokerException

performs a SQL UPDTE, INSERT or DELETE statement against RDBMS.

Specified by:

executeUpdateSQL in interface JdbcAccess

Parameters:

sqlStatement - the query string.

cld - ClassDescriptor providing meta-information.

values1 - The first set of values to bind to the statement (may be null)

values2 - The second set of values to bind to the statement (may be null)

Returns:

int returncode

Throws:

PersistenceBrokerException

executeUpdate

public void executeUpdate(ClassDescriptor cld,
                          java.lang.Object obj)
                   throws PersistenceBrokerException

performs an UPDATE operation against RDBMS.

Specified by:

executeUpdate in interface JdbcAccess

Parameters:

obj - The Object to be updated in the underlying table.

cld - ClassDescriptor providing mapping information.

Throws:

PersistenceBrokerException

materializeObject

public java.lang.Object materializeObject(ClassDescriptor cld,
                                          Identity oid)
                                   throws PersistenceBrokerException

performs a primary key lookup operation against RDBMS and materializes an object from the resulting row. Only skalar attributes are filled from the row, references are not resolved.

Specified by:

materializeObject in interface JdbcAccess

Parameters:

oid - contains the primary key info.

cld - ClassDescriptor providing mapping information.

Returns:

the materialized object, null if no matching row was found or if any error occured.

Throws:

PersistenceBrokerException