FWD » Core Development » Database

12/13/2018

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

Several conclusions about building @PL/Java@ and modified @MinGW@ include directory with Windows environment:
1. T... Eugenie Lyzenko

12/12/2018

06:21 PM Feature #3500: implement CLOB and BLOB support

Eric Faulhaber wrote:
> I think the data has to be accessible via the database.
That is clearly better for apps t... Greg Shah

05:17 PM Feature #3500: implement CLOB and BLOB support

I think the data has to be accessible via the database. Eric Faulhaber

03:35 PM Feature #3500: implement CLOB and BLOB support

> The downside is memory consumption; it doesn't take many DMOs with big LOBs stored in memory to cause a problem.
... Greg Shah

02:48 PM Feature #3500: implement CLOB and BLOB support

The way Hibernate maps BLOBs is to @byte[]@ or to @java.sql.Blob@; CLOBs to @String@ or to @java.sql.Clob@.
Using ... Eric Faulhaber

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

It is OK to install a pre-built (on your system) PL/Java on the customer system. Greg Shah

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

I started to build PL/Java on customer system but at the end I stumbled on following issue: the @javah@ is missing fr... Ovidiu Maxiniuc

04:32 AM Feature #3759: setup, test and document PostgreSQL on Windows

Added openssl header files needed to built PL/Java with mingw-built PostgreSQL. Ovidiu Maxiniuc

12/11/2018

01:43 PM Feature #3759: setup, test and document PostgreSQL on Windows

Ovidiu Maxiniuc wrote:
> Eugenie Lyzenko wrote:
> > Can you try to move your @PostgreSQL@ to @C:\PostgreSQL\pg95\..... Eugenie Lyzenko

01:39 PM Feature #3759: setup, test and document PostgreSQL on Windows

Greg Shah wrote:
> We don't need to update the gcc version. Let's just include the missing files and update our dis... Eugenie Lyzenko

01:34 PM Feature #3759: setup, test and document PostgreSQL on Windows

We don't need to update the gcc version. Let's just include the missing files and update our distribution download.
... Greg Shah

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

Eugenie Lyzenko wrote:
> Can you try to move your @PostgreSQL@ to @C:\PostgreSQL\pg95\....@ and check if it works?
... Ovidiu Maxiniuc

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

