search : jdbc connection

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

displaying top 100 results

Coldfusion 2016 JDBC Connection To Oracle
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.
Connect ColdFusion JDBC to Sybase SQL Anywhere
on ColdFusion. Data Source,JDBC Connection,Question,ColdFusion,data source,jdbc connection,question
Comment on Coldfusion 2016 JDBC Connection To Oracle by Legorol San
Comment on JDBC Connection get no Schema Table (Report Query) by Nimit S.
Comment on JDBC Connection get no Schema Table (Report Query) by Akhila K.
/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
When editing a datasource in the CF administrator the JDBC connection string changes causing data corruption
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. Is there anyway this can be looked at? We have a large cluster of servers and many updating/creating JDBC connections is NOT feasible.
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
Comment on When editing a datasource in the CF administrator the JDBC connection string changes causing data corruption by Dattanand M.
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
Exception: [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
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
JDBC Connection get no Schema Table (Report Query)
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
Comment on Coldfusion 2016 JDBC Connection To Oracle by Charlie Arehart
Comment on JDBC Connection get no Schema Table (Report Query) 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
(DATADIRECT) driver enter Zigzagvalet for Data Source Name and Databse server=localhost port=3306 username=root password= root Actual Result: Connection verification failed for data source: ZigZagValet java.sql.SQLException: [Macromedia][MySQL JDBC Driver]Connections to MySQL Community Server
No connection to Oracle database behind firewall
Comment on Coldfusion 2016 JDBC Connection To Oracle by Legorol San
2609751 CF-3785178 External U. I've had similar issues on SQL Server, and it seems to be caused by the arithabort setting on the JDBC connection string. It *could* be the same for Oracle? http://cfmlblog.adamcameron.me/2014/01/set-arithabort.html -- Adam
Comment on Macromedia Oracle JDBC Driver fails to connect to Oracle 11g R2 when database encryption is required by External U.
Comment on Coldfusion 2016 JDBC Connection To Oracle by Charlie Arehart
2608639 CF-4038865 External U. After countless attempts to stop this from happening the solution we finally found was to run the Microsoft JDBC drivers v4.2 inside of ColdFusion11. Once we stopped using all Adobe JDBC drivers to connect to our MS-SQL 2014 server the server stopped being unstable
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
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
Comment on Coldfusion 2016 JDBC Connection To Oracle by Legorol San
to Azure Data Warehouse using the latest MS jdbc driver (mssql-jdbc-6.2.2.jre8.jar) and 'Maintain Connections' is checked. We first attempted to connect using the built in Microsoft SQL Server driver but kept getting this error: Connection verification failed for data source: AzureDev2 java
2673575 CF-4126389 Database Harry Klein Connection to local MySQL database with port 3307 doesn't work Problem Description: JDBC connection error Steps to Reproduce: Please try the MySQL connection in the CONTENS CMS installation I prepared for you. Just update the Express Version in this package
Comment on Macromedia Oracle JDBC Driver fails to connect to Oracle 11g R2 when database encryption is required by Nimit S.
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
Comment on ColdFusion not maintaining connection to Azure Data Warehouse by Bob K.
Connection fails from SequeLink JDBC Driver to Unicode SequeLink service using Java 1.8
Macromedia Oracle JDBC Driver fails to connect to Oracle 11g R2 when database encryption is required
Comment on Coldfusion 2016 JDBC Connection To Oracle by Legorol San
Comment on Error when creating CF data source for viaSQL connection (works in previous versions of CF) by Nimit S.
Comment on Coldfusion 2016 JDBC Connection To Oracle by Charlie Arehart
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 Between CF 11,0,04,293328 and 11,0,10,300066, DataDirect Oracle JDBC driver updated and now causing closed connections. by Jonas M.
Comment on Database connection issue via CFIDE/admin & MAMP Pro by External U.
not sure how and where to add/register SQLServerConnection.registerColumnEncryptionKeyStoreProviders. Kindly help if this is possible from ColdFusion 11. https://docs.microsoft.com/en-us/sql/connect/jdbc/azure-key-vault-sample-version-7.0?view=sql-server-2016 The post How to access AlwaysEncrypted column
2609894 CF-3750467 External U. Weird. I didn't receive email notifications on your comments. My apologies. The issue is present in CF11 (as well as Railo/Lucee), but seems to be related to the PostgreSQL JDBC driver and connection pooling. Increasing the max allowed connections will help up
(Socket.java:469) at java.net.Socket.(Socket.java:366) at java.net.Socket.(Socket.java:209) at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:173) at com.mysql.jdbc.MysqlIO.(MysqlIO.java:267) at com.mysql.jdbc.Connection.cre ateNewIO(Connection.java:2739
: Connection verification failed for data source: testjava.sql.SQLException: [Macromedia][MySQL JDBC Driver]Connections to MySQL Community Server are not supported. Please contact MySQL to obtain a MySQL Enterprise or Commercial version.The root cause was that: java.sql.SQLException: [Macromedia][MySQL JDBC
the NT registry. Variable DRIVERPATH is undefined. ----------- 3) See writeDump(queryExecute("SELECT * FROM myTable", [], {datasource="MyAccessDSN"})) throws "java.sql.SQLException: [Macromedia][SequeLink JDBC Driver]TCP/IP error, connection refused." 4) Per CF-4202199, change all '20006' to '20008
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
Datasource Connection between CF9 and Oracle using the in built JDBC Oracle type 4 driver randomly drops out
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
works in the public beta but gives an error in the new version Method: Result: Connection verification failed for data source: andspotcom.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Could not create connection to database server. Attempted reconnect 3 times. Giving up.The root
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
ODBC Connection not working on WinSrv2016
Comment on Between CF 11,0,04,293328 and 11,0,10,300066, DataDirect Oracle JDBC driver updated and now causing closed connections. by Inigo K.
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.
Comment on Between CF 11,0,04,293328 and 11,0,10,300066, DataDirect Oracle JDBC driver updated and now causing closed connections. by Nimit S.
Comment on Between CF 11,0,04,293328 and 11,0,10,300066, DataDirect Oracle JDBC driver updated and now causing closed connections. by Nimit S.
Comment on Connection fails from SequeLink JDBC Driver to Unicode SequeLink service using Java 1.8 by Nimit S.
IQ1 I am having a similar issue, I have successfully configured the JDBC thin driver to connect to Oracle from ColdFusion 2018. Everything works but some of my reports are breaking when I Pass a datetime string of the format dd/mm/yyy 00:00:00 For anything else other than 00:00:00 it seems to work
2612388 CF-3516357 Database : JDBC ext-user Connection verification failed for data source: csvfiles Problem: Customer has been using a iNet Fositex CSV JDBC driver. It allows to read CSV files like database tables, defining the file layouts in a schema.ini. It is easy to add the folder the JAR
2601423 CF-3037977 Database : General daniel plesse Bug 76111:Mysql driver 5 Problem: Mysql driver 5.0.5 returns java.lang.NullPointerException at com.mysql.jdbc.Statement.setMaxRows(Statement.java:2178) when maintain connection is set Mysql driver 5.1 returns java.io.EOFException: Can
) at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:125) at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:110) at org.hibernate.engine.jdbc.internal.proxy.ConnectionProxyHandler.continueInvocation(Connection
Comment on Error Executing Database Query. Timed out trying to establish connection by External U.
source: db_admin_clientvariablesjava.sql.SQLNonTransientConnectionException: [Macromedia][SQLServer JDBC Driver]Error establishing socket to host and port: 172.23.111.35:1433. Reason: Connection refused: connect The root cause was that: java.sql.SQLNonTransientConnectionException: [Macromedia
Comment on Connection verification failed for data source: csvfiles by Rupesh K.
Comment on Datasource Connection between CF9 and Oracle using the in built JDBC Oracle type 4 driver randomly drops out by External U.
Comment on Datasource Connection between CF9 and Oracle using the in built JDBC Oracle type 4 driver randomly drops out by Adobe D.
Comment on Between CF 11,0,04,293328 and 11,0,10,300066, DataDirect Oracle JDBC driver updated and now causing closed connections. by Stephen J.
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
2609885 CF-3752188 Database Keith Alston java.lang.AbstractMethodError on data source verification Problem Description: java.lang.AbstractMethodError on data source verification Steps to Reproduce: using an easysoft jdbc-odbc bridge to connect to odbc data sources Actual Result
of a JDBC connection from CF to the DB. Sadly, there is no MS-provided (let alone Adobe-provided) JDBC driver for Cosmos. There IS a third party company (cdata) who make lots of money filling in such gaps: they DO offer a JDBC driver for Cosmos DB, and you COULD use that with CF (there are docs about
Comment on Connection String in MySQL Datasource sent to Database with trailing space by External U.
2608473 CF-4086564 External U. I am assuming that this feature would do something like Connection.setClientInfo() and pass the metadata that way as described here. http://media.datadirect.com/download/docs/jdbc/alljdbc/index.html#page/userguide/rfi1359985937883.html
Between CF 11,0,04,293328 and 11,0,10,300066, DataDirect Oracle JDBC driver updated and now causing closed connections.
Exception: [Macromedia][Oracle JDBC Driver]No more data available to read." We tried to add the parameters to use encryption in the connection string for the data source "EncryptionLevel=accepted;EncryptionTypes=(AES256,RC4_256,AES192,3DES168,AES128,RC4_128);" but we get the same error. Can someone document the steps
2612565 CF-3497870 External U. Adding the following to the connection parameters of the datasource fixes the issue: DateTimeInputParameterType=dateTime From http://media.datadirect.com/download/docs/jdbc/alljdbc/wwhelp/wwhimpl/js/html/wwhelp.htm#href=userguide/jdbcsqlsrv.13.005.html
administration is : Connection verification failed for data source: oracle java.sql.SQLNonTransientConnectionException: [Macromedia][Oracle JDBC Driver]No more data available to read. The root cause was that: java.sql.SQLNonTransientConnectionException: [Macromedia][Oracle JDBC Driver]No more data available
enabled with a trusted wildcard-SSL certificate fail to verify or connect. The connection string is set to "EncryptionMethod=SSL; CryptoProtocolVersion=TLSv1.2; ValidateServerCertificate=0;". Prior to loading the update, the datasource would verify and connect; post loading the update it would fail
for years using JDBC, and we wanted to upgrade our CF from 8 to 10. The Unidata drivers from Rocket for JDBC have a known issue and are not compatible with CF 10 (only with 9 and under). If we wanted to use CF 10, we'd have to connect via ODBC. However, Unidata's ODBC drivers are only for Windows platforms
for years using JDBC, and we wanted to upgrade our CF from 8 to 10. The Unidata drivers from Rocket for JDBC have a known issue and are not compatible with CF 10 (only with 9 and under). If we wanted to use CF 10, we'd have to connect via ODBC. However, Unidata's ODBC drivers are only for Windows
://helpx.adobe.com/coldfusion/cfml-reference/coldfusion-tags/tags-p-q/cfqueryparam.html Related URL: https://docs.microsoft.com/en-us/sql/connect/jdbc/understanding-data-type-differences?view=sql-server-2017 Note: That MSSQL doc uses a '?view=sql-server-2017' URL parameter for version-specific docs. Slick huh? Adobe could take heed for version-specific CF docs.
] 1.0 Overview [...] Because a JdbcRowSet is a connected rowset, that is, it continually maintains its connection to a database using a JDBC technology-enabled driver, [it] can simply take calls invoked on it and in turn call them on its ResultSet object. As a consequence, [...] it can be used
before the closing tag  in the context.xml present at ColdFusion2018/cfusion/runtime/conf , which defines database connection detail : jdbc/test” auth=”Container” type=”javax.sql.DataSource” maxActive=”50″ maxIdle=”30″ maxWait=”10000″ username=”username” password
Duration"; public static final String METRICS_EJB_METHOD_COUNT = "methodCount"; public static final String METRICS_JDBC_POOL_SIZE = "poolSize"; public static final String METRICS_JDBC_TIMEOUTS = "timeouts"; public static final String METRICS_JDBC_ACTIVE_CONNECTIONS = "activeConnections"; public static final
for . Closed the physical connection. The select query actually runs well but after that, any other query fail with the following message : "[Macromedia][Oracle JDBC Driver]Object has been closed" The JDBC driver is the Oracle built-in driver. The select query contains : - one inner join - 6 left outer
) is missing in ColdFusion 10. Method:The following info is missing - Updated April 3, 2008: Added information on Oracle RAC You can also use this option to create a datasource for Oracle Real Application Cluster (RAC). Specify the following settings: JDBC URL jdbc:macromedia:oracle://hostname:port;ServiceName=servicename;AlternateServers=(alternatehostname:port);Connection
.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
Impl").newInstance(); DriverManager.setDriver("com.mysql.jdbc.Driver"); DriverManager.setUrl("jdbc:mysql://localhost:3306/pcsilva"); DriverManager.setPassword("root"); DriverManager.setUsername("root"); Connection = DriverManager.getConnection(); Connection.setUseUnicode(true); Connection.setCharacterEncoding("utf8
Name"; // With JDBC URL (Other) this.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
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