FWD » Core Development » Database

06/17/2013

06:04 PM Feature #1652: add conversion and runtime support for dynamically prepared temp-tables

Eric, I wasn't sure if the definitions of indexes in Hibernate are used by P2J. If they are not used - great! Stanislav Lomany

01:58 PM Feature #1652: add conversion and runtime support for dynamically prepared temp-tables

This all makes sense to me, except:
> 3. there is no direct replacement for index section, so it looks like another ... Eric Faulhaber

12:51 PM Feature #1652: add conversion and runtime support for dynamically prepared temp-tables

I was working on the code generation for dynamic DMOs. At first I started with the approach that re-uses hibernate/ja... Stanislav Lomany

06/15/2013

04:50 PM Feature #1588: add conversion and runtime support for embedded SQL

failed in latest revision in bazaar Vadim Nebogatov

04:49 PM Feature #1588: add conversion and runtime support for embedded SQL

sql_count.p conversion failed with error in #10... Vadim Nebogatov

06/14/2013

06:29 PM Feature #1588: add conversion and runtime support for embedded SQL

Please upload the test case that is causing this error.
Eric Faulhaber

06:09 PM Feature #1588: add conversion and runtime support for embedded SQL

My tests for @COUNT(*)@ runtime work for permanent tables, but for temporary tables I receive exception in common-pr... Vadim Nebogatov

06/12/2013

03:36 PM Feature #1588: add conversion and runtime support for embedded SQL

No, we only need runtime support for the forms listed in note 1 above.
Please see the following in the testcases p... Eric Faulhaber

02:52 PM Feature #1588: add conversion and runtime support for embedded SQL

What about support of @COUNT(DISTINCT column)@? 4GL supports such expressions as part of obsolete SQL-89, with the fo... Vadim Nebogatov

10:08 AM Feature #1652: add conversion and runtime support for dynamically prepared temp-tables

Stanislav Lomany wrote:
> Since table names can be the same across multiple or even one user context, I think we sho... Eric Faulhaber

06/11/2013

04:51 PM Feature #1652: add conversion and runtime support for dynamically prepared temp-tables

Since table names can be the same across multiple or even one user context, I think we should use @<table name>___<un... Stanislav Lomany

01:44 PM Feature #1652: add conversion and runtime support for dynamically prepared temp-tables

We will be supporting both widget pools and the DELETE OBJECT. That work is not yet complete. See #1983.
Constan... Greg Shah

12:57 PM Feature #1652: add conversion and runtime support for dynamically prepared temp-tables

"The dynamic temp-table object is scoped like the buffer object. It is created in a widget pool and ends when the wid... Stanislav Lomany

06/10/2013

05:12 PM Feature #1652: add conversion and runtime support for dynamically prepared temp-tables

Check out the harness project using bzr and look in src/com/goldencode/compile/ for the backing code. Also look at:
... Greg Shah

05:01 PM Feature #1652: add conversion and runtime support for dynamically prepared temp-tables

> What in your opinion makes Javassist a different/better solution for our needs?
I didn't notice that we are alread... Stanislav Lomany

04:35 PM Feature #1652: add conversion and runtime support for dynamically prepared temp-tables

I want to be careful about adding another bytecode manipulation library to the project. We have a few options alread... Eric Faulhaber

03:55 PM Feature #1652: add conversion and runtime support for dynamically prepared temp-tables

Eric, how we a going to implement classes of entities for dynamic tables? I gravitate towards Javassist. Stanislav Lomany

05:34 AM Feature #1652: add conversion and runtime support for dynamically prepared temp-tables

For 5000 tables addition of a new one takes about 50 ms.

> What class of hardware were you using for these measur... Stanislav Lomany

07:15 AM Feature #2156: datetime-tz and hibernate

The 2-column compound type implementation of @datetime-tz@ is realized in multiple stages:
# conversion time. In hib... Ovidiu Maxiniuc

06:26 AM Feature #2156: datetime-tz and hibernate

In @datetime-tz@ datatype is a @datetime@ with an integer timezone-offset, equivalent of ANSI @TIMESTAMP WITH TIME ZO... Ovidiu Maxiniuc

05:07 AM Feature #2156 (Closed): datetime-tz and hibernate

Ovidiu Maxiniuc

06/09/2013

06:04 PM Feature #2080 (Test): add runtime support for database methods

