Hi all,
I'm testing my code either with jackrabbit 2.x on mariadb or oak on mongodb,
both with filedatastore.
I've found executing benchmarks that oak with mongo is really slow compared to
jackrabbit, so I wanted test oak with mariadb, I'm not able to do it working,
when I try I see in logs:
2024.09.29 17:31:27.293 - *ERROR* [main] o.a.j.o.p.d.rdb.RDBDocumentStoreDB: DB
type MariaDB unknown, trying default settings (getValue in
RDBDocumentStoreDB.java, line 903)
2024.09.29 17:32:30.450 - *ERROR* [main] o.a.j.o.p.d.rdb.RDBDocumentStore:
Unknown database type: MariaDB (initialize in RDBDocumentStore.java, line 1044)
As jdbc url I use:
<connectionURL>jdbc:mariadb://localhost:3306/arpav</connectionURL>
<driver>org.mariadb.jdbc.Driver</driver>
and mariadb-java-client as jdbc driver and RDBDocumentNodeStoreBuilder in this
way:
HikariDataSource ds = new HikariDataSource();
ds.setMaximumPoolSize(20);
ds.setDriverClassName(storagePersistenceDriver);
ds.setJdbcUrl(storagePersistenceConnectionURL);
ds.addDataSourceProperty("user", storagePersistenceUsername);
ds.addDataSourceProperty("password", storagePersistencePassword);
ds.setAutoCommit(false);
RDBDocumentNodeStoreBuilder rdbnsb = new RDBDocumentNodeStoreBuilder();
rdbnsb.setRDBConnection(ds);
but the main issues start during table creation... I'm using "CHARACTER SET
utf8mb4 COLLATE utf8mb4_unicode_ci" as suggested here
https://jackrabbit.apache.org/oak/docs/nodestore/document/rdb-document-store.html
2024.09.29 17:51:35.549 - *WARN * [main] o.m.jdbc.message.server.ErrorPacket:
Error: 1074-42000: Column length too big for column 'DATA' (max = 16383); use
BLOB or TEXT instead (warn in Slf4JLogger.java, line 99)
2024.09.29 17:51:35.549 - *ERROR* [main] o.a.j.o.p.d.rdb.RDBDocumentStore:
Failed to create table 'CLUSTERNODES' in 'MariaDB - using default settings
(jdbc:mariadb://localhost/default_tenant?user=default_tenant&password=***)'
(createTableFor in RDBDocumentStore.java, line 1401)
java.sql.SQLSyntaxErrorException: (conn=4) Column length too big for column
'DATA' (max = 16383); use BLOB or TEXT instead
at
org.mariadb.jdbc.export.ExceptionFactory.createException(ExceptionFactory.java:289)
at org.mariadb.jdbc.export.ExceptionFactory.create(ExceptionFactory.java:378)
at org.mariadb.jdbc.message.ClientMessage.readPacket(ClientMessage.java:172)
at
org.mariadb.jdbc.client.impl.StandardClient.readPacket(StandardClient.java:915)
at
org.mariadb.jdbc.client.impl.StandardClient.readResults(StandardClient.java:854)
at
org.mariadb.jdbc.client.impl.StandardClient.readResponse(StandardClient.java:773)
at org.mariadb.jdbc.client.impl.StandardClient.execute(StandardClient.java:697)
at org.mariadb.jdbc.Statement.executeInternal(Statement.java:1035)
Have you some hint in using MariaDb?
I've tried specifying jdbcurl MySql style but the driver of mariadb rejects it.
Thanks
Cordiali saluti / Best regards,
Raffaele Gambelli
Senior Java Developer
E [email protected]<mailto:[email protected]>
[CEGEKA] Via Ettore Cristoni, 84
IT-40033 Bologna (IT),Italy
T +39 02 2544271
WWW.CEGEKA.COM<https://www.cegeka.com>
[https://2655225.fs1.hubspotusercontent-na1.net/hubfs/2655225/0.0%20Cegeka%20(new)/1.%20Visuals/Email%20Signatures/Annual_Report_Visuals_2023_Email%20Banner%201.png]<https://www.cegeka.com/it/annual-report-2023?utm_campaign=[EN]%20-%20Annual%20Report%202023&utm_source=email%20signature%20banner&utm_medium=email%20signature%20banner%20annual%20report%202023>
Dichiarazione di Riservatezza
Le informazioni contenute nella mail sono riservate. Se si rende conto di non
essere il destinatario corretto della mail, la preghiamo di segnalare l'errore
al mittente e di cancellare immediatamente il messaggio. L’utilizzo improprio
di informazioni riservate può comportare sanzioni.
Protezione dei dati personali
La informiamo che i suoi dati saranno trattati da Cegeka nel rispetto delle
disposizioni di legge applicabili (D. Lgs 196/2003 e Regolamento UE 679/2016).
Per maggiori dettagli può consultare le nostre informative privacy al link
https://www.cegeka.com/it/informazioni-sulla-privacy.<https://www.cegeka.com/it/informazioni-sulla-privacy>
