对H2以外的数据库的H2控制台访问 [英] H2 console access for databases other than h2

问题描述

H2控制台( http://localhost:8082/login.jsp )可以选择查看任何数据库的详细信息，如果我们有与mysql或其他数据库服务器的tp对话，我们应该在哪里复制jdbc驱动程序.在bin目录下复制jdbc驱动程序文件(mysql-connector-java-5.0.8-bin.jar)似乎没有帮助

H2 console (http://localhost:8082/login.jsp) has the option to look at details of any database, where should we copy the jdbc driver if we have tp talk to the mysql or other database servers. Copying the jdbc driver file (mysql-connector-java-5.0.8-bin.jar) under bin directory didn't seem to help

注意:我的H2服务器正在作为服务运行

Note: My H2 server is running as a service

推荐答案

要使用其他数据库(例如MySQL)，必须先将这些数据库的JDBC驱动程序的位置添加到环境变量H2DRIVERS或CLASSPATH中，然后再安装服务.可以设置多个驱动程序；每个条目需要用分隔; (Windows)或:(其他操作系统).支持路径名称中的空格.不得引用设置.

To use other databases (for example MySQL), the location of the JDBC drivers of those databases need to be added to the environment variables H2DRIVERS or CLASSPATH before installing the service. Multiple drivers can be set; each entry needs to be separated with a ; (Windows) or : (other operating systems). Spaces in the path names are supported. The settings must not be quoted.

这篇关于对H2以外的数据库的H2控制台访问的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！