background image

48

Chapter 3:  Data Source Management

Connecting to MySQL

Use the settings in the following table to connect ColdFusion MX to MySQL data sources:

Maintain Connections

ColdFusion MX 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. 

String Format

Enable this option if your application uses Unicode data in DBMS-
specific Unicode datatypes such as National Character or nchar.

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 

cfqueryparam

Unique 

cfstoredproc

 tags

Timeout (min)

The maximum number of minutes after the data source connection is 
made that you want ColdFusion MX to cache a connection after it is used.

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 MX 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 not selected, ColdFusion MX retrieves 
the amount 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 MX retrieves 
the amount specified in the Blob Buffer setting.

LongText Buffer

The default buffer size, used if Enable Long Text Retrieval(CLOB) is not 
selected. Default is 64000 bytes.

BLOB Buffer

The default buffer size, used if Enable binary large object retrieval 
(BLOB) is not selected. Default is 64000 bytes.

Allowed SQL

The SQL operations that can interact with the current data source.

Setting

Description

CF Data Source Name

The data source name (DSN) used by ColdFusion MX 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.

Port

The number of the TCP/IP port that the server monitors for connections.

Setting

Description

Summary of Contents for COLDFUSION MX 61 - CONFIGURING AND ADMINISTERING COLDFUSION...

Page 1: ...Configuring and Administering ColdFusion MX...

Page 2: ...denames of Macromedia Inc or other entities and may be registered in certain jurisdictions including internationally This product includes code licensed from RSA Data Security This guide contains link...

Page 3: ...on 14 Data Services section 15 Debugging Logging section 15 Extensions section 16 Security section 16 CHAPTER 2 Basic ColdFusion MX Administration 17 Initial administration tasks 17 Server Settings se...

Page 4: ...38 Adding data sources 39 Adding data sources in the Administrator 39 Connecting to DB2 Universal Database 6 x 7 2 and OS 390 41 Connecting to Informix 9 x 43 Connecting to Microsoft Access 44 Connec...

Page 5: ...stering Verity CHAPTER 7 Introducing Verity Tools 85 About the Verity utilities 85 ColdFusion MX OEM restrictions 86 Collection structure and ColdFusion MX 86 Verity search modes in ColdFusion MX 87 H...

Page 6: ...intenance options 128 Setting MIME types 129 Syntax restrictions 129 MIME types and web crawling 129 MIME types and file system indexing 130 Indexing unknown MIME types 130 Known MIME types for file s...

Page 7: ...e utility 152 Displaying fields 153 Using the Verity merge utility 153 Merging collections using the merge utility 154 Splitting collections using the merge utility 154 CHAPTER 13 Verity Error Message...

Page 8: ...8 Contents...

Page 9: ...dministering ColdFusion MX Part I describes how to manage the ColdFusion environment including connecting to your data sources and configuring security for your applications Part II describes Verity s...

Page 10: ...10 Introduction...

Page 11: ...ncluding connecting to your data sources and configuring security for your applications Chapter 1 Administering ColdFusion MX 13 Chapter 2 Basic ColdFusion MX Administration 17 Chapter 3 Data Source M...

Page 12: ......

Page 13: ...2EE The default location for the ColdFusion MX Administrator login page is http servername CFIDE administrator index cfm In the previous URL servername is the fully qualified domain name of your web s...

Page 14: ...n contains links to pages for managing aspects of the system Server Settings Manage whitespace client and memory variables locking and mappings Register a mail server and configure mail logging Config...

Page 15: ...ing its name Data Services section The Data Services section contains the following pages Data Sources Create and manage your data sources You can specify login parameters connection information and r...

Page 16: ...ing the cfapplet tag CFX Tags Register edit or delete C and Java custom tags Custom Tag Paths Register the paths that contain your custom tags CORBA Connectors Register edit or delete CORBA connectors...

Page 17: ...ons require data source connections to query and write to databases To create verify edit and delete database connections use the Data Sources pages in the Administrator For more information see Chapt...

Page 18: ...sions section on page 33 Restrict tag access Some CFML tags might present a potential security risk for your server To disable certain tags use the Sandbox Security page of the Administrator For more...

Page 19: ...contain your application s commonly accessed ColdFusion pages yet small enough to avoid excessive reloading You can experiment with a range of values on your development server a suitable starting poi...

