Search results

  1. T

    Answered Transaction Isolation Level not working

    KB entry (Progress Customer Community) gave a little more insight into the problem but has one flaw. With my tests, NO-LOCK reads from progress ABL will cause dirty-reads ONLY on SQL transactions. Cant agree on the statement that it can happen to ABL transaction aswell . Tried this and it never...
  2. T

    INSERT INTO with multiple rows without Select?

    I just got this error: Normaly in SQL you can do INSERT INTO (columns_list) VALUES (values for row1), (values for row2) ... I looked up the docs and theres the possiblity to insert rows from a subselect or something. Is there no way to just put 2 rows with one statement...
  3. T

    Answered Progress JDBC Implementation (limit connection count)

    In my case with node-jdbc it is save to use multible statements one one Connection at the same time (read and write). It will only be shown as one user in promon. My problem solved itself.
  4. T

    Answered Progress JDBC Implementation (limit connection count)

    Hello @TomBascom, sorry i missed that. I got same results under dlc 11.6 and dlc 12.2. But i think i got rid of the problem myself it seems like one connection can handle multible statements simultaneously. Currently im running some stress tests. I will post my results shortly for everyone...
  5. T

    Answered Progress JDBC Implementation (limit connection count)

    Hello Community, im using the jdbc to query data from Progress db via sql. The documentation states that there is a parameter for maxPooledStatements. I've run some tests and found ot that this property does not limit the pooled connections or statements. Currently im programming a client-side...
  6. T

    Answered Transaction Isolation Level not working

    Thanks for the help so far. I will leave this thread open until i had the time to look up all documentations i can get and then post my solution to this problem. Probably i will end up writing my own buffer logic and write the collected data in one swift commit. Probably i will lose some...
  7. T

    Answered Transaction Isolation Level not working

    Thank you very much for the Information. I didnt knew that ABL would allow dirty reads by default. Also I understand now that the SQL Client transaction is configurable in terms of what it can read and what not. But there is still one thing that bothers me: Let's say we have a table...
  8. T

    Answered Transaction Isolation Level not working

    Hello Progress Community, im currently using progress 12.2 running on Linux Ubuntu 20.04.3 LTS (Focal Fossa) and access it via JDBC and ABL-Sessions. (Promon screenshot showing the connections) So i did the following test: 1) Open a transaction via JDBC, change a Record via SQL `UPDATE` and...
Top