Re: Spark hangs while reading from jdbc - does nothing

2020-04-11 Thread jane thorpe
You seem to be implying the error is intermittent.  You seem to be implying data is being ingested  via JDBC. So the connection has proven itself to be working unless no data is arriving from the  JDBC channel at all.  If no data is arriving then one could say it could be  the JDBC. If the

Re: Spark hangs while reading from jdbc - does nothing

2020-04-11 Thread Mich Talebzadeh
Hi, Have you checked your JDBC connections from Spark to Oracle. What is Oracle saying? Is it doing anything or hanging? set pagesize set linesize 140 set heading off select SUBSTR(name,1,8) || ' sessions as on '||TO_CHAR(CURRENT_DATE, 'MON DD HH:MI AM') from v$database; set heading on