Page 20: ...riables you must allocate sufficient memory and disk space You can override settings specified in the Client Variables page using the attributes of the cfapplication tag For more information see Devel...

Page 21: ...eate client variable tables for data sources that use bundled JDBC drivers For more information see the online Help Sample table creation page Create the Client variable storage tables in a datasource...

Page 22: ...sion variables ColdFusion creates an identifier for each session and does not use the CFToken or CFID cookie value For more information see Developing ColdFusion MX Applications Mappings page You use...

Page 23: ...Server Port Enter the number of the port on which the mail server is running Contact your server administrator if you are unsure of the appropriate port number Verify Mail Server Connection Select th...

Page 24: ...dFusion MX Enterprise Edition you can spool messages either to disk slower but messages persist across shutdowns or to memory faster but messages do not persist You can override this setting in the cf...

Page 25: ...ources Verity collections Scheduled tasks Java applets CFX tags Archive to do lists Max number of charting threads Specify the maximum number of chart requests that can be processed concurrently The m...

Page 26: ...source in the ColdFusion MX Administrator For more information see Chapter 3 Data Source Management on page 37 Verity Collections page The Verity Development Kit VDK provides indexing and searching te...

Page 27: ...t have to specify the entire Web Services Description Language WSDL URL when you reference the web service The first time you reference a web service ColdFusion MX automatically registers it in the Ad...

Page 28: ...udes modules and custom tags that were executing at the time of the exception The default is 5 A blank value or 0 implies no limit Database Activity Shows the database activity for the SQL Query event...

Page 29: ...or a new template Req Q ed Number of queued requests The number of requests that are currently waiting for ColdFusion MX to process them Lower values which you can achieve with efficient CFML are bett...

Page 30: ...If you do not specify IP addresses and debugging options are active debugging output is displayed for all users Bytes In Sec Bytes incoming per second The number of bytes that ColdFusion MX read in th...

Page 31: ...s taking longer than n seconds Log the names of pages that take longer than the specified interval to process Logging slow pages can help you diagnose potential problems or bottlenecks in your ColdFus...

Page 32: ...r ColdFusion applications Like scheduled tasks they access a URL at a specified interval but they can also check for the presence or absence of a string in the URL If the URL contents are unexpected o...

Page 33: ...tag override parameters defined in the Java Applets page For more information see the online Help CFX Tags page Before you can use a CFX tag in ColdFusion applications you must register it You use the...

Page 34: ...ies file which contains the following properties that configure the ORB org omg CORBA ORBClass com inprise vbroker orb ORB org omg CORBA ORBSingletonClass com inprise vbroker orb ORB SVCnameroot namin...

Page 35: ...links to other web applications and sites These links appear under the Custom Extensions section in the left navigation pane of the Administrator Note You must create a link for the Custom Extensions...

Page 36: ...36 Chapter 2 Basic ColdFusion MX Administration...

Page 37: ...ng to Microsoft Access 44 Connecting to Microsoft Access with Unicode 46 Connecting to Microsoft SQL Server 7 x 2000 47 Connecting to MySQL 48 Connecting to ODBC Socket 50 Connecting to Oracle R3 8 1...

Page 38: ...ered by the ColdFusion MX Microsoft Access with Unicode driver 3 JDBC Net pure Java driver Translates JDBC calls to the middle tier server which then translates the request to the database specific na...

Page 39: ...a source name DSN and set all information required to establish a connection Note ColdFusion MX includes several data sources that are configured by default including cfsnippets CompanyInfo and exampl...

Page 40: ...ColdFusion MX Administrator to specify connection string arguments for data sources that use the Microsoft Access ODBC Socket MYSQL or DB2 drivers In the Advanced Settings page for one of these driver...

Page 41: ...ata 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 spe...

Page 42: ...Unique cfstoredproc tags Timeout min The maximum number of minutes after the data source connection is made that you want ColdFusion to cache a connection after it is used Interval min The time in min...

Page 43: ...mber 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...

Page 44: ...a database that contains database security information The system database is usually located in winnt system32 system mdw Use Default Username If selected ColdFusion MX does not pass a user name or p...

Page 45: ...t you want ColdFusion MX to cache a connection after it is used The Timeout setting does not return a connection to the cache after a specified period of time regardless of how infrequently it is used...

