displaying top 100 results
Tracker Issue Query of Queries targets wrong type4 jdbc driver
Query of Queries targets wrong type4 jdbc driver
Comment on Query of Queries targets wrong type4 jdbc driver by External U.
Tracker Issue SQL Server 2008 (or newer) HierarchyID datatype not supported by CF10 jdbc driver (works in CF8)
SQL Server 2008 (or newer) HierarchyID datatype not supported by CF10 jdbc driver (works in CF8)
Tracker Comment Comment on SQL Server 2008 (or newer) HierarchyID datatype not supported by CF10 jdbc driver (works in CF8) by External U.
Comment on SQL Server 2008 (or newer) HierarchyID datatype not supported by CF10 jdbc driver (works in CF8) by External U.
Tracker Comment Comment on SQL Server 2008 (or newer) HierarchyID datatype not supported by CF10 jdbc driver (works in CF8) by Asha K.
Comment on SQL Server 2008 (or newer) HierarchyID datatype not supported by CF10 jdbc driver (works in CF8) by Asha K.
Tracker Comment Comment on SQL Server 2008 (or newer) HierarchyID datatype not supported by CF10 jdbc driver (works in CF8) by Nimit S.
Comment on SQL Server 2008 (or newer) HierarchyID datatype not supported by CF10 jdbc driver (works in CF8) by Nimit S.
Tracker Comment Comment on SQL Server 2008 (or newer) HierarchyID datatype not supported by CF10 jdbc driver (works in CF8) by External U.
Comment on SQL Server 2008 (or newer) HierarchyID datatype not supported by CF10 jdbc driver (works in CF8) by External U.
Tracker Comment Comment on SQL Server 2008 (or newer) HierarchyID datatype not supported by CF10 jdbc driver (works in CF8) by External U.
Comment on SQL Server 2008 (or newer) HierarchyID datatype not supported by CF10 jdbc driver (works in CF8) by External U.
Tracker Comment Comment on SQL Server 2008 (or newer) HierarchyID datatype not supported by CF10 jdbc driver (works in CF8) by External U.
Comment on SQL Server 2008 (or newer) HierarchyID datatype not supported by CF10 jdbc driver (works in CF8) by External U.
Tracker Comment Comment on JDBC ERROR by External U.
Comment on JDBC ERROR by External U.
Portal Topic Coldfusion 2016 JDBC Connection To Oracle
Coldfusion 2016 JDBC Connection To Oracle
Portal Topic Connect ColdFusion JDBC to Sybase SQL Anywhere
Connect ColdFusion JDBC to Sybase SQL Anywhere
Tracker Comment Comment on CF11 upate 10 - macromedia_drivers.jar not working on Oracle 11g R2 by External U.
2608072 CF-4196837 External U. This is new try to deploy patch on cf11 after same issue described with Bug CF-4162547 .
Full stacktrace is :
java.sql.SQLNonTransientConnectionException: [Macromedia][Oracle JDBC Driver]No more data available to read. at macromedia.jdbc
Comment on JDBC Connection get no Schema Table (Report Query) by Akhila K.
Comment on JDBC driver fails on updating entities with NULL bit fields in MSQL: specified SQL type is not supported by this driver. by External U.
2612388 CF-3516357 Rupesh K. Why should this be a bug in ColdFusion? We are on JDBC 4.0 and we expect the driver to be on this.This clearly looks like the driver here is not on JDBC 4.0 compliant.
2612626 CF-3489160 External U. This is supported in current JDBC drivers for the most common databases. Since it was only removed due to lack of support in JDBC 2.2 (which was many, many years ago), it's long overdue for being reintroduced!
Comment on JDBC Connection get no Schema Table (Report Query) by Nimit S.
Comment on JDBC Connection get no Schema Table (Report Query) by External U.
Comment on JDBC Connection get no Schema Table (Report Query) by Nimit S.
Tracker Comment Comment on JDBC ERROR by External U.
Comment on JDBC ERROR by External U.
Comment on Bug 75196:(Watson Migration Closure)Upgrade to JDBC 4 by External U.
Comment on Bug 75196:(Watson Migration Closure)Upgrade to JDBC 4 by External U.
Comment on Bug 75196:(Watson Migration Closure)Upgrade to JDBC 4 by External U.
Tracker Issue JDBC ERROR
JDBC ERROR
Tracker Comment Comment on Error when creating CF data source for viaSQL connection (works in previous versions of CF) by Nimit S.
2608788 CF-3996917 Nimit S. Hi Michael,
I am unable to find any documentation related to this driver.
It looks like this JDBC driver implements an older version of the JDBC API, which isn't JDBC 3 and/or 4 ready.
Can you please check the latest version of this driver?
Regards,
Nimit
Tracker Comment Comment on MSSQL 2012 Support by External U.
2611323 CF-3630461 External U. Support for Microsoft SQL Server 2012 AlwaysOn support has been added to the DataDirect JDBC drivers version 5.1.1
http://www.datadirect.com/products/datadirect-connect/jdbc-drivers/features/connect-for-jdbc-release-notes-history
Tracker Comment Comment on Connection String in MySQL Datasource sent to Database with trailing space by External U.
2613636 CF-3197321 External U. This was also occurring on a Linux 64 Bit install
*** Workaround ***
Setup a new datasource with type other
JDBC URL = jdbc:mysql://xxx.xxx.xxx.xxx:3306/dbName?zeroDateTimeBehavior=convertToNull
Driver class = com.mysql.jdbc.Driver
Driver name = MySQL (Other)
Tracker Comment Comment on Slow database performance - Windows 2012 vs Windows 2016/2019 - ColdFusion 2018 by Michael T.
6299942 CF-4205369 Michael T. ColdFusion support recommended updating the JDBC driver. We updated the JDBC driver to Microsoft JDBC Driver 7.4 for SQL Server and the performance issue was resolved on Windows 2019.
There seems to be an issue with the built in drivers for CF.
How to access AlwaysEncrypted column using Microsoft JDBC Driver in Coldfusion 11?
Tracker Issue Bug 78910:Bundle Oracle JDBC driver with CF9
Bug 78910:Bundle Oracle JDBC driver with CF9
Tracker Comment Comment on Conflicting connection information. When the instance name is specified, it is invalid to specify the port number. by External U.
2609752 CF-3784829 External U. I believe this issue stems from JDBC 5 SQL server drivers.
According to Progress.com:
Fixed in hot fix 5.0.1.000060. Refer to 000001201, "Connect for JDBC hot fix download and install instructions" for instructions on how to download and install the hot fix
Tracker Comment Comment on Table names that clash with reserved words no longer escaped properly by Ashudeep S.
5196242 CF-4203835 Ashudeep S. As per my investigation, i found that the query generated by Hibernate framework in this case is correct, its just that the JDBC drivers doesn't allow executing these kind of queries.
the following query is generated by hibernate
*alter table ORM
Comment on Coldfusion 2016 JDBC Connection To Oracle by Legorol San
Leith Tussing We also run the Microsoft native JDBC driver instead of the built in CF one of CF11 and CF2016. We did not experience any issue post upgrade on either. Which version of the JDBC driver are you running? There have been updates along the way to support newer releases of Java. We
Tracker Issue Bug 75196:(Watson Migration Closure)Upgrade to JDBC 4
Bug 75196:(Watson Migration Closure)Upgrade to JDBC 4
Comment on JDBC Connection get no Schema Table (Report Query) by Nimit S.
Comment on [Macromedia][Oracle JDBC Driver][Oracle]ORA-06502: PL/SQL by Nimit S.
Tracker Comment Comment on JDBC ERROR by External U.
Comment on JDBC ERROR by External U.
Tracker Comment Comment on Postgres JDBC driver is so old we cannot use current features in Postgres and self-upgrades beyond 8.3 fail by External U.
Comment on Postgres JDBC driver is so old we cannot use current features in Postgres and self-upgrades beyond 8.3 fail by External U.
Tracker Comment Comment on Microsoft Access with Unicode driver not available on 64 bit platform by Rupesh K.
2610612 CF-3691289 Rupesh K. The JDBC driver is not available on 64-bit platform and hence this can't be fixed.
Tracker Issue MariaDB JDBC : cfquery latin chars
MariaDB JDBC : cfquery latin chars
Portal Topic Connect coldfusion application with Azure cosmos db
on ColdFusion. Data Source,JDBC Connection,Question,ColdFusion,data source,jdbc connection,question
Suchika Singh Hi Benjamin,
I created a datasource using the native JDBC . I used the driver "mssql-jdbc-6.1.0.jre8.jar" to create the database . Then I applied update 8 . Verifying the database shows OK to me. Is there something that I am missing ?
Regards,
Suchika
Bernhard Döbler The driver may not support all database features optimally. However, I know of no incompatibilites. To be save, you can use Oracle's own JDBC driver from https://www.oracle.com/technetwork/database/application-development/jdbc/downloads/index.html
Tracker Issue Support for Access DB
5218797 CF-4203867 Database : MSAccess Support for Access DB Currently receiving error:
Connection verification failed for data source: TEST
java.sql.SQLException: [Macromedia][SequeLink JDBC Driver][SequeLink Server]The specified data source is not defined.
The root cause was that: java
6677312 CF-4206728 Database : JDBC coldfusion queries are executed as sp_prepexec rather than sp_executesql We encounter performances issues due to the fact that queries are executed as sp_prepexec rather than sp_executesql using the default JDBC driver provided by Coldfusion.
error.
Here is part of the stacktrace for the exception:
java.sql.SQLException: Query Of Queries syntax error. Encountered "). Query Of Queries runtime error. at coldfusion.sql.imq.jdbcStatement.parseSQL(jdbcStatement.java:590) at coldfusion.sql.imq.jdbcStatement.fetchResult(jdbcStatement.java:547
Comment on JDBC Connection get no Schema Table (Report Query) by External U.
Tracker Comment Comment on Macromedia Oracle JDBC Driver fails to connect to Oracle 11g R2 when database encryption is required by External U.
Comment on Macromedia Oracle JDBC Driver fails to connect to Oracle 11g R2 when database encryption is required by External U.
Portal Topic CF2016/2018 Datasource SSL configuration
.sql.SQLNonTransientConnectionException: [Macromedia][SQLServer JDBC Driver]SSL handshake failed: Unknown named group ID: 29 The root cause was that: java.sql.SQLNonTransientConnectionException: [Macromedia][SQLServer JDBC Driver]SSL handshake failed: Unknown named group ID: 29” 2- ValidateCertificate=true: “Connection verification failed for data
Tracker Comment Comment on MariaDB JDBC : cfquery latin chars by Nimit S.
Comment on MariaDB JDBC : cfquery latin chars by Nimit S.
Portal Topic ColdFusion 2016 standard and Oracle adventures
on ColdFusion. Blog,Data Source,JDBC Connection,ColdFusion,data source,jdbc,jdbc connection,Oracle,standard
Portal Topic ColdFusion 2016 and Oracle 12c Release2
nc777 ColdFusion 2016 and Oracle 12c Release2 Hi My DBA is going to upgrade our current Oracle from 12c Release 1 to Release 2. For the datasource of my app I have been using JDBC (oracle.jdbc.OracleDriver) to connect to Oracle and it has been working fine. Does anyone know if Release 2 will have
Tracker Issue JDBC Connection get no Schema Table (Report Query)
JDBC Connection get no Schema Table (Report Query)
[Macromedia][Oracle JDBC Driver]No more data available to read
/5 as the driver
- click add
- fill out database name, localhost, username, password
- click submit
Result:
Connection verification failed for data source: test
com.mysql.jdbc.CommunicationsException: Communications link failure due to underlying exception: ** BEGIN NESTED EXCEPTION ** java
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
but not 9. I have a screenshot if that helps more.
Method:
just go through and set up a datasource using mysql 4/5 and when all info is in I click submit and theres an error
Result:
Connection verification failed for data source: blog
com.mysql.jdbc.CommunicationsException: Communications link failure
5512415 CF-4204112 Database Loads of SQL errors in ClientScopeCleanUpThread with MySQL Problem Description:
I have a CF11 server using MySQL DB for client storage and I see tons of JDBC errors that get reported in FusionReactor. These do not affect HTTP requests as they appear to be part of a back
Portal Comment Comment on Support for Oracle 18c by Tom Chiverton
Tom Chiverton Unless Oracle don't provide a JDBC driver, it'll work.
Not the same thing as being "supported" e.g. if it doesn't work you have a legitimate case for free fix and support from Adobe.
Bernhard Döbler The digit is the JAVA version required to use this JAR because support for different JDBC versions is implemented.
In CFAdmin under "JAVA and JVM" you can check if the jar file is found.
Tracker Issue Bug 83575:After installing 9
stashed by the updater) and bouncing the server resolves the issue.The "bad" file has a size of 10,358k.The "good" file has a size of 11,150k.
Result:
java.sql.SQLException: macromedia.jdbc.sqlserver.SQLServerLicense cannot be cast to macromedia.jdbc.sqlserverbase.BaseLicenseThe root cause was that: java
Tracker Comment Comment on Connection fails from SequeLink JDBC Driver to Unicode SequeLink service using Java 1.8 by Krishna R.
Comment on Connection fails from SequeLink JDBC Driver to Unicode SequeLink service using Java 1.8 by Krishna R.
Tracker Comment Comment on Connection fails from SequeLink JDBC Driver to Unicode SequeLink service using Java 1.8 by Nimit S.
Comment on Connection fails from SequeLink JDBC Driver to Unicode SequeLink service using Java 1.8 by Nimit S.
Tracker Comment Comment on Connection fails from SequeLink JDBC Driver to Unicode SequeLink service using Java 1.8 by External U.
Comment on Connection fails from SequeLink JDBC Driver to Unicode SequeLink service using Java 1.8 by External U.
Comment on JDBC Connection get no Schema Table (Report Query) by Nimit S.
Comment on JDBC Connection get no Schema Table (Report Query) by Nimit S.
Comment on JDBC Connection get no Schema Table (Report Query) by Nimit S.
2608369 CF-4110224 External U. Can someone/anyone provide an update on this bug? As our infrastructure grows we cannot survive without the ability to automate JDBC creation (for consistency purposes across many servers).
2608369 CF-4110224 External U. Is there anyway this can be looked at? We have a large cluster of servers and many updating/creating JDBC connections is NOT feasible.
Comment on [Macromedia][Oracle JDBC Driver][Oracle]ORA-06502: PL/SQL by Nimit S.
Comment on [Macromedia][Oracle JDBC Driver][Oracle]ORA-06502: PL/SQL by External U.
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 macromedia][Oracle JDBC Driver]Internal error: Net8 protocol error. by Nimit S.
Comment on macromedia][Oracle JDBC Driver]Internal error: Net8 protocol error. by Nimit S.
Tracker Comment Comment on [Macromedia][Oracle JDBC Driver]No more data available to read by Nimit S.
Comment on [Macromedia][Oracle JDBC Driver]No more data available to read by Nimit S.
Tracker Comment Comment on Enable dbvarname by default by External U.
2609681 CF-3808734 External U. Hi Himavanth,
I have attached the code and stored proc parameter list.
I tried with oracle as well as jdbc driver. it still doesn't work.
this issue happened only after applying update 3.
Thanks
Tracker Comment Comment on MSSQL 2012 Support by External U.
2611323 CF-3630461 External U. AlwaysoOn:
http://technet.microsoft.com/en-us/library/ff877884.aspx
ApplicationIntent=ReadOnly for JDBC driver:
http://technet.microsoft.com/en-us/library/gg558121.aspx
Tracker Comment Comment on MySQL 5.6 Unable to Execute Queries by External U.
2612466 CF-3506758 External U. Tried CF 10 with mysql 5.6 and had the same issue.
I updated to a newer MySQL JDBC connector and the issue went away.
Tracker Comment Comment on MySQL 5.6 Unable to Execute Queries by External U.
2612466 CF-3506758 External U. I am experiencing the same issue - it's JDBC driver problem - CF needs to be updated to 5.1.22 to resolve it.
Tracker Comment Comment on Calling Oracle Package: [Macromedia][Oracle JDBC Driver]User defined type not found: SYS.DBMS_UTILITY by External U.
Comment on Calling Oracle Package: [Macromedia][Oracle JDBC Driver]User defined type not found: SYS.DBMS_UTILITY by External U.
Tracker Comment Comment on Calling Oracle Package: [Macromedia][Oracle JDBC Driver]User defined type not found: SYS.DBMS_UTILITY by Adobe D.
Comment on Calling Oracle Package: [Macromedia][Oracle JDBC Driver]User defined type not found: SYS.DBMS_UTILITY by Adobe D.
Tracker Comment Comment on Calling Oracle Package: [Macromedia][Oracle JDBC Driver]User defined type not found: SYS.DBMS_UTILITY by Nimit S.
Comment on Calling Oracle Package: [Macromedia][Oracle JDBC Driver]User defined type not found: SYS.DBMS_UTILITY by Nimit S.
Tracker Comment Comment on Calling Oracle Package: [Macromedia][Oracle JDBC Driver]User defined type not found: SYS.DBMS_UTILITY by External U.
Comment on Calling Oracle Package: [Macromedia][Oracle JDBC Driver]User defined type not found: SYS.DBMS_UTILITY by External U.
Tracker Comment Comment on Macromedia Oracle JDBC Driver fails to connect to Oracle 11g R2 when database encryption is required by Nimit S.
Comment on Macromedia Oracle JDBC Driver fails to connect to Oracle 11g R2 when database encryption is required by Nimit S.
errors below:
(verified w/ CF2018 hf7)
Caused by: java.sql.SQLSyntaxErrorException: [Macromedia][DB2 JDBC Driver][DB2]ILLEGAL SYMBOL END-OF-STATEMENT; VALID SYMBOLS ARE ncol, 'beep' as ecol
at macromedia.jdbc.db2base.ddcp.b(Unknown Source)
at macromedia.jdbc.db2base.ddcp.a(Unknown Source
Comment on Coldfusion 2016 JDBC Connection To Oracle by Legorol San
Portal Comment Comment on ColdFusion 2016 and Oracle 12c Release2 by nc777
nc777 Thank you, Charlie and Bernhard.
After the upgrade (from R1 to R2 on Oracle) on my dev server I had the server admin installed 12.2.0 client and my CF data source worked. I did see there is a "ojdbc8.jar" file in the new client directory (\client_1\jdbc\lib\). The old client directory
Priyank Shrivastava Hi Charlie,
We have users who still would like to use JNDI data source who are either migrating from WebSphere environment to Standalone installation of CF. We offered them to use the JDBC option however they want to stick to JNDI data source.
I don't see any benefit over
macromedia][Oracle JDBC Driver]Internal error: Net8 protocol error.
Bug 82800:Hi,it seems as if CFs QueryTableMetaData class does not correctly use the underlying JDBC specification when it comes to read meta data from the used JDBC driver
Tracker Comment Comment on Coldfusion CF11 - Update 8 - Issue on macromedia_drivers.jar by External U.
2608214 CF-4162547 External U. This is the error message seen in coldfusion administrator when checking datasource :
Connection verification failed for data source: SoFive
java.sql.SQLNonTransientConnectionException: [Macromedia][Oracle JDBC Driver]No more data available to read.
The root cause
Tracker Comment Comment on Coldfusion CF11 - Update 8 - Issue on macromedia_drivers.jar by External U.
2608214 CF-4162547 External U. I have just tried to install Coldfusion 11 Update 9 and there is same issue :
Connection verification failed for data source: SoFive
java.sql.SQLNonTransientConnectionException: [Macromedia][Oracle JDBC Driver]No more data available to read.
The root cause was that
Tracker Issue Postgres JDBC driver is so old we cannot use current features in Postgres and self-upgrades beyond 8.3 fail
Postgres JDBC driver is so old we cannot use current features in Postgres and self-upgrades beyond 8.3 fail
Tracker Issue Macromedia Oracle JDBC Driver fails to connect to Oracle 11g R2 when database encryption is required
Macromedia Oracle JDBC Driver fails to connect to Oracle 11g R2 when database encryption is required
Portal Topic Guide to configure JNDI datasource in ColdFusion
Priyank Shrivastava Guide to configure JNDI datasource in ColdFusion Here’s a guide to show you how to configure JNDI datasource in ColdFusion 2018. 1. Get the JDBC Driver The JDBC Driver needs to be placed in ColdFusion2018/cfusion/lib folder. 2. context.xml configuration Add a resource block
Tracker Issue Connection fails from SequeLink JDBC Driver to Unicode SequeLink service using Java 1.8
Connection fails from SequeLink JDBC Driver to Unicode SequeLink service using Java 1.8
Tracker Issue Error when creating CF data source for viaSQL connection (works in previous versions of CF)
2608788 CF-3996917 Administrator Michael Rolfes Error when creating CF data source for viaSQL connection (works in previous versions of CF) Problem Description: I am migrating from CF9 to CF11 and the driver which connects to viaSQL through JDBC does not validate as it does successfully from within
Tracker Issue Bring the dbvarname attribute back for cfprocparam
. ColdFusion uses JDBC 2.2 and does not support named parameters. This is deprecated."
[...]
Now, whilst JDBC 2.2 indeed didn't support named params, JDBC 3.0 did support them, and JDBC 3.0 was released a year before CFMX was. [...] We're up to JDBC 4.1.
[...]
There are a number of tickets
Tracker Issue When editing a datasource in the CF administrator the JDBC connection string changes causing data corruption
When editing a datasource in the CF administrator the JDBC connection string changes causing data corruption
[Macromedia][Oracle JDBC Driver][Oracle]ORA-06502: PL/SQL