org.javaWebGen.data
Class OracleDataManager

java.lang.Object
  org.javaWebGen.data.OracleDataManager

All Implemented Interfaces:

DataManager

public class OracleDataManager
extends java.lang.Object
implements DataManager

Handles talking to an oracle database. This has not been tested much because I do not have oracle installed. This should work! SOMEDAY It will use Oracle Sequence tables for the next value stuff.

Field Summary

java.lang.String	BIG_DECIMAL
java.lang.String	DATE
java.lang.String	INT
java.lang.String	LONG
java.lang.String	OBJECT
java.lang.String	STRING
java.lang.String	TIMESTAMP

Constructor Summary

OracleDataManager()

Method Summary

void	close(java.sql.Connection con) close this connection ignoring any errors
void	endTransaction(java.sql.Connection con) end Db tranacton commiting any uncommited data
java.lang.String	formatDate(java.util.Date date) get a String that the Oracle data will accept
java.sql.Connection	getConnection() get db connection
java.util.Date	getDate(java.lang.String dateStr) get a date object by parsing a string the databases native format useful for doing updates etc..
int	getNextValue(java.sql.Connection con, java.lang.String tablename) get next value for the primary key
int	getNextValue(java.lang.String tablename) get next value for the primary key
Sequence	getSequence()
java.lang.String	getSqlText(java.lang.String text) get a String that is escaped (handles ') Oracle likes '' not \'
java.lang.String[]	getTableList() EXPERIMENTAL returns a list of tables
void	init()
void	rollbackTransaction(java.sql.Connection con) rollback uncommited data ignoring any errors
void	setReader(PropertiesReader propReader)
void	setSequence(Sequence seq) Use this sequence generator NOTE this should not be used by a calling class
void	startTransaction(java.sql.Connection con) start Db tranacton

Methods inherited from class java.lang.Object

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

Field Detail

BIG_DECIMAL

public final java.lang.String BIG_DECIMAL

See Also:

Constant Field Values

LONG

public final java.lang.String LONG

See Also:

Constant Field Values

INT

public final java.lang.String INT

See Also:

Constant Field Values

STRING

public final java.lang.String STRING

See Also:

Constant Field Values

OBJECT

public final java.lang.String OBJECT

See Also:

Constant Field Values

DATE

public final java.lang.String DATE

See Also:

Constant Field Values

TIMESTAMP

public final java.lang.String TIMESTAMP

See Also:

Constant Field Values

Constructor Detail

OracleDataManager

public OracleDataManager()

Method Detail

setReader

public void setReader(PropertiesReader propReader)

Specified by:

setReader in interface DataManager

getSequence

public Sequence getSequence()

Specified by:

getSequence in interface DataManager

setSequence

public void setSequence(Sequence seq)

Description copied from interface: DataManager

Use this sequence generator NOTE this should not be used by a calling class

Specified by:

setSequence in interface DataManager

Parameters:

seq - sequence object

init

public void init()

Specified by:

init in interface DataManager

getConnection

public java.sql.Connection getConnection()
                                  throws java.sql.SQLException

Description copied from interface: DataManager

get db connection

Specified by:

getConnection in interface DataManager

Throws:

java.sql.SQLException

close

public void close(java.sql.Connection con)

Description copied from interface: DataManager

close this connection ignoring any errors

Specified by:

close in interface DataManager

Parameters:

con - db connection

getNextValue

public int getNextValue(java.lang.String tablename)
                 throws DBException

Description copied from interface: DataManager

get next value for the primary key

Specified by:

getNextValue in interface DataManager

Parameters:

tablename - table name

Throws:

DBException

getNextValue

public int getNextValue(java.sql.Connection con,
                        java.lang.String tablename)
                 throws java.sql.SQLException

Description copied from interface: DataManager

get next value for the primary key

Specified by:

getNextValue in interface DataManager

Parameters:

con - db connection

tablename - table name

Throws:

java.sql.SQLException

startTransaction

public void startTransaction(java.sql.Connection con)
                      throws java.sql.SQLException

Description copied from interface: DataManager

start Db tranacton

Specified by:

startTransaction in interface DataManager

Parameters:

con - db connection

Throws:

java.sql.SQLException

endTransaction

public void endTransaction(java.sql.Connection con)
                    throws java.sql.SQLException

Description copied from interface: DataManager

end Db tranacton commiting any uncommited data

Specified by:

endTransaction in interface DataManager

Parameters:

con - db connection

Throws:

java.sql.SQLException

rollbackTransaction

public void rollbackTransaction(java.sql.Connection con)

Description copied from interface: DataManager

rollback uncommited data ignoring any errors

Specified by:

rollbackTransaction in interface DataManager

Parameters:

con - db connection

formatDate

public java.lang.String formatDate(java.util.Date date)

get a String that the Oracle data will accept

Specified by:

formatDate in interface DataManager

Parameters:

date - to convert

Returns:

date string the database understands

getDate

public java.util.Date getDate(java.lang.String dateStr)
                       throws java.text.ParseException

get a date object by parsing a string the databases native format useful for doing updates etc.. when not using databean objects oracle uses DD-MMM-YYYY by default

Specified by:

getDate in interface DataManager

Parameters:

dateStr - date text

Returns:

formatted string of the date

Throws:

java.text.ParseException

getSqlText

public java.lang.String getSqlText(java.lang.String text)

get a String that is escaped (handles ') Oracle likes '' not \'

Specified by:

getSqlText in interface DataManager

Parameters:

text - input text

Returns:

sql text

getTableList

public java.lang.String[] getTableList()
                                throws java.sql.SQLException

EXPERIMENTAL returns a list of tables

Specified by:

getTableList in interface DataManager

Returns:

list of current tables

Throws:

java.sql.SQLException