Reserved words for data source names in ColdFusion MX on Windows platforms

If reserved words are used as data source names in Macromedia ColdFusion MX, you will have problems after restarting ColdFusion and will not be able to display any ColdFusion templates.

Do not use the following reserved words as data source names when creating data sources in the ColdFusion Administrator:

service
comp

The ColdFusion MX Application Server service will not be able to successfully restart if either of these reserved words is used as a data source name.

You will receive one of the following errors when restarting the ColdFusion MX Application Server service on Windows:

On Windows NT: The ColdFusion MX Application Server service returned service specific error 2.
On Windows 2000: Windows could not start the ColdFusion MX Application Server on Local Computer. For more information, review the System Event Log. If this is a non-Microsoft service, contact the service vendor, and refer to service-specific error code 2.

When executing any .cfm template after trying to start ColdFusion, you will receive one of the following errors in the browser:

500 There is no web application configured to service your request

There is no web application configured to service your request
HTTP 500 Internal Server Error

Follow the steps below in order to correct this error.

Make a copy of the jrun-resources.xml file located in thecf_root\runtime\servers\default\SERVER-INF directory and of the neo-query.xml file located in the cf_root\lib directory.

In each XML file, search for the reserved word string and replace it with a non-reserved word. The reserved word will appear twice in each file.

Here is a sample of the neo-query.xml file section that would need to be modified:

<var name='service'><struct type='coldfusion.server.ConfigMap'><var name='update'><boolean value='true'/></var><var name='alter'><boolean value='true'/></var><var name='delete'><boolean value='true'/></var><var name='buffer'><number>64000.0</number></var><var name='storedproc'><boolean value='true'/></var><var name='disable'><boolean value='false'/></var><var name='password'><string></string></var><var name='insert'><boolean value='true'/></var><var name='drop'><boolean value='true'/></var><var name='CLASS'><string>macromedia.jdbc.MacromediaDriver</string></var><var name='login_timeout'><number>30.0</number></var><var name='create'><boolean value='true'/></var><var name='NAME'><string>service</string></var><var name='DRIVER'><string>Oracle</string></var><var name='description'><string></string></var><var name='url'><string>jdbc:macromedia:oracle:   //ps-ale:1521;SID=psale;sendStringParametersAsUnicode   =false</string></var><var name='blob_buffer'><number>64000.0</number></var><var name='revoke'><boolean value='true'/></var><var name='urlmap'><struct type='coldfusion.server.ConfigMap'><var name='defaultpassword'><string></string></var><var name='host'><string>ps-ale</string></var><var name='defaultusername'><string></string></var><var name='databaseFile'><string></string></var><var name='informixServer'><string></string></var><var name='pageTimeout'><string></string></var><var name='args'><string></string></var><var name='database'><string></string></var><var name='maxBufferSize'><string></string></var><var name='port'><string>1521</string></var><var name='selectMethod'><string>direct</string></var><var name='datasource'><string></string></var><var name='SID'><string>psale</string></var><var name='UseTrustedConnection'><string>false</string></var><var name='sendStringParametersAsUnicode'><string>false</string></var><var name='systemDatabaseFile'><string></string></var><var name='CONNECTIONPROPS'><struct><var name='SID'><string>psale</string></var><var name='PORT'><string>1521</string></var><var name='HOST'><string>ps-ale</string></var><var name='SENDSTRINGPARAMETERSASUNICODE'><string>false</string></var></struct></var></struct></var><var name='interval'><number>420.0</number></var><var name='grant'><boolean value='true'/></var><var name='timeout'><number>1200.0</number></var><var name='username'><string>system</string></var><var name='select'><boolean value='true'/></var><var name='disable_blob'><boolean value='true'/></var><var name='pooling'><boolean value='true'/></var><var name='disable_clob'><boolean value='true'/></var></struct></var>

Here is a sample section of the jrun-resources.xml file that would need to be modified:

<data-source><dbname>service</dbname><driver>macromedia.jdbc.MacromediaDriver</driver><url>jdbc:macromedia:oracle:     //ps-ale:1521;SID=psale;     sendStringParametersAsUnicode=false</url><username>system</username><password>820C344489FA5E4A067CA5AD9268C581</password><encrypted>true</encrypted><encryption-class>jrun.security.JRunCrypterForTwofish</encryption-class><native-results>true</native-results><remove-on-exceptions>true</remove-on-exceptions><pool-statements>false</pool-statements><initial-connections>0</initial-connections><connection-timeout>1200</connection-timeout><transaction-timeout>20</transaction-timeout><cache-enabled>false</cache-enabled><cache-size>5</cache-size><cache-refresh-interval>30</cache-refresh-interval><jndi-name>service</jndi-name><poolname>Pool</poolname><minimum-size>0</minimum-size><maximum-size>2147483647</maximum-size><user-timeout>1200</user-timeout><skimmer-frequency>420</skimmer-frequency><shrink-by>5</shrink-by><maximum-soft>true</maximum-soft><debugging>false</debugging><disable-pooling>false</disable-pooling></data-source>

Restart the ColdFusion MX Application Server service and you will be able to serve .cfm templates.

Subtotal
Promotions
Estimated Shipping
VAT	Calculated at checkout

Total

Reserved words for data source names in ColdFusion MX on Windows platforms

Products Affected

Issue

Solution

Additional Information

Products

Download

Support & Learning

Buy

Company