Adobe Community : All Content - All Communities

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

forums_noreply@adobe.com — Thu, 26 Jun 2014 13:10:21 GMT

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

which driver best for DB connection Native driver vs jdbc drivers

forums_noreply@adobe.com — Thu, 26 Jun 2014 14:24:56 GMT

In ColdFusion we can create DSN in 2 ways. Either we can select the driver for the specific database or we can use the Other as the driver and we can create the DSN by specifying the connection string. Which is the best way in terms of the performance for apps. Any idea.

Here I am looking to create the DSN to SQL Server 2012 and I have create 2 DSN's, one with SQL Server driver and one with other and mentioned the connection string. I don't see any difference as of now. Please advise which one to user.

how to connect to sql server 2012 multi-subnet failover clustering

forums_noreply@adobe.com — Mon, 19 May 2014 16:18:59 GMT

Hello,

I am looking to connect to the last sql server 2012 multi-subnet failover clustering which requires to mention the connection string MULTISUBNETFAILOVER=Yes.

Even though I have mention, its still failing to create the DSN, I am able to connect to it from SQL Server Management Studio. Does any able to connect it. do i need to install any JDBC drivers for this to success.

Here I am using ColdFusion 9 enterprise edition.

Thanks

Srinivas

cant get the font on PDF document and alignment

forums_noreply@adobe.com — Mon, 27 Jan 2014 15:51:21 GMT

I cant get the font on PDF document and alignment eventhough I have margins to 0 still getting some space from the top and left side.

I have added fonts to CF Admin and restarted too still same issue. I am able to see fonts are added in CF Admin.

Object instantiation exception

forums_noreply@adobe.com — Wed, 23 Nov 2011 06:21:59 GMT

Intermittently i am getting the below error.

Object instantiation exception.

An exception occurred while instantiating a Java object. The class must not be an interface or an abstract class. If the class has a constructor that accepts an argument, you must call the constructor explicitly using the init(args) method. Error

I have an web service and using the java i am invkoing it. in CF i am creating object and calling the menthod which in turn invoke the web service. but i am getting the above error.

coldfusion.runtime.TemplateNotFoundException: File not found: /appcheck/index.cfm

forums_noreply@adobe.com — Wed, 29 Aug 2012 14:23:16 GMT

I am getting the below error in Coldfusion, i am getting the HTML/image files but not getting the cfm files eventhough the files are there. i have verified the permissions issue and they are all good. Even the CF administrator is working fine and i am able to access it but if i upload a new file in it its not executing it.

"Error","jrpp-22","08/29/12","10:13:50",,"File not found: /appcheck/test.cfm The specific sequence of files included or processed is: /opt/coldfusion9/apps/www/olp-dev.com/appcheck/test.cfm'' "

coldfusion.runtime.TemplateNotFoundException: File not found: /appcheck/test.cfm

at coldfusion.filter.PathFilter.invoke(PathFilter.java:90)

at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:70)

at coldfusion.filter.BrowserDebugFilter.invoke(BrowserDebugFilter.java:74)

at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:2 8)

at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38)

at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:46)

at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38)

at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22)

at coldfusion.filter.CachingFilter.invoke(CachingFilter.java:53)

at coldfusion.CfmServlet.service(CfmServlet.java:200)

at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:89)

at jrun.servlet.FilterChain.doFilter(FilterChain.java:86)

at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:42 )

at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:46)

at jrun.servlet.FilterChain.doFilter(FilterChain.java:94)

at jrun.servlet.FilterChain.service(FilterChain.java:101)

at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:106)

at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42)

at jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:286)

at jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:543)

at jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java:203)

at jrunx.scheduler.ThreadPool$DownstreamMetrics.invokeRunnable(ThreadPool.java:320)

at jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:428)

at jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeRunnable(ThreadPool.java:266)

at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66)

Best way to build search functionality

forums_noreply@adobe.com — Tue, 14 Aug 2012 09:55:41 GMT

we have a search functionality for the searching the order details. we have around 5 lacs+ orders and its taking so much time to get the details. we have indexed the DB fields but still too slow.

Now i am looking to buikd the search functionality with the verity, so i am checking how much helpful is this as everyday we get new orders and rerunning the query will take so much time.

when building the indexes for the first do i need to get all the records from the DB, if that is the case it will take so much time in the production and may impact to the production DB server.

can any one suggest best solution.

search functionality in coldfusion

forums_noreply@adobe.com — Fri, 25 May 2012 14:41:28 GMT

Hi All,

I have a huge database and users try to thousands of data from the DB and its taking much type to retrive data and display it to users. to make it fast can i use the Verify/Solr search functionality. Previosly i used verity searchy for docs but not for DB. which search functionality is best verity/solr with DB.

Query returning different results from coldfusion

forums_noreply@adobe.com — Mon, 05 Mar 2012 13:45:33 GMT

Hi,

I have below query which is returning the previous day results also. when i am executing the same query in query tool its returning the only today's orders. recently we have migrated the servers and coldfusion to newer versions, after the migration we are facing this issue.

below the query:

select eoo_dist_organization, eoo_dist_po_no, eoo_insertdatetime, eoo_order_date, eoo_is_acknowledged from edi_orders

where eoo_insertdatetime >= '01-Mar-2012 00:00:00' AND

eoo_insertdatetime <= '01-Mar-2012 23:59:59'

order by eoo_insertdatetime desc

Normally this query should return only todays' orders but its returning yesterday orders also. As per my observation this query works till 6:30PM EST(returns only today's orders) after 6:30 PM EST it also returns the yesterday's orders also. Does any one faced this issue. what could be the issue.

getting Element DIST_NAME is undefined in FORM

forums_noreply@adobe.com — Mon, 09 Apr 2012 12:26:22 GMT

I am getting below intermittent error in the coldfusion exception logs. when run the code, its working fine but for some users the below error is throwing. as per the exception.log from CF administrator. ( The variable form.DIST_NAME is exist and works fine when i run the file from the browser).

coldfusion.runtime.UndefinedElementException: Element DIST_NAME is undefined in FORM.

at coldfusion.runtime.CfJspPage.resolveCanonicalName(CfJspPage.java:1724)

at coldfusion.runtime.CfJspPage._resolve(CfJspPage.java:1677)

at coldfusion.runtime.CfJspPage._resolveAndAutoscalarize(CfJspPage.java:1812)

at coldfusion.runtime.CfJspPage._resolveAndAutoscalarize(CfJspPage.java:1805)

at cfordersearchresultsReporting2ecfm1172240657._factor2(/opt/coldfusion9/apps/www/olpsales/ ordersearchresultsReporting.cfm:105)

at cfordersearchresultsReporting2ecfm1172240657._factor8(/opt/coldfusion9/apps/www/olpsales/ ordersearchresultsReporting.cfm:103)

at cfordersearchresultsReporting2ecfm1172240657.runPage(/opt/coldfusion9/apps/www/olpsales/o rdersearchresultsReporting.cfm:1)

at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:231)

at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:416)

at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65)

at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:363)

at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:48)

at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40)

at coldfusion.filter.PathFilter.invoke(PathFilter.java:87)