tracker issue : CF-3940288

select a category, or use search below
(searches all categories and all time range)
Title:

Cannot find already verified datasource

| View in Tracker

Status/Resolution/Reason: Closed/Withdrawn/CannotReproduce

Reporter/Name(from Bugbase): Troy Garrett / Troy Garrett (Troy Garrett)

Created: 02/14/2015

Components: Database, JDBC

Versions: 11.0

Failure Type:

Found In Build/Fixed In Build: CF11_Final /

Priority/Frequency: Major / All users will encounter

Locale/System: English / Mac 10.9

Vote Count: 0

Problem Description: After connecting to a MySQL 5.6 Community Server database and creating a datasource in CF Admin, any page that tries to reference the datasource receives an error: Datasource "test" could not be found.

Steps to Reproduce: 
Install CF11 Standalone, Apache, MacOSX 10.10.2. Install MySQL Community Server 5.6, Install MySQL JDBC Connector. 
Create database in MySQL
Create Datasource in CF Admin & verify
Create .cfm document that calls datasource. 
Load document.

Actual Result:

Expected Result:

Any Workarounds:

----------------------------- Additional Watson Details -----------------------------

Watson Bug ID:	3940288

External Customer Info:
External Company:  
External Customer Name: Troy
External Customer Email:  
External Test Config: My Hardware and Environment details:

Mac Mini & MacBook Air

OSX10.10.2

MySQL Community Server 5.6

Attachments:

  1. February 15, 2015 00:00:00: 1_Archive.zip

Comments:

Troy, I am using MySQL community 5.7.3-m13 (the supported version of MySQL) hosted on Win 7 x64 CF11 update 4 build 293328 hosted on OSX 10.10.2 JDBC driver : mysql-connector-java-5.1.32-bin.jar. I am able to query the DSN in a cfm page even after restarting CF. What is the update level (or build no.) of your CF 11. You can find that info in the settings summary in the CF administrator. Also can you share the specifics on the driver you are using (version no., source of download)
Comment by Piyush K.
8485 | February 24, 2015 07:09:11 AM GMT
Hi Piyush, The build number is 000094 JDBC Driver version 5.1.34 (from http://dev.mysql.com/downloads/connector/j/ ) It is very strange behaviour.
Comment by External U.
8486 | February 24, 2015 02:29:06 PM GMT
Troy, "000094" does NOT sound like a CF build number. Can you confirm how you are pulling that piece of info. Have you applied any CF updates, if so what is the udpate level (the latest you can have is Update 4 build/version no: 11,0,04,293328)? When you register a Data Source Name the information is persisted in neo-datasource.xml config file at (<cf_root>/cfusion/lib on a standalone CF server) Can you check the file to see if it contains the details of your DSN. The DSN xml element should be created when you register the DSN.
Comment by Piyush K.
8487 | February 26, 2015 07:54:43 AM GMT
Closing this, since this is not reproducible and we haven't heard back from the reporter. We can reopen this if more info is made available.
Comment by Piyush K.
8488 | June 16, 2015 03:18:12 AM GMT