mariadb-connector-j-usage

MariaDB-specific behavior of MariaDB Connector/J (the org.mariadb.jdbc:mariadb-java-client JDBC driver) for application code — that JDBC 4 auto-registers the driver so Class.forName is unneeded; that the URL scheme is jdbc:mariadb://host:port/db?opts (jdbc:mysql: needs permitMysqlScheme); that useServerPrepStmts defaults to false, so PreparedStatement substitutes parameters client-side; that batched INSERTs use the COM_STMT_BULK protocol by default and getGeneratedKeys() then returns all generated ids, one per row, not a single id; that autocommit defaults to true so transactions need setAutoCommit(false); that setFetchSize(Integer.MIN_VALUE) throws (fetch size must be >= 0); that pooling should use MariaDbPoolDataSource or an external pool; and that failover uses multi-host URLs, not driver code. Use when writing or reviewing Java code that talks to MariaDB with the mariadb-java-client JDBC driver.