FWD » Core Development » Database

12/16/2018

05:12 AM Feature #3500: implement CLOB and BLOB support

3750a/11346 adds support for the import of BLOBs and CLOBs. It requires that all LOB export files reside in a subdire... Eric Faulhaber

12/15/2018

03:49 AM Feature #3500: implement CLOB and BLOB support

I've added basic conversion and runtime support for BLOB and CLOB in 3750a/11334. Does not include changes to data im... Eric Faulhaber

12/13/2018

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

Turns out, I need to fetch the LOB data at the time the record is retrieved, otherwise we can't be sure we can get it... Eric Faulhaber

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

The cause of this issue is documented in @ConnectionManager.java@:438:... Ovidiu Maxiniuc

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

This thread is public, but I agree that the artifacts should be seen from the other two documents as well. Greg Shah

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

Greg Shah wrote:
> What updates need to be made to the documentation chapters so that it is complete?
>
> https:/... Ovidiu Maxiniuc

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

What updates need to be made to the documentation chapters so that it is complete?
https://proj.goldencode.com/pro... Greg Shah

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

Ovidiu Maxiniuc wrote:
> Eugenie,
>
> I guess you refer in note-65 of MinGW-built PostgreSQL. Building with MSVC... Eugenie Lyzenko

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

Eugenie,
I guess you refer in note-65 of MinGW-built PostgreSQL. Building with MSVC-built PostgreSQL is much simp... Ovidiu Maxiniuc

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