I have a program that uses aspects of Java and Perl to create an ODBC connection to create CSV data from a Lotus Notes Database and place into a MySQL table. When connecting after about a week or two, the program stops connecting and complains with:
"java.net.SocketException: No buffer space available (maximum connections reached?): NET_Bind"
Has anyone seen this type of error before?
2007-03-08 01:21:51 · 2 answers · asked by BlessedKhaos 1 in Computers & Internet ➔ Programming & Design
bad java code! hung sockets -> wasted memory -> no buffer space!
Don't rely on a java app to stay up for more than a short time!
2007-03-08 05:20:17 · answer #1 · answered by jake cigar™ is retired 7 · 0⤊ 0⤋
Are you using a persistant connetion, if so DONT. Open then close the connection when you finish each update. Also if MySql is running in a windows system good luck it really needs the linux os to shine.
2007-03-08 10:27:12 · answer #2 · answered by Tracy L 7 · 0⤊ 0⤋