FWD » Core Development » Database

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

12/17/2012

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

Variant above does not require aliases mapping because argument type is calculated in HQLPreprocessor.
I made one m... Vadim Nebogatov

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

Testcase for the "Found two representations of same collection" issue:... Stanislav Lomany

12/15/2012

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

Approach described above is implemented, it works and on testing now.
But I have found one more problem.
If where... Vadim Nebogatov

12/14/2012

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

> Did this behavior change from 3.0.5?
Yes, 3.0.5 just checks if there is the entity in the persistence context (reg... Stanislav Lomany

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

Stanislav Lomany wrote:
> The "crossReferenceItem already exists with" issue is about Session.contains function. In ... Eric Faulhaber

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

The "crossReferenceItem already exists with" issue is about Session.contains function. In Hibernate 4 it returns FALS... Stanislav Lomany

01:46 PM Feature #1911: add runtime support for sequences

Ovidiu Maxiniuc wrote:
> ...The fact is, this is the exact way PostgreSQL handles sequences and this should be a goo... Eric Faulhaber

11:21 AM Feature #1911: add runtime support for sequences

I have discovered something at least interesting today. The Progress/4GL 9 and OpenEdge/ABL 11 Reference books, both ... Ovidiu Maxiniuc

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

As I created a new test case file for sequences I discovered that the @Sequencemanager.setValue()@ set of overloaded ... Ovidiu Maxiniuc

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

I understood the reason of problem with nested SQL Functions invocation (NPE on parsing SQL Function argument time): ... Vadim Nebogatov

12/13/2012

12:21 PM Feature #1926: create an en_GB@p2j_basic locale definition

I have done a first cut of this as described above, but I'm pretty sure it's not quite right yet.
I exported the c... Eric Faulhaber

12/12/2012

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

Some tests are attached and passed as expected.
Now I am working with tests containing nested sql functions - not a... Vadim Nebogatov

12/11/2012

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

I have attached SQL Functions I am going to test now. Sorry, there are no proper comments and formatting just because... Vadim Nebogatov

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

Ovidiu Maxiniuc wrote:
> The @_seqvals.d@ is indeed the default filename for exported sequence values. I documented ... Eric Faulhaber

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

Changes in today's update:
* @src@ directory structure fixed
* @dbimport@ replaced @seqimp@
* fixed indentation/al... Ovidiu Maxiniuc