我如何在hibernate.cfg.xml中使用openshift环境变量 [英] how can i using openshift environment variables in hibernate.cfg.xml

问题描述

在hibernate.cfg.xml中

使用Hibernate时OpenShift ：

 < property name =connection.url> jdbc：mysql：//10.143.140.62：52016 / yoodp< ; /性> 
  

有用。

但是当我使用：

 < property name =connection.url> jdbc：mysql：// $ {env.OPENSHIFT_MYSQL_DB_HOST} ：$ {env.OPENSHIFT_MYSQL_DB_PORT} / $ {ENV .OPENSHIFT_APP_NAME}< /性> 
  

或

 < property name =connection.url> jdbc：mysql：// $ {OPENSHIFT_MYSQL_DB_HOST}：$ {OPENSHIFT_MYSQL_DB_PORT} / $ {OPENSHIFT_APP_NAME}< / property> 
  

无效。

如何解决它？

解决方案

我猜你正在使用Openshift Tomcat，因此只需连接到MySQL数据库使用已为您定义的数据源。

JNDI数据源名为jdbc / MySQLDS，您可以在hibernate中使用connection.datasource属性。

https://help.openshift.com/hc/en-us/articles/202399720-How-to-use-the-预配置-MySQLDS-and-PostgreSQLDS-data-sources-in-the-Java-cartridge

I am using Hibernate on OpenShift now.

In hibernate.cfg.xml

When I use:

<property name="connection.url">jdbc:mysql://10.143.140.62:52016/yoodp</property>

It works.

But when I use:

<property name="connection.url">jdbc:mysql://${env.OPENSHIFT_MYSQL_DB_HOST}:${env.OPENSHIFT_MYSQL_DB_PORT}/${env‌​.OPENSHIFT_APP_NAME}</property>

or

<property name="connection.url">jdbc:mysql://${OPENSHIFT_MYSQL_DB_HOST}:${OPENSHIFT_MYSQL_DB_PORT}/${OPENSHIFT_APP_NAME}</property>

It doesn't work.

How can I fix it?

解决方案

I'm guessing you're using Openshift Tomcat, so to connect to your MySQL database simply use the datasource that is already defined for you.

The JNDI datasource is named jdbc/MySQLDS and you use it in hibernate with the connection.datasource property.

https://help.openshift.com/hc/en-us/articles/202399720-How-to-use-the-pre-configured-MySQLDS-and-PostgreSQLDS-data-sources-in-the-Java-cartridges

这篇关于我如何在hibernate.cfg.xml中使用openshift环境变量的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！