FWD » Core Development » Database

03/19/2020

07:13 PM Feature #4011: database/persistence layer performance improvements

Greg, never mind.
This seems to have something to do with my registration mechanism. It works with other test case... Eric Faulhaber

06:55 PM Feature #4011: database/persistence layer performance improvements

Greg, could you please double-check the @entry@ hook logic for this test case?... Eric Faulhaber

03:51 PM Feature #4011: database/persistence layer performance improvements

Ovidiu Maxiniuc wrote:
> The actual cause of NPW was the fact that the @activeOffset@ was accessed for the @snapshot... Eric Faulhaber

03:26 PM Feature #4011: database/persistence layer performance improvements

The actual cause of NPW was the fact that the @activeOffset@ was accessed for the @snapshot@ of the @dmo@ of the @Rec... Ovidiu Maxiniuc

02:33 PM Feature #4011: database/persistence layer performance improvements

Ovidiu, those places we are seeing the NPE on @BaseRecord.activeBuffer@ seem to be old code where we are calling a se... Eric Faulhaber

03/16/2020

06:33 PM Feature #4011: database/persistence layer performance improvements

In 4011a revision 11402, I have added @Finalizable.entry()@ which is called during @TransactionManager.blockSetup()@ ... Greg Shah

07:11 AM Feature #4011: database/persistence layer performance improvements

Eric Faulhaber wrote:
> Greg, how hard would it be to add a hook for the savepoint processing which is called at the... Greg Shah

04:14 AM Feature #4011: database/persistence layer performance improvements

Greg, how hard would it be to add a hook for the savepoint processing which is called at the same point in the cycle ... Eric Faulhaber

12:17 AM Feature #4011: database/persistence layer performance improvements

