RE: [ACFUG Discuss] Getting Connection Refused

2013-05-21 Thread Charlie Arehart 
Glad to hear you find things resolved, Brooks. But to be clear, the
resources I pointed to did clarify that this was a JVM issue (I just didn't
say that specifically in my pointing them out). :-) 

They did also talk about changing the TTL value. Finally, they did also
propose that just restarting the instance could have helped. 

Just sharing in case your "change" comes back some day to still seem not to
work. It may be that simply restarting CF (and therefore the JVM) would be
the most expedient solution. Saying that as much for other readers who may
someday find/reuse this thread, too.

/charlie

 

From: ad...@acfug.org [mailto:ad...@acfug.org] On Behalf Of Wilson, Brooks
Sent: Tuesday, May 21, 2013 9:25 AM
To: discussion@acfug.org
Subject: RE: [ACFUG Discuss] Getting Connection Refused

 

Greetings:

 

It turns out that technically speaking CF doesn't cache the DNS, but the JVM
does. In this case the JVM DNS cache was corrupted and we were being
directed to the wrong ip. We set the time to live parameter in the JVM DNS
cache to something other than "forever" and restarted the server. This fixed
the problem. This one was very interesting and challenging.

 

Sincerely, Brooks

 




-
To unsubscribe from this list, manage your profile @ 
http://www.acfug.org?fa=login.edituserform

For more info, see http://www.acfug.org/mailinglists
Archive @ http://www.mail-archive.com/discussion%40acfug.org/
List hosted by http://www.fusionlink.com
-

Re: [ACFUG Discuss] SQL Server Question

2013-05-21 Thread Jason Delmore 
I don't think there is anything wrong with using stored procs over inline
SQL to retrieve data.  However, in my view of the world this is application
behavior and not reporting.  Application behavior should be modeled in
objects and the best way is to use persistent components (Hibernate/ORM.)

The code would then look like
claim = entityload("claim", {claimid=1234});
documents = claim.getDocuments();  //  this uses ORM to generate SQL that
really just does select * from documents where claimid=1234
document = documents[1];
formfields = document.getFormFields();

IMHO, there is no value of inline SQL over stored procs other than perhaps
that people seem to do a poor job of version control on stored procs.  An
additional benefit of a stored proc is that database guys will go in and
review and tune a stored proc, but are unlikely to go and edit inline SQL
as that falls in the application space.  I would say leave your stored proc
alone unless you are going to go all the way to ORM.

But... that is just my view of the world.

Jason



On Tue, May 21, 2013 at 9:43 AM, MCG  wrote:

> Yes it's been a while, but I've gotten pulled into database design, and
> this group has always been the best place to turn to for technical
> knowledge.
>
> The team here inherited a crap database, over 200+ tables for an
> unexciting claim system, and is now adding new features.  Yes, views are
> better than straight SQL in the code in the case of many tables for your
> query.  Maybe I've just been out of the game, but the team is using stored
> procedures to build queries to output data on a page, which seems odd to
> me.  Maybe it is fear of the outer join, unions, subqueries.
>
> But do I have a case for pushing the funky view SQL versus running stored
> procedures?  The case here is nothing exceptional, we are getting data for
> the list of all documents related to a claim and then the one record for
> form fields for a single document for a claim.
>
> Thanks!
>
> Mary-Catherine
>

[ACFUG Discuss] SQL Server Question

2013-05-21 Thread MCG 
Yes it's been a while, but I've gotten pulled into database design, and
this group has always been the best place to turn to for technical
knowledge.

The team here inherited a crap database, over 200+ tables for an unexciting
claim system, and is now adding new features.  Yes, views are better than
straight SQL in the code in the case of many tables for your query.  Maybe
I've just been out of the game, but the team is using stored procedures to
build queries to output data on a page, which seems odd to me.  Maybe it is
fear of the outer join, unions, subqueries.

But do I have a case for pushing the funky view SQL versus running stored
procedures?  The case here is nothing exceptional, we are getting data for
the list of all documents related to a claim and then the one record for
form fields for a single document for a claim.

Thanks!

Mary-Catherine

Re: [ACFUG Discuss] Getting Connection Refused

