java.sql.SQLException: Timed out trying to establish connection

Question

I am trying to connect to SQL Server 2012 with flag MULTISUBNETFAILOVER=TRUE

I have created the DSN and it works fine for some time and next day i will get the below erorr. I have verified the DB server and its up and working fine and able to connect to it from management studio. Once I restart the server the issue get fixed. Does any one had any idea on why this issue is happening. I am using the sqljdbc4.jar for this connection.

The root cause was that: java.sql.SQLException: Timed out trying to establish connection

Carl Von Stetten · Accepted Answer

yes, the fields are char(x) and nchar(x) fields.

we have many files/modules which is difficult to put trim, so we are calling custom tag and trying to trim the data.

we are passing the query to customer and executing the query in custom tag with cfquery and trying to do trim by using the QoQ as it trims the data.

Again, I don't believe QofQ supports the Trim function. In fact, the only place Trim appears on the QofQ page in Adobe docs is to indicate it is a reserved word and shouldn't be used.

As far as I can see, you only have two choices here: modify your database queries to use TRIM before running your QofQ, or change the database colums from char(x) and nchar(x) to varchar(x) and nvarchar(x). Unless this or other applications are relying on fixed character length fields, switching to varchar(x)/nvarchar(x) shouldn't result in any data loss or adverse side effects.

-Carl V.

Carl Von Stetten · Answer

Which version (Standard, Enterprise, Developer) and release (9, 10, 11) of CF are you using, and on what OS?Also, what is the entire JDBC connect string you are using?-Carl V.

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.

Scanning file for viruses.

This file cannot be downloaded