This is usually caused by the JDBC Driver having a buffer set too low, or not to 'unlimited/0'. Basically, what you are seeing (and i'm guessing you're sending large amounts of mail at once) is that the process rolling through your queue, and after it hits so many (somewhere in the 1000+ range) you are hitting the buffer limit. I'd need a full stacktrace around the time it starts failing from the process to give you a more exact cause. But I can tell you just from the error and how you describe it happening its resource contention, whether its literally your script is eating up everything server side, (but i'd expect an OOM and it sounds like your script keeps going just fails to connect) or its limitations in the drivers configurations.
Take a look at InsensitiveResultSetBufferSize https://docs.oracle.com/cd/E13157_01/wlevs/docs30/jdbc_drivers/mssqlserver.html which is where I expect you are having this problem. Usually this gets set to a low number, increasing it or setting it to 0 usually helps with wire contention issues.
Let me know if that helps or if you've already tried that direction. If you can get a full stack trace if that doesn't help, I may be able to see more
I'm going to drop you back into the queue for someone else hopefully figure out what's missed.
I apologize, I missed that you were loading the macromedia driver and not the oracle driver. While all java, you are correct they are different. I do expect the issue you are having is similar between the two, but I expect, like with the oracle driver, this is not something you can modify through the administrator panel.
I looked over the strace for a bit, but I couldn't find anything that said "this is surely the fault, blame this". So hopefully another expert will.
Hi there, my name is***** few things:
OK, so it was working OK and then you replaced the server, so it's most likely a setting on the server side. When you say it's generating a new record in the Sent table, what does it store? The entire email or just a little log information that it was sent?
Have you checked the SQL Server logs? What do they say?
You haven't told me yet how much data it's storinig about each email it sends.
Can you give me the code in the stored procedure for connecting to the database?
Thank you. And the connection code?
Right. Sorry, since it already existed I thought you might have a copy of it somewhere, since the issue is connecting to the database and not recovering or rebuilding its contents.