2013-05-21 Thread Dawn Hoagland 
Sounds about right - and I believe I did run into that once or twice
(several eons ago) when I was in a purely java environment.

Interesting it had been set to the CF default - unless it was a newer
server that FRIT setup.  Whenever I updated the JVM I pointed CF to a
different directory and the default JVM setup is to not cache indefinitely.
 Of course, FRIT may not have liked how I setup the servers and changed it
:)

Glad to hear it was resolved!


On Tue, May 21, 2013 at 9:25 AM, Wilson, Brooks
wrote:

>  Greetings:
>
> ** **
>
> It turns out that technically speaking CF doesn’t cache the DNS, but the
> JVM does. In this case the JVM DNS cache was corrupted and we were being
> directed to the wrong ip. We set the time to live parameter in the JVM DNS
> cache to something other than “forever” and restarted the server. This
> fixed the problem. This one was very interesting and challenging.
>
> ** **
>
> Sincerely, Brooks
>   --
>
> Brooks Wilson  |  Senior Web Developer Programmer/Analyst
> *Technology Solutions Services  |  **Application Delivery Services*
>
> Federal Reserve Bank of Atlanta  |  1000 Peachtree Street,  Atlanta, GA
> 30309-4470
>
> Phone: 404.498.8178 | Fax: 404.498.8239 | Mobile: 404.985.9270
>
> Email: brooks.wil...@atl.frb.org
>
> ** **
>
> *From:* ad...@acfug.org [mailto:ad...@acfug.org] *On Behalf Of *Charlie
> Arehart
> *Sent:* Thursday, May 16, 2013 4:50 PM
> *To:* discussion@acfug.org
> *Subject:* RE: [ACFUG Discuss] Getting Connection Refused
>
> ** **
>
> Brooks, do you mean you were “reading **that** CF caches DNS entries”?
> Yes, that’s so. And while there doesn’t seem to be a way to clear it (other
> than to restart CF), there is a way to control how long it’s set to live.
> For more, see these blog entries (one really old, one relatively old):
>
> http://tjordahl.blogspot.com/2004/10/cfmx-and-dns-caching.html
>
> http://coldfused.blogspot.com/2008/01/dns-lookup-caching-in-coldfusionjava.html
>
> And the following more generic resources:
>
>
> http://docs.oracle.com/javase/6/docs/technotes/guides/net/properties.html#nct
> http://www.rgagnon.com/javadetails/java-0445.html
> http://serverfault.com/questions/459814/clearing-tomcats-dns-cache
>
> Hope that helps.
>
> /charlie
>
> ** **
>
> *From:* ad...@acfug.org [mailto:ad...@acfug.org ] *On
> Behalf Of *Wilson, Brooks
> *Sent:* Thursday, May 16, 2013 10:20 AM
> *To:* discussion@acfug.org
> *Subject:* [ACFUG Discuss] Getting Connection Refused
>
> ** **
>
> Greetings:
>
> ** **
>
> I’m using a CFFEED tag to retrieve an RSS feed. It has suddenly stopped
> working. Nothing has changed. When we trace the request – nothing happens.
> I was reading the CF caches DNS entries – but I don’t see any information
> on how to clear the cache. Does anyone have any experience with misbehaving
> CFFEED/CFHTTP tags?
>
> ** **
>
> Sincerely, Brooks
>   --
>
> Brooks Wilson  |  Senior Web Developer Programmer/Analyst
> *Technology Solutions Services  |  **Application Delivery Services*
>
> Federal Reserve Bank of Atlanta  |  1000 Peachtree Street,  Atlanta, GA
> 30309-4470
>
> Phone: 404.498.8178 | Fax: 404.498.8239 | Mobile: 404.985.9270
>
> Email: brooks.wil...@atl.frb.org
>
> ** **
>
>
> -
> To unsubscribe from this list, manage your profile @
> http://www.acfug.org?fa=login.edituserform
>
> For more info, see http://www.acfug.org/mailinglists
> Archive @ http://www.mail-archive.com/discussion%40acfug.org/
> List hosted by FusionLink 
> - 
>
>
> -
> To unsubscribe from this list, manage your profile @
> http://www.acfug.org?fa=login.edituserform
>
> For more info, see http://www.acfug.org/mailinglists
> Archive @ http://www.mail-archive.com/discussion%40acfug.org/
> List hosted by FusionLink 
> - 
>
> -
> To unsubscribe from this list, manage your profile @
> http://www.acfug.org?fa=login.edituserform
>
> For more info, see http://www.acfug.org/mailinglists
> Archive @ http://www.mail-archive.com/discussion%40acfug.org/
> List hosted by FusionLink 
> -
>