Ovidiu, I need a few more days to work through the UNDO code. Some of the features I expected to see (e.g., the track... Eric Faulhaber

01:14 PM Feature #3813: misc DB features part deux

A fixed @CONNECT@ statement rework was committed to the branch 4231b revision 11368. Igor Skornyakov

04:04 AM Feature #3813: misc DB features part deux

Greg Shah wrote:
> If it does not depend on 4335a, you can put it in 4231b. If 4335a is needed first, then wait for... Igor Skornyakov

03/15/2020

06:07 PM Feature #3813: misc DB features part deux

If it does not depend on 4335a, you can put it in 4231b. If 4335a is needed first, then wait for the 4231b rebase fr... Greg Shah

03/14/2020

01:42 PM Feature #3813: misc DB features part deux

I've found the fix for the CONNECT conversion (see #3813-84).
To which branch should I commit it?
Thank you. Igor Skornyakov

06:38 AM Feature #3813: misc DB features part deux

Igor Skornyakov wrote:
> It seems that the CONNECT statement which caused the @gso_241@ fail is incorrect.
> I've ... Igor Skornyakov

03/13/2020

06:57 PM Feature #4011: database/persistence layer performance improvements

Eric Faulhaber wrote:
> Thinking over some of the issues you've been having, I expect the implicit transaction code ... Ovidiu Maxiniuc

06:52 PM Feature #4011: database/persistence layer performance improvements

I am checking out 4011a2 now...
Thinking over some of the issues you've been having, I expect the implicit transac... Eric Faulhaber

06:46 PM Feature #4011: database/persistence layer performance improvements

I have committed my changes to temporary branch 4011a2. Important things:
* @SavepointReversible@ - dead code;
* @C... Ovidiu Maxiniuc

05:54 PM Feature #3813: misc DB features part deux

It seems that the CONNECT statement which caused the @gso_241@ fail is incorrect.
I've added logging and the argume... Igor Skornyakov

03:45 PM Feature #3813: misc DB features part deux

Task branch 4335a was merged to trunk as revision 11345.
The @ConnectionManager@ change was removed before it was ... Greg Shah

03/10/2020

03:31 AM Feature #4011: database/persistence layer performance improvements

Rev 11397 changes the @BaseRecord@ methods @getId()@ and @setId(Long)@ to @primaryKey()@ and @primaryKey(Long)@, resp... Eric Faulhaber

03/06/2020

05:03 AM Feature #4011: database/persistence layer performance improvements

There is this constant:... Ovidiu Maxiniuc

03/05/2020

03:18 PM Feature #4011: database/persistence layer performance improvements

We have had customer requests to rename the @id@ field/column, which is a commonly used field name in applications. C... Eric Faulhaber

03/03/2020

02:42 PM Bug #4426: Cannot find parent when processing REPEAT PRESELECT

Task branch 4207a was merged to trunk as revision 11344. However, this task was worked around in customer code, and h... Roger Borrello

01:04 PM Bug #4450: implement shared query and shared browse

Branch 4207a was merged to trunk as revision 11344. Greg Shah

01:02 PM Bug #4450 (Closed): implement shared query and shared browse

Greg Shah

10:44 AM Bug #4564: unqualified field references can get the wrong buffer name if a FORM or DEF FRAME is p...

This has nothing to do with the FIND. The issue is in the assignment.... Greg Shah

10:16 AM Bug #4564: unqualified field references can get the wrong buffer name if a FORM or DEF FRAME is p...

h2. Description
Extra scoping causes issues with wrong buffer being used for unqualified field names. Same results... Roger Borrello

10:08 AM Bug #4564 (New): unqualified field references can get the wrong buffer name if a FORM or DEF FRAM...

Roger Borrello

03/02/2020

03:52 PM Feature #4011: database/persistence layer performance improvements

Ovidiu Maxiniuc wrote:
> UNDO update.
> The old implementation was using commits and rollbacks a bit aggressive, al... Eric Faulhaber

03:17 PM Feature #4011: database/persistence layer performance improvements

UNDO update.
The old implementation was using commits and rollbacks a bit aggressive, altogether with creation of ne... Ovidiu Maxiniuc

02:15 PM Feature #4011: database/persistence layer performance improvements

Eric Faulhaber wrote:
> So, are you saying you also would expect @HQLPreprocessor@ to still handle the null paramete... Ovidiu Maxiniuc

02/28/2020

05:38 PM Feature #4011: database/persistence layer performance improvements

So, are you saying you also would expect @HQLPreprocessor@ to still handle the null parameters before getting into th... Eric Faulhaber

04:49 PM Feature #4011: database/persistence layer performance improvements

Eric, please grab the 11396 revision. In my hurry I did not fully test the do and I made it worse. Ovidiu Maxiniuc

02:37 PM Feature #4011: database/persistence layer performance improvements

Thanks. See @raq_nulls_sort.p@ in testcases. Eric Faulhaber

02:32 PM Feature #4011: database/persistence layer performance improvements

Eric Faulhaber wrote:
> I haven't debugged too deeply yet... shouldn't @HQLPreprocessor@ have taken care of those @n... Ovidiu Maxiniuc

02:04 PM Feature #4011: database/persistence layer performance improvements

Ovidiu, I have this stack trace:... Eric Faulhaber

02/26/2020

10:21 AM Bug #4450: implement shared query and shared browse

> Can you do regression testing?
Sure.
Stanislav Lomany

09:43 AM Bug #4450: implement shared query and shared browse

Stanislav Lomany wrote:
> > Would you like me to handle the change to @screen_buffer.rules@,
>
> That seems a sa... Roger Borrello

09:34 AM Bug #4450: implement shared query and shared browse

> Would you like me to handle the change to @screen_buffer.rules@,
That seems a safer option to me.
Stanislav Lomany

09:32 AM Bug #4450: implement shared query and shared browse

Stanislav Lomany wrote:
> > This change in @screen_buffer.rules@ was making sure the @frame-id@ and the other widget... Roger Borrello

08:42 AM Bug #4450: implement shared query and shared browse

> This change in @screen_buffer.rules@ was making sure the @frame-id@ and the other widget annotations are placed in ... Stanislav Lomany

02/25/2020

04:51 PM Feature #4011: database/persistence layer performance improvements

Eric Faulhaber wrote:
> Ovidiu Maxiniuc wrote:
> > So, I started a new manager class that should drive the undo dat... Ovidiu Maxiniuc

02:29 AM Feature #4011: database/persistence layer performance improvements

Ovidiu Maxiniuc wrote:
> Notes/status on UNDO part (related to notes 118/119):
>
> It is a bit difficult for me t... Eric Faulhaber

02/24/2020

05:33 PM Feature #4011: database/persistence layer performance improvements

Notes/status on UNDO part (related to notes 118/119):
It is a bit difficult for me to "dry" discuss. My experience... Ovidiu Maxiniuc

04:00 PM Feature #3813: misc DB features part deux

I see two things regarding @RAW-TRANSFER@ to be done
* Rework @BUFFER@ <-> @RAW@ (de)serialization which is binary c... Igor Skornyakov

03:55 PM Feature #3813: misc DB features part deux

Added correct error messages and fixed incompatibilities of the @RAW-TRANSFER@ support for use cases I could imagine.... Igor Skornyakov

02:06 PM Bug #4450: implement shared query and shared browse

> Is that the same as the issue converting @./uast/browse/browse-at_base_field@?
Yes, my main goal is to fix this ... Stanislav Lomany

07:28 AM Bug #4450: implement shared query and shared browse

Stanislav Lomany wrote:
> 4207a rev 11402 has the shared browse issues fixed: conversion regression testing passes. ... Roger Borrello

01:51 AM Bug #4450: implement shared query and shared browse

4207a rev 11402 has the shared browse issues fixed: conversion regression testing passes. BTW runtume regression test... Stanislav Lomany

02/22/2020

06:03 AM Feature #3813: misc DB features part deux

The reason for the quirk described in #3813-74 is following:
The 4GL expression @LENGTH(hFieldHandle:BUFFER-VALUE())... Igor Skornyakov

02/21/2020

01:22 PM Feature #3813: misc DB features part deux

Fixed the issue described in #3813-72. The problem with @LENGTH(raw)@ is also resolved as it was a result of the fact... Igor Skornyakov

08:44 AM Feature #3813: misc DB features part deux

Also, the new interface must be added to @HandleCommon@. Greg Shah

08:39 AM Feature #3813: misc DB features part deux

Ovidiu Maxiniuc wrote:
> Igor Skornyakov wrote:
> > I've added support for the @BUFFER-FIELD:AVAILABLE@ attribute w... Igor Skornyakov

08:30 AM Feature #3813: misc DB features part deux

Igor Skornyakov wrote:
> I've added support for the @BUFFER-FIELD:AVAILABLE@ attribute which is sufficient for @BUFF... Ovidiu Maxiniuc

07:19 AM Feature #3813: misc DB features part deux

I've noticed a strange effect.
Let @hFieldHandle@ is a handle for the @RAW@ field of a @TEMP-TABLE@. After @RAW-TRAN... Igor Skornyakov

05:18 AM Feature #3813: misc DB features part deux

I've added support for the @BUFFER-FIELD:AVAILABLE@ attribute which is sufficient for @BUFFER:RAW-TRANSER@ runtime su... Igor Skornyakov

04:14 AM Feature #3813: misc DB features part deux

FWD behavior of the @BUFFER-FIELD:BUFFER-VALUE()@ in the situation when there is no data record is not the same as in... Igor Skornyakov

02/20/2020

03:17 PM Feature #3813: misc DB features part deux

@BUFFER-FIELD:AVAILABLE@ attribute is not supported in FWD (raises @** AVAILABLE is not a queryable attribute for BUF... Igor Skornyakov

08:51 AM Feature #3813: misc DB features part deux

> TODO comment in the BufferImpl.rawCopyTo(raw r) method states that FWD is not binary compatible with 4GL on this. M... Greg Shah

06:04 AM Feature #3813: misc DB features part deux

I've found a number of incompatibilities in the behavior of the @RAW-TRANSFER@ statement and @BUFFER:RAW-TRANSFER@ me... Igor Skornyakov

02:00 AM Feature #4011: database/persistence layer performance improvements

I've committed rev 11394, which fixes a few more issues with the validation/flushing. I managed to run an early/rough... Eric Faulhaber

02/19/2020

06:26 PM Feature #4011: database/persistence layer performance improvements

Eric Faulhaber wrote:
> *** once we've determined it is not a fatal database error and is in fact a unique constrain... Eric Faulhaber

04:19 PM Feature #4011: database/persistence layer performance improvements

Eric,
It seems that you have the cache disabled (Session.get(Session.java:255))? I disable it, too, and I was able t... Ovidiu Maxiniuc

03:16 PM Feature #4011: database/persistence layer performance improvements

Ovidiu, I just committed rev 11392 with some fixes.
Please review my change to @FqlToSqlConverted@ for correctness... Eric Faulhaber

02:27 PM Feature #4011: database/persistence layer performance improvements

Eric Faulhaber wrote:
> Ovidiu, is @Validation.checkMaxIndex@ fully implemented? Can I mark this item as complete?
... Ovidiu Maxiniuc

02:19 PM Feature #4011: database/persistence layer performance improvements

Ovidiu, is @Validation.checkMaxIndex@ fully implemented? Can I mark this item as complete? Eric Faulhaber

06:02 AM Feature #4011: database/persistence layer performance improvements

I committed rev 11391, which has changes related to DMO validation and flushing, especially w.r.t. unique constraint ... Eric Faulhaber

01:34 PM Bug #4450: implement shared query and shared browse

I looked and the testcase using the debug version of @frame_scoping.rules@ shows the override frame on line 24 of the... Roger Borrello

12:53 PM Bug #4450: implement shared query and shared browse

> Can you take a look?
Sure, but after I fix all of the @<chui_app>@ regressions caused by shared browse changes.... Stanislav Lomany

11:54 AM Bug #4450: implement shared query and shared browse

Stanislav, saw your *4207a-rev 11398*, and thank your for that update! Are you able to help find the cause of the mis... Roger Borrello

11:37 AM Support #4550: eliminate the need to place the p2jspi.jar in the JVM extension directory

In Java 8 it is supposed to be possible to load service providers from the application classpath. See "ServiceLoader... Greg Shah

11:30 AM Support #4550 (Closed): eliminate the need to place the p2jspi.jar in the JVM extension directory

Greg Shah