displaying top 100 results
Tracker Issue Bug 77420:Tried to set up a datasource using mysql 4/5 type and have the right info and connected with cf8 but not 9
Bug 77420:Tried to set up a datasource using mysql 4/5 type and have the right info and connected with cf8 but not 9
Tracker Comment Comment on MySQL 5.6 Unable to Execute Queries by External U.
Comment on MySQL 5.6 Unable to Execute Queries by External U.
Tracker Comment Comment on Bug 80192:The DataDirect MySQL driver will not connect to a Community Edition MySQL database by External U.
Comment on Bug 80192:The DataDirect MySQL driver will not connect to a Community Edition MySQL database by External U.
Tracker Comment Comment on Bug 80192:The DataDirect MySQL driver will not connect to a Community Edition MySQL database by External U.
Comment on Bug 80192:The DataDirect MySQL driver will not connect to a Community Edition MySQL database by External U.
Tracker Issue Bug 80192:The DataDirect MySQL driver will not connect to a Community Edition MySQL database
Bug 80192:The DataDirect MySQL driver will not connect to a Community Edition MySQL database
2608336 CF-4119801 External U. 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
Tracker Comment Comment on Connection String in MySQL Datasource sent to Database with trailing space by External U.
Comment on Connection String in MySQL Datasource sent to Database with trailing space by External U.
Portal Topic CF18 MYSQL8 Windows Server 2019
CF18 MYSQL8 Windows Server 2019
Tracker Issue MySQL DD corrupts UTF-8 data / MySQL 5 does not
MySQL DD corrupts UTF-8 data / MySQL 5 does not
Comment on Can't Uninstall MySQL from AWS AMI by Vamseekrishna N.
2608336 CF-4119801 Akhila K. 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.
Tracker Comment Comment on MySQL 5.6 datetime rounding error by Himavanth R.
Comment on MySQL 5.6 datetime rounding error by Himavanth R.
Tracker Comment Comment on Unknown table variables in information_schema ColdFusion10 + MySQL 5.5 Enterprise by Nimit S.
Comment on Unknown table variables in information_schema ColdFusion10 + MySQL 5.5 Enterprise by Nimit S.
Comment on Bug 78969:When ColdFusion is running, and successfully makes one or more exchanges with a database ( MySQL in my setup ), and then that database server is restarted ( the MySQL service is restarted ), the first by External U.
Comment on Loads of SQL errors in ClientScopeCleanUpThread with MySQL by Bradley W.
2608613 CF-4049903 Nimit S. Hi Kheirbakhsh,
MySQL(DataDirect) driver is supported only for MySQL Enterprise or Commercial versions.
If you are using MySQL Community Edition, then please try creating data source with "MySQL5" and not with "MySQL(DataDirect)".
Please let us know if you are still
Tracker Comment Comment on Unknown table variables in information_schema ColdFusion10 + MySQL 5.5 Enterprise by Adobe D.
Comment on Unknown table variables in information_schema ColdFusion10 + MySQL 5.5 Enterprise by Adobe D.
Portal Topic MySql Connection
MySql Connection
Bug 77588:Tried to make a database connection using MySQL 4/5 and it failed
Tracker Issue Can't Uninstall MySQL from AWS AMI
Can't Uninstall MySQL from AWS AMI
Tracker Issue CFQUERY turns Emojis into Question marks
3297734 CF-4199071 Database : CFQuery Joshua Saia CFQUERY turns Emojis into Question marks Problem Description: CFQUERY turns Emojis into Question marks on insert in MySQL database
Steps to Reproduce: Using Coldfusion connected to MySQL database with everything set to use UTF8MB4 collation, try
Tracker Comment Comment on Unknown table variables in information_schema ColdFusion10 + MySQL 5.5 Enterprise by External U.
Comment on Unknown table variables in information_schema ColdFusion10 + MySQL 5.5 Enterprise by External U.
Tracker Comment Comment on Please integrate MariaDB driver in CF Administrator since MySQL 5 drivers were dropped in CF 11 by Philipp C.
Comment on Please integrate MariaDB driver in CF Administrator since MySQL 5 drivers were dropped in CF 11 by Philipp C.
Portal Comment Comment on coldfusion 7mx by Charlie Arehart
Charlie Arehart
When you refer to “some” queries “not running”, do you really only some, or do you mean ANY that use mysql?
I’ll assume the latter, and a difference between cf7 and 2018 is that Adobe no longer provides the mysql driver (for licensing reasons) . You need to get it (free
Tracker Comment Comment on Coldfusion CFScript Query with MySQL Assignment Operator by Vamseekrishna N.
Comment on Coldfusion CFScript Query with MySQL Assignment Operator by Vamseekrishna N.
Comment on Coldfusion CFScript Query with MySQL Assignment Operator by Himavanth R.
Tracker Comment Comment on Connection String in MySQL Datasource sent to Database with trailing space by External U.
Comment on Connection String in MySQL Datasource sent to Database with trailing space by External U.
Tracker Comment Comment on Connection String in MySQL Datasource sent to Database with trailing space by External U.
Comment on Connection String in MySQL Datasource sent to Database with trailing space by External U.
Tracker Issue Bug 76111:Mysql driver 5
Bug 76111:Mysql driver 5
Tracker Issue MySQL 5.6 Unable to Execute Queries
MySQL 5.6 Unable to Execute Queries
Tracker Comment Comment on Why are the MySQL drivers not shipped? by External U.
Comment on Why are the MySQL drivers not shipped? by External U.
Comment on MySQL DD corrupts UTF-8 data / MySQL 5 does not by Nimit S.
Comment on MySQL DD corrupts UTF-8 data / MySQL 5 does not by External U.
Tracker Comment Comment on MySQL 5.6 Unable to Execute Queries by External U.
Comment on MySQL 5.6 Unable to Execute Queries by External U.
Tracker Issue Why are the MySQL drivers not shipped?
Why are the MySQL drivers not shipped?
Tracker Issue Cannot find already verified datasource
2609062 CF-3940288 Database : JDBC Troy Garrett Cannot find already verified datasource 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
Unknown table variables in information_schema ColdFusion10 + MySQL 5.5 Enterprise
Tracker Issue Database connection issue via CFIDE/admin & MAMP Pro
2608613 CF-4049903 Database Mohammad kheirbakhsh Database connection issue via CFIDE/admin & MAMP Pro Problem Description:
Steps to Reproduce:
start CF server via yosemite terminal on macbook Pro
go to http://127.0.0.1/CFIDE/administrator/index.cfm
under datasource click add datasource with MYSQL
Tracker Issue Please integrate MariaDB driver in CF Administrator since MySQL 5 drivers were dropped in CF 11
Please integrate MariaDB driver in CF Administrator since MySQL 5 drivers were dropped in CF 11
Tracker Issue Issue while creating application-specific data source using lowercase alphabet only in format.
2609408 CF-3849591 Database : General ext-user Issue while creating application-specific data source using lowercase alphabet only in format. Problem: Issue while creating application-specific data source using lowercase alphabet only in format.
Method:
see notes
this.datasources = { "mysql5_DD
Tracker Comment Comment on Cannot find already verified datasource by Piyush K.
2609062 CF-3940288 Piyush K. 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
Bug 78969:When ColdFusion is running, and successfully makes one or more exchanges with a database ( MySQL in my setup ), and then that database server is restarted ( the MySQL service is restarted ), the first
Loads of SQL errors in ClientScopeCleanUpThread with MySQL
How to use Unicode for Chinese characters in ColdFusion and MySQL
Tracker Issue MySQL 5.6 datetime rounding error
MySQL 5.6 datetime rounding error
Comment on Why are the MySQL drivers not shipped? by Vamseekrishna N.
Tracker Comment Comment on Why are the MySQL drivers not shipped? by Luis M.
Comment on Why are the MySQL drivers not shipped? by Luis M.
Tracker Comment Comment on Can't Uninstall MySQL from AWS AMI by External U.
Comment on Can't Uninstall MySQL from AWS AMI by External U.
2673653 CF-4119834 External U. The attached report is full accessable but you can't see the query.
RDS -> Coldfusion MySQL embedded ODBC driver.
Server: Windows Server 2008
Client: Windows 7
2609062 CF-3940288 External U. 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.
Tracker Comment Comment on MySQL 5.6 datetime rounding error by External U.
Comment on MySQL 5.6 datetime rounding error by External U.
Tracker Comment Comment on MySQL 5.6 Unable to Execute Queries by External U.
Comment on MySQL 5.6 Unable to Execute Queries by External U.
Tracker Comment Comment on MySQL 5.6 Unable to Execute Queries by External U.
Comment on MySQL 5.6 Unable to Execute Queries by External U.
Tracker Comment Comment on Connection String in MySQL Datasource sent to Database with trailing space by External U.
Comment on Connection String in MySQL Datasource sent to Database with trailing space by External U.
Tracker Comment Comment on Connection String in MySQL Datasource sent to Database with trailing space by External U.
Comment on Connection String in MySQL Datasource sent to Database with trailing space by External U.
Tracker Comment Comment on Connection String in MySQL Datasource sent to Database with trailing space by Nimit S.
Comment on Connection String in MySQL Datasource sent to Database with trailing space by Nimit S.
Tracker Comment Comment on Connection String in MySQL Datasource sent to Database with trailing space by External U.
Comment on Connection String in MySQL Datasource sent to Database with trailing space by External U.
Tracker Comment Comment on Bug 80629:A date value returned from a MySQL query using the GREATEST() function, is seen by CF9 as a binary value by External U.
Comment on Bug 80629:A date value returned from a MySQL query using the GREATEST() function, is seen by CF9 as a binary value by External U.
Comment on Loads of SQL errors in ClientScopeCleanUpThread with MySQL by Nimit S.
Tracker Issue CF10u11 requests improper SQL for Cluster Scheduling
2611550 CF-3612846 Scheduler Kevyn Weiner CF10u11 requests improper SQL for Cluster Scheduling Problem Description:
When attempting to configure a Cluster Setup for Scheduled Tasks, and utilizing a mySQL datasource, ColdFusion creates all upper case tables, but when requesting the tables uses mixed
Comment on CF18 MYSQL8 Windows Server 2019 by Charlie Arehart
Bug 79536:This error is caused when setting up a MySQL 4/5 Datasource, the same datasource works in the public beta but gives an error in the new version
Tracker Issue Bug 85531:(Watson Migration Closure)cfdbinfo tag returns column_size of 10 for MySQL columns of datatype INT(8)
Bug 85531:(Watson Migration Closure)cfdbinfo tag returns column_size of 10 for MySQL columns of datatype INT(8)
Portal Topic Problem picking-up my datasource
martyi3150533 Problem picking-up my datasource Any assistance would be appreciated ?? I connected my CF2018 to my mariaDB server: Actions Data Source Name Driver Status rhce MySQL OK But, I’m getting below output: SELECT sno, firstname, lastname, city, country, age FROM scientists Sno First
Tracker Issue After installation the Coldfusion Administrator worked at first, then gave error "The DataSource service is not available"
2673364 CF-4126692 Administrator A. Bakia After installation the Coldfusion Administrator worked at first, then gave error "The DataSource service is not available" Problem Description: I successfully installed Coldfusion Raijin on Windows 7, 32 Bit. I then opened the administrator and added MySQL
Tracker Issue Coldfusion CFScript Query with MySQL Assignment Operator
Coldfusion CFScript Query with MySQL Assignment Operator
Tracker Issue cfexecute has a problem using redirect operator <
2613538 CF-3285881 Language Eric Sontag cfexecute has a problem using redirect operator -p -D
Actual Result:
cmdoutput retyurns:
mysql.exe Ver 14.3 Distrib 4.1.1-alpha, for Win95/Win98 (i32) Copyright (C) 2002 MySQL AB This software comes with ABSOLUTELY NO WARRANTY. This is free ...
dummy
Connection String in MySQL Datasource sent to Database with trailing space
Tracker Issue Bug 80629:A date value returned from a MySQL query using the GREATEST() function, is seen by CF9 as a binary value
Bug 80629:A date value returned from a MySQL query using the GREATEST() function, is seen by CF9 as a binary value
Tracker Issue Bug 78418:Hi,
2600373 CF-3039097 ORM Support Sam Farmer Bug 78418:Hi, Problem:
Hi,
I am getting a DDL generation error with the code below. Connecting to a MySQL 5.1 community database on Mac OS 10.5.7.
Thanks,
Sam
Method:
App.cfc:
Component Application {
this.name = "trackrApp";
this
Tracker Comment Comment on CFQUERY BUG by Chad A.
4056001 CF-4201446 Chad A. I found the problem. I was testing ColdFusion 2016 Standard on the same MySQL 5.7 database as the production server running ColdFusion 9 Enterprise. After making a copy of the production database and using the copied database for testing, the SQL statements are now
3185843 CF-4198855 Chris D. Is this issue actually fixed in HF5? I'm encountering a similar issue with CF2016 HF5 while using MySQL and Oracle datasources, see post at: https://forums.adobe.com/message/10044289#10044289
Tracker Comment Comment on Better Guidance on Advance DB settings for large amounts of data by External U.
2673022 CF-4156096 External U. its vague, because they don't think its their baby. Maybe they should at least put out or endorse an end to end solution with the 2 major CF DBs MySQL and SQL Server. CF needs to document itself more as a solution to common problems.
2673653 CF-4119834 Poonam J. Crasen,
Could you please provide more information to let us understand the scenario:
1) Which mysql version you are using?
2) The screenshot attached says RDS type as JDBC while in note you are mentioning the type as ODBC.
3)How you configured the data source
2609215 CF-3910529 External U. Have you tried with MySQL instead of Apache Derby? Have you tried using a real Application.cfc instead of some lines inside a file named Application.cfc? Have you tried using a service object instead of a function inline in the view file?
Tracker Comment Comment on MySQL 5.6 datetime rounding error by Himavanth R.
Comment on MySQL 5.6 datetime rounding error by Himavanth R.
Tracker Comment Comment on Connection String in MySQL Datasource sent to Database with trailing space by External U.
Comment on Connection String in MySQL Datasource sent to Database with trailing space by External U.
Tracker Comment Comment on Connection String in MySQL Datasource sent to Database with trailing space by External U.
Comment on Connection String in MySQL Datasource sent to Database with trailing space by External U.
Tracker Comment Comment on Connection String in MySQL Datasource sent to Database with trailing space by External U.
Comment on Connection String in MySQL Datasource sent to Database with trailing space by External U.
Tracker Comment Comment on Connection String in MySQL Datasource sent to Database with trailing space by Asha K.
Comment on Connection String in MySQL Datasource sent to Database with trailing space by Asha K.
Tracker Comment Comment on Connection String in MySQL Datasource sent to Database with trailing space by External U.
Comment on Connection String in MySQL Datasource sent to Database with trailing space by External U.
Tracker Comment Comment on Connection String in MySQL Datasource sent to Database with trailing space by Nimit S.
Comment on Connection String in MySQL Datasource sent to Database with trailing space by Nimit S.
Tracker Comment Comment on Connection String in MySQL Datasource sent to Database with trailing space by External U.
Comment on Connection String in MySQL Datasource sent to Database with trailing space by External U.
Tracker Comment Comment on Connection String in MySQL Datasource sent to Database with trailing space by External U.
Comment on Connection String in MySQL Datasource sent to Database with trailing space by External U.
Tracker Comment Comment on Connection String in MySQL Datasource sent to Database with trailing space by External U.
Comment on Connection String in MySQL Datasource sent to Database with trailing space by External U.
Tracker Comment Comment on Bug 80629:A date value returned from a MySQL query using the GREATEST() function, is seen by CF9 as a binary value by External U.
Comment on Bug 80629:A date value returned from a MySQL query using the GREATEST() function, is seen by CF9 as a binary value by External U.
Tracker Comment Comment on Bug 80629:A date value returned from a MySQL query using the GREATEST() function, is seen by CF9 as a binary value by External U.
Comment on Bug 80629:A date value returned from a MySQL query using the GREATEST() function, is seen by CF9 as a binary value by External U.
Tracker Comment Comment on Cannot Retrieve Columns for Tables with Underscore Characters by Nimit S.
5394853 CF-4204046 Nimit S. Hi Travis,
I have tried it with Oracle12c, MySQL 5.6 and MS SQL Server 2016. It is working as expected.
Create Table Snippet:
{code:java}
create table table_test1 (name_test varchar(20))
{code}
CFML Code Snippet:
{code:java}
{code}
Can you try reproducing
Tracker Comment Comment on Query-Of-Query syntax error when filtering by a string with two dashes by Yogesh P.
6617320 CF-4206460 Yogesh P. I have try to reproduce this issue on CF2016 with update 13,12 and 11, and mysql database i have used. and it's working as expected.
we need some more information.
1.in which update this issue is producible.
2.which database used
Connection to local MySQL database with port 3307 doesn't work
Tracker Issue Cannot clear query cache
2611830 CF-3587061 Caching Michael Henson Cannot clear query cache Problem Description:
I cannot clear the query cache. Using does not work and neither does clearing the query cache from the CF administrator.
Steps to Reproduce:
I run a query on my MySQL database and use the attribute
Tracker Issue Add ability to define datasources within Application.cfc
.datasources.mydatasource={
class:'org.gjt.mm.mysql.Driver'
,connectionString:'jdbc:mysql://localhost:3306/demo_db?characterEncoding=UTF-8&useUnicode=true'
,username:'demouser'
,password:"encrypted:5943217a74b3d570f7ed78738da72bb4972228f46c8f9b7e96f5e995d66d1e9a"
};
}
----------------------------- Additional Watson Details
Setup section, "Datasource" should be "Data source" as that's how it's spelled throughout the rest of the CF Administrator.
2. "Currently supported databases for cluster setup are MYSQL, SQLSERVER and ORACLE" should be "Currently supported databases for cluster setup are MySQL, Microsoft SQL Server
Tracker Issue Bug 73864:(Watson Migration Closure)It'd be nice if we could include parts of the admin in the application setup wizard
CMS. It needs a database for it. I'd be nice if I could have something in the preinstall like
$simpleCMS
MySQL
Derby
This would allow the person installing to setup a datasource during the install process and either set it up as a MySQL or derby DB
2673542 CF-4126428 General Server Philipp Cielen [cielen] OS X Preference pane for starting/stopping CF server There is an OS X preference pane for MySQL and Tomcat and it would be nice to have one for ColdFusion too so one can conveniently start/stop the server from there
to a certain number of records. MySQL doesn't exhibit the same behavior.
My workaround has been to create the indexes manually and set index=false on all persistent properties. Closing the is probably the right call on your end, as the bug should be submitted to the driver development team.
Tracker Comment Comment on Cannot clear query cache by Adobe D.
2611830 CF-3587061 Adobe D. Used CF10 update 11 with mysql datasource and run the below code in Chrome(Windows 7):
select firstname from t1
select firstname from t1
It has dumped the cached value in the first select query
and the changed value in second select query.
Can you please let
Portal Comment Comment on MySql Connection by Charlie Arehart
Comment on MySql Connection by Charlie Arehart
Portal Topic Linked Folder
called Learn Cold Fusion in a Week and struggled through it having to adapt Cold Fusion 10 to Cold Fusiln 2018 and MySql to Sql Server. I […]
The post Linked Folder appeared first on ColdFusion. Blog,CF2018 Updates,ColdFusion 2018,Question,2018,cf2018 updates,coldfusion 2018,question
Legorol San Charlie, when we had this issue, our problem was that the connection timeout set for the datasource in the CF admin was simply ignored by the CF server. The timeout set on the db server was not relevant. (For full clarity, we were using MySQL and not Oracle).
One experiment we did