xxDBC
The xxDBC Object alows you to connect to a local or remote Database for executing commands and Queries. Actually there are three different connections:
- ODBC (Windows)
- ORACLE (Windows, Linux)
- DB2 (Windows, Linux)
Constructor
var connection = new xxDBC();
Properties
| Property | Description |
|---|---|
| DataSource | Specifies the logical name of database connection associated with this object, this is the name specified in the XX/1 main configuration xxscfg.xml. If this property is not set, the default as defined in the XX/1 main configuration applies. |
Methods
| Method | Description |
|---|---|
| Open | Opens the connection to the database |
| Close | Closes an existing database connection |
| GetLastError | Retrieves the last error which occurred on a connection |
| ExecuteQuery | Executes the specified SQL statement and returns an xxResultSet object |
| ExecuteUpdate | Executes an SQL statement which results in update of database |