Page 46: ...s 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 Connecti...

Page 47: ...nections Username The user name that ColdFusion MX 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...

Page 48: ...f selected suspends all client connections Login Timeout sec The number of seconds before ColdFusion MX times out the data source connection login attempt CLOB Select to return the entire contents of...

Page 49: ...s option to improve performance by caching the data source connection Timeout min The maximum number of minutes after the data source connection is made that you want ColdFusion MX to cache a connecti...

Page 50: ...he 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 Limit C...

Page 51: ...r 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 Limit Connections Specifies w...

Page 52: ...elected Default is 64000 bytes Allowed SQL The SQL operations that can interact with the current data source Setting Description CF Data Source Name The data source name DSN used by ColdFusion MX to c...

Page 53: ...ds before ColdFusion MX 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 not selected ColdF...

Page 54: ...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 Select Method Determines whether s...

Page 55: ...l client connections Login Timeout sec The number of seconds before ColdFusion MX times out the data source connection login attempt CLOB Select to return the entire contents of any CLOB Text columns...

Page 56: ...56 Chapter 3 Data Source Management...

Page 57: ...nts Understanding web servers in ColdFusion MX 57 Using the built in web server 58 Using an external web server 59 Web server configuration 59 Advanced configurations 65 Understanding web servers in C...

Page 58: ...pen cf_root runtime servers default SERVER INF jrun xml in a text editor and examine the port attribute of the WebService service Note When installing ColdFusion MX Enterprise Edition using the option...

Page 59: ...g elements to the Apache httpd conf file A LoadModule directive defines the connector An AddHandler directive tells Apache to route requests for ColdFusion pages through the connector For Apache 1 3 x...

Page 60: ...e server or cluster name that you want to configure Individual server names in a cluster do not appear Clustering support is only available on the JRun J2EE configuration Note The server or cluster do...

Page 61: ...specify cfm cfc cfml jsp jws filter prefix only Sets ignoresuffixmap true in the jrun ini file This means that the connector module runs as an IIS extension IIS only coldfusion In conjunction with up...

Page 62: ...the first site 0 run but you can rerun with site 0 at a later time and the Web Server Configuration Tool configures new sites only Netscape on UNIX java_home bin java jar opt coldfusionmx runtime lib...

Page 63: ...coldfusionmx runtime lib wsconfig 1 jrunserver store JRunConfig Bootstrap 127 0 0 1 51010 Property Description bootstrap The IP address and port on which the JRun server s proxy service is listening f...

Page 64: ...exp cfc type jrun internal ObjectType fn type by exp exp cfml type jrun internal ObjectType fn type by exp exp jsp type jrun internal ObjectType fn type by exp exp jws type jrun internal ObjectType f...

Page 65: ...te to specify the location of the cfform js file Disabling cacheRealPath To ensure that ColdFusion MX always returns pages from the correct server ensure that Cache Web Server Paths is disabled in the...

Page 66: ...e_root conf httpd conf file in a text editor and create virtual hosts as necessary For more information see your Apache documentation For example JRun Settings LoadModule jrun_module C CFusionMX runti...

Page 67: ...J2EE configuration on JRun set the cacheRealPath attribute to false for the ProxyService in the jrun xml file 8 Test each virtual host to ensure that CFM pages are served correctly Sun ONE Web Server...

Page 68: ...CFEngineering o Macromedia L Newton ST MA C US keyalg rsa keystore keystore name 2 When prompted enter appropriate passwords that are six or more characters in length 3 Rerun keytool to add certificat...

Page 69: ...Remote Development Services RDS which allows developers to develop CFML pages remotely You implement runtime security in your CFML pages and in the ColdFusion MX Administrator ColdFusion MX has the fo...

Page 70: ...et permissions for ColdFusion application and document directories Using sandbox security Sandbox security called Resource security in the Standard Edition uses the location of your ColdFusion pages t...

Page 71: ...ation see the Administrator online Help Note When running ColdFusion MX in the J2EE configuration on IBM WebSphere file directory security and IP port security are not enabled About directories and pe...

Page 72: ...t Security Context is the only sandbox There is no initial list of defined directory permissions To configure a sandbox 1 Open the Security Sandbox Security page Security Resource Security in Standard...

