DBEngine
Represents a database connection.
This object enables you to query the database and perform related operations.
Most methods in this class require 'sql' rights. If the operator invokes a method and does not have the appropriate rights, an exception is raised. Generally speaking, all methods that change the database require 'sql' rights, while methods which simply view information do not. Refer to the documentation on each method to find out whether or not the rights are required.
Methods
| batchDelete | Deletes the records of a table by packets. |
| dispose | Frees the connection from all resources linked to it. |
| execute | Executes a SQL command. |
| exec | Alias of the execute command. This function is obsolete, use execute() |
| query | Executes a SELECT type SQL query. |
| queryWithTypes | Executes a SELECT type SQL query with column type specification. |
| begin | Starts a new transaction on the connection. |
| commit | Approves the transaction in progress on the connection. |
| rollback | Cancels the transaction in progress on the connection. |
Properties
| isOracle | Returns true if the database is Oracle. |
| isDB2 | Returns true if the database is of DB2 type. |
| isMySQL | Returns true if the database is of MySQL type. |
| isMSSQL | Returns true if the database is SQL Server. |
| isPostgreSQL | Returns true if the database is PostgreSQL. |
| isSybase | Returns true if the database is Sybase. |
| isSybaseIQ | Returns true if the database is Sybase IQ. |
| isBroken | Returns true if the connection is no longer usable. |
| useUnicodeData | Returns true if the database contains unicode data. |
| useNChar | Returns true if Neolane uses NCHAR, NVARCHAR, NCLOB, NTEXT type fields. |
Features
Available in:
- Content management
- Delivery properties
- Typology rule
- JSSP
- SOAP Method
- WebApp
- Workflow