mariadb vs. mysql (from the JDBCPlugin point of view)
mariadb vs. mysql (from the JDBCPlugin point of view)
- Subject: mariadb vs. mysql (from the JDBCPlugin point of view)
- From: René Bock via Webobjects-dev <email@hidden>
- Date: Thu, 2 Feb 2023 13:43:14 +0000
- Arc-authentication-results: i=1; mx.microsoft.com 1; spf=pass smtp.mailfrom=salient-doremus.de; dmarc=pass action=none header.from=salient-doremus.de; dkim=pass header.d=salient-doremus.de; 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-AntiSpam-MessageData-ChunkCount:X-MS-Exchange-AntiSpam-MessageData-0:X-MS-Exchange-AntiSpam-MessageData-1; bh=YNoPU2xXHA0qcr0W3QDX5HBppmYfl7hZZBm497JpIkc=; b=SjHiDBvxbWxWDX6UN0RU5EGkx4E5VhrWODxkV8jruuwh7gYHldEjTnpUkGRnrpO6+yBtJZvP173h1nUUQ6FzlDtPezVSUz7zY9KJwl8XFtQ+0143qWcY8DBFd/M+c6vtyZqnE+NJI5+bRte+6YWhxVEfOK4fa78BXC6gPt6e39XtbMpd7yQx7XurmxCS7U8jYtk/XW2WheO29qqUWsMG3CcoYD0bh27fDCT1ELUNRokdxNV1e8K1C1lYPKrxyR9gLqQSUktVSH4OETtNs8i7Uldarj6EiXVM/UnTma0bCjkMWyhqrCeEPf2QNh+mXNt8C6iuOvVUTjM8I4mQscy0uw==
- Arc-seal: i=1; a=rsa-sha256; s=arcselector9901; d=microsoft.com; cv=none; b=YpYHzni4q0SwQ85p7hApE4vegy706P9fVQWOrGvb0JeKf8geXmJ2capUIv5KNJ+uQOyqNWO3ImVhKEqs2kVot0GX96tfhgLhZer9tzIbW8A9ELyi10ns2rRr93g6jaE2YwOBSydKgxsL+LJMW8dRDFhcPCPmRh5DwwJREfV585BsOK33R2Nf7ETSKTRR10vgTIVQDvJYuym+o1Ft3+el+bx8YNtbQJ2tFJtjAF4amGkbt6gg76mTN91/jRxfX8D2Tp1CmCy6+gHirouHOAx+80ezhh/bcvAmwFMcv+cm5p+s0uxDRNEOYiOEMtsfL7JTwtx99uD8WGUazZpNuHB2Lw==
- Thread-topic: mariadb vs. mysql (from the JDBCPlugin point of view)
Hi,
Is anybody using the MySQLAdaptor against a mariadb?
Basically, using the MySQLAdaptor + mysql-connector-java jdbc connector ->
mariadb works fine.
Except, when we upgrade the mysql-connector-java from version 5.1.6 to modern
version 8.0.28, we get the nasty
> Invocations of setNanos() are illegal.
> java.lang.IllegalStateException: com.webobjects.foundation.NSTimestamp is an
> immutable object. Invocations of setNanos() are illegal.
exceptions.
Using the sendFractionalSeconds=false parameter in the connections string
works only for real MySql-Database, not for a mariadb :-(
My current approach is, to enhance the MySQLPlugIn to be used along with both
mysql-connector-java and mariadb-java-client jdbc connectors.
The changes are basically:
* set _MySQLPlugIn.DriverClassName = null (as since JDBC 4.0 the driver class
is no longer needed to open a jdbc connection.)
* also register the _MySQLPlugIn for the mariadb subprotocol
Does this sound reasonable?
Regards
René
--
Phone: +49 69 650096 18
salient GmbH // Lindleystraße 12 // 60314 Frankfurt
Amtsgericht Frankfurt am Main // salient GmbH HRB 48693
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden