You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@tomee.apache.org by mauro2java2011 <ma...@gmail.com> on 2014/11/20 12:34:08 UTC
datasource mysql not work at openshift tomee diy
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.
Re: datasource mysql not work at openshift tomee diy
Posted by mauro2java2011 <ma...@gmail.com>.
i think it is a problem that tomee not read the value from the env variables
specified into resource.xml
with ${OPENSHIFT_MYSQL_DB_HOST}
${OPENSHIFT_MYSQL_DB_PORT}
${OPENSHIFT_APP_NAME}
i have deployed with value hard coded int oresource.,xml and it works.
So i think that not work on openshift speficy int oresource,.xml the vlaue
with EL
--
View this message in context: http://tomee-openejb.979440.n4.nabble.com/datasource-mysql-not-work-at-openshift-tomee-diy-tp4672950p4672964.html
Sent from the TomEE Users mailing list archive at Nabble.com.
Re: datasource mysql not work at openshift tomee diy
Posted by Romain Manni-Bucau <rm...@gmail.com>.
so it means openshift doesn't provides this variable.
Romain Manni-Bucau
@rmannibucau
http://www.tomitribe.com
http://rmannibucau.wordpress.com
https://github.com/rmannibucau
2014-11-20 18:22 GMT+01:00 mauro2java2011 <ma...@gmail.com>:
> I have already make the simulation. With ubuntu i have created a file
> setenv.sh that it is called from catalina.sh and i have esported the
> variables for mysql with the same names .
>
> Locally it works .
> Il 20/nov/2014 17:18 "Romain Manni-Bucau [via TomEE & OpenEJB]" <
> ml-node+s979440n4672961h66@n4.nabble.com> ha scritto:
>
>> it is the one often used for php apps. Prefixing it by "jdbc:" can be
>> enough. In all cases you can try to reproduce locally setting the
>> envrt variables and creating a resource using them. This would say us
>> if it is a tomee/config issue or an openshift specific issue.
>>
>>
>> Romain Manni-Bucau
>> @rmannibucau
>> http://www.tomitribe.com
>> http://rmannibucau.wordpress.com
>> https://github.com/rmannibucau
>>
>>
>> 2014-11-20 16:55 GMT+01:00 mauro2java2011 <[hidden email]
>> <http://user/SendEmail.jtp?type=node&node=4672961&i=0>>:
>>
>> > But the url returned from env var is different that classic connection
>> > string
>> > Il 20/nov/2014 12:51 "Romain Manni-Bucau [via TomEE & OpenEJB]" <
>> > [hidden email] <http://user/SendEmail.jtp?type=node&node=4672961&i=1>>
>> ha scritto:
>> >
>> >> 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 <[hidden email]
>> >> <http://user/SendEmail.jtp?type=node&node=4672951&i=0>>:
>> >>
>> >> >
>> >> >
>> >> > 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.
>> >>
>> >>
>> >> ------------------------------
>> >> If you reply to this email, your message will be added to the
>> discussion
>> >> below:
>> >>
>> >>
>> http://tomee-openejb.979440.n4.nabble.com/datasource-mysql-not-work-at-openshift-tomee-diy-tp4672950p4672951.html
>> >> To unsubscribe from datasource mysql not work at openshift tomee diy,
>> click
>> >> here
>> >> <
>> >> .
>> >> NAML
>> >> <
>> http://tomee-openejb.979440.n4.nabble.com/template/NamlServlet.jtp?macro=macro_viewer&id=instant_html%21nabble%3Aemail.naml&base=nabble.naml.namespaces.BasicNamespace-nabble.view.web.template.NabbleNamespace-nabble.view.web.template.NodeNamespace&breadcrumbs=notify_subscribers%21nabble%3Aemail.naml-instant_emails%21nabble%3Aemail.naml-send_instant_email%21nabble%3Aemail.naml>
>>
>> >>
>> >
>> >
>> >
>> >
>> > --
>> > View this message in context:
>> http://tomee-openejb.979440.n4.nabble.com/datasource-mysql-not-work-at-openshift-tomee-diy-tp4672950p4672960.html
>> > Sent from the TomEE Users mailing list archive at Nabble.com.
>>
>>
>> ------------------------------
>> If you reply to this email, your message will be added to the discussion
>> below:
>>
>> http://tomee-openejb.979440.n4.nabble.com/datasource-mysql-not-work-at-openshift-tomee-diy-tp4672950p4672961.html
>> To unsubscribe from datasource mysql not work at openshift tomee diy, click
>> here
>> <http://tomee-openejb.979440.n4.nabble.com/template/NamlServlet.jtp?macro=unsubscribe_by_code&node=4672950&code=bWF1cm8yamF2YTIwMTFAZ21haWwuY29tfDQ2NzI5NTB8LTExMTcxODc2MjU=>
>> .
>> NAML
>> <http://tomee-openejb.979440.n4.nabble.com/template/NamlServlet.jtp?macro=macro_viewer&id=instant_html%21nabble%3Aemail.naml&base=nabble.naml.namespaces.BasicNamespace-nabble.view.web.template.NabbleNamespace-nabble.view.web.template.NodeNamespace&breadcrumbs=notify_subscribers%21nabble%3Aemail.naml-instant_emails%21nabble%3Aemail.naml-send_instant_email%21nabble%3Aemail.naml>
>>
>
>
>
>
> --
> View this message in context: http://tomee-openejb.979440.n4.nabble.com/datasource-mysql-not-work-at-openshift-tomee-diy-tp4672950p4672962.html
> Sent from the TomEE Users mailing list archive at Nabble.com.
Re: datasource mysql not work at openshift tomee diy
Posted by mauro2java2011 <ma...@gmail.com>.
I have already make the simulation. With ubuntu i have created a file
setenv.sh that it is called from catalina.sh and i have esported the
variables for mysql with the same names .
Locally it works .
Il 20/nov/2014 17:18 "Romain Manni-Bucau [via TomEE & OpenEJB]" <
ml-node+s979440n4672961h66@n4.nabble.com> ha scritto:
> it is the one often used for php apps. Prefixing it by "jdbc:" can be
> enough. In all cases you can try to reproduce locally setting the
> envrt variables and creating a resource using them. This would say us
> if it is a tomee/config issue or an openshift specific issue.
>
>
> Romain Manni-Bucau
> @rmannibucau
> http://www.tomitribe.com
> http://rmannibucau.wordpress.com
> https://github.com/rmannibucau
>
>
> 2014-11-20 16:55 GMT+01:00 mauro2java2011 <[hidden email]
> <http://user/SendEmail.jtp?type=node&node=4672961&i=0>>:
>
> > But the url returned from env var is different that classic connection
> > string
> > Il 20/nov/2014 12:51 "Romain Manni-Bucau [via TomEE & OpenEJB]" <
> > [hidden email] <http://user/SendEmail.jtp?type=node&node=4672961&i=1>>
> ha scritto:
> >
> >> 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 <[hidden email]
> >> <http://user/SendEmail.jtp?type=node&node=4672951&i=0>>:
> >>
> >> >
> >> >
> >> > 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.
> >>
> >>
> >> ------------------------------
> >> If you reply to this email, your message will be added to the
> discussion
> >> below:
> >>
> >>
> http://tomee-openejb.979440.n4.nabble.com/datasource-mysql-not-work-at-openshift-tomee-diy-tp4672950p4672951.html
> >> To unsubscribe from datasource mysql not work at openshift tomee diy,
> click
> >> here
> >> <
> >> .
> >> NAML
> >> <
> http://tomee-openejb.979440.n4.nabble.com/template/NamlServlet.jtp?macro=macro_viewer&id=instant_html%21nabble%3Aemail.naml&base=nabble.naml.namespaces.BasicNamespace-nabble.view.web.template.NabbleNamespace-nabble.view.web.template.NodeNamespace&breadcrumbs=notify_subscribers%21nabble%3Aemail.naml-instant_emails%21nabble%3Aemail.naml-send_instant_email%21nabble%3Aemail.naml>
>
> >>
> >
> >
> >
> >
> > --
> > View this message in context:
> http://tomee-openejb.979440.n4.nabble.com/datasource-mysql-not-work-at-openshift-tomee-diy-tp4672950p4672960.html
> > Sent from the TomEE Users mailing list archive at Nabble.com.
>
>
> ------------------------------
> If you reply to this email, your message will be added to the discussion
> below:
>
> http://tomee-openejb.979440.n4.nabble.com/datasource-mysql-not-work-at-openshift-tomee-diy-tp4672950p4672961.html
> To unsubscribe from datasource mysql not work at openshift tomee diy, click
> here
> <http://tomee-openejb.979440.n4.nabble.com/template/NamlServlet.jtp?macro=unsubscribe_by_code&node=4672950&code=bWF1cm8yamF2YTIwMTFAZ21haWwuY29tfDQ2NzI5NTB8LTExMTcxODc2MjU=>
> .
> NAML
> <http://tomee-openejb.979440.n4.nabble.com/template/NamlServlet.jtp?macro=macro_viewer&id=instant_html%21nabble%3Aemail.naml&base=nabble.naml.namespaces.BasicNamespace-nabble.view.web.template.NabbleNamespace-nabble.view.web.template.NodeNamespace&breadcrumbs=notify_subscribers%21nabble%3Aemail.naml-instant_emails%21nabble%3Aemail.naml-send_instant_email%21nabble%3Aemail.naml>
>
--
View this message in context: http://tomee-openejb.979440.n4.nabble.com/datasource-mysql-not-work-at-openshift-tomee-diy-tp4672950p4672962.html
Sent from the TomEE Users mailing list archive at Nabble.com.
Re: datasource mysql not work at openshift tomee diy
Posted by Romain Manni-Bucau <rm...@gmail.com>.
it is the one often used for php apps. Prefixing it by "jdbc:" can be
enough. In all cases you can try to reproduce locally setting the
envrt variables and creating a resource using them. This would say us
if it is a tomee/config issue or an openshift specific issue.
Romain Manni-Bucau
@rmannibucau
http://www.tomitribe.com
http://rmannibucau.wordpress.com
https://github.com/rmannibucau
2014-11-20 16:55 GMT+01:00 mauro2java2011 <ma...@gmail.com>:
> But the url returned from env var is different that classic connection
> string
> Il 20/nov/2014 12:51 "Romain Manni-Bucau [via TomEE & OpenEJB]" <
> ml-node+s979440n4672951h56@n4.nabble.com> ha scritto:
>
>> 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 <[hidden email]
>> <http://user/SendEmail.jtp?type=node&node=4672951&i=0>>:
>>
>> >
>> >
>> > 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.
>>
>>
>> ------------------------------
>> If you reply to this email, your message will be added to the discussion
>> below:
>>
>> http://tomee-openejb.979440.n4.nabble.com/datasource-mysql-not-work-at-openshift-tomee-diy-tp4672950p4672951.html
>> To unsubscribe from datasource mysql not work at openshift tomee diy, click
>> here
>> <http://tomee-openejb.979440.n4.nabble.com/template/NamlServlet.jtp?macro=unsubscribe_by_code&node=4672950&code=bWF1cm8yamF2YTIwMTFAZ21haWwuY29tfDQ2NzI5NTB8LTExMTcxODc2MjU=>
>> .
>> NAML
>> <http://tomee-openejb.979440.n4.nabble.com/template/NamlServlet.jtp?macro=macro_viewer&id=instant_html%21nabble%3Aemail.naml&base=nabble.naml.namespaces.BasicNamespace-nabble.view.web.template.NabbleNamespace-nabble.view.web.template.NodeNamespace&breadcrumbs=notify_subscribers%21nabble%3Aemail.naml-instant_emails%21nabble%3Aemail.naml-send_instant_email%21nabble%3Aemail.naml>
>>
>
>
>
>
> --
> View this message in context: http://tomee-openejb.979440.n4.nabble.com/datasource-mysql-not-work-at-openshift-tomee-diy-tp4672950p4672960.html
> Sent from the TomEE Users mailing list archive at Nabble.com.
Re: datasource mysql not work at openshift tomee diy
Posted by mauro2java2011 <ma...@gmail.com>.
But the url returned from env var is different that classic connection
string
Il 20/nov/2014 12:51 "Romain Manni-Bucau [via TomEE & OpenEJB]" <
ml-node+s979440n4672951h56@n4.nabble.com> ha scritto:
> 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 <[hidden email]
> <http://user/SendEmail.jtp?type=node&node=4672951&i=0>>:
>
> >
> >
> > 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.
>
>
> ------------------------------
> If you reply to this email, your message will be added to the discussion
> below:
>
> http://tomee-openejb.979440.n4.nabble.com/datasource-mysql-not-work-at-openshift-tomee-diy-tp4672950p4672951.html
> To unsubscribe from datasource mysql not work at openshift tomee diy, click
> here
> <http://tomee-openejb.979440.n4.nabble.com/template/NamlServlet.jtp?macro=unsubscribe_by_code&node=4672950&code=bWF1cm8yamF2YTIwMTFAZ21haWwuY29tfDQ2NzI5NTB8LTExMTcxODc2MjU=>
> .
> NAML
> <http://tomee-openejb.979440.n4.nabble.com/template/NamlServlet.jtp?macro=macro_viewer&id=instant_html%21nabble%3Aemail.naml&base=nabble.naml.namespaces.BasicNamespace-nabble.view.web.template.NabbleNamespace-nabble.view.web.template.NodeNamespace&breadcrumbs=notify_subscribers%21nabble%3Aemail.naml-instant_emails%21nabble%3Aemail.naml-send_instant_email%21nabble%3Aemail.naml>
>
--
View this message in context: http://tomee-openejb.979440.n4.nabble.com/datasource-mysql-not-work-at-openshift-tomee-diy-tp4672950p4672960.html
Sent from the TomEE Users mailing list archive at Nabble.com.
Re: datasource mysql not work at openshift tomee diy
Posted by Romain Manni-Bucau <rm...@gmail.com>.
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 <ma...@gmail.com>:
>
>
> 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.