FWD » Core Development » Database

12/07/2018

03:20 PM Feature #3757: add metadata support

Eric Faulhaber wrote:
> Please review the context of these metadata uses and report the purpose of the programs in w... Eric Faulhaber

02:59 PM Feature #3757: add metadata support

Ovidiu, please implement the metadata tables/fields in this task. The priority right now (must be done by end of next... Eric Faulhaber

02:50 PM Feature #3757: add metadata support

I updated the previous entries and I see that there are a few more metadata tables/fields that are accessed: @_DbStat... Ovidiu Maxiniuc

01:04 PM Feature #3761: add DYNAMIC-FUNCTION() support to the dynamic database WHERE clause interpreter

I found an issue with the solution. When the converted query has a @RandomAccessQuery@, the @P2JQuery.Parameter@ lamb... Ovidiu Maxiniuc

12/06/2018

04:54 PM Feature #3761: add DYNAMIC-FUNCTION() support to the dynamic database WHERE clause interpreter

Committed revision 11303. Ovidiu Maxiniuc

04:09 PM Feature #3761: add DYNAMIC-FUNCTION() support to the dynamic database WHERE clause interpreter

Great! Please use 3750a. Greg Shah

04:05 PM Feature #3761: add DYNAMIC-FUNCTION() support to the dynamic database WHERE clause interpreter

It actually works! At least for the testcase the client provided and for a a few other I tested.
The lambda is evalu... Ovidiu Maxiniuc

12/05/2018

04:43 PM Feature #3761: add DYNAMIC-FUNCTION() support to the dynamic database WHERE clause interpreter

The current implementation should convert and compile without any problems. However, since this part of FWD uses the ... Ovidiu Maxiniuc

12/03/2018

05:04 PM Feature #3759: setup, test and document PostgreSQL on Windows

OK, thanks for the update.
Eugenie will take this when he gets back. Greg Shah

04:33 PM Feature #3759: setup, test and document PostgreSQL on Windows

I installed Visual Studio 2017 Community edition. I cannot build. Maven keeps complaining that @Could not launch cmd.... Ovidiu Maxiniuc

10:22 AM Feature #3759: setup, test and document PostgreSQL on Windows

> I was about to attempt to compile PL/Java with MSVC compiler. Just to see it works. There was the free Visual Studi... Greg Shah

10:03 AM Feature #3759: setup, test and document PostgreSQL on Windows

Greg Shah wrote:
> Ovidiu: Are you close to resolving this? If not, I propose that Eugenie can take the next steps.... Ovidiu Maxiniuc

09:40 AM Feature #3759: setup, test and document PostgreSQL on Windows

Ovidiu: Are you close to resolving this? If not, I propose that Eugenie can take the next steps. He is quite a wiza... Greg Shah

09:37 AM Feature #3760 (Closed): temp-table options

Greg Shah

09:36 AM Feature #3760: temp-table options

Yes, this tracker can be closed. Ovidiu Maxiniuc

09:34 AM Feature #3760: temp-table options

3782a was merged to trunk as revision 11292.
Is there any reason to keep this task open? It is set to 90% done, b... Greg Shah

11/30/2018

10:24 AM Feature #3759: setup, test and document PostgreSQL on Windows

I suspect you will need to build the project yourself from source. In this way you can ensure that everything is mat... Greg Shah

10:06 AM Feature #3759: setup, test and document PostgreSQL on Windows

I found an installed a PostgreSQL that is apparently built with MinGW. It is available here: https://www.openscg.com/... Ovidiu Maxiniuc

11/29/2018

09:18 AM Feature #3759: setup, test and document PostgreSQL on Windows

Eugenie Lyzenko wrote:
> Do you mean this build: https://sourceforge.net/projects/postgresql-mingw-w64/ ?
I downloa... Ovidiu Maxiniuc

07:17 PM Feature #3759: setup, test and document PostgreSQL on Windows

Ovidiu Maxiniuc wrote:
> _If your PostgreSQL server was built using MinGW-w64 (which you can check by running pg... Eugenie Lyzenko

11/28/2018

06:11 PM Feature #3759: setup, test and document PostgreSQL on Windows

Ovidiu Maxiniuc wrote:
> I tried today with a fresh new system, hoping that the initial system could have been someh... Eugenie Lyzenko

05:44 PM Feature #3759: setup, test and document PostgreSQL on Windows

I tried today with a fresh new system, hoping that the initial system could have been somehow corrupted. There is no ... Ovidiu Maxiniuc

11/27/2018

02:48 PM Feature #3759: setup, test and document PostgreSQL on Windows

Eric Faulhaber wrote:
> https://tada.github.io/pljava/build/mingw64.html implies that the PostgreSQL server needs to... Ovidiu Maxiniuc

02:45 PM Feature #3759: setup, test and document PostgreSQL on Windows

> Also it would be great to have more debugging info for 0xC0000005. The module name and address will help significan... Ovidiu Maxiniuc

02:44 PM Feature #3759: setup, test and document PostgreSQL on Windows

https://tada.github.io/pljava/build/mingw64.html implies that the PostgreSQL server needs to have been built using mi... Eric Faulhaber

02:38 PM Feature #3759: setup, test and document PostgreSQL on Windows

Ovidiu Maxiniuc wrote:
> I think I was a little to enthusiastic about the successful build. Apparently there is an ... Eugenie Lyzenko

02:12 PM Feature #3759: setup, test and document PostgreSQL on Windows

I think I was a little to enthusiastic about the successful build. Apparently there is an issue with the binaries be... Ovidiu Maxiniuc

11/26/2018

05:00 PM Feature #3759: setup, test and document PostgreSQL on Windows

I finally get it 100% compiled. The problem is that psql does not know what are the 'resources' (read 'header declara... Ovidiu Maxiniuc

12:31 PM Feature #3757 (WIP): add metadata support

h4. @_filelist._filelist-name@, @_filelist._FileList-BlkSize@ and @_filelist._fileList-id@
This _meta table allow ... Ovidiu Maxiniuc

01:48 AM Feature #3757: add metadata support

Ovidiu, as you have down time from other tasks, please investigate and document the meanings of the above metadata ta... Eric Faulhaber

11/25/2018

02:56 PM Feature #3816: table and table handle parameter options

Options which need support:
* BIND
* APPEND - mostly implemented; partial conversion
* BY-REFERENCE - mostly imp... Eric Faulhaber

02:38 PM Feature #3816 (Closed): table and table handle parameter options

Eric Faulhaber

02:37 PM Feature #3809: ProDataSet support

Dataset parameter options:
* BY-REFERENCE
* APPEND
* BIND Eric Faulhaber

12:29 PM Feature #3809: ProDataSet support

The following list of features is not exhaustive, but we know we need to implement at least...
+Language Statement... Eric Faulhaber

09:29 AM Feature #3809: ProDataSet support

There are also features in non-database parts of the system.
* SESSION:FIRST-DATASET Greg Shah

07:25 AM Feature #3809: ProDataSet support

This task is intended to implement compatible and comprehensive support for the ProDataSet features of the 4GL. At t... Greg Shah

07:17 AM Feature #3809 (Closed): ProDataSet support

Greg Shah

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

Temp-table field option:
* COLUMN-CODEPAGE Eric Faulhaber

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

The following temp-table options need to be supported:
* LIKE-SEQUENTIAL
* BEFORE-TABLE (ProDataSet-related) Eric Faulhaber

01:57 PM Feature #3815 (Closed): more temp-table options

Eric Faulhaber

12:43 PM Feature #3814: more schema metadata

The following schema metadata features are used in an application and are either unsupported or are partially impleme... Eric Faulhaber

12:38 PM Feature #3814 (Closed): more schema metadata

Eric Faulhaber

09:28 AM Feature #3813: misc DB features part deux

+Language Statements+
* -BUFFER-COMPARE- - implement NO-LOBS (already done for the POC?)
* -BUFFER-COPY- - implem... Greg Shah

09:25 AM Feature #3813 (Closed): misc DB features part deux

Greg Shah

11/24/2018

09:51 PM Feature #3759: setup, test and document PostgreSQL on Windows

As far as I know the MinGW64 has support for @long long int@. it is @__int64@. So what you need to do is to try to de... Eugenie Lyzenko

11/23/2018

02:59 PM Feature #3759: setup, test and document PostgreSQL on Windows

Eugenie Lyzenko wrote:
> Take a look at your @.m2\repository\com\git-hub\maven-nar\nar-maven-plugin\version@ directo... Ovidiu Maxiniuc

12:27 PM Feature #3759: setup, test and document PostgreSQL on Windows

Also checklist for PLJava:
https://tada.github.io/pljava/build/build.html
Nar plugin:
http://maven-nar.github.io/ Eugenie Lyzenko

12:24 PM Feature #3759: setup, test and document PostgreSQL on Windows

Ovidiu Maxiniuc wrote:
> After I
> [...]
> the mingw profile is indeed used. However, the issues remain.
Take a... Eugenie Lyzenko

11:46 AM Feature #3759: setup, test and document PostgreSQL on Windows

After I... Ovidiu Maxiniuc

11:44 AM Feature #3759: setup, test and document PostgreSQL on Windows

Eugenie Lyzenko wrote:
> Try to add system variable:
> @MSYSTEM@ to be @MINGW64@
I will try that.
> What versio... Ovidiu Maxiniuc

11:41 AM Feature #3759: setup, test and document PostgreSQL on Windows

Ovidiu Maxiniuc wrote:
> Please find the attached logs from
> [...]
> and
> [...]
>
> I noticed that the @ms... Eugenie Lyzenko

06:23 AM Feature #3759: setup, test and document PostgreSQL on Windows

Please find the attached logs from ... Ovidiu Maxiniuc

09:22 PM Feature #3759: setup, test and document PostgreSQL on Windows

Eugenie: Please review this task and offer any advice about mingw. Greg Shah

11/22/2018

03:41 PM Feature #3759 (WIP): setup, test and document PostgreSQL on Windows

I am having some difficulties with building PL/Java on Windows. Apparently, msvc profile is selected by Maven. I do n... Ovidiu Maxiniuc

11/19/2018

03:48 PM Feature #3761: add DYNAMIC-FUNCTION() support to the dynamic database WHERE clause interpreter

Eric Faulhaber wrote:
> Is this inability to cache limited to the cases which use DYNAMIC-FUNCTION? Or are you sayin... Ovidiu Maxiniuc

11/16/2018

03:30 PM Feature #3761: add DYNAMIC-FUNCTION() support to the dynamic database WHERE clause interpreter

Ovidiu Maxiniuc wrote:
> I see an issue though: doing so will alterate the interpreted AST tree and break the caches... Eric Faulhaber

03:14 PM Feature #3761: add DYNAMIC-FUNCTION() support to the dynamic database WHERE clause interpreter

The problem is that the current implementation of the dynamic queries is too logical in FWD. If the parameters and an... Ovidiu Maxiniuc

10:13 PM Feature #3761: add DYNAMIC-FUNCTION() support to the dynamic database WHERE clause interpreter

In other words, it is treated as a query substitution parameter? Greg Shah

11/15/2018

02:26 PM Feature #3761: add DYNAMIC-FUNCTION() support to the dynamic database WHERE clause interpreter

This is a bit (or more) strange. The combination of dynamic queries and dynamic function call is in fact used as a wo... Ovidiu Maxiniuc

11/14/2018

03:05 PM Feature #3761: add DYNAMIC-FUNCTION() support to the dynamic database WHERE clause interpreter

Yes, this is the objective. I will separately send you some example customer code which is supposed to work. Greg Shah

03:04 PM Feature #3761: add DYNAMIC-FUNCTION() support to the dynamic database WHERE clause interpreter

Well, I encountered some strange results. Please confirm that the goal of this task is to add support for constructs ... Ovidiu Maxiniuc

02:04 PM Feature #3761 (WIP): add DYNAMIC-FUNCTION() support to the dynamic database WHERE clause interpreter

Started by creating toy testcases that use DYNAMIC-FUNCTION(). Ovidiu Maxiniuc

02:03 PM Feature #3760 (Review): temp-table options

Added conversion and runtime support for @SERIALIZE-NAME@ attribute. Committed to 3782a/11317.
Automated testing is ... Ovidiu Maxiniuc

11/13/2018

03:57 PM Feature #3760 (WIP): temp-table options

In all my testcases the @RCODE-INFORMATION@ seems to be implemented. In fact, this is only a legacy keyword (as the d... Ovidiu Maxiniuc

08:17 AM Feature #3759: setup, test and document PostgreSQL on Windows

> * Will the database server run on same machine as the FWD server?
Yes.
> * Is there a preferred PostgreSQL ve... Greg Shah

07:54 AM Feature #3759: setup, test and document PostgreSQL on Windows

A few questions here:
* Will the database server run on same machine as the FWD server?
Theoretically, this shoul... Ovidiu Maxiniuc