FWD » Core Development » Database

06/05/2019

04:04 PM Bug #3651: regression in server startup when _connect metadata is active and a database is loaded...

This is 100% complete, right? Greg Shah

03:29 PM Feature #3814: more schema metadata

Which FWD classes are working with metadata? I've never worked with this and need some starting point.
Thank you. Igor Skornyakov

03:12 PM Feature #3814 (WIP): more schema metadata

Greg Shah

06/04/2019

07:59 AM Feature #3809: ProDataSet support

Ovidiu Maxiniuc wrote:
> Constantin Asofiei wrote:
> > @WRITE-JSON(...,JsonObject|JsonArray)@ is needed at least fo... Constantin Asofiei

07:51 AM Feature #3809: ProDataSet support

Constantin Asofiei wrote:
> @WRITE-JSON(...,JsonObject|JsonArray)@ is needed at least for buffer.
Is this urgent?
... Ovidiu Maxiniuc

04:07 AM Feature #3809: ProDataSet support

@WRITE-JSON(...,JsonObject|JsonArray)@ is needed at least for buffer. Constantin Asofiei

06/03/2019

01:51 AM Bug #4071: FWD server stops allowing new web client logins after abend

Eric Faulhaber wrote:
> 4045a/11327 has an attempted workaround for this issue, but I'm not satisfied that it is a g... Constantin Asofiei

12:49 AM Bug #4071: FWD server stops allowing new web client logins after abend

4045a/11327 has an attempted workaround for this issue, but I'm not satisfied that it is a good solution. In @Persist... Eric Faulhaber

06/02/2019

01:38 PM Bug #4071: FWD server stops allowing new web client logins after abend

Constantin Asofiei wrote:
>Eric, lets 'switch' the question a little; why are we not already rolling back the tx i... Eric Faulhaber

01:17 PM Bug #4071: FWD server stops allowing new web client logins after abend

Greg Shah wrote:
> Another question: do we ever need to run session cleanup on the Reader or Writer threads? If it ... Eric Faulhaber

05/31/2019

04:36 PM Feature #3816: table and table handle parameter options

See "Testcases":/projects/p2j/wiki/Writing_4GL_Testcases#Testcase-Project to access the 4GL code. Greg Shah

08:58 AM Feature #3809: ProDataSet support

This was caused because in Progress parser, @resolveLvalueCoreType@ _variables by the same name as a field, will hide... Ovidiu Maxiniuc

07:07 AM Bug #4071: FWD server stops allowing new web client logins after abend

Another question: do we ever need to run session cleanup on the Reader or Writer threads? If it always runs on the C... Greg Shah

01:32 AM Bug #4071: FWD server stops allowing new web client logins after abend

Eric, lets 'switch' the question a little; why are we not already rolling back the tx in case of an abend, on the Con... Constantin Asofiei

05/30/2019

07:26 PM Feature #3809: ProDataSet support

Ovidiu, the testcase is like this:... Constantin Asofiei

04:36 PM Feature #3809: ProDataSet support

