hmm, when i used OpenShift i had (i was using trunk):
<Resource id="jdbc/app">
JdbcDriver com.mysql.jdbc.Driver
JdbcUrl jdbc:mysql://${OPENSHIFT_MYSQL_DB_HOST}:${OPENSHIFT_
MYSQL_DB_PORT}/${OPENSHIFT_MYSQL_DB_USERNAME}
UserName ${OPENSHIFT_MYSQL_DB_USERNAME}
Password ${OPENSHIFT_MYSQL_DB_PASSWORD}
</Resource>
*Romain Manni-Bucau*
*Twitter: @rmannibucau <https://twitter.com/rmannibucau>*
*Blog: **http://rmannibucau.wordpress.com/*<http://rmannibucau.wordpress.com/>
*LinkedIn: **http://fr.linkedin.com/in/rmannibucau*
*Github: https://github.com/rmannibucau*
2013/7/11 mauro2java2011 <[email protected]>
> hi all .
> I have to set int othe WEB-INF/resources.xml a datasource .
>
> i have deployes tomee into openshift cloud .
>
> But my problem is not a openshift problem.
> from openshift i can get the following values from variables environments :
>
> OPENSHIFT_MYSQL_DB_HOST
> OPENSHIFT_MYSQL_DB_PORT
> OPENSHIFT_MYSQL_DB_USERNAME
> OPENSHIFT_MYSQL_DB_PASSWORD
>
> --------
> now i would create a system properties at tomee startup or web application
> startup for get the properties into my resources.xml (I WOULD SET SYSTEM
> PROPERTIES FROM READ THE VARIABLES ENVIRONMENTS THAT I CAN GET FROM
> OPENSHIFT.)
>
>
> I would to set:
> mydbmysql.host=$OPENSHIFT_MYSQL_DB_HOST
> mydbmysql.port=$OPENSHIFT_MYSQL_DB_PORT
> mydbmysql.username=$OPENSHIFT_MYSQL_DB_USERNAME
> mydbmysql.password=$OPENSHIFT_MYSQL_DB_PASSWORD
>
> i not know if i have to set into catalina.sh or setenv.bat.
> or with JAVA_OPTS=..........
>
> but what is it the syintax correct??
>
> from resources.xml i would declare:
>
> <Resource id="MySQL Database" type="DataSource">
> # MySQL example
> #
> # This connector will not work until you download the driver at:
> # http://www.mysql.com/downloads/api-jdbc-stable.html
>
> JdbcDriver com.mysql.jdbc.Driver
> JdbcUrl jdbc:mysql://${mydbmysql.host}/test
> UserName ${mydbmysql.username}
> Password ${mydbmysql.password}
> </Resource>
>
> or i can get the values direct from variables environments????????
>
> 2) how i can add variables environments at TOMEE startup? a esample for
> add
> a variable ?????
> for example : i would add a variable environment named $MYMESSAGE=Hi to all
> user of TOMEE
> how i can declare for TOMEE ?
> tank you very much
> Mauro
>
>
>
>
>
> --
> View this message in context:
> http://openejb.979440.n4.nabble.com/how-set-system-properties-for-datasource-into-resources-xml-from-variables-environments-tp4664217.html
> Sent from the OpenEJB User mailing list archive at Nabble.com.
>
