[{"_1":2,"_189":-5,"_190":-5},"loaderData",{"_3":4,"_13":14,"_21":22,"_165":166},"root",{"_5":-5,"_6":-7,"_7":8,"_9":-7,"_10":11,"_12":-7},"currentUser","primaryEmail","siteVerification","6LeIxAcTAAAAAJcZVRqyHh71UMIEGNQ_MXjiZKhI","toast","enableDev",false,"incidentStatus","routes/_layout",{"_15":-5,"_16":17,"_18":17,"_19":11,"_20":11},"username","isAskGordonEnabled",true,"isUsingNewTemplate","showMinimalLanding","showHoneypotTrap","routes/_layout.r.$namespace.$reponame",{"_23":24,"_25":-5,"_26":11,"_27":11,"_28":29,"_30":31,"_32":-5,"_33":11,"_34":35,"_94":95,"_118":119,"_156":-5,"_157":11,"_158":17,"_159":11,"_160":-5,"_161":11,"_162":-5,"_163":164},"canonicalUrl","https://hub.docker.com/r/esignbr/wildfly-mysql/tags","mcpServer","canSeeDockerfile","canSeeAutobuilds","namespace","esignbr","reponame","wildfly-mysql","cloudBuildSource","isAutobuildsAvailable","repo",{"_36":37,"_49":50,"_52":53,"_54":55,"_56":11,"_57":58,"_59":60,"_61":62,"_39":31,"_28":29,"_64":65,"_66":51,"_67":68,"_69":68,"_70":71,"_72":-5,"_73":74,"_75":76,"_77":11,"_78":29,"_79":80,"_85":17,"_86":87,"_91":29,"_92":93},"categories",[38,43,46],{"_39":40,"_41":42},"name","Languages & frameworks","slug","languages-and-frameworks",{"_39":44,"_41":45},"Integration & delivery","integration-and-delivery",{"_39":47,"_41":48},"Databases & storage","databases-and-storage","content_types",[51],"image","date_registered","2018-11-17T22:32:40.049025Z","description","Wildfly custom Docker image prepared for MySQL connection.","is_private","last_updated","2019-10-19T20:46:45.963761Z","last_modified","2024-10-16T13:48:34.145251Z","media_types",[63],"application/vnd.docker.container.image.v1+json","pull_count",6441,"repository_type","star_count",1,"status","status_description","active","source","collaborator_count",0,"full_description","# Wildfly custom Docker image prepared for MySQL connection\n\n[![License: MIT](https://img.shields.io/badge/License-MIT-yellow.svg)](https://opensource.org/licenses/MIT) [![Docker Build status](https://img.shields.io/docker/build/esignbr/wildfly-mysql.svg)](https://hub.docker.com/r/esignbr/wildfly-mysql/builds) [![Docker Pulls](https://img.shields.io/docker/pulls/esignbr/wildfly-mysql.svg)](https://hub.docker.com/r/esignbr/wildfly-mysql)\n\nThis custom Wildfly image is built based on the official [jboss/wildfly:13.0.0.Final](https://github.com/jboss-dockerfiles/wildfly/tree/13.0.0.Final) image.\n\n## MySQL connection\n\nThe image brings the [version 8.0.12](http://central.maven.org/maven2/mysql/mysql-connector-java/8.0.12/mysql-connector-java-8.0.12.jar) of the official JDBC driver for MySQL ([Connector/J](https://dev.mysql.com/downloads/connector/j)).\n\nDuring the setup, the MySQL instance is checked until it is ready for connection. This is done during the execution of [wait-for-mysql.sh](wait-for-mysql.sh), the [image entrypoint](https://docs.docker.com/engine/reference/builder/#entrypoint).\n\nA very simple Java class is responsible for testing the connection: [TestConnection.java](TestConnection.java). The class is compiled inside the image, during its building process.\n\n## Required environment variables\n\nThe following environment variables are mandatory in order to run appropriately the image:\n\n- MYSQL_HOST - The name of the MySQL host. If the MySQL port is other than the default 3306, add `:`.\n- MYSQL_DATABASE - The name of the database used by the application deployed in Wildfly.\n- MYSQL_ROOT_PASSWORD - The MySQL root user password.\n- MYSQL_USER - The database superuser.\n- MYSQL_PASSWORD - The database user password.\n\nIf you are using this image together with the [official MySQL image](https://hub.docker.com/_/mysql), set the same values to *MYSQL_DATABASE*, *MYSQL_ROOT_PASSWORD*, *MYSQL_USER* and *MYSQL_PASSWORD* for both images.\n\n## Wildfly datasource\n\nThe image is also built with a pre-configured datasource, defined in the file [standalone.xml](standalone.xml). As can be seen in the *xml* below, the configuration depends on the environment variables.\n\n```xml\n\n jdbc:mysql://${env.MYSQL_HOST}/${env.MYSQL_DATABASE}?serverTimezone=UTC\n mysql\n \n ${env.MYSQL_USER}\n ${env.MYSQL_PASSWORD}\n \n \n \n \n \n\n```\n\n> Notice that both **jndi-name** and **pool-name** depend on the name of the database, defined in *MYSQL_DATABASE*. You must take it into consideration for JNDI bindings within your application code.\n\n## Extending this image\n\nIf your Java application is deployed in Wildfly and uses a MySQL database, create a Dockerfile like the example:\n\n```dockerfile\nFROM esignbr/wildfly-mysql\n\nADD target/application.war /opt/jboss/wildfly/standalone/deployments/\n```\n\n> I'm assuming you've used [Maven](https://maven.apache.org) to build your application, thus the *war* file is in the *target* folder. Wildfly expects the packaged application file inside */opt/jboss/wildfly/standalone/deployments/*, for automaticaly deploying it on boot.\n\nYou can then build your own application Docker image:\n\n`docker build -t myimages/myapplication .`\n\n### Running your own image\n\nDon't forget to define appropriately the environment variables during the image initialization. If your environment is whole Docker, all of your services run in containers, you can use a docker-compose.yml like the example:\n\n```yaml\nversion: '3'\nservices:\n myapp:\n image: myimages/myapplication\n container_name: myapp\n environment:\n - MYSQL_HOST=mysql\n - MYSQL_DATABASE=myapp\n - MYSQL_ROOT_PASSWORD=secret\n - MYSQL_USER=dbuser\n - MYSQL_PASSWORD=dbpass\n depends_on:\n - mysql\n mysql:\n image: mysql:8\n container_name: mysql\n environment:\n - MYSQL_DATABASE=myapp\n - MYSQL_ROOT_PASSWORD=secret\n - MYSQL_USER=dbuser\n - MYSQL_PASSWORD=dbpass\n```\n\nYou can then run your application and MySQL together:\n\n`docker-compose up -d`\n","has_starred","hub_user","immutable_tags_settings",{"_81":11,"_82":83},"enabled","rules",[84],".*","is_automated","permissions",{"_88":17,"_89":11,"_90":11},"read","write","admin","user","storage_size",3184349453,"orgData",{"_96":97,"_98":99,"_100":101,"_102":29,"_103":104,"_105":106,"_107":108,"_109":110,"_111":112,"_113":114,"_115":104,"_116":104,"_117":17},"id","26e38c99650c4c609f0351e8a8dca2e0","uuid","26e38c99-650c-4c60-9f03-51e8a8dca2e0","type","organization","orgname","full_name","","location","Lisbon","company","Esign Consulting","profile_url","https://github.com/esign-consulting","date_joined","2017-09-11T14:43:25.571653Z","gravatar_url","https://www.gravatar.com/avatar/4a113c597d6412009402560b6270eda1?s=80&r=g&d=mm","gravatar_email","badge","is_active","recentTags",[120],{"_121":51,"_122":123,"_124":125,"_96":126,"_127":128,"_57":145,"_146":123,"_147":29,"_148":63,"_39":149,"_150":151,"_152":136,"_153":145,"_154":71,"_155":17},"content_type","creator",2147716,"full_size",563445799,40227347,"images",[129],{"_130":131,"_132":133,"_134":104,"_135":136,"_137":138,"_139":140,"_141":104,"_142":-5,"_143":125,"_69":71,"_144":-5},"architecture","amd64","digest","sha256:7b4b45806d33882f48d2770db0eceed1828be326e31bc7a462e618bfc4808d1f","features","last_pulled","2026-09-22T03:27:19.986709826Z","last_pushed","2019-10-19T20:46:46Z","os","linux","os_features","os_version","size","variant","2019-10-19T20:46:45.686257Z","last_updater","last_updater_username","media_type","latest","repository",6309855,"tag_last_pulled","tag_last_pushed","tag_status","v2","sbxKitMetadata","isPotentialSpam","isHubSbxKitsEnabled","showSbxLogoOverride","sbxTrademarkText","displaySecurityMetadata","tagAttestations","tagsHaveAttestations",[],"routes/_layout.r.$namespace.$reponame.tags",{"_34":167,"_177":178,"_163":187,"_188":11},{"_36":168,"_49":172,"_52":53,"_54":55,"_56":11,"_57":58,"_59":60,"_61":173,"_39":31,"_28":29,"_64":65,"_66":51,"_67":68,"_69":68,"_70":71,"_72":-5,"_73":74,"_75":76,"_77":11,"_78":29,"_79":174,"_85":17,"_86":176,"_91":29,"_92":93},[169,170,171],{"_39":40,"_41":42},{"_39":44,"_41":45},{"_39":47,"_41":48},[51],[63],{"_81":11,"_82":175},[84],{"_88":17,"_89":11,"_90":11},"tags",{"_179":68,"_180":-5,"_181":-5,"_182":183},"count","next","previous","results",[184],{"_121":51,"_122":123,"_124":125,"_96":126,"_127":185,"_57":145,"_146":123,"_147":29,"_148":63,"_39":149,"_150":151,"_152":136,"_153":145,"_154":71,"_155":17},[186],{"_130":131,"_132":133,"_134":104,"_135":136,"_137":138,"_139":140,"_141":104,"_142":-5,"_143":125,"_69":71,"_144":-5},[],"canDeleteTags","actionData","errors"]

esignbr/wildfly-mysql

Tags for esignbr/wildfly-mysql