MACROMEDIA COLDFUSION 4.5-ADMINISTRING COLDFUSION SERVER Technical Information Page 43
- Page / 174
- Table of contents
- TROUBLESHOOTING
- BOOKMARKS
Rated. / 5. Based on customer reviews
38
CONFIGURING AND ADMINISTERING COLDFUSION 9
Data Source Management
Last updated 2/21/2012
Connecting to Apache Derby Embedded
Use the settings in the following table to connect ColdFusion to Apache Derby Embedded:
CLOB Returns the entire contents of any CLOB/ Text columns in the database for this data source. If deselected,
ColdFusion retrieves the number of characters specified in the Long Text Buffer setting. For UDB 7.1 and 7.2, a 32K
limit on CLOBs exists.
BLOB Returns the entire contents of any BLOB/Image columns in the database for this data source. If deselected,
ColdFusion retrieves the number of characters specified in the BLOB Buffer setting. BLOBs are not supported on
UDB 7.1 and 7.2.
LongText Buffer (chr) The default buffer size, used if the CLOB option is not selected. The default value is 64000 bytes.
BLOB Buffer (bytes) 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 just 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 folder The folder where the database is located.
Create Database Select this option to create a database. The new database exists in the path specified in the Database Folder. If the
database exists, an SQL warning is generated, and a connection to the existing database is established.
Description (Optional) A description for this connection.
ColdFusion user name The user name you use to log in to the ColdFusion Administrator.
ColdFusion Password The password you use to log in to the ColdFusion Administrator.
Connection String A field that passes database-specific parameters, such as login credentials, to the data source.
Limit Connections Specifies whether ColdFusion 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.
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 Select this option to reuse 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.
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 Returns the entire contents of any CLOB/ Text columns in the database for this data source. If deselected,
ColdFusion retrieves the number of characters specified in the Long Text Buffer setting. For UDB 7.1 and 7.2, a 32K
limit on CLOBs exits.
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. | 0.128 s |
Manymanuals.com
Manymanuals.de
Manymanuals.fr
Manymanuals.it
Manymanuals.pl
Manymanuals.cz
Manymanuals.es
Manymanuals-pt.com
Comments to this Manuals