Hide Forgot
Description of problem: Create a scalable jbossas app and embed mysql to it. Copy the app template to the git repo and git push. Version-Release number of selected component (if applicable): How reproducible: Always Steps to Reproduce: 1.Create an scalable jbossas app using REST API $ curl -k -H "Accept: application/xml" --user "<user>:<pass>" https://<server_dns>/broker/rest/domains/<domain_name>/applications -X POST -d name=<appname> -d cartridge=jbossas-7 -d scale=true 2.Embed mysql to the app $ rhc app cartridge add -a <app_name> -c mysql-5.1 3.Copy the attached app template to git repo, change the username, password to your own ones and git push. Actual results: <-------------web page-------------> type Exception report message description The server encountered an internal error () that prevented it from fulfilling this request. exception javax.servlet.ServletException: java.sql.SQLException: javax.resource.ResourceException: IJ000453: Unable to get managed connection for java:jboss/datasources/MysqlDS ........... javax.resource.ResourceException: IJ000658: Unexpected throwable while trying to create a connection: null ......... javax.resource.ResourceException: Could not create connection ...... com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown database '98a78c714b' ........ <--------------------------------> Expected results: The app should connect to mysql successfully. Additional info:
Version-Release number of selected component (if applicable): rhc-cartridge-haproxy-1.4-0.6.5-1.el6_2.noarch rhc-cartridge-jbossas-7-0.88.4-1.el6_2.noarch rubygem-stickshift-controller-0.6.6-1.el6_2.noarch stickshift-abstract-0.6.6-1.el6_2.noarch rubygem-stickshift-node-0.6.7-1.el6_2.noarch rubygem-stickshift-common-0.6.4-1.el6_2.noarch
Created attachment 569660 [details] connect to mysql, insert some data, and read them
This use case doesn't make sense to me. Embedded mysql shouldn't work with a scalable app. It would only be embedded in the haproxy gear in this case right? What should work is connecting to a standalone mysql from jboss based on US2009.