Meaning of FETCH_CURSOR jconnect_implicit_1 in Sybase
0
votes
1
answer
283
views
# Situation
I am trying to troubleshoot performance when connecting to Sybase ASE Version 15.7 from Sqoop over JDBC.
Though I cannot check things myself it appears to be 10x slower to extract data this way then with another tool (which uses ODBC).
# Observation
The DB team has observed the following:
# Question:
### What is the meaning of

FETCH_SIZE jconnect_implicit_1:
?
Of course other hints on what may be causing the performance issue are welcome as well.
----
The DB team believes it means a cursor is made for each row, perhaps because of this link which contains something vaguely similar , but I suspect it means something else as I have not found any reference of Oozie causing this over JDBC (we enforce a larger fetch size in the oozie command).
Asked by Dennis Jaheruddin
(103 rep)
Jan 16, 2020, 02:42 PM
Last activity: Jan 16, 2020, 05:28 PM
Last activity: Jan 16, 2020, 05:28 PM