Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

008982 implement dpi adapter #575

Open
c-bik opened this issue Feb 14, 2019 · 3 comments
Open

008982 implement dpi adapter #575

c-bik opened this issue Feb 14, 2019 · 3 comments
Assignees
Labels
enhancement oranif integration deprecation of erloci Size: 8 8 story points

Comments

@c-bik
Copy link
Member

c-bik commented Feb 14, 2019

depends on #574

  1. Connextions dropdown
  2. ddAdapter
  3. Connect to a oracle DB
  4. Making "All Tables" view working
  5. Ensuring it loads in parallel with legacy erloci
@c-bik c-bik added enhancement Size: 8 8 story points oranif integration deprecation of erloci labels Feb 14, 2019
@stoch stoch changed the title implement dpi adapter 008982 implement dpi adapter Feb 18, 2019
@c-bik
Copy link
Member Author

c-bik commented Apr 8, 2019

implement dpi_adpater.erl and port coi_adapter.erl functionalities

cc @acautin for design PR review etc

@acautin acautin added this to the 4.0.0 milestone May 10, 2019
@c-bik c-bik removed this from the 3.5.0 milestone Jul 3, 2019
@acautin
Copy link
Contributor

acautin commented Jul 16, 2019

@c-bik branch https://github.com/K2InformaticsGmbH/dderl/tree/oranif-integration contains the basis for simple integration, sadly could not tested so I doubt it will be working properly.

After K2InformaticsGmbH/oranif#117 is implemented, you can try to do

select * from <BIGTABLE> to see if you have some luck and maybe can get a feel for the performance

@acautin
Copy link
Contributor

acautin commented Aug 8, 2019

The following query fails on ZHH management when connected to SBS1.EXAPROD, the dderl session dies with {error,noproc}

SELECT
    REVICS_SEPID, REVICS_SHORTID, REVICS_ROWID_MASTER, REVICS_COUNT_EXPECTED,
    REVICS_TABLE_SLAVE, REVICS_ROWID_SLAVE
FROM
    SBS1_ADMIN.REVI_CONTENT_SUB
WHERE
    REVICS_SEPID = '201907'
    AND REVICS_ROWID_SLAVE IS NULL

In TOAD, 67'000 rows are returned.
It would be a good (advanced) test to see that this now works with the new Oracle driver.

acautin added a commit that referenced this issue Aug 9, 2019
…odpi_stmt and finished delete implementation. #575
acautin added a commit that referenced this issue Aug 16, 2019
@acautin acautin removed their assignment Jun 2, 2020
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
enhancement oranif integration deprecation of erloci Size: 8 8 story points
Projects
None yet
Development

No branches or pull requests

3 participants