Page 73: ...ser from browsing another user s directory you must use file based permissions 13 Click the IP Port tab 14 To turn off default behavior global access to all IP addresses and ports enter the IP address...

Page 74: ...74 Chapter 5 Administering Security...

Page 75: ...cause each server instance runs in its own JVM problems encountered by one application have no effect on other applications Load balancing and failover You deploy the same application to each server i...

Page 76: ...in Windows jrun_root bin jrun on UNIX Start the admin server if it is not running 2 Open the JMC by typing http hostname 8000 in a browser You are prompted for the user name and password specified dur...

Page 77: ...plained in the Starting and stopping JRun servers discussion in Installing JRun Note These instructions describe creating multiple server instances on a single computer To create multiple server insta...

Page 78: ...Repeat these steps for each server instance Web server configuration for application isolation When using multiple server instances for application isolation the steps you perform to configure commun...

Page 79: ...ds 25 attribute attribute name backlog 500 attribute attribute name deactivated false attribute attribute name interface attribute attribute name maxHandlerThreads 1000 attribute attribute name minHan...

Page 80: ...Ssl false JRunConfig Ignoresuffixmap false JRunConfig Serverstore C JRun4 lib wsconfig 1 jrunserver store JRunConfig Bootstrap 127 0 0 1 51020 AddHandler jrun handler jsp jws cfm cfml cfc IfModule Na...

Page 81: ...r optimizes performance and stability by automatically balancing load and by switching requests to another server instance when a server instance stops running For maximum failover protection use mult...

Page 82: ...name in the list c Open the Macromedia ColdFusion MX application d Specify the context path usually e Select Enable Session Replication f In the New Replication Buddy field enter the names of the oth...

Page 83: ...hooting Verity collection Chapter 7 Introducing Verity Tools 85 Chapter 8 Managing Collections with the mkvdk Utility 89 Chapter 9 Indexing Collections with Verity Spider 101 Chapter 11 Searching Coll...

Page 84: ......

Page 85: ...k2 and vspider utilities The following table describes the relationship between the major Verity utilities and the corresponding cfcollection cfsearch and cfindex ColdFusion tags the cfcollection tag...

Page 86: ...oldFusion MX such as the native Verity indexing tool mkvdk For more information on mkvdk see Chapter 8 Managing Collections with the mkvdk Utility on page 89 The directory structure of a collection th...

Page 87: ...fied in your cfsearch tag Note You cannot combine collections registered with ColdFusion MX and with K2 Server in a single cfsearch tag Use two cfsearch tags to search both collection types from the s...

Page 88: ...p If the neo verity xml and neo verity bak files become damaged use the neo verity org file This file is a valid neo verity xml file that has not been modified since you installed ColdFusion MX About...

Page 89: ...ry In Windows this is typically C CFusionMX on UNIX this is typically opt coldfusionmx On UNIX platform refers to the UNIX version of the server that runs ColdFusion _solaris _hpux11 or _ilnx21 The mk...

Page 90: ...of your choice by using the loglevel and logfile options The log file contains the following fields Date Time Level Code Component Description You can use the log file to view details about what happ...

Page 91: ...his structure You can create a collection in two steps using two separate commands To create a collection 1 Set up a collection using the following syntax mkvdk create collection collectionname Where...

Page 92: ...ription create Creates a collection in the specified collection directory It creates the directory structure determines the index contents and sets up the document s table schema according to the styl...

Page 93: ...collection data when using topics mode mode Sets the indexing mode Values are case insensitive The following are the valid settings Generic FastSearch NewsfeedIdx NewsfeedOpt BulkLoad ReadOnly Any cus...

Page 94: ...on of Windows displays is 8859 This is NOT the name of the character set of documents being indexed it is only the name of the character set that your display can handle properly The character set of...

Page 95: ...mats and the numeric date formats listed in the following table Service level keywords The following table describes the valid keywords for the servlev keyword Format variable Description MDY Dates wr...

Page 96: ...on page 89 Option Description extract Extracts field values from documents using the field extraction rules specified in the style tde file insert Adds documents to the collection This is the default...

Page 97: ...the number of documents to insert or delete from the bulk insert file or files If you specify multiple bulk insert or delete files and use the numdocs option the numdocs setting is applied to all of t...

