[Date Prev][Date Next]   [Thread Prev][Thread Next]   [Thread Index] [Date Index] [Author Index]

how to allow database connexion




Hello all of you;

I have problem with glassfish application,
I want to push glassfish application to openshift origin

my default setup./glassfish-resources.xml is
 
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE resources PUBLIC "-//GlassFish.org//DTD GlassFish Application Server 3.1 Resource Definitions//EN" "http://glassfish.org/dtds/glassfish-resources_1_5.dtd">
<resources>
    <jdbc-connection-pool allow-non-component-callers="false" associate-with-thread="false" connection-creation-retry-attempts="0" connection-creation-retry-interval-in-seconds="10" connection-leak-reclaim="false" connection-leak-timeout-in-seconds="0" connection-validation-method="auto-commit" datasource-classname="com.mysql.jdbc.jdbc2.optional.MysqlDataSource" fail-all-connections="false" idle-timeout-in-seconds="300" is-connection-validation-required="false" is-isolation-level-guaranteed="true" lazy-connection-association="false" lazy-connection-enlistment="false" match-connections="false" max-connection-usage-count="0" max-pool-size="32" max-wait-time-in-millis="60000" name="mysql_tracking_rootPool" non-transactional-connections="false" pool-resize-quantity="2" res-type="javax.sql.DataSource" statement-timeout-in-seconds="-1" steady-pool-size="8" validate-atmost-once-period-in-seconds="0" wrap-jdbc-objects="false">

      
 <property name="serverName" value="localhost"/>
        <property name="portNumber" value="3306"/>
        <property name="databaseName" value="tracking"/>
        <property name="User" value="root"/>
        <property name="Password" value="privat"/>
        <property name="URL" value="jdbc:mysql://localhost:3306/tracking?zeroDateTimeBehavior=convertToNull"/>
        <property name="driverClass" value="com.mysql.jdbc.Driver"/>


openshift mysql information are:

OPENSHIFT_MYSQL_DIR=/var/lib/openshift/54381c1c653e8ad768000075/mysql/
OPENSHIFT_MYSQL_DB_PORT=3306
OPENSHIFT_MYSQL_DB_HOST=127.4.76.130
OPENSHIFT_MYSQL_DB_PASSWORD=8676Ijyf_u3y
OPENSHIFT_MYSQL_IDENT=redhat:mysql:5.5:0.2.15
OPENSHIFT_MYSQL_DB_USERNAME=adminEcVHhGk
OPENSHIFT_MYSQL_DB_SOCKET=/var/lib/openshift/54381c1c653e8ad768000075/mysql//socket/mysql.sock
OPENSHIFT_MYSQL_DB_URL=mysql://adminEcVHhGk:8676Ijyf_u3y 127 4 76 130:3306/
OPENSHIFT_MYSQL_DB_LOG_DIR=/var/lib/openshift/54381c1c653e8ad768000075/app-root/logs/
OPENSHIFT_MYSQL_LD_LIBRARY_PATH_ELEMENT=/opt/rh/mysql55/root/usr/lib64


mysql-5.5 (MySQL 5.5)
  ---------------------
    Gears:          Located with diy-0.1
    Connection URL: mysql://$OPENSHIFT_MYSQL_DB_HOST:$OPENSHIFT_MYSQL_DB_PORT/
    Database Name:  glassfish
    Password:       8676Ijyf_u3y
    Username:       adminEcVHhGk



how can i do to allow my application to have acces into database of openshift origin

i have try to have acces to openshift mysql with mysql-workbeanch and it was success
with the following information






[Date Prev][Date Next]   [Thread Prev][Thread Next]   [Thread Index] [Date Index] [Author Index]