FWD » Core Development » Database

01/16/2013

06:56 AM Feature #1949: add conversion support for database triggers

In regard to the TRIGGER PROCEDURE conversion, it seems like the external procedure can be converted to something wit... Greg Shah

09:21 PM Feature #1949: add conversion support for database triggers

We need to convert the session triggers (like your ON example above), but we also need support for schema triggers (i... Eric Faulhaber

08:34 PM Feature #1947: add conversion support for database methods

Vadim Nebogatov wrote:
> Please check if I am on the correct way.
>
> I have started implementation for BUFFER-... Eric Faulhaber

01/15/2013

04:53 PM Feature #1949 (WIP): add conversion support for database triggers

Eric, am I correct that I only need to cover session triggers, i.e.... Stanislav Lomany

12:44 PM Feature #1953 (WIP): add conversion support for CREATE BUFFER statement

Ovidiu Maxiniuc

07:48 PM Feature #1953: add conversion support for CREATE BUFFER statement

This issue is meant to track conversion support only; runtime implementation should be deferred as much as possible,... Eric Faulhaber

07:45 PM Feature #1953 (Closed): add conversion support for CREATE BUFFER statement

Eric Faulhaber

07:52 PM Feature #1955: add conversion support for CREATE-TEMP-TABLE statement

This issue is meant to track conversion support only; runtime implementation should be deferred as much as possible,... Eric Faulhaber

07:52 PM Feature #1955 (Closed): add conversion support for CREATE-TEMP-TABLE statement

Eric Faulhaber

07:50 PM Feature #1954: add conversion support for CREATE QUERY statement

This issue is meant to track conversion support only; runtime implementation should be deferred as much as possible,... Eric Faulhaber

07:50 PM Feature #1954 (Closed): add conversion support for CREATE QUERY statement

Eric Faulhaber

01/14/2013

06:16 PM Bug #18: issues with ne/equal and true/false conversion in WHERE clauses

Changed sources are attached just for backup Vadim Nebogatov

04:47 PM Bug #18: issues with ne/equal and true/false conversion in WHERE clauses

I have attached tests passed for mandatory and not mandatory fields and their combinations Vadim Nebogatov

05:10 PM Feature #1949: add conversion support for database triggers

We need to support conversion of trigger procedures and ON statements for the following database triggers:
* DELET... Eric Faulhaber

04:45 PM Feature #1949 (Closed): add conversion support for database triggers

Eric Faulhaber

04:06 PM Feature #1910 (Closed): add schema conversion support for sequences

Eric Faulhaber

11:56 AM Feature #1910: add schema conversion support for sequences

I just updated a fresh copy from bzr repository and checked all modified files. There are no conflicts.
I am going ... Ovidiu Maxiniuc

11:36 AM Feature #1910: add schema conversion support for sequences

No code review comments. We put this update through regression testing and it has passed. Please re-confirm these c... Eric Faulhaber

10:52 AM Feature #1926: create an en_GB@p2j_basic locale definition

The customer has confirmed that they normally use 8859-1 for the database but 8859-15 for the 4GL environment (code e... Greg Shah

09:56 AM Feature #1580: upgrade Hibernate to latest level

About "Session factory scoping warning": now the XmlDocuments produced by ORMHandler are stored and re-used for datab... Stanislav Lomany

03:56 AM Feature #1947: add conversion support for database methods

The following are database, handle-based methods that we need to support (in priority order):
* BUFFER-FIELD (KW_BUF... Eric Faulhaber

03:42 AM Feature #1947 (Closed): add conversion support for database methods

Eric Faulhaber

01/10/2013

06:08 PM Bug #18: issues with ne/equal and true/false conversion in WHERE clauses

Created sync testing environments for using persistent tables with mandatory/not-mandatory fields on 4GL and P2J: cre... Vadim Nebogatov

09:26 AM Feature #1583: add conversion and runtime support for the INSERT language statement

Replacement of INSERT by CREATE+UPDATE moved to new ruleset file. The intermediary files generated differ just by pee... Ovidiu Maxiniuc

08:06 AM Feature #1910: add schema conversion support for sequences

Apparently I omitted to put @com.goldencode.p2j.persist.pl.Operators.java@ file on the update package.
I also re-rev... Ovidiu Maxiniuc

01:28 AM Feature #1910: add schema conversion support for sequences

Code review 20130109a:
Good work overall! However, I did have one serious problem; see below.
I made some minor ch... Eric Faulhaber

01/09/2013

09:05 AM Feature #1910 (Review): add schema conversion support for sequences

The sequences are now imported directly into psql using generated ddl from conversion step and initialized at the imp... Ovidiu Maxiniuc

01/08/2013

01:29 PM Feature #1580: upgrade Hibernate to latest level

About "Error closing Hibernate session": session factory is closed in the context which holds the last session connec... Stanislav Lomany

12:19 PM Feature #1933: add conversion support for certain metadata constructs

This task is just about converting these constructs and stubbing out any new runtime methods needed, so that the conv... Eric Faulhaber

12:15 PM Feature #1933 (Closed): add conversion support for certain metadata constructs

Eric Faulhaber

01/04/2013

02:07 PM Feature #1910: add schema conversion support for sequences

Ovidiu Maxiniuc wrote:
> Does-it make sense to create another file or should I just extend the @dmo-index@'s dtd @sc... Eric Faulhaber

12:26 PM Feature #1910: add schema conversion support for sequences

> OK, I understand that there is some configuration that needs to be migrated, when the backing database does not sup... Ovidiu Maxiniuc

10:40 AM Feature #1910: add schema conversion support for sequences

OK, I understand that there is some configuration that needs to be migrated, when the backing database does not suppo... Greg Shah

10:15 AM Feature #1910: add schema conversion support for sequences

When doing the (one-time) import there is no special care for sequences, they are imported with the actual value. How... Ovidiu Maxiniuc

09:36 AM Feature #1910: add schema conversion support for sequences

I thought that the "directory-backed crossed-the-sequence-boundary flag" approach was only needed to remember the fac... Greg Shah

01:44 PM Feature #1651: add support for dynamic database features

We need to determine whether dynamic database features are scope-agnostic in terms of resolving database references; ... Eric Faulhaber

01/03/2013

07:23 PM Feature #1910: add schema conversion support for sequences

Ovidiu Maxiniuc wrote:
> ...
> I have some issues / questions about all these modification:
> 1. I did not have ac... Eric Faulhaber

01/02/2013

01:10 AM Feature #1910: add schema conversion support for sequences

Sequence conversion and import for PostgreSQL seems to work well with some minor changes I've made. I need to merge ... Eric Faulhaber

01:08 AM Feature #1926 (Hold): create an en_GB@p2j_basic locale definition

Eric Faulhaber

12/31/2012

08:15 AM Feature #1580: upgrade Hibernate to latest level

1. About NPE in suggestNextVendorNumber: strange, but if we use a PreparedStatement which returns a ResultSet in do(R... Stanislav Lomany

12/28/2012

11:58 AM Feature #1910: add schema conversion support for sequences

This note is somewhere at the border between sequence conversion and runtime.
I tried to add the H2 database support... Ovidiu Maxiniuc

09:30 AM Feature #1580: upgrade Hibernate to latest level

1.
> Please be careful in making any changes to code which initializes collections; I originally tried to make the ... Stanislav Lomany

12/26/2012

01:06 PM Feature #1580: upgrade Hibernate to latest level

> What version of QaVendorUtils are you using? There is no ResultSet.close() call at line 269 in my version (004). ... Stanislav Lomany

12:16 PM Feature #1580: upgrade Hibernate to latest level

Stanislav Lomany wrote:
> 1. Reproduction: F - V - A
> ... Eric Faulhaber

12:07 PM Feature #1580: upgrade Hibernate to latest level

Please be careful in making any changes to code which initializes collections; I originally tried to make the initia... Eric Faulhaber

08:16 AM Feature #1580: upgrade Hibernate to latest level

> OK, let's try it. Can you think of an easy (generic) way to determine when an entity has a collection, or do you p... Stanislav Lomany

12/21/2012

12:54 PM Feature #1660: add conversion and runtime support for OF keyword use in a CAN-FIND

I still need to review customer reports to determine actual scenarios, but please start with some basic use cases. Eric Faulhaber

12:35 PM Feature #1910: add schema conversion support for sequences

I have merged the 1214a update with my local changes and tested a real-world database import with sequences. I found... Eric Faulhaber

12:19 PM Feature #1663: test/debug case-sensitive field support

This task is about defining temporary and permanent database tables with a mix of case-sensitive and case-insensitive... Eric Faulhaber

09:40 AM Feature #1580: upgrade Hibernate to latest level

OK, let's try it. Can you think of an easy (generic) way to determine when an entity has a collection, or do you pro... Eric Faulhaber

04:41 AM Feature #1580: upgrade Hibernate to latest level

Eric, the snippet represents the process of deletion and the following rollback of an entity in P2J (during rollback ... Stanislav Lomany

12/20/2012

06:28 PM Feature #1910: add schema conversion support for sequences

Code review 1214a:
Is the version of SequenceManager.java in this update the correct one? It doesn't compile. Fi... Eric Faulhaber

05:28 PM Feature #1580: upgrade Hibernate to latest level

PS: see the stacktrace in the #1566 bug. Constantin Asofiei

05:26 PM Feature #1580: upgrade Hibernate to latest level

Stas/Eric, just a thought: do you see the "Found two representations of same collection" issue any way related to the... Constantin Asofiei

05:07 PM Feature #1580: upgrade Hibernate to latest level

Sorry, I don't understand what your workaround example is trying to accomplish. What use case in P2J does this repre... Eric Faulhaber

06:23 AM Feature #1580: upgrade Hibernate to latest level

In order to reproduce the "Found two representations of same collection" issue the following Hibernate command sequen... Stanislav Lomany

08:45 AM Bug #18: issues with ne/equal and true/false conversion in WHERE clauses

The keyword is specified in the schema (.df file) as an option on a field:... Greg Shah

12/19/2012

05:59 PM Bug #18: issues with ne/equal and true/false conversion in WHERE clauses

I read about this option, but I found no examples of it's using. Maybe it depends on 4GL version?
Syntax like
..... Vadim Nebogatov

04:35 PM Bug #18: issues with ne/equal and true/false conversion in WHERE clauses

Progress uses the keyword MANDATORY to denote a non-nullable field.
Thanks,
Eric Vadim Nebogatov

04:34 PM Bug #18: issues with ne/equal and true/false conversion in WHERE clauses

Reading and investigation of Progress 4GL documentation as regards not-nullable fields. I did not find any field opti... Vadim Nebogatov

12/18/2012

05:50 PM Feature #1926: create an en_GB@p2j_basic locale definition

Here is the information screen for the @<db_name>@ database on windev01 from the Data Administration --> Utilities --... Eric Faulhaber

12:47 PM Feature #1580: upgrade Hibernate to latest level

1. Found two representations of same collection -- a day, may be two to find the cause and make a solution
2. Sessio... Stanislav Lomany

11:39 AM Feature #1580: upgrade Hibernate to latest level

Please summarize the current status of all known issues with this task and estimate (if you can) how much effort you ... Eric Faulhaber