Comments - About MariaDB Connector/J
Content reproduced on this site is the property of its respective owners,
and this content is not reviewed in advance by MariaDB. The views, information and opinions
expressed by this content do not necessarily represent those of MariaDB or any other party.
I built an application for productivity that interfaces MySQL and MS-SQL. Drivers from MySQL and Microsoft are used and work fine. User can switch between MySQL and MS-SQL if he chooses to. Today I am in the process of adding MariaDB to the list of databases. I downloaded 2 clients from MariaDB: "mariadb-java-client-1.1.3.jar and mariadb-java-1.1.7.jar". I could not connect with either one to mySQL database. The drivers were placed in my java JRE directory like the mySQL driver.
Database used: MySQL, Vesion:4.0.21.-nt-max-log
Currently using: MySQL-AB JDBC Driver Version: mysql-connector-java-3.1.14 ($Date:2006-10-18 17:40:15 +0200 (Wed, 18 Oct 2006)$,$Revision:5888$)
That driver was not tested with server version 4.0 (nor 4.1 nor 5.0) an is not likely to work with any server version for which lifecycle support ended . MySQL Sever 4.0 is out of support maybe for 7 or 8 years something like that.
Thank you for commenting. Yes I had MSQL Server 4.0 running for at least 12 yrs on an XP-machine, and few years before that on a Window 2000. I will download a newer version to continue development on my application. I have a question about the MariaDB Client. When I run my application, I see that MariaDB client that I put in my Java JRE directory already loaded. It does not happen with MySQL driver that I have been using. So the question is: does MariaDB clients have a feature that Java recognizes and loads the Client automatically?
Yes, autoregistration is part of JDBC 4.0, which came wiith Java 6 , in 2006 The connector/j driver you are using is probably quite old if it does not have this feature.
The exception I have is "java.nio.BufferUnderflowException"
Yeah, in the long past the packet server sent was on new connection was shorter according. So underflow exception can be explained.
Thank you.