tracker issue : CF-4119801

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

JDBC Connection get no Schema Table (Report Query)

| View in Tracker

Status/Resolution/Reason: Closed/Withdrawn/CannotReproduce

Reporter/Name(from Bugbase): Carsten Pohl / Carsten Pohl (Carsten Pohl)

Created: 02/19/2016

Components: Reporting, CFReport

Versions: 10.0

Failure Type: Non Functioning

Found In Build/Fixed In Build: CFB2016_Final /

Priority/Frequency: Critical / All users will encounter

Locale/System: English / Win 2008 Server x64

Vote Count: 0

Problem Description:
Coldfusion 11 Data Source (JDBC) shows no Table Info in the Query Builder of Coldfusion Report Builder.

Steps to Reproduce:
1.<click on Report Query>
2.<chose RDS Server>
3.<chose JDBC SOURCE>

Actual Result:
Empty Result after click (file 2016-02-19_110645.png)
Expected Result:
Table definition of selectet Schema like ODBC driver

Any Workarounds:

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

Watson Bug ID:	4119801

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

Server:

Coldfusion 11

Windows 2008

Client:

Report Builder (Build 282452)

Windows 7

Attachments:

  1. February 19, 2016 00:00:00: 1_Coldfusion.zip
  2. February 24, 2016 00:00:00: 2_Bug.zip
  3. June 21, 2016 00:00:00: 3_MySQL-JDBC_CF11_9-Video_2016-06-21_133910.zip
  4. August 02, 2016 00:00:00: 4_mysql-connector-java-5.1.37.zip

Comments:

We are unable to repro this issue, tried with drivers MySQL 5, MySQL (DataDirect) . Please provide us more details on JDBC driver name, version for repro. Thanks, Akhila.
Comment by Akhila K.
4601 | February 23, 2016 09:14:13 AM GMT
MySQL Connector/J 5.1.37 gets no table information of MySQL 5.7 Your suggestion: MySQL 5 embedded driver shows Table definition (works) MySQL Data direct is not supported by MSQL Enterprise 5.7 ---------- We had to use the JDBC driver to see the SQL query and detail infomation in the FusionReactor. Attachment: Bug.zip
Comment by External U.
4602 | February 24, 2016 04:20:10 AM GMT
Carsten, Are you able to verify this datasource in ColdFusion administrator? -Nimit
Comment by Nimit S.
4603 | June 14, 2016 05:18:19 AM GMT
Carsten, Is there any update on this issue? -Nimit
Comment by Nimit S.
4604 | June 20, 2016 09:21:47 PM GMT
I hope this may help.
Comment by External U.
4605 | June 21, 2016 06:15:26 AM GMT
Carsten, Please apply the latest ColdFusion 11 update and try using report query. We have upgraded our database driver with the latest update.
Comment by Nimit S.
4606 | August 02, 2016 06:48:46 AM GMT
Carsten, Is it possible to have connect(remote) session where I can see this issue and help you resolve it? Please contact me at nimsharm@adobe.com -Nimit
Comment by Nimit S.
4607 | August 09, 2016 05:35:25 AM GMT
Carsten, Please provide an update on this.
Comment by Nimit S.
4608 | August 24, 2016 12:24:40 AM GMT
We are closing this bug as we are not able to repro this issue. If you are still this issue please send me an email to have a connect session. I will re-open this bug.
Comment by Nimit S.
4609 | September 21, 2016 09:32:13 AM GMT