-- 
Dawn

RE: [ACFUG Discuss] Getting Connection Refused

2013-05-21 Thread Wilson, Brooks 
Greetings:

It turns out that technically speaking CF doesn't cache the DNS, but the JVM 
does. In this case the JVM DNS cache was corrupted and we were being directed 
to the wrong ip. We set the time to live parameter in the JVM DNS cache to 
something other than "forever" and restarted the server. This fixed the 
problem. This one was very interesting and challenging.

Sincerely, Brooks

Brooks Wilson  |  Senior Web Developer Programmer/Analyst
Technology Solutions Services  |  Application Delivery Services
Federal Reserve Bank of Atlanta  |  1000 Peachtree Street,  Atlanta, GA 
30309-4470
Phone: 404.498.8178 | Fax: 404.498.8239 | Mobile: 404.985.9270
Email: brooks.wil...@atl.frb.org

From: ad...@acfug.org [mailto:ad...@acfug.org] On Behalf Of Charlie Arehart
Sent: Thursday, May 16, 2013 4:50 PM
To: discussion@acfug.org
Subject: RE: [ACFUG Discuss] Getting Connection Refused

Brooks, do you mean you were "reading *that* CF caches DNS entries"? Yes, 
that's so. And while there doesn't seem to be a way to clear it (other than to 
restart CF), there is a way to control how long it's set to live. For more, see 
these blog entries (one really old, one relatively old):

http://tjordahl.blogspot.com/2004/10/cfmx-and-dns-caching.html
http://coldfused.blogspot.com/2008/01/dns-lookup-caching-in-coldfusionjava.html

And the following more generic resources:

http://docs.oracle.com/javase/6/docs/technotes/guides/net/properties.html#nct
http://www.rgagnon.com/javadetails/java-0445.html
http://serverfault.com/questions/459814/clearing-tomcats-dns-cache

Hope that helps.

/charlie

From: ad...@acfug.org [mailto:ad...@acfug.org] On 
Behalf Of Wilson, Brooks
Sent: Thursday, May 16, 2013 10:20 AM
To: discussion@acfug.org
Subject: [ACFUG Discuss] Getting Connection Refused

Greetings:

I'm using a CFFEED tag to retrieve an RSS feed. It has suddenly stopped 
working. Nothing has changed. When we trace the request - nothing happens. I 
was reading the CF caches DNS entries - but I don't see any information on how 
to clear the cache. Does anyone have any experience with misbehaving 
CFFEED/CFHTTP tags?

Sincerely, Brooks

Brooks Wilson  |  Senior Web Developer Programmer/Analyst
Technology Solutions Services  |  Application Delivery Services
Federal Reserve Bank of Atlanta  |  1000 Peachtree Street,  Atlanta, GA 
30309-4470
Phone: 404.498.8178 | Fax: 404.498.8239 | Mobile: 404.985.9270
Email: brooks.wil...@atl.frb.org


-
To unsubscribe from this list, manage your profile @
http://www.acfug.org?fa=login.edituserform

For more info, see http://www.acfug.org/mailinglists
Archive @ http://www.mail-archive.com/discussion%40acfug.org/
List hosted by FusionLink
-

-
To unsubscribe from this list, manage your profile @
http://www.acfug.org?fa=login.edituserform

For more info, see http://www.acfug.org/mailinglists
Archive @ http://www.mail-archive.com/discussion%40acfug.org/
List hosted by FusionLink
-



-

To unsubscribe from this list, manage your profile @ 

http://www.acfug.org?fa=login.edituserform



For more info, see http://www.acfug.org/mailinglists

Archive @ http://www.mail-archive.com/discussion%40acfug.org/

List hosted by http://www.fusionlink.com

-