Member Avatar for antoniokp

I am totally new to posting here and dealing with Coldfusion. Hello ALL. I have an application built by a past employee over 4 years ago that is just now showing errors on a regular basis. I have tried to explore the files associated with the errors when I catch it to no avail. Can someone let me know what I COULD copy and paste here to show an error page associated with my problems? I actually attached a txt file with the text I get on the error page if that helps. Once I know I pray I could learn something from you CFpros out there. Thanks all for your time.

Antoniokp

Error Executing Database Query.
I/O Error: Connection reset
 
The error occurred in \\nawinfs03\home\users\web\b1235\rh.tommy1\linkmanager\query.cfm: line 1

1 : <cfquery datasource="key_word" name="getclients">
2 : select *
3 : from clients

SQL 	   select * from clients where inactive = 0 order by cname
DATASOURCE 	  key_word
SQLSTATE 	  08S01
Resources:

    * Check the ColdFusion documentation to verify that you are using the correct syntax.
    * Search the Knowledge Base to find a solution to your problem.

Browser   	Mozilla/5.0 (Windows; U; Windows NT 6.1; en-US; rv:1.9.2.10) Gecko/20100914 Firefox/3.6.10 GTB7.1
Remote Address   	71.235.94.115
Referrer   	http://www.keywordperformance.com/linkmanager/access/login.cfm
Date/Time   	24-Jan-11 09:15 AM
Stack Trace
at cfquery2ecfm2104324051.runPage(\\nawinfs03\home\users\web\b1235\rh.tommy1\linkmanager\query.cfm:1) at cfApplication2ecfm2087273963.runPage(\\nawinfs03\home\users\web\b1235\rh.tommy1\linkmanager\Application.cfm:2)

java.sql.SQLException: I/O Error: Connection reset
	at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2277)
	at net.sourceforge.jtds.jdbc.TdsCore.login(TdsCore.java:599)
	at net.sourceforge.jtds.jdbc.ConnectionJDBC2.<init>(ConnectionJDBC2.java:331)
	at net.sourceforge.jtds.jdbc.ConnectionJDBC3.<init>(ConnectionJDBC3.java:50)
	at net.sourceforge.jtds.jdbc.Driver.connect(Driver.java:178)
	at coldfusion.server.j2ee.sql.pool.JDBCPool.createPhysicalConnection(JDBCPool.java:562)
	at coldfusion.server.j2ee.sql.pool.ConnectionRunner$RunnableConnection.run(ConnectionRunner.java:67)
	at java.lang.Thread.run(Thread.java:534)
Caused by: java.net.SocketException: Connection reset
	at java.net.SocketInputStream.read(SocketInputStream.java:168)
	at java.io.DataInputStream.readFully(DataInputStream.java:266)
	at java.io.DataInputStream.readFully(DataInputStream.java:242)
	at net.sourceforge.jtds.jdbc.SharedSocket.readPacket(SharedSocket.java:826)
	at net.sourceforge.jtds.jdbc.SharedSocket.getNetPacket(SharedSocket.java:707)
	at net.sourceforge.jtds.jdbc.ResponseStream.getPacket(ResponseStream.java:466)
	at net.sourceforge.jtds.jdbc.ResponseStream.read(ResponseStream.java:103)
	at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2172)
	... 7 more
  • 2 Contributors
  • 7 Replies
  • 143 Views
  • 12 Hours Discussion Span
  • Latest Post Latest Post by arrgh
Member Avatar for arrgh

The error means there's some problem connecting to your database. The cause could be a lot of things.

- has something changed with your db recently
- which db type are you using?
- does the error happen every time or just sporadically?

Member Avatar for antoniokp

The error means there's some problem connecting to your database. The cause could be a lot of things.

- has something changed with your db recently
- which db type are you using?
- does the error happen every time or just sporadically?

Thanks for getting back to me Arrgh...:cool: Answers to your 3 lines;

- Nothing has changed in a few years with the db.
- mysql is the db he used.
- The error happened sporadically throughout the months of a given year prior to last week. Now it is sporadically throughout the day, every day.

The original developer mentioned that because the application was not built for a client there were a few things he should have coded but didn't figuring there really was no client-side and any fix needed would get done because he worked here, now he doesn't. I am still in contact with him though as he produces for our video company.

Your time is appreciated Aargh, thanks for the help.

Member Avatar for arrgh

Looks like you're using the jtds driver. I usually use the built in one (though it has problems too). Honestly I've never seen that specific error. Google only returns 94 results for it ;-) It's possible it's a weird driver problem. But connection reset errors could also be caused by a legitimate problem reaching the db. For example, if the db were on another server which couldn't be reached for some reason. ie Temporary network problems.

You could try switching drivers, but first does the error go away if you refresh the same page?

Member Avatar for antoniokp

Looks like you're using the jtds driver. I usually use the built in one (though it has problems too). Honestly I've never seen that specific error. Google only returns 94 results for it ;-) It's possible it's a weird driver problem. But connection reset errors could also be caused by a legitimate problem reaching the db. For example, if the db were on another server which couldn't be reached for some reason. ie Temporary network problems.

You could try switching drivers, but first does the error go away if you refresh the same page?

Funny you should ask. In the past YES, one click of the refresh button and all was well. Now it can take 1-2 minutes before it comes back.

Member Avatar for arrgh

Is the db on the same server as CF?

Member Avatar for antoniokp

Is the db on the same server as CF?

Yes it is.

Member Avatar for arrgh

Hm... it could still be a network problem or just the db going away. That type of error isn't easy to diagnose. You'd need a packet sniffer. So happens there's a similar problem with the built in driver. A great thread about it here:

http://forums.adobe.com/message/3396333

Just for kicks, you might try the suggestion of adding a validation query to your dsn settings. See if that has any effect.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.