xmlBlaster 2.1.0 API

org.xmlBlaster.test.contrib.replication
Class SpecificHelper

java.lang.Object
  extended by 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()

xmlBlaster 2.1.0 API

Copyright © 1999-2011 The xmlBlaster.org contributers.