Page 98: ...n in the background The following command purges the specified collection in the background mkvdk purge purgeback collection path Specifying persistent service The following command runs the mkvdk com...

Page 99: ...ts in them readonly Marks the collection as read only and unchanged after the function call is done This is appropriate for CD ROM collections spanword Creates a spanning word list across all the coll...

Page 100: ...mns that relate to each other by row position VDB tables are not relational and their architecture supports quick and efficient searching over textual data A VDB consists of segments that are packed i...

Page 101: ...y Spider enables you to index web based and file system documents throughout your enterprise Verity Spider works in conjunction with the Verity KeyView document filtering technology so that you can in...

Page 102: ...gracefully and efficiently restarting halted indexing jobs Previous versions of Verity Spider only held state information in memory which meant that any stoppage of spidering resulted in lost work Th...

Page 103: ...e on proxy servers Note Information Server V3 7does not support retrieving documents for viewing through secure proxy servers Do not use the proxyauth option for indexing documents that you will view...

Page 104: ...path This is because the Verity Spider executable depends on other files to run properly Using a command file For simpler reuse and archiving of your indexing commands use the cmdfile option for abstr...

Page 105: ...re also deleted from the persistent store and the collection The exception to this rule is when you use the nooptimize option with the refresh option In this case any document deleted from the reposit...

Page 106: ...r update Note You receive an error if you specify a filename with an extension of CLM Meta collections are not supported help Displays Verity Spider syntax options jobpath Syntax jobpath path Specifie...

Page 107: ...rough the file system use the prefixmap option with the abspath option to map the absolute file paths to URLs See also prefixmap detectdupfile Type File system only Enables checksum based detection of...

Page 108: ...CII text that maps file extensions to MIME types This lets you make custom associations and override defaults The following is the format for the control file file_ext_no_dot mime type abc application...

Page 109: ...also nocache and nosubmit For more information on the mkvdk utility see Chapter 8 Managing Collections with the mkvdk Utility on page 89 nosubmit Specifies that Verity Spider gathers document location...

Page 110: ...otation marks are not necessary within a command file the cmdfile option See also regexp prefixmap Type File system only Syntax prefixmap path_and_filename Specifies a control file simple ASCII text t...

Page 111: ...egular expression ab 0 9 0 9 The full extent to which regular expressions can be employed is beyond the scope of this description For more information on regular expressions refer to a book devoted to...

Page 112: ...me field that is part of the HTTP request Since web servers can be configured to return different versions of the same page depending on the requesting agent you can use the agentname option to impers...

Page 113: ...number of host names to cache to avoid DNS lookups Without this option the host cache continues to grow The default value is 256 noflowctrl Type Web crawling only Disables round robin indexing of web...

Page 114: ...login information for proxy server connections that require authorization to get outside the firewall Use this option in conjunction with the proxy option Note You must have valid Verity Spider licen...

Page 115: ...s because the URL is missing parameters that are required for processing in order to produce a page nothing happens There is no page to index and parse Example The following is a URL without parameter...

Page 116: ...ultiple hosts by separating each one with a single space URLs not on the specified host s are not downloaded or parsed https Type Web crawling only Lets you index SSL enabled websites Note You must ha...

Page 117: ...ents See also regexp norobo Type Web crawling only Specifies to ignore any robots txt files encountered The robots txt file is used on many websites to specify what parts of the site indexers should a...

Page 118: ...he refresh option When you use vsdb recreate the last indexed date is cleared reparse Type Web crawling only Forces parsing of all HTML documents already in the collection You must specify a starting...

Page 119: ...ns describe the Verity Spider content options casesen Makes processing case sensitive by specifying that the spider separately process keys that differ only in case Use only for indexing UNIX servers...

Page 120: ...expressions the indinclude option allows Verity Spider to follow what matches the specified expressions while not indexing For document types use the mimeinclude option instead for example specify mim...

Page 121: ...risk On UNIX use single quotation marks This is only required when you run the indexing job from a command line Quotation marks are not necessary within a command file the cmdfile option To use regula...

Page 122: ...t only those MIME types that match the expressions be followed and indexed The mimeinclude option does not let you index desired documents if the starting URL is not followed For the mime variable you...