Code review 20130609a:
Code looks good. Please regression test on devsrv01, according to the instructions Greg re... Eric Faulhaber

07:29 AM Feature #2080: add runtime support for database methods

I have attached update vmn_upd20130609a.zip.
Added FIND-BY-ROWID() runtime support and some fixes. Should be teste... Vadim Nebogatov

05:57 PM Feature #1652: add conversion and runtime support for dynamically prepared temp-tables

I'm not so concerned about the initial time, this will be part of server startup. It is good that the incremental ca... Eric Faulhaber

04:26 PM Feature #1652: add conversion and runtime support for dynamically prepared temp-tables

For 100 tables initial @builtSessionFactory@ takes 1500 ms and subsequent @buildMappings@ calls - 15 ms. Stanislav Lomany

06/07/2013

04:04 PM Feature #1652: add conversion and runtime support for dynamically prepared temp-tables

> Specifically, I imagine the @configuration.buildMappings()@ call can be quite expensive with a large number of exis... Stanislav Lomany

12:16 PM Feature #1652: add conversion and runtime support for dynamically prepared temp-tables

This is a good start. The following lines in the test app concern me:... Eric Faulhaber

09:46 AM Feature #2080: add runtime support for database methods

Code review 20130606:
I think the changes in RecordBuffer, DMOValidator, DatabaseManager, and the changes which ar... Eric Faulhaber

03:53 AM Feature #2080: add runtime support for database methods

I have attached update vmn_upd20130606a.zip/vmn_upd20130606b.zip
Added @FIND-BY-ROWID()@ runtime support. Main pro... Vadim Nebogatov

06/06/2013

05:57 PM Feature #1652: add conversion and runtime support for dynamically prepared temp-tables

Here is the proof of concept of mutable session factory. BTW, since our factory extends @SessionFactoryImpl@, we don'... Stanislav Lomany

06/03/2013

03:14 PM Feature #1652: add conversion and runtime support for dynamically prepared temp-tables

> It will be unavoidable to make changes in Hibernate code, like removing the final modifier from SessionFactoryImpl ... Stanislav Lomany

05/31/2013

11:41 AM Feature #1652: add conversion and runtime support for dynamically prepared temp-tables

To clarify my last post, there will be no ORM associations allowed between dynamically generated temp-tables and exis... Eric Faulhaber

11:37 AM Feature #1652: add conversion and runtime support for dynamically prepared temp-tables

Another factor that may simplify making our partially-mutable SessionFactoryImplementor is the fact that we know the ... Eric Faulhaber

11:27 AM Feature #1652: add conversion and runtime support for dynamically prepared temp-tables

It looks like re-implementing/replacing SessionFactoryImpl is a tricky job, but there are some factors that limit our... Eric Faulhaber

05/29/2013

06:50 PM Feature #1652: add conversion and runtime support for dynamically prepared temp-tables

> How do you see the pure JDBC or name/value mapping working, specifically with regards to cooperating with all the 4... Stanislav Lomany

05/28/2013

01:51 PM Feature #1652: add conversion and runtime support for dynamically prepared temp-tables

Stanislav Lomany wrote:
> It looks like the single way to update ORM at runtime is to create/update @Configuration@ ... Eric Faulhaber

10:59 AM Bug #2090 (Closed): correct sorting of DMO properties during schema conversion

Eric Faulhaber

02:55 AM Bug #2090: correct sorting of DMO properties during schema conversion

Committed to bzr revision 10354. Constantin Asofiei

05/27/2013

06:47 PM Feature #1652: add conversion and runtime support for dynamically prepared temp-tables

Some thoughts:
1. About dynamic addition / removal of Hibernate entities: Eric, please see my previous note and tell... Stanislav Lomany

04:49 PM Bug #2090: correct sorting of DMO properties during schema conversion

The changes look good to me; please commit. Nice work! Eric Faulhaber

10:05 PM Feature #2080: add runtime support for database methods

There is probably an implicit assumption that there will always be a valid sort (order by) clause passed into the Fin... Eric Faulhaber

05/26/2013

05:55 PM Feature #2080: add runtime support for database methods

Created example for test FIND-BY-ROWID with locked records, and found also NPE on RandomAccessQuery, line 673 - inde... Vadim Nebogatov

05/25/2013

09:12 AM Bug #2090 (Review): correct sorting of DMO properties during schema conversion

Constantin Asofiei

09:01 AM Bug #2090: correct sorting of DMO properties during schema conversion

