Project

General

Profile

Activity

From 06/06/2021 to 07/05/2021

07/05/2021

06:51 PM Feature #4022: upgrade to a newer PostgreSQL release
I noticed that @postgresql-10-pljava@ was on the auto-update list, and pljava was upgraded at 5pm to @1.6.2-2.pgdg20.... Roger Borrello
04:59 PM Feature #5491: custom locale/collation implementations
Please change the @title@ in the @LC_IDENTIFICATION@ section of the @en_GB@ locale definitions to say, "Great Britain... Eric Faulhaber
04:26 PM Feature #5491: custom locale/collation implementations
No, I'll close it after review of this current batch. As we create more locales/collators over time, we can reopen it... Eric Faulhaber
04:20 PM Feature #5491 (Review): custom locale/collation implementations
Do we keep this task open for adding new collations? Ovidiu Maxiniuc

07/02/2021

05:13 PM Support #5183: database collation
Ovidiu Maxiniuc wrote:
> The listing you obtained is pretty much the one we currently have in @locale/xx_XX@ISO8859-...
Eric Faulhaber
10:27 AM Support #5183: database collation
The listing you obtained is pretty much the one we currently have in @locale/xx_XX@ISO8859-1@basic@FWD@ and @src/com/... Ovidiu Maxiniuc
10:06 AM Support #5183: database collation
Eric,
The space character (@0x20@, or @32@ decimal) is incorrectly listed in the 2nd position. This is because the c...
Ovidiu Maxiniuc
04:43 AM Support #5183: database collation
h2. Comparison of OE ISO-8859-1 basic collation vs. PostgreSQL ISO-8859-1 default collation (en_US)
I created ISO-...
Eric Faulhaber
03:33 PM Bug #5512: Java todate(text) UDF returns incorect value
@public.todate('06302001')@ returns '2001-06-29' which doesn't look correct. Igor Skornyakov
03:32 PM Bug #5512 (New): Java todate(text) UDF returns incorect value
Igor Skornyakov
02:01 PM Feature #4022: upgrade to a newer PostgreSQL release
Constantin Asofiei wrote:
> Please read the above as 'unofficial steps'. There may be a better way to do this, but ...
Roger Borrello
01:57 PM Feature #4022: upgrade to a newer PostgreSQL release
The release notes for PL/Java https://tada.github.io/pljava/releasenotes.html indicate the moved to the Java 9 module... Roger Borrello
01:56 PM Feature #4022: upgrade to a newer PostgreSQL release
I went through setting up PL/Java 1.6.2 last week (with psql 12.7). 1.6.2 does require Java 11 - it is compiled as s... Constantin Asofiei
01:45 PM Feature #4022: upgrade to a newer PostgreSQL release
OK, don't install PL/Java through apt. This is actually untested, so you are breaking new ground here.
Does PL/Jav...
Eric Faulhaber
01:09 PM Feature #4022: upgrade to a newer PostgreSQL release
Roger Borrello wrote:
> So getting to the Java 11 uninstall... it also uninstall pljava. So when this is done, I'll ...
Roger Borrello
01:05 PM Feature #4022: upgrade to a newer PostgreSQL release
I started reading the fine manual at PL/Java: https://tada.github.io/pljava/install/install.html
When I ran @pg_co...
Roger Borrello
02:12 AM Feature #4022: upgrade to a newer PostgreSQL release
Roger Borrello wrote:
> What are your thoughts on the @/opt/pljava/install.sql@ script (attached) in terms of when/h...
Eric Faulhaber
12:08 AM Feature #4022: upgrade to a newer PostgreSQL release
What are your thoughts on the @/opt/pljava/install.sql@ script (attached) in terms of when/how to run it? I don't see... Roger Borrello
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
01:53 PM Bug #5511: todate(text) Java UDF throws strange exception
Java UDF @todate(text)@ throws an exception @SQL Error [XX000]: ERROR: java.lang.NoClassDefFoundError: com/goldencode... Igor Skornyakov
01:52 PM Bug #5511 (New): todate(text) Java UDF throws strange exception
Igor Skornyakov

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
 

Also available in: Atom