Page 123: ...double them so that they are properly escaped for example C test docs path To use regular expressions also specify the regexp option Example To skip all HTML documents that contain the word personnel...

Page 124: ...and differ This can be useful when the valid field value is always sent but you want to specify your own value with a custom meta tag If you use the n override flag the value for the custom meta tag...

Page 125: ...default is to index documents of any sizes skip Type Web crawling only Syntax skip HTML_tag exp Specifies that Verity Spider not index any HTML document that contains the text of exp within the given...

Page 126: ...he Verity import date format to use Valid values are MDY the default DMY YMD USA and EUR For descriptions of these values see Date format options on page 95 language Syntax language name Specifies the...

Page 127: ...badkey log Included with all arguments progress Current state of a document key written to progress log Note that a key with a progress of inserting might be a badkey and therefore skipped rather than...

Page 128: ...atly reduce search times purge Deletes document tables and index files in the collection and cleans up the collection s persistent store The collection is then fresh with its original style files and...

Page 129: ...u must enclose each separate parameter value in single quotation marks For example mimeinclude text plain application If you enclose the entire sequence of parameter values as follows mimeinclude text...

Page 130: ...mple a typical ASCII file you might want indexed is a log file filename log Since Verity Spider does not understand that files with LOG extensions are ASCII text of MIME type text plain you will see i...

Page 131: ...Format MIME type Extension HTML text html htm html ASCII text plain txt text ASCII source files text plain c h cpp cxx PDF application pdf pdf MS Word application msword doc MS Excel application excel...

Page 132: ...132 Chapter 9 Indexing Collections with Verity Spider...

Page 133: ...er by running the k2server executable See Starting K2 Server on page 135 3 Specify hostname and port information for K2 Server See Specifying K2 Server parameters in the ColdFusion MX Administrator on...

Page 134: ...e highlighted line above to uncomment the code If the line remains as a comment K2 Server will not execute correctly 4 In the code for Coll 0 specify in the collPath parameter the directory of a colle...

Page 135: ...indows On UNIX you run the startk2server script in Windows you run the startk2server bat file These files are located in the cf_root lib directory in Windows and in the cf_root lib directory on UNIX I...

Page 136: ...ou can use in the server section of the server configuration file The K2 Server executable includes a sample configuration file k2server ini Parameter Description serverAlias An arbitrary name used to...

Page 137: ...to YES in the k2server ini file in the server section and the k2broker ini file in the broker section sortTruncDocs The maximum number of documents to consider when sorting accessProfile The Security...

Page 138: ...files are located Leaving this parameter null means that the server uses the default internal locale which is english written in the 850 character set resultCacheTimeout The timeout in milliseconds f...

Page 139: ...cified the value of the maxFiles parameter from the server section is used The maxfiles and numThreads values together can be used to tune system performance The following values can be set for a coll...

Page 140: ...name of a cs file in the root of the common directory that configures a character set and its mappings If not specified the value of the charMap parameter from the server section is used For example...

Page 141: ...y collection information d k2dockey Display fields for the K2 document key specified v k2dockey Stream the document and display it with highlights r docstart Display results starting with the first re...

Page 142: ...142 Chapter 10 Searching Collections with K2 Server...

Page 143: ...cvdk executable is located in the cf_root lib _nti40 bin directory in Windows and in the cf_root lib platform bin directory on UNIX In these pathnames cf_root refers to the ColdFusion MX root director...

Page 144: ...ion file_walking collbldg html Attaching to collection z doc1 c public Collection file_walking collbldg html Successfully attached to 1 collection RC The rcvdk utility lets you attach to one or more c...

Page 145: ...d search97 s97is locale english doc collbldg 08_cbg htm 10 0 90 d search97 s97is locale english doc collbldg 04_cbg1 htm 11 0 90 d search97 s97is locale english doc collbldg 01_cbg1 htm 12 0 87 d sea...

Page 146: ...ain in order to see the results list with the fields you requested For example RC expert Expert mode enabled RC fields title 20 RC s universal filter Search update finished 100 Retrieved 18 18 85 RC r...

Page 147: ...hown in the following example The field order corresponds to the order of the columns with the first field specified appearing in the second column The first column is reserved for the rank order Reru...

Page 148: ...148 Chapter 11 Searching Collections with the rcvdk Utility...

