DBEngine (Class)

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.

isFDA

Returns true if the database is accessed through FDA.

isBroken

Returns true if the connection is no longer usable.

useUnicodeData

Returns true if the database contains unicode data.

useNChar

Returns true if Adobe Campaign uses NCHAR, NVARCHAR, NCLOB, NTEXT type fields.

Features

Available in:

  • Content management
  • Delivery properties
  • Typology rule
  • JSSP
  • SOAP Method
  • WebApp
  • Workflow