Skip to main content

Relativity JDBC - SQL Question

  • August 18, 2020
  • 4 replies
  • 0 views
Swapnil Gupta

Good Morning -

I am trying to query Table via JDBC. Opened a cursor and reading from first till last record.

ISAM File corresponding to TABLE : Len 512 Char, 84 fields.

JDBC connection is automatically closing after 450K records. Is there any setting missing ?

I understand file is getting read from top to bottom. Expecting slow speed but is there any way to enhance speed.

    4 replies

    Thomas Morrison
    • Thomas Morrison
    • Participating Frequently
    • August 18, 2020

    Good Morning -

    I am trying to query Table via JDBC. Opened a cursor and reading from first till last record.

    ISAM File corresponding to TABLE : Len 512 Char, 84 fields.

    JDBC connection is automatically closing after 450K records. Is there any setting missing ?

    I understand file is getting read from top to bottom. Expecting slow speed but is there any way to enhance speed.

    This is a question better handled by Support. Raise an incident on the support site.
    Tom Morrison, Consultant, South Carolina, USA
    D

    Good Morning -

    I am trying to query Table via JDBC. Opened a cursor and reading from first till last record.

    ISAM File corresponding to TABLE : Len 512 Char, 84 fields.

    JDBC connection is automatically closing after 450K records. Is there any setting missing ?

    I understand file is getting read from top to bottom. Expecting slow speed but is there any way to enhance speed.

    I’m going to guess that there’s an error or a crash that is closing the connection.

    Anyway, this seems more like a customer incident than a "How do I do this?" forum type question. In other words, I can’t possibly answer this question with the information given.

    Thomas Morrison
    • Thomas Morrison
    • Participating Frequently
    • August 19, 2020

    Good Morning -

    I am trying to query Table via JDBC. Opened a cursor and reading from first till last record.

    ISAM File corresponding to TABLE : Len 512 Char, 84 fields.

    JDBC connection is automatically closing after 450K records. Is there any setting missing ?

    I understand file is getting read from top to bottom. Expecting slow speed but is there any way to enhance speed.

    Are you able to trap ans interrogate an error when the connection closes? Any error messages at all?
    Tom Morrison, Consultant, South Carolina, USA
    Swapnil Gupta
    • Swapnil Gupta
    • Author
    • Participating Frequently
    • November 21, 2020
    Are you able to trap ans interrogate an error when the connection closes? Any error messages at all?

    Hi Tom - 

     

    It is issue with Relativity JDBC implementation. Seems JDBC drive is terminating without displaying error when Relativity made 2nd call internal call to fetch data. And 2nd call has issue.

    Defect being raised on MicroFocus  Side. 

    Recent badge winners

    Explore all badges
    Terms & ConditionsAccessibility statement