FWD » Core Development » Database

07/11/2013

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

Good question. I'm sure a DELETE FROM style bulk delete would be rolled back at a full transaction scope, but we nee... Eric Faulhaber

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

Are there sense of reversible bulk delete for persistent tables? Vadim Nebogatov

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

Vadim Nebogatov wrote:
> Additionally to note 29.
> I have tested @DELETE FOR@ with @WHERE@ clause. I understand i... Eric Faulhaber

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

OK, please check in and distribute this update. Eric Faulhaber

01:58 PM Feature #2080: add runtime support for database methods

Regression 20130711_075408 completed with the following results.
Only 2 tests failed: tc_job_002 as expected and ... Vadim Nebogatov

07/09/2013

06:09 PM Feature #2080: add runtime support for database methods

I looked over the test results.
One of the failures, tc_job_002, is expected, as described in Constantin's regress... Eric Faulhaber

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

Additionally to note 29.
I have tested @DELETE FOR@ with @WHERE@ clause. I understand it is not require to support,... Vadim Nebogatov

09:45 AM Feature #1588: add conversion and runtime support for embedded SQL

avg runtime works properly now Vadim Nebogatov

06:13 AM Feature #1588: add conversion and runtime support for embedded SQL

Update SqlGenerator. Stanislav Lomany

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

Fixes the problem with avg. Stanislav Lomany

12:43 PM Feature #1911: add runtime support for sequences

Taking into consideration that some other data are also managed in P2J using the legacy-name (for example the second ... Ovidiu Maxiniuc

04:34 AM Feature #1911: add runtime support for sequences

The actual implementation of sequences does change their name to a SQL-legal name and the old "historical" name is te... Ovidiu Maxiniuc

07/08/2013

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

*Testing @DELETE FROM@ in multi-user environment.*
The behavior does not depend on @SHARE-LOCK | EXCLUSIVE-LOCK | ... Vadim Nebogatov

06:59 AM Feature #1588: add conversion and runtime support for embedded SQL

Stas,
I have attached update vmn_upd20130707a.zip merged to latest revision 10362.
I used example... Vadim Nebogatov

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

Vadim, can you provide the failing code so I can try to fix Hibernate? Stanislav Lomany

06:25 AM Feature #1588: add conversion and runtime support for embedded SQL

I just ported the GCD changes for Hibernate 3.0.5 to Hibernate 4.1.8.
3.0.5 didn't have @functionType@ parameter so... Stanislav Lomany

06:11 AM Feature #1588: add conversion and runtime support for embedded SQL

I have found the reason of NPE in @avg@ runtime support.
Problem is in patching @org.hibernate.hql.internal.ast.Sql... Vadim Nebogatov

07/07/2013

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

Update for review. Contains changes that allow to run conversion at run time and changes in Hibernate-related rules. Stanislav Lomany

07/06/2013

01:28 AM Feature #2080: add runtime support for database methods

Regression seems passed. There are 2-3 errors related with timeout and unexpected EOF. No 7345 errors ("Unable to CRE... Vadim Nebogatov

07/05/2013

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

Some intermediate ideas about avg() runtime bugs related with Hibernate.
The reason is not clear so far. I debugged ... Vadim Nebogatov

07/04/2013

06:13 PM Feature #2080: add runtime support for database methods

4GL test results for buffer-delete() outside transaction.
For persistent tables - gives 7345 error ("Unable to CR... Vadim Nebogatov

02:46 PM Feature #1580: upgrade Hibernate to latest level

I did not find sources. shared/projects does not contain hibernate subfoder...
I see only old shared/projects/p2j/hi... Vadim Nebogatov

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

OK, I did it. Stanislav Lomany

07/03/2013

03:45 PM Feature #1580: upgrade Hibernate to latest level

Stas: you must have a full version of the modified 4.1.8Final Hibernate source code on your system, from which you b... Eric Faulhaber

06/27/2013

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

Yes, I am just doing this now Vadim Nebogatov

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

Vadim wrote (in email):
> select avg(...) is not logged because exception happens on statement creation time
You ... Eric Faulhaber

07:55 AM Feature #2000: add conversion support for table and table handle parameters

Stanislav: this is from one of my tests, I think is safe to put it in your low priority queue, as it doesn't affect t... Constantin Asofiei

07:52 AM Feature #2000: add conversion support for table and table handle parameters

Constantin, I looked at it and have no quick idea how to fix it. It looks like TableParameters-related code just wasn... Stanislav Lomany

06/26/2013

01:54 PM Feature #2000: add conversion support for table and table handle parameters

Stanislav, any idea why this code converts badly?... Constantin Asofiei

10:46 AM Feature #1588: add conversion and runtime support for embedded SQL

Vadim Nebogatov wrote:
> For change hibernate logging I need to create corresponding cfg/log4j.properties file. As I... Eric Faulhaber

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

For change hibernate logging I need to create corresponding cfg/log4j.properties file. As I see in note 111 for issue... Vadim Nebogatov

06/25/2013

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

Eric Faulhaber wrote:
> Have you turned on logging in Hibernate to see what SQL is being generated from this?
Not ... Vadim Nebogatov

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

Have you turned on logging in Hibernate to see what SQL is being generated from this? Have you debugged into Hiberna... Eric Faulhaber

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

> I have to take a deeper look and dig into the details, but so far, nice work getting this going at runtime! Have yo... Stanislav Lomany

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

I have to take a deeper look and dig into the details, but so far, nice work getting this going at runtime! Have you ... Eric Faulhaber

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

Test update that generates DMO classes (Java code) and mappings (hbm.xml) at server run time using conversion engine.... Stanislav Lomany

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