Mysql connection URL openshift

Question

How do I see MySql connection URL from openshift? I need it to use it in hibernate.cfg.xml When I log onto my account online I only see the username and password.

MartinB · Accepted Answer · 2014-04-13 20:33:37Z

2

On open shift the database is already available in JNDI. It's name is jdbc/MySQLDS.

To use this 'datasource' in hibernate, your hibernate.cfg.xml should look something like this:

    <!-- Database connection settings -->
    <property name="hibernate.connection.datasource">java:comp/env/jdbc/MySQLDB</property>

    <!-- SQL dialect -->
    <property name="hibernate.dialect">org.hibernate.dialect.MySQLDialect</property>

    <!-- Mapped annotated entity-->
    <mapping class="org.hibernate.tutorial.domain.Event"/>

</session-factory>

To help you even mote please tell us if you are using JbossEWS 1.0, 2.0, JBoss AS6, JBoss EAP. Is your app scale, etcetera.

answered Apr 13, 2014 at 20:33

MartinB

2111 silver badge5 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Wai Hein Over a year ago

I am using JBoss app server 7

Wai Hein Over a year ago

I am new to hibernate too. so for <property name="hibernate.connection.url"> jdbc:mysql://${env.OPENSHIFT_MYSQL_DB_HOST}:${env.OPENSHIFT_MYSQL_DB_PORT}/${env.OPENSHIFT_APP_NAME} </property>

MartinB Over a year ago

No, in stead af using <property name="hibernate.connection.url"> use <property name="hibernate.connection.datasource"> as described above. JBoss already has a datasource set up for your application(s)

Collectives™ on Stack Overflow

Mysql connection URL openshift

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related