Page 149: ...operations on Verity collections Verity utility Description For more information rcvdk Search collections and display documents See Chapter 11 Searching Collections with the rcvdk Utility on page 143...

Page 150: ...contents of the word list for a partition by using the didump utility with the words flag The command line syntax must include the words flag and a pathname to a partition file like the following did...

Page 151: ...olumns in the display indicate the following Fmt The internal data format used to store the zone information Size The number of bytes used by the Verity engine to store information about the zone Doc...

Page 152: ...an be provided explicitly If a field is blank it has not been populated The browse utility executable which starts the browse utility application is located in the cf_root lib _nti40 bin directory in...

Page 153: ...fields are displayed Using the Verity merge utility The merge utility lets you combine multiple collections with identical schemas This is useful for merging smaller collections built from different...

Page 154: ...hly equal pieces using the filenames given for newCollection1 and so on If you want to split a very large collection into a large number of new collections you can use the following command instead of...

Page 155: ...f the cfcollection cfindex or cfsearch tags Generic error codes Usage error codes Error code No Description VdkSuccess 0 Operation completed successfully VdkFail 2 A general failure not covered by ano...

Page 156: ...t find installation directory Error code No Description VdkError_StyleFiles 31 Invalid style files VdkError_Permissions 32 Bad file or directory permission VdkError_CollNotAvail 33 The collection is n...

Page 157: ...dkError_LicenseDataPrep 57 Not licensed to index documents VdkError_LicenseStreams 58 Not licensed for streams VdkError_LicenseTopics 59 Not licensed for topics VdkError_LicenseThes 60 Not licensed fo...

Page 158: ...ion gateways VdkError_LicenseSoundex 127 No support for Soundex queries VdkError_LicenseSentpara 128 No support for SENTENCE or PARAGRAPH operators VdkError_Scoreop 129 No support for Score operators...

Page 159: ...was down when it was opened VdkWarning_QueryComplex 11 Too many matching words VdkWarning_LowMemory 12 Memory is low for indexing VdkWarning_CollectionReadOnly 13 The collection is read only VdkWarni...

Page 160: ...nvalidSortSpec 28 Invalid sort specification K2Error_GatewayNotAvail 29 Gateway driver not available K2Error_VersionMismatch 30 arg or Vdk Object mismatch K2Error_NoInstallDir 100 Cannot find installa...

Page 161: ...uery has a parsing error ErrorCode No Description K2Error_InvalidUse 80 Invalid user password combination Error code No Description K2Error_HostNotAvail 90 Cannot contact remote host K2Error_NotReEntr...

Page 162: ...tion Error code No Description K2TcpError_Memory c100 Out of memory K2TcpError_ConnDrop c200 Connection closed by remote host K2TcpError_WillBlock c300 Will block on this call K2TcpError_Call_DNS c600...

Page 163: ...stat utility using 29 CFX Tags page ColdFusion MX Administrator 33 Charting page ColdFusion MX Administrator 24 client variables about 20 creating tables for 21 migrating data 21 Client Variables page...

Page 164: ...40 context root multiple server instances 77 CORBA Connectors page ColdFusion MX Administrator 33 Custom Extensions section ColdFusion MX Administrator 35 Custom Tag Paths page ColdFusion MX Administ...

Page 165: ...erver see built in web server jrun dll 59 jrun ini file 62 jrun trusted hosts 82 jrun_iis6 dll 59 jrun_iis6_wildcard dll 59 jrun_nsapi35 dll 59 JRunScripts directory 63 JVM custom JVM for a JRun serve...

Page 166: ...ribute disabling 65 66 CFIDE scripts copying 65 IIS 65 iPlanet 67 multiple server instances 77 overview 65 Sun ONE Web Server 67 multiple server instances application isolation 77 creating 76 custom J...

Page 167: ...cation isolation configuration 81 configuration overview 59 multihoming 67 Sybase connecting to 54 U Unicode Microsoft Access 46 V VDK error codes 155 verbose property 63 Verity Collections page ColdF...

Page 168: ...ch files 62 cluster 82 command line interface 60 configuration files 62 GUI mode 60 shell scripts 62 SSL 68 using 59 web servers built in web server 58 configuring 59 configuring for load balancing an...

Reviews: