MACROMEDIA COLDFUSION 5 - INSTALING AND CONFIGURING SERVER Manuale Utente Pagina 44
- Pagina / 170
- Indice
- SEGNALIBRI
Valutato. / 5. Basato su recensioni clienti
44 Chapter 3: Data Source Management
About JDBC
JDBC is a Java Application Programming Interface (API) that you use to execute SQL statements.
JDBC enables an application, such as ColdFusion MX 7, to interact with a variety of database
management systems (DBMSs), without using interfaces that are database- and platform-specific.
The following table describes the four types of JDBC drivers:
JDBC drivers are stored in JAR files. For example, the JDBC drivers that are supplied with
ColdFusion MX are in the macromedia_drivers.jar file. If you are using another JDBC driver, you
must store it in the ColdFusion classpath. For example, cf_root/cfusion/lib (server configuration)
or cf_webapp_root/WEB-INF/cfusion/lib (multiserver or J2EE configuration).
Type Name Description
1JDBC-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.
Macromedia 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 vendor’s client database libraries must reside on
the same computer as ColdFusion.
ColdFusion MX includes a type 2 driver for use with Microsoft Access
Unicode databases.
3JDBC-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 No need for vendor’s database libraries to be present on
client computer. Can be tailored for small size (faster loading).
Disadvantages Database-specific code must be executed in the
middle tier.
ColdFusion MX includes an ODBC socket type 3 driver for use with
Microsoft Access databases and ODBC data sources.
4Native-
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 MX.
Disadvantages Many of these protocols are proprietary, requiring a
different driver for each database.
ColdFusion MX includes type 4 drivers for many popular DBMSs;
however, not all DBMSs are supported in ColdFusion MX Standard
Edition.
- COLDFUSION 1
- CONTENTS 3
- Contents 5 5
- 6 Contents 6
- INTRODUCTION 7
- 8 Introduction: 8
- Administering ColdFusion MX 7 9
- CHAPTER 1 11
- Administering ColdFusion MX 11
- About Verity administration 12
- CHAPTER 2 13
- Initial administration tasks 14
- Accessing user assistance 14
- Server Settings section 15 15
- Caching page 16
- • In database tables 17
- Sample table creation page 19
- Mail Server Settings area 21
- Mail Spool Settings area 21
- Server Settings section 23 23
- Data & Services section 24
- • Data Sources page 25
- • Verity Collect ions page 25
- • Verity K2 Server page 25
- • Web Services page 25
- Extensions section 32
- • Java Applets page 32
- • CFX Tags page 32
- • Custom Tag Paths page 32
- • CORBA Connectors page 32
- Extensions section 33 33
- Event Gateways section 34
- • Event Gateway Settings page 34
- • Gateway Types page 34
- • Gateway Instances page 34
- Security section 35
- • CF Admin Password page 35
- • RDS Password page 35
- • Sandbox Security page 35
- Enterprise Manager section 37 37
- Custom Extensions section 38
- Administrator API 39
- Administrator API 41 41
- Data Source Management 43
- CHAPTER 3 43
- About JDBC 44
- Adding data sources 45
- ■ service 46
- ■ jms_provider 46
- Connecting to Informix 49
- 64000 bytes 50
- Connecting to MySQL 56
- Connecting to ODBC Socket 57
- Connecting to Oracle 59
- Connecting to Sybase 62
- CHAPTER 4 65
- Web Server Management 65
- Using the built-in web server 66
- Using an external web server 67
- Web server configuration 68
- Web server configuration 69 69
- Web server configuration 71 71
- Apache configuration file 73
- IIS configuration file 73
- Multihoming 74
- Multihoming 75 75
- Multihoming 77 77
- CHAPTER 5 79
- Using the cfcompile utility 82
- -deploy option 83
- CHAPTER 6 85
- Administering Security 85
- Using password protection 86
- Using sandbox security 86
- Using sandbox security 87 87
- Using sandbox security 89 89
- CHAPTER 7 91
- MX 6.1 documentation 92
- To define a server instance: 93
- Administrator 101
- Administering Verity 103
- CHAPTER 8 105
- CHAPTER 9 109
- -connections option 110
- -noflowctrl option 110
- About Verity Spider syntax 111
- Core options 114
- Processing options 115
- Processing options 117 117
- Processing options 119 119
- Networking options 120
- Networking options 121 121
- Path and URL options 123
- Path and URL options 125 125
- Example 127
- Content options 128
- Content options 129 129
- -indinclude option 130
- Example 1 132
- Example 2 132
- Content options 133 133
- Locale options 135
- Logging options 136
- Maintenance options 137
- Setting MIME types 138
- Setting MIME types 139 139
- CHAPTER 10 141
- Using Verity Utilities 141
- Using the mkvdk utility 142
- Using the mkvdk utility 143 143
- -style dir 144
- -description desc 144
- General processing options 145
- Using the default options 146
- Servicing only 146
- Bulk inserting or deleting 147
- Message options 148
- Document processing options 148
- Using the mkvdk utility 149 149
- Repairing a collection 150
- Backing up a collection 150
- Deleting a collection 151
- Purging a collection 151
- Specifying persistent service 151
- Using the rck2 utility 153
- Using the rcvdk utility 154
- Using the rcvdk utility 155 155
- Displaying a field 157
- Using the didump utility 158
- Using the didump utility 159 159
- Using the browse utility 160
- Using the browse utility 161 161
- Using the merge utility 162
- Using the merge utility 163 163
- 166 Index 166
- Index 167 167
- 168 Index 168
- Index 169 169
- 170 Index 170
Prodotti e manuali riguardandi Server MACROMEDIA COLDFUSION 5 - INSTALING AND CONFIGURING SERVER
Server MACROMEDIA FLASH MEDIA SERVER 2-INSTALLING FLASH MEDIA SERVER 2 Informazioni Techniche
(66 pagine)
(66 pagine)
Server MACROMEDIA FLASH MEDIA SERVER 2-USING FLASH MEDIA SERVER EDGE SERVERS Guida Utente
(25 pagine)
(25 pagine)
Server MACROMEDIA COLDFUSION 5 - INSTALING AND CONFIGURING SERVER Informazioni Techniche
(77 pagine)
(77 pagine)
Server MACROMEDIA FLASH MEDIA SERVER 2-SERVER MANAGEMENT ACTIONSCRIPT LANGUAGE Guida di Installazione
(59 pagine)
(59 pagine)
Server MACROMEDIA FLASH MEDIA SERVER 2-SERVER-SIDE ACTIONSCRIPT LANGUAGE Manuale Utente
(240 pagine)
(240 pagine)
Server MACROMEDIA FLASH COMMUNICATION SERVER MX-SERVER-SIDE COMMUNICATION ACTIONSCRIPT DICTIONARY Specifiche
(369 pagine)
(369 pagine)
© 2020, manymanuals.it. Tutti i diritti riservati | 0.057 s |
Manymanuals.com
Manymanuals.de
Manymanuals.fr
Manymanuals.it
Manymanuals.pl
Manymanuals.cz
Manymanuals.es
Manymanuals-pt.com
Commenti su questo manuale