Stack Overflow
Stack Overflow

Questions tagged [mariadb-connect-engine]

A MariaDB storage engine for connecting to other databases / data sources (Binary, JSON, SQLite, etc.)

42 questions
0
votes
0 answers

Mock a MariaDB Socket connection for test purposes

I have been looking for a way to mock a MariaDB connection for test purposes. The code I need to test opens a connection to a MariaDB server through unix socket. All along the code, it updates rows. The behavior I want to test has nothing to do with…
Mathis Germa
  • 103
  • 1
  • 7
0
votes
0 answers

Unable to connect with MariaDB using Java

I am trying to connect with My company's database which is 'MariaDB', using Java, I am using following code: package co.companyname.helpers; import java.sql.*; public class DatabaseConnectivity { public static void main(String[] args) { …
Taimoor Pasha
  • 192
  • 2
  • 3
  • 16
0
votes
1 answer

Unable to create partition on Mariadb on this child table where Foreign Key Exists?

Unable to create partition this child table "city" with parent table "country" It is showing below error "Foreign Key Not Supported". Without foreign key how relation maintain ForeignKey not supported by partition] [2]…
Sheikh Wasiu Al Hasib
  • 450
  • 5
  • 18
0
votes
0 answers

Python add .tar.gz file to library

New mariaDB-Version as download available. But: I have downloaded this [https://mariadb.com/downloads/connectors/] mariadb-connector-c-3.2.4-ubuntu-focal-amd64.tar.gz. Unfortunately, it's a .tar.gz. I have no idea how to insert it into the Python…
Intaxa Entwickler
  • 31
  • 1
  • 4
0
votes
2 answers

how to disable the ODBC connection wizard

I use ADO connectionstring to MariaDB in dBase and when the connection is unsuccessful (invalid userid, pwd, port number, IP address, databasename or if the server is not running), I get the MariaDB datasource connector wizard. Once I cancel or…
Gaetano De Luisi
  • 51
  • 6
0
votes
2 answers

How to use MariaDB Connector/J with Pyspark for JDBC?

I'm using Pyspark Spark 3.0.1 on Ubuntu 18.04 and want to export data to a MariaDB server using JDBC. I'm specifying the Connector/J jar on the pyspark command line like this: $ pyspark --jars /usr/share/java/mariadb-java-client.jar However, when I…
zachfrey
  • 63
  • 8
0
votes
1 answer

Java - MariaDB Perfoming slow with Hibernate criteria

Environment: mariadb-java-client-2.7.0 DB : MariaDB 10.5.7 ojdbc8 - Oracle 11.2.0.3.0 JDBC 4.0 DB : Oracle Database 11g Hibernate 4.3.8 Code : Session session = sessionFactory.openSession(); Criteria fetchCriteria =…
Developer
  • 150
  • 2
  • 12
0
votes
0 answers

Login Timeout Expired Error when connecting from MariaDB to MSSQL using CONNECT engine and unixODBC

I am on Mariadb 10.4.13 and am trying to pull data from an MSSQL 2016 standard edition server. I downloaded and installed unixODBC and configured the CONNECT engine plugin using the instructions on -…
Murali
  • 351
  • 1
  • 6
  • 10
0
votes
1 answer

How to troubleshoot this MariaDB error? => ERROR 1296 (HY000): Got error 122 'Cannot retrieve error message' from CONNECT

Anyone knows how I can troubleshoot below MariaDB CONNECT storage engine error? ERROR 1296 (HY000): Got error 122 'Cannot retrieve error message' from CONNECT Above error occurs if I select from a JDBC external table after using CONNECT engine…
Chan Kar Heng
  • 1
0
votes
0 answers

MariaDB: SELECT INSERT from ODBC CONNECT engine from SQL Server keeps causing "error code 1406 data too long"

Objective: Using MariaDB I want to read some data from MS SQL Server (via ODBC Connect engine) and SELECT INSERT it into a local table. Issue: I keep geting "error code 1406 data too long" even if source and destination varchar fields have the very…
Simone Avogadro
  • 789
  • 8
  • 23
0
votes
0 answers

How to query millions of JSON objects in multiple files with MariaDb CONNECT Engine without crash?

Assume I have a collection of .json files in a folder, each of which represents exactly one book, i.e. Book 1 in folder/1.json Book 2 in folder/2.json … The files are between only 6kb and 3mb in size each, but there are millions of them! Now I do…
Remirror
  • 692
  • 5
  • 14
0
votes
1 answer

Broken connection with MariaDB

I have a Wildly server connected to MariaDB Server on the same machine. For some reason I get this error from time to time: 20:38:51,536 INFO [stdout] (default task-1) 20:38:51.535 [default task-1] WARN o.h.e.jdbc.spi.SqlExceptionHelper - SQL…
Peter Penzov
  • 1,126
  • 134
  • 430
  • 808
0
votes
1 answer

Connecting to MariaDB from an Android app

Disclaimer: I know people don't typically do this, I am using an SQL database for cost reasons, also I am relatively new to programming. I am trying to send SQL scripts to my MariaDB database from my Android Studio application. I am currently…
user9543690
0
votes
1 answer

How does MariaDB work with maintaining db connection?

I am using Peewee ORM to update and modify database table from my python project. I have set max connection limit to 15 using: set global max_connections = 15 to get total connection I run the command, > select count(*) from …
Ciasto piekarz
  • 7,853
  • 18
  • 101
  • 197
0
votes
2 answers

MariaDB ColumnStore Questions

I have question regarding MariaDB ColumnStore:- Is this free, can use in production system? Is this the extension of Mariadb (prerequisite is MariaDB) or we can install this alone? Can install in single machine in Production, give better…
ankitbeohar90
  • 109
  • 13
1
2
3