CODEWITHSUNDEEP
mysqlopenshift
Wai Hein
Wai Hein

Reputation: 69

Mysql connection URL openshift

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.

Upvotes: 2

Views: 1212

Answers (1)

MartinB
MartinB

Reputation: 231

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.

Upvotes: 2

Related Questions