FWD » Core Development » Database

06/22/2013

05:20 PM Feature #1588: add conversion and runtime support for embedded SQL

Testing, code commenting aggregate functions runtime in embedded SQL.
@cnt, max, min, sum@ work properly, but there... Vadim Nebogatov

06/19/2013

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

Problem fixed with @COUNT(*)@ runtime in case when WHERE clause is missed because of bug in BufferImpl: ... Vadim Nebogatov

06/18/2013

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

Thanks, conversion works now for count(*) Vadim Nebogatov

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

The temp-table problem was further back than common-progress.rules. We were only adding the "simple_sql_conversion" ... Eric Faulhaber

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