org.xmlBlaster.test.contrib.replication
Class SpecificHelper

java.lang.Object
  org.xmlBlaster.test.contrib.replication.SpecificHelper

public final class SpecificHelper
extends java.lang.Object

Helper class for tests. Encapsulates all database specific stuff.

Author:

Michele Laghi

Field Summary

private java.lang.String	cascade
private java.lang.String	dbType
private static java.lang.String	ORACLE
private java.lang.String[]	oracleTypesSql For a detailed compatibility list for oracle look at: http://www.ss64.com/orasyntax/datatypes.html unknown to ora8.1.6: BINARY_FLOAT, BINARY_DOUBLE, CHAR(n BYTE), CHAR(n CHAR), TIMESTAMP, TIMESTAMP(n)..., ROWID, INTERVAL..
private static java.lang.String	POSTGRES
private java.lang.String[]	postgresTypesSql
private java.util.Properties	props
private java.lang.String[]	sql

Constructor Summary

SpecificHelper(java.util.Properties props)

Method Summary

java.lang.String	getCascade()
java.lang.String	getOwnSchema(I_DbPool pool)
java.util.Properties	getProperties()
java.lang.String[]	getSql(java.lang.String tableName)
void	informativeStuff(I_DbPool pool) If the table does not exist we expect a null ResultSet
boolean	isOracle()
boolean	isPostgres()
java.lang.String	replace(java.lang.String txt, java.util.Map map) Replaces all tokens found in the txt with the associated values found in the map.
private void	setDefaultProperty(java.util.Properties props, java.lang.String key, java.lang.String val)
private java.lang.String	setOracleDefault(java.util.Properties props)
private java.lang.String	setPostgresDefault(java.util.Properties props)

Methods inherited from class java.lang.Object

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

Field Detail

ORACLE

private static final java.lang.String ORACLE

See Also:

Constant Field Values

POSTGRES

private static final java.lang.String POSTGRES

See Also:

Constant Field Values

postgresTypesSql

private java.lang.String[] postgresTypesSql

oracleTypesSql

private java.lang.String[] oracleTypesSql

For a detailed compatibility list for oracle look at: http://www.ss64.com/orasyntax/datatypes.html unknown to ora8.1.6: BINARY_FLOAT, BINARY_DOUBLE, CHAR(n BYTE), CHAR(n CHAR), TIMESTAMP, TIMESTAMP(n)..., ROWID, INTERVAL.. UROWID should actually be supported but I get an exception when trying to read the column information out of a result set metadata: "ORA-03115: unsupported network datatype or representation"

See Also:

SqlInfo.fillMetadata(Connection, String,String,String,ResultSet,I_AttributeTransformer)

sql

private java.lang.String[] sql

dbType

private java.lang.String dbType

props

private java.util.Properties props

cascade

private java.lang.String cascade

Constructor Detail

SpecificHelper

public SpecificHelper(java.util.Properties props)
               throws java.lang.Exception

Throws:

java.lang.Exception

Method Detail

setDefaultProperty

private void setDefaultProperty(java.util.Properties props,
                                java.lang.String key,
                                java.lang.String val)

setOracleDefault

private java.lang.String setOracleDefault(java.util.Properties props)
                                   throws java.lang.Exception

Throws:

java.lang.Exception

setPostgresDefault

private java.lang.String setPostgresDefault(java.util.Properties props)

informativeStuff

public final void informativeStuff(I_DbPool pool)
                            throws java.lang.Exception

If the table does not exist we expect a null ResultSet

Throws:

java.lang.Exception - Any type is possible

getProperties

public java.util.Properties getProperties()

replace

public java.lang.String replace(java.lang.String txt,
                                java.util.Map map)

Replaces all tokens found in the txt with the associated values found in the map.

Parameters:

txt -

map -

Returns:

getSql

public java.lang.String[] getSql(java.lang.String tableName)

isOracle

public boolean isOracle()

isPostgres

public boolean isPostgres()

getOwnSchema

public java.lang.String getOwnSchema(I_DbPool pool)
                              throws java.lang.Exception

Throws:

java.lang.Exception

getCascade

public java.lang.String getCascade()