maria-discuss team mailing list archive
-
maria-discuss team
-
Mailing list archive
-
Message #05865
Re: MariaDbConnector 1.x -> 2.6, problem updating/inserting Torque objects
-
To:
Diego Dupin <diego.dupin@xxxxxxxxxxx>
-
From:
Clemens Wyss - MySign AG <clemens.wyss@xxxxxxxxx>
-
Date:
Wed, 22 Jul 2020 04:49:11 +0000
-
Accept-language:
de-CH, en-US
-
Arc-authentication-results:
i=1; mx.microsoft.com 1; spf=pass smtp.mailfrom=mysign.ch; dmarc=pass action=none header.from=mysign.ch; dkim=pass header.d=mysign.ch; arc=none
-
Arc-message-signature:
i=1; a=rsa-sha256; c=relaxed/relaxed; d=microsoft.com; s=arcselector9901; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version:X-MS-Exchange-SenderADCheck; bh=vTxTd0l/XG8ASSuSAvrv4QkbAE2K273VE23qNW3vY8A=; b=Z07OO4iWlRfWZ/+sVo/GJn81E2ZdzGHl8fXquPk1UuKp+AYUK1X2sCP7CxMLU9MGjdMykGEdB+omqt+PeRBHDPM+0wOaQH6RA+pqK2BD00+LHBLIiZHZa3cTsBiibodF4zaJIz1D1UG6C5/9JjUbACn609bQTdLQTQdMFyAhkeqHo4PNm1WdsyZSLVnDkWdI+/SE00f4ep6ntFr30QOswoFWvAtXInyDB966Kb+R4wkLDHfENYXcwL4zqjHlDGNuhQdundHxUYErSB1eVsrrdq3RvAV0+TiB2P2pu5rfuo4KXmXWID/Pq2waTizY12UcPTT/tnlr/m51cs26ZjvCkw==
-
Arc-seal:
i=1; a=rsa-sha256; s=arcselector9901; d=microsoft.com; cv=none; b=kMtI993V9onrBhBVHBAt69ZnYG2KOmrio0uYqH9Y+ABo9ZP3wmtkpg9mTBJy3hCIq0zg0cSFD8rQU1T7qCqUqoRdPsU5uVFglGg2SgsE0ODoqtLLXVxqaQOqAqTRJvh2f6nkKvJs1MwsFhklTHmv49RvuCllFgYcmr71t7yxKcS7bOqSXa4yFCFeaHazhgGwcjGutw3GcX0x+qGSCmFT3Micubrtx9k03WXMTOIQF0XLtMt2r4dEled1e85kDOTC9QYhzoxmvtBabKrJ7uLROI7wbSN2CJ82oQldY3PQjf2revmy3zutAi2v+KwQG9dEN7XQC2CVI4yIOrIO2WhyHQ==
-
Authentication-results:
mariadb.com; dkim=none (message not signed) header.d=none;mariadb.com; dmarc=none action=none header.from=mysign.ch;
-
Cc:
"maria-discuss@xxxxxxxxxxxxxxxxxxx" <maria-discuss@xxxxxxxxxxxxxxxxxxx>
-
In-reply-to:
<CANmoJ32LfCq62+iSSK8e6b1C79peNKxrd5Op5nue-z1mQd3D1A@mail.gmail.com>
-
Thread-index:
AdZfGOkB1R0lSrcARcCFQG25/EW0NgACNf2AAABLR1AAF6f0gAAXuPOw
-
Thread-topic:
[Maria-discuss] MariaDbConnector 1.x -> 2.6, problem updating/inserting Torque objects
> Correction on "internal" classes is not a solution
agree
> could you create a JIRA issue
https://jira.mariadb.org/browse/CONJ-809 pls feel free to clarify the issue
Von: Diego Dupin <diego.dupin@xxxxxxxxxxx>
Gesendet: Dienstag, 21. Juli 2020 19:08
An: Clemens Wyss - MySign AG <clemens.wyss@xxxxxxxxx>
Cc: Eric Herman <eric.herman@xxxxxxxxx>; maria-discuss@xxxxxxxxxxxxxxxxxxx
Betreff: Re: [Maria-discuss] MariaDbConnector 1.x -> 2.6, problem updating/inserting Torque objects
Hi, could you create a JIRA issue for that on https://jira.mariadb.org/browse/CONJ ?
JDBC state that https://docs.oracle.com/en/java/javase/11/docs/api/java.sql/java/sql/ResultSetMetaData.html#isReadOnly(int) Indicates whether the designated column is definitely not writable.
Driver indicate that resultset not an updatable resultset. Feel more like a bug
Correction on "internal" classes is not a solution.
On Tue, Jul 21, 2020 at 3:52 PM Clemens Wyss - MySign AG <clemens.wyss@xxxxxxxxx<mailto:clemens.wyss@xxxxxxxxx>> wrote:
Hi Eric,
first of all: thx for the ultra fast reply
> configuration variable
we've got the options "at hand". Hence we could add "enforceUpdatableResultSet" (per default false) to Options and then
> new MariaDbResultSetMetaData(columnsInformation, options, forceAlias, options.enforceUpdatableResultSet )
Still feels like a very "localized solution"
-----Ursprüngliche Nachricht-----
Von: Eric Herman <eric.herman@xxxxxxxxx<mailto:eric.herman@xxxxxxxxx>>
Gesendet: Dienstag, 21. Juli 2020 07:43
An: Clemens Wyss - MySign AG <clemens.wyss@xxxxxxxxx<mailto:clemens.wyss@xxxxxxxxx>>; maria-discuss@xxxxxxxxxxxxxxxxxxx<mailto:maria-discuss@xxxxxxxxxxxxxxxxxxx>
Betreff: Re: [Maria-discuss] MariaDbConnector 1.x -> 2.6, problem updating/inserting Torque objects
On 7/21/20 6:39 AM, Clemens Wyss - MySign AG wrote:
> I could patch org.mariadb.jdbc.internal.com<http://org.mariadb.jdbc.internal.com>.read.resultset.
> SelectResultSet# getMetaData to return
>> new MariaDbResultSetMetaData(columnsInformation, options, forceAlias,
>> false )
> instead of
>> new MariaDbResultSetMetaData(columnsInformation, options, forceAlias,
>> true )
> but that doesn't really feel "right" 😉
I agree, that doesn't feel "right" ... yet, a patch could be a reasonable short-term work-around, until a better solution becomes apparent.
I would recommend patching such that the boolean value is pulled from a configuration variable if present, otherwise defaults to the current value. In this way, your patch may even be something which you could contribute, as it may turn out to be useful for others.
--
Eric Herman
mobile:+31 620719662 skype:eric_herman jabber:eric.herman@xxxxxxxxx<mailto:jabber%3Aeric.herman@xxxxxxxxx>
_______________________________________________
Mailing list: https://launchpad.net/~maria-discuss
Post to : maria-discuss@xxxxxxxxxxxxxxxxxxx<mailto:maria-discuss@xxxxxxxxxxxxxxxxxxx>
Unsubscribe : https://launchpad.net/~maria-discuss
More help : https://help.launchpad.net/ListHelp
--
Diego Dupin,
Connector team
References
