Java中的MariaDB动态列集成 [英] MariaDB Dynamic Columns integration in Java

问题描述

我正在研究有关将MariaDB动态列概念与Java集成的概念证明。所以问题是该列将在BLOB中，数据将存储在键值对中。目前，当从数据库返回字节[]时，没有任何JSON对象格式或任何分隔符。所以很难解析数据并找到一个密钥的值。这可以使用Java中的Native查询完成。但是如何使用JPA / Hibernate检索数据，还是会支持动态列？
Thanks Advance in。

I am working on Proof of concept regarding the integration of MariaDB Dynamic column concept with Java. So the problem is the column will be in BLOB and the data will be stored in key - value pairs. Currently when byte[] is returned from the database doesnot have any JSON object format or any separators. So its very hard to parse the data and find the value for a key. This can be done using Native queries in Java. But how to retrieve data using JPA/Hibernate or will they support Dynamic columns? Thanks in Advance.

推荐答案

您是否试图以COLUMN_JSON（dyncol）检索数据？在这里阅读更多关于它的信息： https://mariadb.com/kb/en/mariadb/column_json/

Have you tried to retrieve the data as COLUMN_JSON(dyncol)? Read more about it here: https://mariadb.com/kb/en/mariadb/column_json/

这篇关于Java中的MariaDB动态列集成的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！