Beside renumbering of the TempRecord DMOs (not sure why, but I this should not be a problem), changes related to this... Constantin Asofiei

03:22 AM Bug #2090: correct sorting of DMO properties during schema conversion

The server project -compiled- converted fully (no schema generation errors). Lots of changes, I'm running conversion ... Constantin Asofiei

05/24/2013

04:21 PM Bug #2090: correct sorting of DMO properties during schema conversion

ca_upd20130524d.zip has passed runtime regression testing. I'll runn full server project conversion next. Constantin Asofiei

06:10 AM Bug #2090: correct sorting of DMO properties during schema conversion

This fix has passed MAJIC conversion testing; there are diffs, but they are expected. I think this fixes the DMO-rela... Constantin Asofiei

01:46 AM Bug #2090: correct sorting of DMO properties during schema conversion

There are two issues with this update:
# I left behind the ORDER nodes
# I expected for the parser, in a @define te... Constantin Asofiei

10:48 AM Feature #2080: add runtime support for database methods

Vadim Nebogatov wrote:
> Eric Faulhaber wrote:
> > I think you need to execute the FindQuery with silent error mode... Eric Faulhaber

10:46 AM Feature #2080: add runtime support for database methods

Vadim Nebogatov wrote:
> Eric Faulhaber wrote:
> > Vadim Nebogatov wrote:
> > > I thought these methods are still ... Eric Faulhaber

05/23/2013

05:42 PM Feature #1652: add conversion and runtime support for dynamically prepared temp-tables

It looks like the single way to update ORM at runtime is to create/update @Configuration@ object and build a new @Ses... Stanislav Lomany

05:28 PM Feature #2080: add runtime support for database methods

Eric Faulhaber wrote:
> I think you need to execute the FindQuery with silent error mode enabled, then return the res... Vadim Nebogatov

04:56 PM Feature #2080: add runtime support for database methods

Eric Faulhaber wrote:
> Please help me understand the need for the ErrorIfNull enum and the changes to @RecordBuffer... Vadim Nebogatov

04:45 PM Feature #2080: add runtime support for database methods

Eric Faulhaber wrote:
> Vadim Nebogatov wrote:
> > I thought these methods are still not implemented properly and p... Vadim Nebogatov

12:39 AM Feature #2080: add runtime support for database methods

Vadim Nebogatov wrote:
> Eric Faulhaber wrote:
> > I think you need to execute the FindQuery with silent error mode... Eric Faulhaber

04:17 PM Bug #2090: correct sorting of DMO properties during schema conversion

Please see the attached fix. At this time, I think the DataModelWorker solved the symptom, and not the cause. Idea is... Constantin Asofiei

12:54 PM Bug #2090 (WIP): correct sorting of DMO properties during schema conversion

Constantin Asofiei

08:27 AM Bug #2090: correct sorting of DMO properties during schema conversion

Good work.
Please go ahead and work this. Right now, the code as we have it checked into bzr can't properly conve... Greg Shah

08:15 AM Bug #2090: correct sorting of DMO properties during schema conversion

I can confirm this is a real problem. This is the case in dan/Dec.java:... Constantin Asofiei

08:03 AM Bug #2090: correct sorting of DMO properties during schema conversion

Attached the DataModelWorker changes. Constantin Asofiei

05/22/2013

05:56 PM Feature #2080: add runtime support for database methods

Eric Faulhaber wrote:
> I think you need to execute the FindQuery with silent error mode enabled, then return the re... Vadim Nebogatov

02:46 PM Feature #2080: add runtime support for database methods

I think you need to execute the FindQuery with silent error mode enabled, then return the result of @ErrorManager.isE... Eric Faulhaber

12:50 PM Bug #2090: correct sorting of DMO properties during schema conversion

How much time is estimated to be needed to check this? Greg Shah

10:59 AM Bug #2090: correct sorting of DMO properties during schema conversion

The remaining problem here is that this fix changes the widget order for some "display temp-buffer." cases in MAJIC. ... Constantin Asofiei

05/21/2013

04:34 AM Feature #2080: add runtime support for database methods

I am comparing and fixing differences with 4GL and P2J error handling after I implemented method FIND-BY-ROWID as
<p... Vadim Nebogatov

05/20/2013

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

I've changed the H2 and PostgreSQL dialects to not use quoted sequence names, so that we are not forcing case-sensiti... Eric Faulhaber