search : jdbc

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

displaying top 100 results

Query of Queries targets wrong type4 jdbc driver
Comment on Query of Queries targets wrong type4 jdbc driver by External U.
SQL Server 2008 (or newer) HierarchyID datatype not supported by CF10 jdbc driver (works in CF8)
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 Asha K.
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 External U.
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.
Coldfusion 2016 JDBC Connection To Oracle
Connect ColdFusion JDBC to Sybase SQL Anywhere
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.
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.
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
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
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)
Bug 78910:Bundle Oracle JDBC driver with CF9
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
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
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.
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.
2610612 CF-3691289 Rupesh K. The JDBC driver is not available on 64-bit platform and hence this can't be fixed.
MariaDB JDBC : cfquery latin chars
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
Comment on JDBC Connection get no Schema Table (Report Query) by External U.
Comment on Macromedia Oracle JDBC Driver fails to connect to Oracle 11g R2 when database encryption is required by External U.
.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
on ColdFusion. Blog,Data Source,JDBC Connection,ColdFusion,data source,jdbc,jdbc connection,Oracle,standard
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
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
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
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.
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
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 Nimit S.
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.
Comment on macromedia][Oracle JDBC Driver]Internal error: Net8 protocol error. by Nimit S.
Comment on [Macromedia][Oracle JDBC Driver]No more data available to read by Nimit S.
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
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
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.
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.
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 Adobe D.
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 External U.
Comment on Macromedia Oracle JDBC Driver fails to connect to Oracle 11g R2 when database encryption is required by Nimit S.
Comment on Coldfusion 2016 JDBC Connection To Oracle by Legorol San
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
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
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
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
Postgres JDBC driver is so old we cannot use current features in Postgres and self-upgrades beyond 8.3 fail
Macromedia Oracle JDBC Driver fails to connect to Oracle 11g R2 when database encryption is required
Connection fails from SequeLink JDBC Driver to Unicode SequeLink service using Java 1.8
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
. 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
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
Tracker Issue MSSQL 2012 Support
Intent=ReadOnly" or "ApplicationIntent=ReadWrite" to the datasource connection string and have it route to a SQL ReadOnly or ReadWrite database, but it does not. This is specifically related to the MSSQL driver provided by Adobe (Datadirect), the JDBC driver supplied by Microsoft has this functionality. This functionality
Datasource Connection between CF9 and Oracle using the in built JDBC Oracle type 4 driver randomly drops out
Comment on Between CF 11,0,04,293328 and 11,0,10,300066, DataDirect Oracle JDBC driver updated and now causing closed connections. by Jonas M.
Vikram Kumar How to configure DSN using service name for Oracle 12c RAC in CF2016? You may come across a situation where you need to set up a DSN for Oracle database(RAC) using service name instead of SID. In such scenario, you could use JDBC connection string to define the DSN. In this article, we
passed.  It's possible ColdFusion 2018 is using a newer JDBC driver for SQL Server, and it may have an issue. Also, are you using the SQL Server driver that comes with ColdFusion, or the Microsoft JDBC driver (using the "Other" driver type in CF Administrator)?
nc777 Hi Bernhard, Thank you. Since I am not familiar with CF Admin, my next question might sound very dump. I see "C:\ColdFusion2016\jre" in Java Virtual Machine Path and the ColdFusion Class Path is blank. Does it mean I need to make a copy of the jdbc8 files and copy them from this "C:\app64
Tracker Issue CF11 ODBC DSN Issue
5244304 CF-4203902 Database : ODBC CF11 ODBC DSN Issue Problem: CF11 ODBC DSN Issue Method: Create ODBC connection with SQL server using SQL driver  Result: Error- {code:java} Connection verification failed for data source: TEST java.sql.SQLException: [Macromedia][SequeLink JDBC Driver
5267304 CF-4203934 Database : ODBC No ODBC connection on WINSRV2016 possible Problem Description: We are Using CF 2018. By trying to connect to a data source via ODBC System DSN, Coldfusion Administrator throws an error: [Macromedia][SequeLink JDBC Driver][SequeLink Server]The specified data