There is a case where in a @define dataset@ there is a line like @data-relation rxx for t1, t2 relation-fields (f1,f1... Constantin Asofiei

04:08 PM Feature #3809: ProDataSet support

Constantin Asofiei wrote:
> Ovidiu, are you planning on implementing this method: @buffer-handle:SYNCHRONIZE().@? L... Ovidiu Maxiniuc

04:06 PM Feature #3809: ProDataSet support

Ovidiu, are you planning on implementing this method: @buffer-handle:SYNCHRONIZE().@? Looks like there is an implici... Constantin Asofiei

06:52 PM Feature #3815: more temp-table options

Created task branch 3815a from P2J trunk revision 11311. Stanislav Lomany

05/28/2019

10:15 AM Feature #3815: more temp-table options

Stanislav Lomany wrote:
> I've found that the @CODEPAGE@ can be inherited from another permanent or temp-table throu... Eric Faulhaber

05/27/2019

06:01 PM Feature #3815: more temp-table options

I've found that the @CODEPAGE@ can be inherited from another permanent or temp-table through either table- or field-l... Stanislav Lomany

05/24/2019

06:27 PM Feature #3809: ProDataSet support

Ovidiu Maxiniuc wrote:
> As an intermediary conclusion, I believe they are some kind of dynamic buffers. Not sure ho... Constantin Asofiei

06:24 PM Feature #3809: ProDataSet support

I am struggling to make before-buffer conversion work correctly.
Apparently FWD converts correct these tables/buffer... Ovidiu Maxiniuc

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

@BUFFER-VALIDATE@ method is required for the current large app work. Constantin Asofiei

05/23/2019

05:35 PM Feature #3815: more temp-table options

> The only good reason is that they are hidden.
Sorry for bothering you, I wrote a code in @DumpTree@ which prints... Stanislav Lomany

12:53 PM Feature #3815: more temp-table options

> Do you have an idea why the middle part is not iterated? Nodes are not hidden.
The only good reason is that they... Greg Shah

11:58 AM Feature #3815: more temp-table options

Guys, I need some technical help. I was going to emit a function that sets the codepage in @convert/buffer_definition... Stanislav Lomany

05/22/2019

10:22 AM Feature #3809: ProDataSet support

> For the first two parameters they are parented to the passed object. In the last two cases, we find them parented t... Greg Shah

10:17 AM Feature #3815: more temp-table options

> I don't think we should support this at this point.
The problem here is that if we don't support this now, we wi... Greg Shah

05/21/2019

03:55 PM Feature #3809: ProDataSet support

The problem is not just RUN statement: for function/method calls, there is no PARAMETER node - so every option (APPEN... Constantin Asofiei

03:49 PM Feature #3809: ProDataSet support

The problem with parameter options is that FWD uses a mixed tree locations. Here is an example:... Ovidiu Maxiniuc

02:26 PM Feature #3815: more temp-table options

It is interesting that when @COLUMN-CODEPAGE@ is calculated _initial_ value of the parameter is used instead of the p... Stanislav Lomany

05/20/2019

06:03 PM Feature #3815: more temp-table options

> Please check to confirm that the expression is only evaluated once
It is evaluated once. Stanislav Lomany

02:33 PM Feature #3815: more temp-table options

> Ok. When I wrote this I thought these changes were needed for the same projects as 3751a.
It is but for differen... Greg Shah

02:32 PM Feature #3815: more temp-table options

Stanislav Lomany wrote:
> Guys, do we need to support arbitrary expressions as a @COLUMN-CODEPAGE@? As far as I get,... Greg Shah

02:29 PM Feature #3815: more temp-table options

Constantin Asofiei wrote:
> Eric Faulhaber wrote:
> > Stanislav Lomany wrote:
> > > Into what branch should I comm... Eric Faulhaber

02:25 PM Feature #3815: more temp-table options

Eric Faulhaber wrote:
> Stanislav Lomany wrote:
> > Into what branch should I commit?
> Probably 3751a. Constantin... Constantin Asofiei

02:21 PM Feature #3815: more temp-table options

Stanislav Lomany wrote:
> In this case we'll have to pass the expression to some function at the beginning of the ex... Constantin Asofiei

02:20 PM Feature #3815: more temp-table options

Guys, do we need to support arbitrary expressions as a @COLUMN-CODEPAGE@? As far as I get, it can be combination of:
... Stanislav Lomany

05/18/2019

12:49 PM Feature #3809: ProDataSet support

Constantin Asofiei wrote:
> There are issues with by-reference, append and bind options for caller's DATASET-HANDLE,... Ovidiu Maxiniuc

10:00 AM Feature #3815: more temp-table options

> Beyond the immediate scope of your changes
I'm not sure about this. I don't know when we would do this otherwise. Greg Shah

01:29 AM Feature #3815: more temp-table options

Stanislav Lomany wrote:
> Into what branch should I commit?
Probably 3751a. Constantin, is that ok with you?
> A... Eric Faulhaber

05/17/2019

03:19 PM Feature #3809: ProDataSet support

There are issues with by-reference, append and bind options for caller's DATASET-HANDLE, DATASET, TABLE-HANDLE, TABLE... Constantin Asofiei

09:12 PM Feature #3815: more temp-table options

Into what branch should I commit?
Am I right that there is no runtime part for @COLUMN-CODEPAGE@? Stanislav Lomany

05/16/2019

09:22 AM Feature #3816: table and table handle parameter options

Status update on 4GL testcases development:
> Subject: Feature #3816 - table and table handle parameter options
>... Greg Shah

05/15/2019

09:05 AM Support #4080: AWS Aurora support

A customer has asked this question:
>We want to move our customers to AWS. When moving to AWS it would be great to... Greg Shah

08:52 AM Support #4080 (New): AWS Aurora support

Greg Shah

05/14/2019

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

@DEFAULT-STRING@ conversion and runtime stub was added in 3751a rev 11322 Constantin Asofiei

04:19 PM Feature #3809: ProDataSet support

I committed the conversion support for you as r11321 in 3751a. Ovidiu Maxiniuc

04:07 PM Feature #3809: ProDataSet support

Constantin Asofiei wrote:
> I need compiler constant support for the ROW-STATE possible values... planing to add the... Ovidiu Maxiniuc

04:02 PM Feature #3809: ProDataSet support

I need compiler constant support for the ROW-STATE possible values... planing to add them now to 3751a. Constantin Asofiei

01:53 PM Feature #3809: ProDataSet support

I'm posting this here, but we may need to work it in a different branch; when calling a TABLE argument with the BY-R... Constantin Asofiei

04:10 PM Feature #3815: more temp-table options

Constantin Asofiei wrote:
> What is the state of BEFORE-TABLE option at conversion time? I need this for my current... Ovidiu Maxiniuc

10:42 AM Feature #3815: more temp-table options

What is the state of BEFORE-TABLE option at conversion time? I need this for my current work... Constantin Asofiei

05/13/2019

05:31 PM Feature #3815 (WIP): more temp-table options

@WRITE-XML/JSON@ as well as buffer @DISPLAY/UPDATE@ use order by @ORDER@.
I couldn't make @BUFFER-COPY@ and @BUFFER-... Stanislav Lomany

12:42 PM Feature #3809: ProDataSet support

Please update 3751a to r11316.
I could not test on Dataset project because of some other issue.
Ovidiu Maxiniuc

11:13 AM Feature #3809: ProDataSet support

I will add this in a couple of hours. Ovidiu Maxiniuc

11:11 AM Feature #3809: ProDataSet support

Ovidiu, I need some help; this is valid code (both runtime and compile) in OpenEdge 11.7:... Constantin Asofiei

05/10/2019

12:01 PM Feature #3809: ProDataSet support

Related to previous discussion about @BEFORE-TABLE@ in #3815, entries 7 to 10.
We had a problem with the attribute ... Ovidiu Maxiniuc

11:38 AM Feature #3815: more temp-table options

Greg Shah wrote:
> Hmm. I suspect the order of processing inside @BUFFER-COPY@ and @BUFFER-COMPARE@ may also depend... Eric Faulhaber

11:07 AM Feature #3815: more temp-table options

Hmm. I suspect the order of processing inside @BUFFER-COPY@ and @BUFFER-COMPARE@ may also depend on @ORDER@ or @POSI... Greg Shah

11:04 AM Feature #3815: more temp-table options

Stanislav Lomany wrote:
> Do you know other function than @RAW-TRANSFER@ and @BUFFER-FIELD@ that depend on fields or... Ovidiu Maxiniuc

10:43 AM Feature #3815: more temp-table options

I don't know the answer. Ovidiu and/or Eric may have some ideas there.
I think searching the 4GL docs and knowled... Greg Shah

10:33 AM Feature #3815: more temp-table options

Do you know other function than @RAW-TRANSFER@ and @BUFFER-FIELD@ that depend on fields order? Stanislav Lomany

05/09/2019

07:32 PM Feature #3815: more temp-table options

If we need this information for runtime purposes, then we do need to add this to annotations. Greg Shah

05:09 PM Feature #3815: more temp-table options

OK, we have @fieldId@, @order@ and @position@ fields, and the last two are optional. ... Stanislav Lomany

10:42 AM Feature #3815: more temp-table options

This seems to be a "feature" of the @BUFFER-FIELD()@ method.
Please see this article:
https://knowledgebase.pro... Greg Shah

09:09 AM Feature #3815: more temp-table options

As far as I tested, @LIKE@ and @LIKE-SEQUENTIAL@ behave in the same way (like @LIKE-SEQUENTIAL@). E.g. we have table ... Stanislav Lomany

03:29 AM Feature #3815: more temp-table options

Yes, the @BEFORE-TABLE@ option is working for me. I created a small testcase:... Ovidiu Maxiniuc

04:57 PM Bug #4071: FWD server stops allowing new web client logins after abend

Greg Shah wrote:
> > > Otherwise we probably need to ensure any rollback is executed on the conversation thread.
> ... Constantin Asofiei

04:55 PM Bug #4071: FWD server stops allowing new web client logins after abend

> > Otherwise we probably need to ensure any rollback is executed on the conversation thread.
>
> Agreed. I didn't... Greg Shah

10:46 AM Feature #3809: ProDataSet support

I do agree that using "HANDLE" seems incorrect for these cases. Aren't these specific types which cannot be intermix... Greg Shah

09:19 AM Feature #3809: ProDataSet support

Yes, I though the annotation is incorrect. The type attribute is @"HANDLE"@, too, in @name-map@. I understand they ha... Ovidiu Maxiniuc

08:11 AM Feature #3809: ProDataSet support

Ovidiu Maxiniuc wrote:
> Constantin, I have the following definitions in a object:
> [...]
> They are converted in... Constantin Asofiei

08:10 AM Feature #3809: ProDataSet support

Constantin, I have the following definitions in a object:... Ovidiu Maxiniuc

04:39 AM Feature #3809: ProDataSet support

Please check out the 3751a/11308. Ovidiu Maxiniuc

05/08/2019

06:13 PM Feature #3809: ProDataSet support

Constantin Asofiei wrote:
> Ovidiu, @dataset-handle@ parameters need to convert as @DatasetParameter@ (same as @tabl... Constantin Asofiei

04:06 PM Feature #3815: more temp-table options

Stanislav: Don't do anything on @BEFORE-TABLE@. It will be handled in #3809.
> However, it seems to be already wo... Greg Shah

03:48 PM Feature #3815: more temp-table options

Eric Faulhaber wrote:
> Ovidiu, please see previous posts. Is conversion of BEFORE-TABLE already handled as part of ... Ovidiu Maxiniuc

03:28 PM Feature #3815: more temp-table options

Ovidiu, please see previous posts. Is conversion of BEFORE-TABLE already handled as part of #3809? Eric Faulhaber

02:42 PM Feature #3815: more temp-table options

Do I need to work on @BEFORE-TABLE@ as well? Stanislav Lomany

02:51 PM Feature #4056: instrument FWD and supporting libraries to measure database performance

Eric Faulhaber wrote:
> Hynek Cihlar wrote:
> > How about to exclude the FWD classes in aop.xml? So that the FWD cl... Hynek Cihlar

02:30 PM Feature #4056: instrument FWD and supporting libraries to measure database performance

Hynek Cihlar wrote:
> How about to exclude the FWD classes in aop.xml? So that the FWD classes are only weaved by th... Eric Faulhaber

02:01 PM Feature #4056: instrument FWD and supporting libraries to measure database performance

Eric Faulhaber wrote:
> Hynek Cihlar wrote:
> > I'm not sure how well you can combine load-time and compile-time we... Hynek Cihlar

01:56 PM Feature #4056: instrument FWD and supporting libraries to measure database performance

Hynek Cihlar wrote:
> I'm not sure how well you can combine load-time and compile-time weaving.
Actually, I did not... Eric Faulhaber

01:40 PM Feature #4056: instrument FWD and supporting libraries to measure database performance

Eric Faulhaber wrote:
> Thank you for the guidance.
>
> I am using compile-time weaving only because that seemed ... Hynek Cihlar

01:32 PM Feature #4056: instrument FWD and supporting libraries to measure database performance

Thank you for the guidance.
I am using compile-time weaving only because that seemed to be the most direct way to ... Eric Faulhaber

01:14 PM Feature #4056: instrument FWD and supporting libraries to measure database performance

Here is more info on load time weaving http://www.eclipse.org/aspectj/doc/released/devguide/ltw.html. Hynek Cihlar

01:12 PM Feature #4056: instrument FWD and supporting libraries to measure database performance

Hynek Cihlar wrote:
> Eric Faulhaber wrote:
> > Hynek, I am using AspectJ to capture method-level profile data (jus... Hynek Cihlar

01:07 PM Feature #4056: instrument FWD and supporting libraries to measure database performance

Eric Faulhaber wrote:
> Hynek, I am using AspectJ to capture method-level profile data (just number of invocations a... Hynek Cihlar

12:51 PM Feature #4056 (WIP): instrument FWD and supporting libraries to measure database performance

Hynek, I am using AspectJ to capture method-level profile data (just number of invocations and aggregate elapsed time... Eric Faulhaber