Java 支持多少种 DBMS，哪一种最适合存储 XML？
我正在使用 Jsbs，希望为需要本机 XML 数据库的应用程序选择一个 DBMS。你们能指导我吗？
1) Java 支持多少种 DBMS（几乎所有 DBMS 都是 Java 支持的吗？）
2) 哪一种是 XML 存储和检索的最佳选择？
提前致谢。
I am working with Jsbs and want to select a DBMS for my application that require a native XML database. Can you people guide me?
1) how many DBMS are supported by Java (is it true almost all DBMS are supported by java?)
2) Which one will be the best selection for XML storage and retrieval?
Thanks in advance.
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（4）
这里是 JDBC 驱动程序及其适用的数据库的列表。可能每个数据库都有一个 JDBC 驱动程序。
至于是否支持 XML，这取决于您是否希望能够针对 XML 进行查询。大多数现代 DBMS 在某种程度上都支持 XML。您是否有已经在使用或建议您使用的产品？
Here is a list of JDBC Drivers and the DBs they work for. Probably every database out there has a JDBC driver.
As far as supporting XML it depends if you want to be able to do queries against the XML or not. Most modern DBMSs support XML to some degree. Do you have one you are already using, or that you are recommended to use ?
1) 是的，所有主要 DBMS（Oracle、MySQL、Postgres、DB2...）都有 JDBC 驱动程序，还有一些有趣的 Java DBMS，如 HSQL
2) 据我所知 Oracle、DB2、PostgreSQL（可能还有 MySQL）全部都有 XML 列类型
1) Yes, there are JDBC drivers for all the major DBMS (Oracle, MySQL, Postgres, DB2...) and also some interesting java DBMS like HSQL
2) As far as I know Oracle, DB2, PostgreSQL (and probably MySQL) all have XML column types
对我来说，除了支持 Blob 或 Clob 之外，还需要其他任何东西来实现简单的 XML 存储和检索，这一点并不明显。仅当您需要对 XML 中包含的数据执行查询时，才需要特殊的 XML 支持。
您所说的是“支持 XML”的 RDBMS。根据您的实际要求，您可能还需要查看原生 XML 数据库 (NXD)。甚至还有一个用于查询 NXD 的标准 Java API (XQJ)，尽管并非所有供应商都支持它。
It is not obvious to me that you need anything more than support for Blobs or Clobs to implement simple XML storage and retrieval. You'd only need special XML support if you needed to perform queries against the data contained in the XML.
What you are talking about is an "XML enabled" RDBMS. Depending on your actual requirements, you may also want to look into native XML databases (NXDs). There is even a standard Java API (XQJ) for querying NXDs, though not all vendors support it.
大多数现代数据库都有 JDBC 驱动程序，这是 Java 程序连接到数据库所需的。您通常需要不依赖于本机代码的类型 4 驱动程序。
首先，我会推荐 Apache Derby，它是用 Java 编写的，可以成为程序的一部分，从而保持简单。 http://db.apache.org/derby/。如果您后来发现需要另一个数据库，您可以替换 JDBC 驱动程序，并仔细检查您的 SQL 语句。
Most modern databases have JDBC-drivers, which is what is needed for Java programs to connect to the database. You generally want type 4 drivers which do not depend on native code.
For starting I would recommend Apache Derby, which is written in Java and can be part of your program, which keeps it simple. http://db.apache.org/derby/. If you later find you need another database you replace the JDBC-driver, and double-check your SQL-statements.