|
|||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | ||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |
java.lang.Object isc.sensor.outputadaptor.oaextensions.SimpleSinkSQLGenerator
public class SimpleSinkSQLGenerator
This SimpleSinkSQLGenerator works with SQLSink to provide support for non-stored procedure databases like MySQL. Unfortunilty Open Adaptor 1.7.1 has a brain dead support for MySql via SQLSink and SimpleSinkSQLGenerator. This file has been copied and modified from the original 1.7.1 code.
Interface that defines a class that can generate SQL for inserting/updating a database
,
org.openadaptor.adaptor.sql.SimpleSQLGenerator
Nested Class Summary | |
---|---|
(package private) class |
SimpleSinkSQLGenerator.SQLTemplate
helper class to hold parameterised SQL statement and to generate actual SQL given a DataObject |
(package private) class |
SimpleSinkSQLGenerator.TypeTransformer
|
Field Summary | |
---|---|
(package private) java.util.Hashtable |
_attn_transformers
|
(package private) org.openadaptor.dataobjects.DOPredicate[] |
_predicates
array of predicates to check |
(package private) java.util.Hashtable |
_sql_templates
maping between predicate and SQL string arrays |
(package private) static java.lang.String |
NO_TYPE
|
Constructor Summary | |
---|---|
SimpleSinkSQLGenerator()
|
Method Summary | |
---|---|
java.lang.String[] |
getSQL(org.openadaptor.dataobjects.DataObject dob)
|
void |
init(java.util.Properties props,
java.lang.String prefix)
Called at init time |
boolean |
isAddAutoQuotes()
|
static boolean |
isSDOTypeNumeric(org.openadaptor.dataobjects.SDOType type)
Deprecated. |
void |
setAutoAddQuotes(java.lang.String bool_str)
|
Methods inherited from class java.lang.Object |
---|
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait |
Field Detail |
---|
static java.lang.String NO_TYPE
org.openadaptor.dataobjects.DOPredicate[] _predicates
java.util.Hashtable _sql_templates
java.util.Hashtable _attn_transformers
Constructor Detail |
---|
public SimpleSinkSQLGenerator()
Method Detail |
---|
public void setAutoAddQuotes(java.lang.String bool_str) throws org.openadaptor.adaptor.IbafException
bool_str
-
org.openadaptor.adaptor.IbafException
public static boolean isSDOTypeNumeric(org.openadaptor.dataobjects.SDOType type) throws java.lang.NullPointerException
type
- SDO type to evaluate
java.lang.NullPointerException
public void init(java.util.Properties props, java.lang.String prefix) throws org.openadaptor.adaptor.IbafException
init
in interface org.openadaptor.adaptor.jdbc.SinkSQLGenerator
org.openadaptor.adaptor.IbafException
public java.lang.String[] getSQL(org.openadaptor.dataobjects.DataObject dob) throws org.openadaptor.dataobjects.DataObjectException
getSQL
in interface org.openadaptor.adaptor.jdbc.SinkSQLGenerator
org.openadaptor.dataobjects.DataObjectException
public boolean isAddAutoQuotes()
|
|||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | ||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |