SQLSyntaxErrorException: Unknown column <columnName> in field list

MariaDB does not support sequences, hence what exactly should the schema attribute be used by Hibernate in this case? Again, you should use the catalog attribute instead.

I did not find anything in the docs specifying removal of support for mariadb in schema attribute.

But the MariaDB documentation explains that a SCHEMA is practically a CATALOG. However, it does not support the CATALOG → SCHEMA → STRUCTURE.

Default database and main database.
schema1 is populated by another application which is our default database(Used in Table schema).
schema2 is managed by our application and is our main database(Used in Secondary Table schema).

Again, you are not creating schemas, but catalogs or databases.