<?xml version="1.0" encoding="UTF-8"?>
|
<!DOCTYPE html
|
PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
|
<!--#config errmsg="" --><!-- saved from url=(0022)http://help.adobe.com/ -->
|
<html lang="en-us">
|
<head>
|
<meta http-equiv="content-type" content="text/html; charset=UTF-8" />
|
<meta name="lang" content="en-us" />
|
<meta name="area" content="livedocs" />
|
<title>Adobe ColdFusion 10 * Adding data sources</title>
|
<link rel="shortcut icon" href="images/ColdFusionLinkIndicator.png" />
|
<meta name="book" content="Configuring and Administering ColdFusion 10" />
|
<meta name="product" content="ColdFusion" />
|
<meta name="keywords" content="" /><!--<PageMap><DataObject type="document"><Attribute name="product" value="ColdFusion"></Attribute><Attribute name="book" value="Configuring and Administering ColdFusion 10"></Attribute><Attribute name="keywords" value=""></Attribute></DataObject></PageMap>-->
|
|
<script type="text/javascript" language="Javascript" charset="UTF-8"><!--[CDATA[
|
var currentTreeNode = "WSc3ff6d0ea77859461172e0811cbf3639b1-7ffc.html";
|
document.cookie = "topicId=" + "WSc3ff6d0ea77859461172e0811cbf3639b1-7ffc.html";
|
// ]]--></script>
|
<script src="terms.js" type="text/javascript" language="Javascript" charset="UTF-8">...</script> <script src="help.js" type="text/javascript" language="Javascript" charset="UTF-8">...</script> <script src="utilities.js" type="text/javascript" language="Javascript" charset="UTF-8">...</script> <script src="event.js" type="text/javascript" language="Javascript" charset="UTF-8">...</script> <script src="treeview.js" type="text/javascript" language="Javascript" charset="UTF-8">...</script> <script src="toc.js" language="Javascript" type="text/javascript" charset="UTF-8">..</script> <script src="swfobject.js" language="Javascript" type="text/javascript" charset="UTF-8">..</script> <script src="booklist.js" language="Javascript" type="text/javascript" charset="UTF-8">..</script>
|
<script type="text/javascript">
|
<!--[CDATA[
|
var topictype = "topic";
|
var headId = document.getElementsByTagName("head")[0];
|
if (use_ie_6_behavior) {
|
var linkId = document.createElement("link");
|
linkId.href = "content-ie6.css";
|
linkId.rel = "stylesheet";
|
linkId.type = "text/css";
|
headId.appendChild(linkId);
|
}
|
function initRoboHelpDOM() {
|
if (use_chm_behavior) {
|
hideElement("search");
|
}
|
if (use_robohelp_behavior) {
|
hideElement("search");
|
hideElement("productmenu");
|
//hideElement("notyourversion");
|
}
|
if(!use_chc_behavior) {
|
//document.getElementById("notyourversion").style.display = "inline";;
|
}
|
}
|
var dirname = location.pathname.match( /.*\// );
|
function setSearchUserPref(){
|
if ( document.cookie.indexOf( "ah_searchpref" ) > -1 ) {
|
if ( document.cookie.indexOf( dirname ) > 0 ) {
|
document.search.gsa.checked = true ;
|
}else{
|
document.search.gsa.checked = false ;
|
}
|
}
|
}
|
YAHOO.util.Event.onDOMReady(initRoboHelpDOM);
|
YAHOO.util.Event.onDOMReady(setSearchUserPref);
|
// ]]-->
|
</script>
|
<!--#include virtual="/ssi/globalheader.ssi" -->
|
<!--#include virtual="/en_US/ssi/localheader.ssi" -->
|
<!--#include virtual="header.ssi" -->
|
<link rel="stylesheet" type="text/css" href="tree.css" />
|
<link rel="stylesheet" type="text/css" href="content.css" />
|
<link rel="stylesheet" type="text/css" href="localeSpecific.css" />
|
</head>
|
<body id="content_body" onload="window.focus();">
|
<a name="top" shape="rect"><!--LeaveCommentHere--></a>
|
|
<div id="mnemonic">
|
<div class="ColdFusion"><div class="banner"><a href="WSf01dbd23413dda0e51f089d212047ee7a02-8000.html">Adobe ColdFusion 10</a></div></div>
|
</div>
|
|
<div id="searchbar">
|
<table id="searchbartable">
|
<tr>
|
<td colspan="2">
|
<div id="pdf"><img src="images/PDF.gif" width="16" height="16" hspace="10" /> 
|
<a title="View Help PDF" href="http://help.adobe.com/en_US/ColdFusion/10.0/Admin/coldfusion_10_admin.pdf">View Help PDF (adobe.com)</a></div>
|
</td>
|
</tr>
|
</table>
|
</div>
|
|
<!-- BEGIN SEARCH CONTENT -->
|
<form id="search" name="search" action="search.html" target="_self">
|
<script type="text/javascript">
|
<!--[CDATA[
|
if ( !use_chc_behavior ){
|
if (typeof(terms_AHV_SEARCH_CONSTRAINT) != "undefined" &&
|
terms_AHV_SEARCH_CONSTRAINT.length > 0 &&
|
document.location.href.indexOf(".adobe.com") > 0){
|
if ( typeof(terms_SEARCH_THIS_HELP_ONLY) != "undefined" && terms_SEARCH_THIS_HELP_ONLY == "ON" ) {
|
document.write('<div id="searchscope"> \
|
<input onchange="setAHSearchPref();" \
|
class="gsa" \
|
name="gsa" \
|
id="gsa" \
|
type="checkbox" \
|
checked="checked" \
|
value="1" ><\/input>');
|
|
// Leave the "Search this help system only" checkbox unckecked
|
}else{
|
document.write('<div id="searchscope"> \
|
<input onchange="setAHSearchPref();" \
|
class="gsa" \
|
name="gsa" \
|
id="gsa" \
|
type="checkbox" \
|
value="1" ><\/input>');
|
}
|
document.write('<span class="gsalabel">' + terms_AHV_SEARCH_CONSTRAINT + '<\/span><\/div>');
|
}
|
document.write('<input class="searchinput" \
|
name="q" \
|
id="q" \
|
type="text" \
|
maxlength="256" \
|
value="' + terms_AHV_SEARCH_BUTTON + '" \
|
onclick="clearSearch()"><\/input><input \
|
type="button" \
|
name="searchbutton" \
|
class="searchbutton" \
|
onclick="submit()"><\/input>');
|
}
|
|
/*
|
* Start Functions
|
*/
|
function clearSearch(){
|
if (document.search.q.value == terms_AHV_SEARCH_BUTTON){document.search.q.value = ""};
|
}
|
|
// set search preferences
|
function setAHSearchPref(){
|
if (document.search.gsa.checked == 1){
|
setAHSearchCookie( dirname );
|
}else{
|
setAHSearchCookie( "community" );
|
}
|
}
|
|
// Set search preferences cookie
|
function setAHSearchCookie( p ){
|
// set cookie ah_searchpref with a value of the document path
|
var expire=new Date();
|
expire.setDate(expire.getDate()+365); // Cookie expires after 1 year (365 days)
|
document.cookie="ah_searchpref=" +p+ "; expires=" +expire.toGMTString()+ ";";
|
}
|
|
// ]]-->
|
</script>
|
</form>
|
<!-- END SEARCH CONTENT -->
|
|
|
|
<!-- BEGIN PAGE CONTENT WRAPPER -->
|
<div id="page_content_wrapper">
|
<!-- BEGIN PAGE WRAPPER -->
|
<table id="page_content_table">
|
<tr>
|
<!--#include virtual="recommendations_topic.ssi" -->
|
<td id="col2">
|
<!-- BEGIN CONTENT WRAPPER -->
|
<!-- BEGIN BREADCRUMBS -->
|
|
|
<div id="breadcrumb">
|
|
<ul class="navigation"><li class="prev"><a accesskey="p" class="prev" href="WSc3ff6d0ea77859461172e0811cbf3639b1-7ffd.html" title="About JDBC"><img src="images/blank.gif" alt="Previous" width="17" height="17" /></a></li><li class="next"><a accesskey="n" class="next" href="WSc3ff6d0ea77859461172e0811cbf364104-7fdb.html" title="Connecting to Apache Derby Client"><img src="images/blank.gif" alt="Next" width="17" height="17" /></a></li></ul><div class="hierarchy" id="hierarchy"><a href="WSf01dbd23413dda0e51f089d212047ee7a02-8000.html"><b>Home</b></a> / <a href="WSf01dbd23413dda0e51f089d212047ee7a02-8000.html"><b>Configuring and Administering ColdFusion 10</b></a> / <a href="WSc3ff6d0ea77859461172e0811cbf364104-7ffa.html"><b>Data Source Management</b></a>
|
</div>
|
|
</div>
|
<!-- END BREADCRUMBS -->
|
<div id="content_wrapper">
|
<!-- BEGIN PAGE TITLE -->
|
<h1>Adding data sources</h1>
|
<!-- END PAGE TITLE -->
|
<!-- BEGIN IONCOMMENTCOUNT -->
|
<div id="ionCount">
|
</div>
|
<!-- END IONCOMMENTCOUNT -->
|
<table id="inner_content_table" width="100%" border="0" cellspacing="0" cellpadding="0"><tr><td>
|
<div style="border-top:#ccc solid 1px;"><p> </p>
|
</div>
|
<!--#include virtual="contentheader.ssi" -->
|
|
<div id="minitoc"><div class="t"><div class="b"><div><ul id="minitoc-links"><li><p><a href="#WSc3ff6d0ea77859461172e0811cbf3639b1-7ffb"><span class="topictitle1">Adding data sources in the Administrator</span>
|
</a></p><ul><li><p><a href="#WSA2A6B77B-A39A-44cd-BF63-58882C44E6B5"><span class="topictitle2">Specifying connection string arguments</span>
|
</a></p></li><li><p><a href="#WS106AE78E-F912-4451-8EDF-5382AE2B8C78"><span class="topictitle2">Guidelines for data sources</span>
|
</a></p></li><li><p><a href="#WSe9cbe5cf462523a0-537db363122d095452c-8000"><span class="topictitle2">Connection Issues</span>
|
</a></p></li></ul></li></ul></div></div></div></div><div><p>In
|
the ColdFusion Administrator, you configure your data sources to
|
communicate with ColdFusion. After you add a data source to the
|
Administrator, you access it by name in any CFML tag that establishes
|
database connections; for example, in the cfquery tag. During a
|
query, the data source tells ColdFusion which database to connect
|
to and what parameters to use for the connection.</p>
|
<p>The ColdFusion Administrator organizes information about all
|
ColdFusion server database connections in a single location. In
|
addition to adding data sources, you can use the Administrator to
|
specify changes to your database configuration, such as relocation,
|
renaming, or changes in security permissions.</p>
|
<ul class="navlinklist"></ul>
|
</div>
|
<div id="WSc3ff6d0ea77859461172e0811cbf3639b1-7ffb" class="nochunk"><a name="WSc3ff6d0ea77859461172e0811cbf3639b1-7ffb"><!-- --></a><h2 class="topictitle2">Adding data sources in the Administrator</h2><div><p>You use the ColdFusion Administrator to quickly add a data
|
source for use in your ColdFusion applications. When you add a data
|
source, you assign it a data source name (DSN) and set all information
|
required to establish a connection. </p>
|
<div class="note"><span class="notetitle">Note: </span>ColdFusion includes data sources that are configured
|
by default. You do not need the following procedure to work with
|
these data sources.</div>
|
<ol><li><p>In the ColdFusion Administrator, select Data & Services
|
> Data Sources.</p>
|
</li>
|
<li><p>Under Add New Data Source, enter a data source name; for
|
example, MyTestDSN. The following names are reserved; you cannot
|
use them for data source names:</p>
|
<ul><li><p>service</p>
|
</li>
|
<li><p>jms_provider</p>
|
</li>
|
<li><p>comp</p>
|
</li>
|
<li><p>jms</p>
|
</li>
|
</ul>
|
</li>
|
<li><p>Select a driver from the drop-down list; for example, Microsoft
|
SQL Server.</p>
|
</li>
|
<li><p>Click Add.</p>
|
<p>A form for additional DSN information appears.
|
The available fields in this form depend on the driver that you
|
selected.</p>
|
</li>
|
<li><p>In the Database field, enter the name of the database; for
|
example, Northwind.</p>
|
</li>
|
<li><p>In the Server field, enter the network name or IP address
|
of the server that hosts the database, and enter any required Port
|
value. For example, the bullwinkle server on the default port.</p>
|
</li>
|
<li><p>If your database requires login information, enter your user
|
name and password.</p>
|
<div class="note"><span class="notetitle">Note: </span>The omission of required
|
user name and password information is a common reason why a data
|
source fails to verify.</div>
|
</li>
|
<li><p>(Optional) Enter a Description.</p>
|
</li>
|
<li><p>(Optional) Click Show Advanced Settings to specify any ColdFusion
|
specific settings; for example, to configure which SQL commands
|
can interact with this data source.</p>
|
</li>
|
<li><p>Click Submit to create the data source.</p>
|
<p>ColdFusion
|
automatically verifies that it can connect to the data source.</p>
|
</li>
|
<li><p>(Optional) To verify this data source later, click the verify
|
icon in the Actions column.</p>
|
<div class="note"><span class="notetitle">Note: </span>To check the
|
status of all data sources available to ColdFusion, click Verify
|
All Connections.</div>
|
</li>
|
</ol>
|
</div><div id="WSA2A6B77B-A39A-44cd-BF63-58882C44E6B5" class="nochunk"><a name="WSA2A6B77B-A39A-44cd-BF63-58882C44E6B5"><!-- --></a><h3 class="topictitle3">Specifying connection string arguments</h3><div><p>The
|
ColdFusion Administrator lets you specify connection-string arguments
|
for data sources. In the Advanced Settings page, use the Connection
|
String field to enter name-value pairs separated by a semicolon.
|
For more information, see the documentation for your database driver.</p>
|
<div class="note"><span class="notetitle">Note: </span>The <samp class="codeph">cfquery</samp><samp class="codeph">connectstring</samp> attribute
|
is no longer supported.</div>
|
</div></div><div id="WS106AE78E-F912-4451-8EDF-5382AE2B8C78" class="nochunk"><a name="WS106AE78E-F912-4451-8EDF-5382AE2B8C78"><!-- --></a><h3 class="topictitle3">Guidelines for data sources</h3><div><p>When you add data sources to ColdFusion,
|
keep in mind the following guidelines: </p>
|
<ul><li><p>Data source names must be all one word.</p>
|
</li>
|
<li><p>Data source names can contain only letters, numbers, hyphens,
|
and the underscore character (_).</p>
|
</li>
|
<li><p>Data source names must not contain special characters or
|
spaces.</p>
|
</li>
|
<li><p>Although data source names are not case sensitive, use a
|
consistent capitalization scheme.</p>
|
</li>
|
<li><p>Depending on the JDBC driver, connection strings and JDBC
|
URLs might be case sensitive.</p>
|
</li>
|
<li><p>Use the Administrator to verify that ColdFusion can connect
|
to the data source.</p>
|
</li>
|
<li><p>A data source must exist in the ColdFusion Administrator
|
before you use it on an application page to retrieve data.</p>
|
</li>
|
</ul>
|
</div></div><div id="WSe9cbe5cf462523a0-537db363122d095452c-8000" class="nochunk"><a name="WSe9cbe5cf462523a0-537db363122d095452c-8000"><!-- --></a><h3 class="topictitle3">Connection Issues</h3><div><p>Executing a query when you restart a database can result
|
in error during the first request. The error does not occur in subsequent
|
requests or if connection pooling is disabled. This is because,
|
during the first request, the cached connection is used to execute
|
the query, leading to an exception. To overcome this issue, validate
|
the connection before executing the query.</p>
|
<div class="para">Provide validationQuery (to validate the connection) before executing
|
the query in the Advanced Settings page. <div class="note"><span class="notetitle">Note: </span>validationQuery has
|
to be used with caution as it can result in performance issues.</div>
|
</div>
|
</div></div></div>
|
|
|
<!-- BEGIN USER PREFERENCES -->
|
<div id="userprefs">
|
</div>
|
<!-- END USER PREFERENCES -->
|
|
<div id="related">
|
|
|
<div class="separator"><a href="#top"><img src="images/BTT.jpg" /></a> </div>
|
</div>
|
<div id="footer">
|
<!-- BEGIN IONCOMMENTS -->
|
<div id="ionComHere">
|
</div>
|
<!-- END IONCOMMENTS -->
|
<!--#include virtual="/ssi/ionComments.ssi" -->
|
<p id="creativecommons"><a href="http://creativecommons.org/licenses/by-nc-sa/3.0/" id="creativecommons_text"><img id="creativecommons_img" src="images/CC.png" alt="This work is licensed under a Creative Commons Attribution-Noncommercial-Share Alike 3.0 Unported License" /></a> Twitter™ and Facebook posts are not covered under the terms of Creative Commons.</p>
|
</div>
|
</td>
|
<td width="10px"></td>
|
<td id="inner_rightcolumn">
|
<!--#include virtual="rightcolumn.ssi" -->
|
</td></tr></table>
|
</div>
|
<!-- BEGIN BREADCRUMBS -->
|
<div id="breadcrumb">
|
|
<ul class="navigation"><li class="prev"><a accesskey="p" class="prev" href="WSc3ff6d0ea77859461172e0811cbf3639b1-7ffd.html" title="About JDBC"><img src="images/blank.gif" alt="Previous" width="17" height="17" /></a></li><li class="next"><a accesskey="n" class="next" href="WSc3ff6d0ea77859461172e0811cbf364104-7fdb.html" title="Connecting to Apache Derby Client"><img src="images/blank.gif" alt="Next" width="17" height="17" /></a></li></ul><div class="hierarchy" id="hierarchy"><a href="WSf01dbd23413dda0e51f089d212047ee7a02-8000.html"><b>Home</b></a> / <a href="WSf01dbd23413dda0e51f089d212047ee7a02-8000.html"><b>Configuring and Administering ColdFusion 10</b></a> / <a href="WSc3ff6d0ea77859461172e0811cbf364104-7ffa.html"><b>Data Source Management</b></a>
|
</div>
|
|
</div>
|
<!-- END BREADCRUMBS -->
|
<!-- END CONTENT WRAPPER -->
|
<!--#include virtual="contentfooter.ssi" -->
|
</td>
|
<td id="col3">
|
<div>
|
<img src="images/adobe-lq.png" />
|
</div>
|
</td>
|
</tr>
|
</table>
|
</div>
|
<!-- END PAGE CONTENT WRAPPER -->
|
<script type="text/javascript">
|
<!--[CDATA[
|
scrollToNameAnchor();
|
// ]]-->
|
</script>
|
<!--#include virtual="/en_US/ssi/productmenu.ssi" -->
|
<style>
|
#legal-notices{
|
margin:10px 40px;
|
font-size:11px;
|
}
|
</style>
|
|
<p id="legal-notices">
|
<script language="javascript">
|
var pageLoc = "en_US";
|
var metaElements = document.all ?
|
document.all.tags('meta') :
|
document.getElementsByTagName ?
|
document.getElementsByTagName ('meta') : new Array();
|
for (var m = 0; m < metaElements.length; m++) {
|
if (metaElements[m].name == "lang") {
|
pageLoc = metaElements[m].content;
|
break;
|
}
|
}
|
var ptn = /(..)-(..)/;
|
if (ptn.test(pageLoc)) {
|
var languageCode = pageLoc.replace(ptn, "$1");
|
var countryCode = pageLoc.replace(ptn, "$2");
|
pageLoc = languageCode + "_" + countryCode.toUpperCase();
|
}
|
|
var legalLoc = "en_US";
|
var legalText = "Legal Notices";
|
var legalPath = legalLoc;
|
var legalArray=[
|
"ar_AE", "إشعارات قانونية",
|
"bg_BG", "Юридически бележки",
|
"cs_CZ", "Právní upozornění",
|
"da_DK", "Juridiske meddelelser",
|
"de_DE", "Rechtliche Hinweise",
|
"el_GR", "Σημειώσεις νομικού περιεχομένου",
|
"es_ES", "Avisos legales",
|
"et_EE", "Juriidilised teated",
|
"fi_FI", "Lakisääteiset ilmoitukset",
|
"fr_FR", "Mentions légales",
|
"he_IL", "הצהרות משפטיות",
|
"hr_HR", "Pravne napomene",
|
"hu_HU", "Jogi közlemények",
|
"it_IT", "Informazioni legali",
|
"ja_JP", "法律上の注意",
|
"ko_KR", "법적 고지 사항",
|
"lt_LT", "Teisinės pastabos",
|
"lv_LV", "Juridisks paziņojums",
|
"nb_NO", "Juridiske merknader",
|
"nl_NL", "Juridische kennisgevingen",
|
"pl_PL", "Informacje prawne",
|
"pt_BR", "Aspectos jurídicos",
|
"ro_RO", "Prevederi legale",
|
"ru_RU", "Юридическая информация",
|
"sk_SK", "Právne upozornenie",
|
"sl_SI", "Pravni pouk",
|
"sv_SE", "Upphovsrätt",
|
"tr_TR", "Yasal uyarılar",
|
"uk_UA", "Юридична інформація",
|
"zh_CN", "法律声明",
|
"zh_TW", "法律注意事項"
|
];
|
|
for (var i = 0; i < legalArray.length; i+=2) {
|
if (pageLoc == legalArray[i]) {
|
legalLoc = pageLoc;
|
legalText = legalArray[i+1];
|
legalPath = legalLoc;
|
break;
|
}
|
}
|
document.write('<a target="_blank" href="http://help.adobe.com/'+legalPath+'/legalnotices/index.html">'+legalText+'</a>');
|
</script>
|
</p>
|
|
<!--#include virtual="/en_US/ssi/localfooter.ssi" -->
|
<!--#include virtual="footer.ssi" -->
|
<!--#include virtual="/ubi/analytics/analytics_ssi.html" -->
|
</body>
|
</html>
|
