Hi
maybe try: JdbcUrl = ${OPENSHIFT_MYSQL_DB_URL}
Romain Manni-Bucau
@rmannibucau
http://www.tomitribe.com
http://rmannibucau.wordpress.com
https://github.com/rmannibucau
2014-11-20 12:34 GMT+01:00 mauro2java2011 <[email protected]>:
>
>
> i have tried to wirte a tomee application that use tomee on openshift and
> mysql .
>
> but i get :
>
> Caused by:
> com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Cannot
> load connection class because of underlying exception:
> 'java.lang.NumberFormatException: For input string:
> "${OPENSHIFT_MYSQL_DB_PORT}"'.
> at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native
> Method)
> at
> sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
> at
> sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
> at java.lang.reflect.Constructor.newInstance(Constructor.java:526)
> at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
> at com.mysql.jdbc.Util.getInstance(Util.java:386)
> at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1013)
> at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:987)
> at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:982)
> at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:927)
> at
> com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:314)
> at
> org.apache.tomcat.jdbc.pool.PooledConnection.connectUsingDriver(PooledConnection.java:278)
> at
> org.apache.tomcat.jdbc.pool.PooledConnection.connect(PooledConnection.java:182)
> at
> org.apache.tomcat.jdbc.pool.ConnectionPool.createConnection(ConnectionPool.java:702)
> at
> org.apache.tomcat.jdbc.pool.ConnectionPool.borrowConnection(ConnectionPool.java:634)
> at
> org.apache.tomcat.jdbc.pool.ConnectionPool.getConnection(ConnectionPool.java:188)
> at
> org.apache.tomcat.jdbc.pool.DataSourceProxy.getConnection(DataSourceProxy.java:128)
> at
> org.apache.tomee.jdbc.TomEEDataSourceCreator$TomEEDataSource.getConnection(TomEEDataSourceCreator.java:251)
> at
> org.apache.openejb.resource.jdbc.managed.local.ManagedDataSource.getConnection(ManagedDataSource.java:43)
> at
> org.apache.openjpa.lib.jdbc.DelegatingDataSource.getConnection(DelegatingDataSource.java:110)
> at
> org.apache.openjpa.lib.jdbc.DecoratingDataSource.getConnection(DecoratingDataSource.java:87)
> at
> org.apache.openjpa.jdbc.sql.DBDictionaryFactory.newDBDictionary(DBDictionaryFactory.java:91)
> ... 104 more
> Caused by: java.lang.NumberFormatException: For input string:
> "${OPENSHIFT_MYSQL_DB_PORT}"
> at
> java.lang.NumberFormatException.forInputString(NumberFormatException.java:65)
> at java.lang.Integer.parseInt(Integer.java:481)
> at java.lang.Integer.parseInt(Integer.java:527)
> at
> com.mysql.jdbc.NonRegisteringDriver.port(NonRegisteringDriver.java:831)
> at
> com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:305)
> ... 115 more
> -------------------------------------------------------------------
>
> The resource.xml file contains:
>
>
> <?xml version="1.0" encoding="UTF-8"?>
>
> <resources>
> <Resource id="db/web" type="javax.sql.DataSource">
> UserName = ${OPENSHIFT_MYSQL_DB_USERNAME}
> Password = ${OPENSHIFT_MYSQL_DB_PASSWORD}
> JdbcUrl =
> jdbc:mysql://${OPENSHIFT_MYSQL_DB_HOST}:${OPENSHIFT_MYSQL_DB_PORT}/${OPENSHIFT_APP_NAME}
> JdbcDriver = com.mysql.jdbc.Driver
> JtaManaged = true
>
> </Resource>
>
> <Resource id="db/web_unmanaged" type="javax.sql.DataSource">
> UserName = ${OPENSHIFT_MYSQL_DB_USERNAME}
> Password = ${OPENSHIFT_MYSQL_DB_PASSWORD}
> JdbcUrl =
> jdbc:mysql://${OPENSHIFT_MYSQL_DB_HOST}:${OPENSHIFT_MYSQL_DB_PORT}/${OPENSHIFT_APP_NAME}
> JdbcDriver = com.mysql.jdbc.Driver
> JtaManaged = false
>
> </Resource>
> </resources>
>
>
>
> ------------------------------------
> the file persistence.xml contain:
>
> <?xml version="1.0" encoding="UTF-8"?>
> <persistence version="2.0" xmlns="http://java.sun.com/xml/ns/persistence";
> xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance";
> xsi:schemaLocation="http://java.sun.com/xml/ns/persistence
> http://java.sun.com/xml/ns/persistence/persistence_2_0.xsd";>
> <persistence-unit name="TestDBMysqlTOMEEOpenshiftPU"
> transaction-type="JTA">
>
> <provider>org.apache.openjpa.persistence.PersistenceProviderImpl</provider>
> <jta-data-source>db/web</jta-data-source>
> <non-jta-data-source>db/web_unmanaged</non-jta-data-source>
> <exclude-unlisted-classes>false</exclude-unlisted-classes>
> <properties>
> <property name="openjpa.jdbc.SynchronizeMappings"
> value="buildSchema(ForeignKeys=true)"/>
> </properties>
> </persistence-unit>
> </persistence>
>
> ----------------------------------------------------------------------------
> whi it not reaead the myslq port from environment variable of openshift ?
>
> Caused by:
> com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Cannot
> load connection class because of underlying exception:
> 'java.lang.NumberFormatException: For input string:
> "${OPENSHIFT_MYSQL_DB_PORT}"'.
>
>
> i have to se t the dialect int opersistence.xml?
>
>
>
>
> --
> View this message in context:
> http://tomee-openejb.979440.n4.nabble.com/datasource-mysql-not-work-at-openshift-tomee-diy-tp4672950.html
> Sent from the TomEE Users mailing list archive at Nabble.com.