Ovidiu Maxiniuc wrote:
> Eugenie Lyzenko wrote:
> > Strange but I do not need this to be copied in MinGW(even for @... Eugenie Lyzenko

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

The my points about new @GCC@ version update is the following. There are a lot of changes between @4.9.0@ to @8.2.0@.... Eugenie Lyzenko

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

Eugenie Lyzenko wrote:
> Strange but I do not need this to be copied in MinGW(even for @GCC 8.2.0@) to build PL/Java... Ovidiu Maxiniuc

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

Ovidiu Maxiniuc wrote:
> * @win32@ directory has about a dozen files and sub-directories. Neither have any headers. ... Eugenie Lyzenko

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

If our existing distribution will work with just adding these files, I'm OK with that approach. Greg Shah

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

Greg Shah wrote:
> Ovidiu Maxiniuc wrote:
> > Greg, how do we handle the missing header files issue? Evidently, we ... Ovidiu Maxiniuc

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

Ovidiu Maxiniuc wrote:
> Greg, how do we handle the missing header files issue? Evidently, we cannot ask the custome... Greg Shah

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

Greg, how do we handle the missing header files issue? Evidently, we cannot ask the customers to install msvc-built P... Ovidiu Maxiniuc

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

Well, the new version of @GCC@ from @20180726@ is @8.2.0@. Need to inspect what the new features we have got in this ... Eugenie Lyzenko

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

Ovidiu Maxiniuc wrote:
> Eugenie Lyzenko wrote:
> > Yes, we can publish our Windows binaries for @PL/Java@. We just... Eugenie Lyzenko

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

Greg Shah wrote:
> I am open to changing our packaged version if needed to support all functionality. What do you r... Eugenie Lyzenko

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

Eugenie Lyzenko wrote:
> Yes, we can publish our Windows binaries for @PL/Java@. We just need to create and test com... Ovidiu Maxiniuc

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

Greg Shah wrote:
> ...
> We need to make it reasonable to get things like this built. We can also publish our Wind... Eugenie Lyzenko

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

The addition. My previous note about @MinGW@ was wrong. We do not build @MinGW@ itself. We use already compiled binar... Eugenie Lyzenko

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

I am open to changing our packaged version if needed to support all functionality. What do you recommend?
We need... Greg Shah

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

Ovidiu Maxiniuc wrote:
> ...
> > Do we have a plans to upgrade our prepackaged versions.
> Yes, Greg agreed on th... Eugenie Lyzenko

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

Ovidiu Maxiniuc wrote:
> I have good news.
>
> The @pljava 1.5.2@ package that I built today installs on both ins... Eugenie Lyzenko

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

I have good news.
The @pljava 1.5.2@ package that I built today installs on both instances of PostgreSQL. Indeed, ... Ovidiu Maxiniuc

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

Or as alternative you can try to manually copy the files from your @postgresql@ subdir to new location:
1. complete ... Eugenie Lyzenko

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

Ovidiu Maxiniuc wrote:
> > The question remaining unclear for me - how can I get the @MSVC@ based PostgreSQL and @Mi... Eugenie Lyzenko

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

Eugenie Lyzenko wrote:
> Ovidiu Maxiniuc wrote:
> This allows to use it in command line leaving original copy in ma... Ovidiu Maxiniuc

05:58 AM Feature #3759: setup, test and document PostgreSQL on Windows

Ovidiu Maxiniuc wrote:
...
> > 3. Use @aol.mingw.properties@ provided here.
> I tried with all above. The @aol.min... Eugenie Lyzenko

05:49 AM Feature #3759: setup, test and document PostgreSQL on Windows

Yes, this time the extension was created with success. I also upgraded to 1.5.2 (I used 1.5.0 previously). I do not k... Ovidiu Maxiniuc

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

Eugenie Lyzenko wrote:
> Looks like I have worked PLJava extension. What was changed:
> 0. @MSYSTEM@ must be @MINGW... Ovidiu Maxiniuc

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

One addition. The system used is @Windows 7 64-bit Ultimate@. Eugenie Lyzenko

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

Looks like I have worked PLJava extension. What was changed:
0. @MSYSTEM@ must be @MINGW64@
1. Upgrade @MAVEN@ to 3... Eugenie Lyzenko

12/10/2018

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

My started config environment:
1. PostgreSQL 9.5.15 downloaded as binary (to be on the almost same level as in Linux... Eugenie Lyzenko

11:55 PM Feature #3758: misc database features

The SERIALIZE-HIDDEN attribute runtime support was not implemented at this time. See #3750-41. Eric Faulhaber

11:05 PM Feature #3758: misc database features

Task branch 3758b contained conversion support and partial/stubbed runtime support for DBTASKID, RECORD-LENGTH builti... Eric Faulhaber

12/08/2018

01:13 PM Feature #3757: add metadata support

I've added @_connect@ and @_myconnection@ to the @standard@ section of @p2j.cfg.xml@ in rev 17 of the customer applic... Eric Faulhaber

01:02 PM Feature #3757: add metadata support

Eric Faulhaber wrote:
> What are the failures, exactly?
The logs are in #3750-29 Constantin Asofiei

12:57 PM Feature #3757: add metadata support

Constantin Asofiei wrote:
> I have files failing with these metadata fields, and they are not in the list for this t... Eric Faulhaber

11:30 AM Feature #3757: add metadata support

I have files failing with these metadata fields, and they are not in the list for this task:... Constantin Asofiei

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