Skip to content

Latest commit

 

History

History
105 lines (88 loc) · 3.41 KB

MySQL-Settings-For-Sample-App.md

File metadata and controls

105 lines (88 loc) · 3.41 KB

MySQL Settings in the Web Application

Configure the environment variable values in Application settings

# repalce the webapp name with yours
WEB_APP_NAME="azure-javaweb-app-0306"
# repalce the resource group name with yours
WEB_APP_RG_NAME="azure-javaweb-app"
 az webapp config appsettings set \
     --resource-group ${WEB_APP_RG_NAME} \
     --name ${WEB_APP_NAME} \
     --settings JDBC_DRIVER="com.mysql.cj.jdbc.Driver"

 az webapp config appsettings set \
     --resource-group ${WEB_APP_RG_NAME} \
     --name ${WEB_APP_NAME} \
     --settings JDBC_URL="jdbc:mysql://my-mysqlserver.mysql.database.azure.com:3306/world?useSSL=true&requireSSL=false&serverTimezone=JST"

# user should be string like: azureuser@my-mysqlserver
 az webapp config appsettings set \
     --resource-group ${WEB_APP_RG_NAME} \
     --name ${WEB_APP_NAME} \
     --settings DB_USER="USER"

 az webapp config appsettings set \
     --resource-group ${WEB_APP_RG_NAME} \
     --name ${WEB_APP_NAME} \
     --settings DB_PASSWORD="PASSWORD"

$ az webapp config appsettings list --name ${WEB_APP_NAME} -g ${WEB_APP_RG_NAME}
[
  {
    "name": "JDBC_DRIVER",
    "slotSetting": false,
    "value": "com.mysql.cj.jdbc.Driver"
  },
  {
    "name": "JDBC_URL",
    "slotSetting": false,
    "value": "jdbc:mysql://my-mysqlserver.mysql.database.azure.com:3306/world?useSSL=true&requireSSL=false&serverTimezone=JST"
  },
  {
    "name": "DB_USER",
    "slotSetting": false,
    "value": "azureuser@my-mysqlserver"
  },
  {
    "name": "DB_PASSWORD",
    "slotSetting": false,
    "value": "mypassword"
  }
]

Configure in the persistence.xml

<?xml version="1.0" encoding="UTF-8"?>
<persistence version="2.1" xmlns="http://xmlns.jcp.org/xml/ns/persistence" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://xmlns.jcp.org/xml/ns/persistence http://xmlns.jcp.org/xml/ns/persistence/persistence_2_1.xsd">
    <persistence-unit name="JPAWorldDatasourcePU" transaction-type="RESOURCE_LOCAL">
        <provider>org.eclipse.persistence.jpa.PersistenceProvider</provider>
        <class>com.microsoft.azure.samples.entities.City</class>
        <class>com.microsoft.azure.samples.entities.Country</class>
        <exclude-unlisted-classes>true</exclude-unlisted-classes>
        <properties>
            <property name="javax.persistence.jdbc.driver" value="com.mysql.cj.jdbc.Driver"/>
            <property name="javax.persistence.jdbc.url" value="jdbc:mysql://my-mysqlserver.mysql.database.azure.com:3306/world?useSSL=true&amp;requireSSL=false&amp;serverTimezone=JST"/>
            <property name="javax.persistence.jdbc.user" value="azureuser@my-mysqlserver"/>
            <property name="javax.persistence.jdbc.password" value="PASSWORD"/> 

            <property name="eclipselink.cache.shared.default" value="false" />
<!--            <property name="eclipselink.ddl-generation" value="create-tables" /> 
            <property name="eclipselink.ddl-generation.output-mode"
                      value="database" /> -->
            <property name="eclipselink.logging.level" value="SEVERE" />
        </properties>
    </persistence-unit>
</persistence>

Note:
In the jdbc.url you need to escape the "&" as "&amp";

Restart WebApp to enable database setting

Run the following command to deploy the app again.

mvn clean package azure-webapp:deploy