| java.lang.Object
 com.salmonllc.sql.DSDataSourceJDBC
All known Subclasses: com.salmonllc.sql.DSDataSourceFireBird, com.salmonllc.sql.DSDataSourceSybase, com.salmonllc.sql.DSDataSourcePostGres, com.salmonllc.sql.DSDataSourceANSISQL92, com.salmonllc.sql.DSDataSourceIngres, com.salmonllc.sql.DSDataSourceDB2MVS, com.salmonllc.sql.DSDataSourceDB2400, com.salmonllc.sql.DSDataSourceDB2, com.salmonllc.sql.DSDataSourceDB2VSE, com.salmonllc.sql.DSDataSourceOracle, com.salmonllc.sql.DSDataSourceMySql,
| Constructor Summary | |
| public | DSDataSourceJDBC()
DSSQLDataSource constructor comment. |
| Method Summary | |
| public void | cancel()
This method was created in VisualAge. | | public boolean | deleteRow(DataStore ds, DataStoreRow row, DBConnection conn)
deleteRow method comment. | | public String | exportAsSQL(DataStore ds, DBConnection conn, String separator)
This method takes the SQL INSERT statements that would have been
generated to add these rows to the database, and, rather than executing
them, returns them as a string that can be written to a SQL script file. | | public String | fixCRLF(String s, String concatOperator)
| | protected String | fixDashes(String source)
| | static String | formatDateTime(Timestamp t, SimpleDateFormat f, DBConnection conn)
| | protected String | generatePrepStmt(DBConnection conn, DataStore ds)
| | public String | generateProc(DBConnection conn, DataStore ds)
| | abstract public String | generateSelect(DataStore ds, String criteria, boolean countOnly)
| | SimpleDateFormat | getDateTimeFormat()
| | public ResultSetMetaData | getMetaData()
This method was created in VisualAge. | | public String | getSelect()
This method was created in VisualAge. | | public boolean | insertRow(DataStore ds, DataStoreRow row, DBConnection conn)
insertRow method comment. | | protected void | populateAutoIncrementValue(DataStoreRow row, DBConnection conn, int colNo)
Called by SOFIA to find an auto-generated Primary Key after it does an
Insert. | | public void | postRetrieve(DataStore ds)
postRetrieve method comment. | | public void | postUpdate(DataStore ds, DBConnection conn, boolean handleTrans, boolean updateSuccessful)
postUpdate method comment. | | public boolean | preRetrieve(DataStore ds, String criteria, boolean countOnly, DBConnection conn)
preRetrieve method comment. | | public boolean | preUpdate(DataStore ds, DBConnection conn, boolean handleTrans)
preUpdate method comment. | | static void | prepareForType(DataStore ds, PreparedStatement pst, Object data, int type, int pos)
This method was created in VisualAge. | | public boolean | retrieveRow(DataStore ds, DataStoreRow row)
retrieveRow method comment. | | void | setParms(StoredProcedureParms p)
| | public void | setProc(String proc, StoredProcedureParms p)
| | void | setSelType(int iSelType)
| | public void | setSelect(String sel)
| | public boolean | updateRow(DataStore ds, DataStoreRow row, DBConnection conn)
|
| SEL_GEN_PREP_STMT | | final public static int SEL_GEN_PREP_STMT(Code) | | |
| SEL_GEN_PROC | | final public static int SEL_GEN_PROC(Code) | | |
| SEL_GEN_SELECT | | final public static int SEL_GEN_SELECT(Code) | | |
| SEL_PREP_STMT | | final public static int SEL_PREP_STMT(Code) | | |
| SEL_STATIC | | final public static int SEL_STATIC(Code) | | |
| _autoIncrementCol | | protected int _autoIncrementCol(Code) | | |
| _fixDashes | | protected boolean _fixDashes(Code) | | |
| _selType | | protected int _selType(Code) | | |
| DSDataSourceJDBC | | public DSDataSourceJDBC()(Code) | | DSSQLDataSource constructor comment.
|
| cancel | | public void cancel() throws Exception(Code) | | This method was created in VisualAge.
|
| exportAsSQL | | public String exportAsSQL(DataStore ds, DBConnection conn, String separator)(Code) | | This method takes the SQL INSERT statements that would have been
generated to add these rows to the database, and, rather than executing
them, returns them as a string that can be written to a SQL script file.
|
| getSelect | | public String getSelect()(Code) | | This method was created in VisualAge.
java.lang.String |
| populateAutoIncrementValue | | protected void populateAutoIncrementValue(DataStoreRow row, DBConnection conn, int colNo)(Code) | | Called by SOFIA to find an auto-generated Primary Key after it does an
Insert. Note that you must call setAutoIncrement(pkey_col, true) and
setUpdatable(pkey_col, false) for autogenerated pkeys to work. The
default implementation of this method is null, and must be overridden on
a per-database basis because of the lamentable lack of standardization on
how to retrieve the pkey of an autonumbered row after inserting it.
|
| setSelType | | void setSelType(int iSelType)(Code) | | |
|
|