FWD » Core Development » Database

07/02/2021

10:07 PM Feature #4022: upgrade to a newer PostgreSQL release

Roger Borrello wrote:
> ...
> Eric and I went over quite a few things, but it doesn't appear that the Java 11 I hav... Eric Faulhaber

08:25 PM Feature #4022: upgrade to a newer PostgreSQL release

Greg suggested I create a new task in database, but this task looks well suited for the issues related to installing ... Roger Borrello

07/01/2021

12:54 PM Support #5183: database collation

> @locale -a@ does not list them
If @localedef@ was successful there should be new locale files. If that is the c... Greg Shah

12:44 PM Support #5183: database collation

Do you have @/usr/share/i18n/charmaps/CP1252.gz@? If so, @gunzip@ it. I think @locale-gen@ just runs @localedef@ unde... Eric Faulhaber

12:35 PM Support #5183: database collation

Eric Faulhaber wrote:
> These were the specific lines I added to @/etc/locale.gen@, based on some Googling:
> [...]... Ovidiu Maxiniuc

12:20 PM Support #5183: database collation

Roger Borrello wrote:
> A general question about the use of a custom locale. The database for an existing applicatio... Eric Faulhaber

12:17 PM Support #5183: database collation

Ovidiu Maxiniuc wrote:
> Eric,
> I have not tried to use the @en_US.cp1252@ locale until now. Only the custom local... Eric Faulhaber

11:39 AM Support #5183: database collation

A general question about the use of a custom locale. The database for an existing application would need to be droppe... Roger Borrello

11:33 AM Support #5183: database collation

Eric,
I have not tried to use the @en_US.cp1252@ locale until now. Only the custom locales. However, when I try to d... Ovidiu Maxiniuc

03:07 AM Support #5183: database collation

Ovidiu, I need your help.
In any of your encoding testing lately, have you been able to create a database cluster ... Eric Faulhaber

06/30/2021

09:20 PM Feature #5491: custom locale/collation implementations

