cancel
Showing results for 
Search instead for 
Did you mean: 

JDBC SQL Server Connection drops out

SOLVED
New Contributor

JDBC SQL Server Connection drops out

I have a set of scripts that I use to bulk load a demonstration system.  It connects to a SQL Server database, and retrieves a recordset that it then processes through in a loop.  Full processing can be over a number of hours.  However, I often find that the loop crashes because of a lost SQL connection.

I have two questions as a result:

1.  How can I keep the SQL connection open, so that the Data Loop does not fail?

2.  If #1 is not possible, are there any suggestions as to how I might loop back to restart the SQL Connection?

 

Many thanks for your considerations ...

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Moderator

Re: JDBC SQL Server Connection drops out

Hi @PMarriott,

 

Your question looks specific to the MS SQL driver functioning, please consider posting your question to the Microsoft forum.
From what I found, this thread may be of some help: https://stackoverflow.com/questions/41021303/sql-server-jdbc-driver-cant-detect-lost-connection-quic...

 

Natalie
Customer Care Team

Did my reply answer your question? Give Kudos or Accept it as a Solution to help others.↓↓↓↓↓

View solution in original post

1 REPLY 1
Highlighted
Moderator

Re: JDBC SQL Server Connection drops out

Hi @PMarriott,

 

Your question looks specific to the MS SQL driver functioning, please consider posting your question to the Microsoft forum.
From what I found, this thread may be of some help: https://stackoverflow.com/questions/41021303/sql-server-jdbc-driver-cant-detect-lost-connection-quic...

 

Natalie
Customer Care Team

Did my reply answer your question? Give Kudos or Accept it as a Solution to help others.↓↓↓↓↓

View solution in original post