MACROMEDIA COLDFUSION 4.5-ADMINISTRING COLDFUSION SERVER Technical Information Page 61
- Page / 174
- Table of contents
- TROUBLESHOOTING
- BOOKMARKS
Rated. / 5. Based on customer reviews
56
CONFIGURING AND ADMINISTERING COLDFUSION 9
Data Source Management
Last updated 2/21/2012
Connecting to Sybase
To see a list of Sybase versions that ColdFusion supports, go to www.adobe.com/go/learn_cfu_cfsysreqs_en. Use the
settings in the following table to connect ColdFusion to Sybase data sources:
Disable Connections If selected, suspends all client connections.
Login Timeout (sec) The number of seconds before ColdFusion times out the attempt to log in to the data source
connection.
CLOB Select to return the entire contents of any CLOB/ Text columns in the database for this data source. If not
selected, ColdFusion retrieves the number of characters specified in the Long Text Buffer setting.
BLOB Select to return the entire contents of any BLOB/ Image columns in the database for this data source. If
not selected, ColdFusion retrieves the number of characters specified in the BLOB Buffer setting.
LongText Buffer The default buffer size; used if Enable Long Text Retrieval (CLOB) is not selected. The default value is
64000 bytes.
BLOB Buffer The default buffer size; used if the BLOB option is not selected. The default value is 64000 bytes.
Allowed SQL The SQL operations that can interact with the current data source.
Validation query Called when a connection from the pool is resued. This can slow query response time because an
additional query is generated. Specify the validation query before restarting the database to verify all
connections, but remove the validation query after restarting the database to avoid any performance
loss.
Setting Description
CF Data Source Name The data source name (DSN) that ColdFusion uses to connect to the data source.
Database The database to which this data source connects.
Server The name of the server that hosts the database that you want to use. If the database is local, enclose the
word local in parentheses. This name must be either a fully qualified domain name (resolvable through
DNS) or an IP address. It cannot be a netbios name (even if you are running NBT), or an alias you set up
using the client connectivity wizard (both of these approaches worked in earlier ColdFusion versions).
Port The number of the TCP/IP port that the server monitors for connections.
User name The user name that ColdFusion passes to the JDBC driver to connect to the data source if a ColdFusion
application does not supply a user name (for example, in a
cfquery tag).
Password The password that ColdFusion passes to the JDBC driver to connect to the data source if a ColdFusion
application does not supply a password (for example, in a
cfquery tag).
Description (Optional) A description for this connection.
Connection String A field that passes database-specific parameters, such as login credentials, to the data source.
Select Method Determines whether server cursors are used for SQL queries.
• The Direct method provides more efficient retrieval of data when you retrieve recordsets in a forward-
only direction and you limit your Sybase connection to a single open SQL statement at a time. This is
typical for ColdFusion applications.
• The Cursor method lets you have multiple open SQL statements on a connection. This is not typical
for ColdFusion applications, unless you use pooled statements.
Setting Description
- COLDFUSION 1
- Contents 3
- Chapter 1: Introduction 6
- About Verity administration 8
- Administrator 9
- Accessing user assistance 10
- Server Settings section 10
- Request Tuning page 12
- Caching page 13
- Client Variables page 13
- Memory Variables page 15
- Mappings page 16
- Mail page 16
- Mail Spool Settings area 17
- Charting page 18
- Font Management page 19
- Document page 19
- Java and JVM page 19
- Data & Services section 20
- Verity K2 Server page 21
- Web Services page 21
- Flex Integration page 21
- Enable SSL 22
- Create the keystore 22
- Configure Flex 23
- Using the cfstat utility 24
- Debugging IP Addresses page 25
- Debugger Settings page 25
- Logging Settings page 26
- Log Files page 26
- Scheduled Tasks page 27
- Server Monitoring section 28
- Extensions section 29
- Event Gateways section 30
- Security section 31
- RDS page 32
- Sandbox security page 32
- User Manager page 32
- Allowed IP Addresses 32
- ColdFusion Archives page 33
- J2EE Archives page 33
- Enterprise Manager section 34
- Custom Extensions section 34
- Administrator API 35
- Use the Administrator API 36
- Examples 36
- About JDBC 39
- Adding data sources 40
- Guidelines for data sources 41
- Connection Issues 42
- • Unique cfstoredproc tags 43
- Connecting to Informix 45
- Connecting to MySQL 51
- DataDirect driver features 53
- Enabling SSL Connection 54
- Connecting to ODBC Socket 56
- Connecting to Oracle 57
- Connecting to PostgreSQL 60
- Connecting to Sybase 61
- Using the built-in web server 64
- Using an external web server 65
- Web server configuration 66
- wsconfig.exe [-options] 67
- ./wsconfig [-options] 67
- Configuration files 69
- Sample configuration files 70
- Multihoming 72
- Applications 76
- Application packaging 77
- Using the cfcompile utility 78
- Sourceless distribution 79
- About ColdFusion security 80
- Using password protection 80
- Exposing services to users 81
- Using sandbox security 82
- Configure a sandbox 84
- Sandbox Considerations 85
- File location considerations 88
- Define a server instance 88
- Overview 99
- Statistics 99
- Last updated 2/21/2012 100
- Memory Usage 101
- Database 102
- Snapshots 103
- ColdFusion Server Monitor API 104
- JVM memory usage 106
- Variable memory usage 107
- Request handling 107
- Database response time 107
- Update 1 108
- • MaxThreads 109
- • Logging 109
- Using Admin APIs 110
- Troubleshooting scenarios 110
- Monitoring with SSL 111
- Updating the threadpool 111
- Launch Server Manager 112
- Register servers 112
- • WebLogic 113
- • WebSphere 113
- JRun-specific parameters 114
- WebSphere-specific parameters 115
- JBoss specific parameters 116
- Create Groups 117
- Manage multiple servers 117
- Clear template cache 119
- Apply hot fix 119
- Monitor multiple servers 120
- [Xmx512m]-) 121
- About Verity Spider 122
- About the Verity utilities 123
- Verity Spider 124
- About Verity Spider syntax 125
- Using a command file 126
- Core options 127
- Processing options 128
- -abspath 129
- -detectdupfile 129
- -indexers 129
- -license 129
- -maxindmem 129
- -maxnumdoc 130
- -mimemap 130
- -nocache 130
- -nodupdetect 131
- -noindex 131
- -nosubmit 131
- -persist 131
- -preferred 132
- -prefixmap 132
- -processbif 133
- -submitsize 133
- Networking options 134
- -hostcache 135
- -noflowctrl 136
- -noproxy 136
- Path and URL options 137
- -followdup 139
- -followsymlink 139
- -nodocrobo 140
- -nofollow 140
- -pathlen 141
- -refreshtime 141
- Content options 142
- -exclude 143
- -include 143
- -indexclude 144
- -indinclude 144
- -indmimeexclude 145
- -indmimeinclude 145
- -indskip 146
- -maxdocsize 147
- -metafile 147
- -mimeexclude 148
- -mimeinclude 148
- -mindocsize 148
- Locale options 149
- Logging options 150
- -loglevel 151
- Maintenance options 152
- Setting MIME types 152
- MIME types and web crawling 153
- Indexing unknown MIME types 154
- Overview of Verity utilities 155
- Using the mkvdk utility 155
- Collection setup options 157
- General processing options 158
- Date format options 159
- Service-level keyword options 160
- Message options 160
- Document processing options 161
- Bulk submit options 161
- Repairing a collection 162
- Backing up a collection 162
- Deleting a collection 162
- Purging a collection 162
- Specifying persistent service 163
- Optimization keywords 163
- Squeezing deleted documents 163
- Using the rck2 utility 164
- Using the rcvdk utility 165
- Basic searching 166
- Displaying more fields 168
- Displaying a field 168
- Displaying multiple fields 168
- Using the didump utility 169
- Using the browse utility 171
- Using the merge utility 172
- Solr collections 174
- Solr server 174
- Migrating from Verity to Solr 174
Related products and manuals for Servers MACROMEDIA COLDFUSION 4.5-ADMINISTRING COLDFUSION SERVER
(9 pages)© 2020, manymanuals.com. All rights reserved. | 1.893 s |
Manymanuals.com
Manymanuals.de
Manymanuals.fr
Manymanuals.it
Manymanuals.pl
Manymanuals.cz
Manymanuals.es
Manymanuals-pt.com
Comments to this Manuals