MACROMEDIA COLDFUSION 5 - INSTALING AND CONFIGURING SERVER Manuale Utente Pagina 48

  • Scaricare
  • Aggiungi ai miei manuali
  • Stampa
  • Pagina
    / 170
  • Indice
  • SEGNALIBRI
  • Valutato. / 5. Basato su recensioni clienti
Vedere la pagina 47
48 Chapter 3: Data Source Management
Connection
String
A field that passes database-specific parameters, such as login credentials, to
the data source.
For UDB on the initial connection, specify DatabaseName,
CreateDefaultPackage, ReplacePackage, and
sendStringParametersAsUnicode (with no spaces), as the following example
shows:
DatabaseName=SAMPLE;CreateDefaultPackage=TRUE;ReplacePackage=TRUE;
sendStringParametersAsUnicode=false
If the database uses Unicode, specify true for the
sendStringParametersAsUnicode parameter.
For UDB on subsequent connections, specify DatabaseName and
sendStringParametersAsUnicode (with no spaces), as the following example
shows:
DatabaseName=SAMPLE;sendStringParametersAsUnicode=false
Your user ID must have CREATE PACKAGE privileges on the database, or your
database administrator must create a package for you.
Limit
Connections
Specifies whether ColdFusion MX limits the number of database connections for
the data source. If you enable this option, use the Restrict Connections To field to
specify the maximum.
Restrict
Connections To
Specifies the maximum number of database connections for the data source. To
use this restriction, you must enable the Limit Connections option.
Maintain
Connections
ColdFusion establishes a connection to a data source for every operation that
requires one. Enable this option to improve performance by caching the data
source connection.
Max Pooled
Statements
Enables reuse of prepared statements (that is, stored procedures and queries
that use the
cfqueryparam tag). Although you tune this setting based on your
application, start by setting it to the sum of the following:
Unique
cfquery tags that use the cfqueryparam tag
Unique
cfstoredproc tags
Timeout (min) The number of minutes that ColdFusion MX maintains an unused connection
before destroying it.
Interval (min) The time (in minutes) that the server waits between cycles to check for expired
data source connections to close.
Disable
Connections
If selected, suspends all client connections.
Login Timeout
(sec)
The number of seconds before ColdFusion times out the data source connection
login attempt.
CLOB Select to return the entire contents of any CLOB/Text columns in the database
for this data source. If unchecked, ColdFusion retrieves the number of characters
specified in the Long Text Buffer setting. For UDB 7.1 and 7.2, there is a 32K
limit on CLOBs.
BLOB Select to return the entire contents of any BLOB/Image columns in the database
for this data source. If unchecked, ColdFusion retrieves the number of characters
specified in the BLOB Buffer setting. BLOBs are not supported on UDB 7.1
and 7.2.
Setting Description
Vedere la pagina 47
1 2 ... 43 44 45 46 47 48 49 50 51 52 53 ... 169 170

Commenti su questo manuale

Nessun commento