clearSessionVariablesOnCommit
void sqlDataManager.clearSessionVariablesOnCommit ( boolean clearVars ) (professional and enterprise editions only)
Description
Clear session variables corresponding to a committed table automatically.
Parameters
- clearVars If true then session variables whose names match field names (case insensitive) will be automatically cleared when the table is committed.
Return Values
Returns void.
Change Log
| Version | Description |
|---|---|
| 5.0 | Available for professional and enterprise editions. |
Examples
Automate Session Variables
// Import classes
import com.screenscraper.datamanager.*;
// Set Variables
host = "127.0.0.1:3306";
database = "mydb";
username = "user";
password = "pwrd";
parameters = null;
// Get MySQL data manager
dm = DataManagerFactory.getMySqlDataManager( session, host, database, username, password, parameters);
// Build Schemas For all Tables
dm.buildSchemas();
// Write Information to Database
// automatically using session variables
dm.addSessionVariablesOnCommit( true );
// Clear session variables on commit
// to avoid carry over
dm.clearSessionVariablesOnCommit( true );
import com.screenscraper.datamanager.*;
// Set Variables
host = "127.0.0.1:3306";
database = "mydb";
username = "user";
password = "pwrd";
parameters = null;
// Get MySQL data manager
dm = DataManagerFactory.getMySqlDataManager( session, host, database, username, password, parameters);
// Build Schemas For all Tables
dm.buildSchemas();
// Write Information to Database
// automatically using session variables
dm.addSessionVariablesOnCommit( true );
// Clear session variables on commit
// to avoid carry over
dm.clearSessionVariablesOnCommit( true );
scraper on 07/16/2010 at 5:22 pm
- Printer-friendly version
- Login or register to post comments