JDBC Connection closes between 'stmt.execute( ... ) and stmt.executeQuery( ... )

dataAllMyLife — Wed, 27 Apr 2022 20:16:20 GMT

I'm running a Java application that registers a CSV table with HIVE and then checks the number of rows imported. Its done in several steps.:

Statement stmt = con.createStatement();

....

stmt.execute( "CREATE TABLE ( <definition> < > );

.....

ResultSet rs = stmt.executeQuery( "SELECT count(*) as rowCnt from ...... );

while (rs.next()) {

rows = rs.getLong(1);

}

As soon as the 2nd statement gets executed I receive an exception

WARNING: sun.reflect.Reflection.getCallerClass is not supported. This will impact performance.

Apr 27, 2022 12:59:37 PM com.simba.spark.jdbc42.internal.apache.http.impl.execchain.RetryExec execute

INFO: I/O exception (java.net.SocketException) caught when processing request to {s}->https://<id>.cloud.databricks.com:443: Connection or outbound has closed

Apr 27, 2022 12:59:37 PM com.simba.spark.jdbc42.internal.apache.http.impl.execchain.RetryExec execute

INFO: Retrying request to {s}->https://<id>.cloud.databricks.com:443

Any ideas or inputs are appreciated .....

Re: JDBC Connection closes between 'stmt.execute( ... ) and stmt.executeQuery( ... )

Noopur_Nigam — Sun, 31 Jul 2022 09:31:21 GMT

@Reto Matter Are you running a jar job or using dbconnect to run java code? Please provide how are you trying to make a connection and full exception stack trace.

topic Re: JDBC Connection closes between 'stmt.execute( ... ) and stmt.executeQuery( ... ) in Data Engineering

JDBC Connection closes between 'stmt.execute( ... ) and stmt.executeQuery( ... )

Re: JDBC Connection closes between 'stmt.execute( ... ) and stmt.executeQuery( ... )