MACROMEDIA COLDFUSION 4.5-ADMINISTRING COLDFUSION SERVER Technical Information Page 39
- Page / 174
- Table of contents
- TROUBLESHOOTING
- BOOKMARKS
Rated. / 5. Based on customer reviews
34
Last updated 2/21/2012
Chapter 4: Data Source Management
A data source is a complete database configuration that uses a JDBC driver to communicate with a specific database.
In Adobe ColdFusion, you configure a data source for each database that you want to use. After you configure a data
source, ColdFusion can then communicate with that data source through JDBC.
For basic information on data sources and connecting to databases, click Resources in the ColdFusion Administrator,
and then select Getting Started Experience.
About JDBC
JDBC is a Java Application Programming Interface (API) that you use to execute SQL statements. JDBC enables an
application, such as ColdFusion, to interact with various database management systems (DBMSs), without using
interfaces that are database- and platform-specific.
The following table describes the four types of JDBC drivers:
Type Name Description
1 JDBC-ODBC bridge Translates JDBC calls to ODBC calls, and sends them to the ODBC driver.
Advantages: Allows access to many different databases.
Disadvantages: The ODBC driver, and possibly the client database libraries, must reside on the
ColdFusion server computer. Performance is slower than other JDBC driver types.
Adobe does not recommend this driver type unless your application requires DBMS-specific
features.
2 Native-API/partly Java
driver
Converts JDBC calls to database-specific calls.
Advantages: Better performance than Type 1 driver.
Disadvantages: The client database libraries of the vendor must reside on the same computer as
ColdFusion.
ColdFusion includes a Type 2 driver for use with Microsoft Access Unicode databases.
3 JDBC-Net pure Java driver Translates JDBC calls to the middle-tier server, which then translates the request to the database-
specific native-connectivity interface.
Advantages: The database libraries of vendors are not required client computer. Can be tailored for
small size (faster loading).
Disadvantages: Database-specific code must be executed in the middle tier.
ColdFusion includes an ODBC socket Type 3 driver for use with Microsoft Access databases and
ODBC data sources.
4 Native-protocol/all-Java
driver
Converts JDBC calls to the network protocol used directly by the database.
Advantages: Fast performance. No special software needed on the computer on which you run
ColdFusion.
Disadvantages: Many of these protocols are proprietary, requiring a different driver for each
database.
ColdFusion includes Type 4 drivers for many DBMSs; however, not all DBMSs are supported in
ColdFusion Standard Edition.
- 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.131 s |
Manymanuals.com
Manymanuals.de
Manymanuals.fr
Manymanuals.it
Manymanuals.pl
Manymanuals.cz
Manymanuals.es
Manymanuals-pt.com
Comments to this Manuals