tracker issue : CF-4126114

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

CFDBINFO type="columns" claims table does not exist in an Oracle 11g db if table name has an underscore in it

| View in Tracker

Status/Resolution/Reason: Closed/Withdrawn/CannotReproduce

Reporter/Name(from Bugbase): Jack Drysdale Jr / Jack Drysdale Jr (Jack Drysdale Jr)

Created: 03/08/2016

Components: Database

Versions: 10.0

Failure Type: Usability Issue

Found In Build/Fixed In Build: Final /

Priority/Frequency: Major / All users will encounter

Locale/System: English / Win 2008 Server

Vote Count: 0

Problem Description:  CFDBINFO type="columns" claims table does not exist in an Oracle 11g db if table name has an underscore in it

Steps to Reproduce:  
1. Create two tables in Oracle 11g; name one "FCOMMENTS" and the other "F_COMMENTS"; give each the same columns/datatypes.
2. Create a .cfm page with the following:
<cftry>
   <cfdbinfo type="columns" table="FCOMMENTS" datasource="foo" name="noUnderscore" />
   <cfdbinfo type="columns" table="F_COMMENTS" datasource="foo" name="withUnderscore" />
   <cfdump var="#noUnderscore#" />
   <cfdump var="#withUnderscore#" />
   <cfcatch>
      <cfdump var="#cfcatch#" />
   </cfcatch>
</cftry>
3. Open page in a browser.

Actual Result:  The noUnderscore dump will appear followed by the CFCATCH dump indicating that the table "F_COMMENTS" does not exist.

Expected Result:  Both "noUnderscore" and "withUnderscore" dumps display.

Any Workarounds:  None, as of this moment.

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

Watson Bug ID:	4126114

External Customer Info:
External Company:  
External Customer Name: Jack Drysdale Jr
External Customer Email:  
External Test Config: My Hardware and Environment details:  Windows Server 2008; CF10, 283111; Java 1.7.0_15.

Attachments:

Comments:

We shouldn't have to rename all our tables to not have an underscore.
Comment by External U.
4375 | March 08, 2016 11:13:27 AM GMT
Correction: Only the CFCATCH dump appears; not the "noUnderscore" dump. Sorry.. lack of sleep plus no caffeine.
Comment by External U.
4376 | March 08, 2016 11:14:51 AM GMT
Hi Jack, I have tried replicating this issue but it is working fine for me. Can you check if you need to prefix schema name with table name? Table which I have used: create table FCOMMENTS ( id int, name varchar2(20) ); create table F_COMMENTS ( id int, name varchar2(20) );
Comment by Nimit S.
4377 | March 09, 2016 01:07:53 AM GMT
@Nimit Sharma: I assume that prefixing schema to table name is not required since it works fine on tables that have names without underscores. But I'll give it a shot.
Comment by External U.
4378 | March 09, 2016 08:24:00 AM GMT
@Nimit Sharma: Prepending the schema name to the table name produces the same error. Table "F.F_COMMENTS" does not exist.
Comment by External U.
4379 | March 09, 2016 08:29:12 AM GMT
Can you please enable spy logging for data source and send the log file? Steps to enable data source logging: 1. Edit the data source. 2. Click on "Show Advanced Settings". 3. Enable "Log Activity" checkbox. Please rerun ColdFusion template after enabling logging.
Comment by Nimit S.
4380 | March 11, 2016 03:58:46 AM GMT
Jack, Please provide the information asked in the previous comment. Nimit
Comment by Nimit S.
4381 | April 11, 2016 06:08:13 AM GMT
We are closing this bug as we have not received any update on this bug. If you are still facing this issue, please comment on this bug along with other details mentioned in the previous comment, so that we can re-open this bug.
Comment by Nimit S.
4382 | May 26, 2016 12:39:20 AM GMT