FWD » Core Development » Database

01/03/2019

03:07 PM Feature #3757: add metadata support

Greg Shah wrote:
> What runtime work is needed to complete this task?
I think the @_database-feature@ and @_start... Eric Faulhaber

01:13 PM Feature #3500: implement CLOB and BLOB support

Greg Shah wrote:
> What work is left in this task?
Basic LOB CRUD access is supported, but some language features... Eric Faulhaber

01/02/2019

03:01 PM Feature #3758: misc database features

Greg Shah wrote:
> Eric: Please summarize what needs to be done for this task.
*DBTASKID Function*
Full runtime ... Eric Faulhaber

11:33 AM Feature #3758: misc database features

Eric: Please summarize what needs to be done for this task. Greg Shah

11:33 AM Feature #3757: add metadata support

What runtime work is needed to complete this task? Greg Shah

10:06 AM Feature #3500: implement CLOB and BLOB support

What work is left in this task? Greg Shah

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