Sorry, I do not know how these task properties has changed. I did not do it on purpose :(. Ovidiu Maxiniuc

09:15 PM Feature #5491: custom locale/collation implementations

Eric Faulhaber wrote:
> Ovidiu, please update the FWD documentation with the new approach to installation and config... Ovidiu Maxiniuc

06/29/2021

04:14 PM Feature #5491: custom locale/collation implementations

Ovidiu, please update the FWD documentation with the new approach to installation and configuration. Specifically, th... Eric Faulhaber

06/28/2021

03:20 PM Feature #5491 (WIP): custom locale/collation implementations

Yes. They would be identified by:
| PostgreSQL | @en_US@CP1252@basic@FWD@,
@en_GB@CP1252@basic@FWD@ and
@nl_NL@CP1... Ovidiu Maxiniuc

02:47 PM Feature #5491: custom locale/collation implementations

OK, understood.
Then shouldn't we mirror the same approach for the @p2jspi.jar@? This may avoid confusion. Greg Shah

02:20 PM Feature #5491: custom locale/collation implementations

It is a bit more complicated than that.
We need to keep the lang/land prefix. This is used within the locale script... Ovidiu Maxiniuc

02:05 PM Feature #5491: custom locale/collation implementations

Then perhaps we should not have @en_US@CP1252@FWD@, @en_GB@CP1252@FWD@ and @nl_NL@CP1252@FWD@ but instead just @basic... Greg Shah

01:36 PM Feature #5491: custom locale/collation implementations

I investigated the content of the @convmap.cp@ on my Windows test machine and I found the following collations availa... Ovidiu Maxiniuc

10:10 AM Feature #5491: custom locale/collation implementations

Indeed, at first I thought that using different CPs will automatically imply a specific sorting order since I did not... Ovidiu Maxiniuc

07:07 AM Feature #5491: custom locale/collation implementations

> The language and country parameters are not relevant (for what I know)
Are you saying that we've never found any... Greg Shah

06/26/2021

05:51 PM Feature #5491: custom locale/collation implementations

Committed revision 12576.
Added @ISO_8859_15Collator.java@ and @CP1252Collator.java@ identified as described above... Ovidiu Maxiniuc

06/25/2021

07:22 PM Feature #5491: custom locale/collation implementations

At this moment @ISO_8859_1Collator@ is the only collation registered with the 'identifier' <code class="Java">new Loc... Ovidiu Maxiniuc

10:53 AM Feature #5491: custom locale/collation implementations

The @locale/gen-locale.p@ program has recently been updated and several new OS-level custom locales have been generat... Eric Faulhaber

10:35 AM Feature #5491 (Closed): custom locale/collation implementations

Eric Faulhaber

06/18/2021

03:12 PM Bug #5476: Bug in Java UDF addinterval(date, ...)

The statement @select public.addinterval(date '1999-01-08', 1, 'months')@ works fine, while @select public.addinterva... Igor Skornyakov

03:11 PM Bug #5476 (New): Bug in Java UDF addinterval(date, ...)

Igor Skornyakov

06/15/2021

07:12 PM Feature #5453: optimize FindQuery hasOne and hasAny implementations

Alternatively, we can keep the record in session cache, hoping a future query will have the result already fetched. U... Ovidiu Maxiniuc

12:15 PM Feature #5453: optimize FindQuery hasOne and hasAny implementations

We currently convert standalone CAN-FIND calls to use @FindQuery.hasAny@ or @FindQuery.hasOne@. These methods will fe... Eric Faulhaber

12:09 PM Feature #5453 (New): optimize FindQuery hasOne and hasAny implementations

Eric Faulhaber

07:05 PM Bug #5452: eliminate use of ResultSet.CONCUR_UPDATABLE?

You are right. Since we always fetch the data from the @ResultSet@ s and use it to hydrate our own @Record@ s there i... Ovidiu Maxiniuc

12:07 PM Bug #5452: eliminate use of ResultSet.CONCUR_UPDATABLE?

Ovidiu, while debugging a few days ago, I came across this in @SQLQuery.scroll(Session, int, boolean, List<RowStructu... Eric Faulhaber

12:00 PM Bug #5452 (Closed): eliminate use of ResultSet.CONCUR_UPDATABLE?

Eric Faulhaber

06/14/2021

06:15 PM Bug #5289: Misc. problems with triggers

Eric Faulhaber wrote:
> Is bullet point 3 (NPE in @PreselectQuery@ for FIND trigger) in #5289-1 the only thing left ... Ovidiu Maxiniuc

02:55 PM Bug #5289: Misc. problems with triggers

Is bullet point 3 (NPE in @PreselectQuery@ for FIND trigger) in #5289-1 the only thing left in this task?
Were you... Eric Faulhaber

02:57 PM Support #3871 (Closed): determine how to change codepages/locales during import

Greg Shah

08:07 AM Feature #3930: allow session level control over the database(s) which are auto-connected

Eric Faulhaber wrote:
> Please do not re-use branches once they have been merged. Please extract your changes and ei... Igor Skornyakov

09:12 PM Feature #3930 (Closed): allow session level control over the database(s) which are auto-connected

Eric Faulhaber

06/13/2021

07:56 PM Feature #3930: allow session level control over the database(s) which are auto-connected

Igor Skornyakov wrote:
> Get rid of the notion of the permanent connection.
>
> Committed to 3930a revision 12499... Eric Faulhaber

04:29 PM Feature #3930: allow session level control over the database(s) which are auto-connected

Get rid of the notion of the permanent connection.
Committed to 3930a revision 12499.
The notion of the transient... Igor Skornyakov

07:42 PM Bug #5440: finish DatabaseManager refactoring for implicit/explicit connections

Issue #3930 added session level control over database connections (in the 4GL sense, not the JDBC sense). These conne... Eric Faulhaber

07:11 PM Bug #5440 (New): finish DatabaseManager refactoring for implicit/explicit connections

Eric Faulhaber

06/11/2021

05:06 PM Bug #5289: Misc. problems with triggers

Yes, attempt to improve generics was rolled back in r12522. It was reported by other colleagues which compiled newly ... Ovidiu Maxiniuc

03:46 AM Bug #5289: Misc. problems with triggers

Is the generics regression in @DatabaseTriggerManager@ which was causing converted code to not compile fixed in 3821c... Eric Faulhaber

10:59 PM Bug #5289: Misc. problems with triggers

I committed the fix for REPLICATION and improved management of table triggers (including veto support) in r12468 and ... Ovidiu Maxiniuc

04:54 PM Support #3871: determine how to change codepages/locales during import

Indeed, the usage of static configuration on client side (added in r12499) was incorrect so was reverted in 12502.
I... Ovidiu Maxiniuc

07:10 AM Support #3871: determine how to change codepages/locales during import

Code Review Task Branch 3821c Revision 12502
The changes are good.
Isn't there still an issue with calling @Con... Greg Shah

10:45 PM Support #3871: determine how to change codepages/locales during import

The revision 12502 of 3821c handles the issues and suggestions from the ode review:
* the @CharsetConverter@ which w... Ovidiu Maxiniuc

03:41 PM Feature #3930: allow session level control over the database(s) which are auto-connected

Eric Faulhaber wrote:
> For the remaining cleanup, please note that the explicit connections really shouldn't be tre... Igor Skornyakov

03:33 PM Feature #3930: allow session level control over the database(s) which are auto-connected

For the remaining cleanup, please note that the explicit connections really shouldn't be treated much differently tha... Eric Faulhaber

06/02/2021

05:13 AM Feature #3930: allow session level control over the database(s) which are auto-connected

Merged to 3821c/12490. Igor Skornyakov

12:34 AM Feature #3930: allow session level control over the database(s) which are auto-connected

The changes in 3930a revs 12482-3 look good. Please add the more detailed javadoc and clean up the code to coding sta... Eric Faulhaber