diff --git a/.idea/libraries/Maven__mysql_mysql_connector_java_8_0_16.xml b/.idea/libraries/Maven__mysql_mysql_connector_java_8_0_16.xml
new file mode 100644
index 0000000..b969cc3
--- /dev/null
+++ b/.idea/libraries/Maven__mysql_mysql_connector_java_8_0_16.xml
@@ -0,0 +1,13 @@
+<component name="libraryTable">
+  <library name="Maven: mysql:mysql-connector-java:8.0.16">
+    <CLASSES>
+      <root url="jar://$MAVEN_REPOSITORY$/mysql/mysql-connector-java/8.0.16/mysql-connector-java-8.0.16.jar!/" />
+    </CLASSES>
+    <JAVADOC>
+      <root url="jar://$MAVEN_REPOSITORY$/mysql/mysql-connector-java/8.0.16/mysql-connector-java-8.0.16-javadoc.jar!/" />
+    </JAVADOC>
+    <SOURCES>
+      <root url="jar://$MAVEN_REPOSITORY$/mysql/mysql-connector-java/8.0.16/mysql-connector-java-8.0.16-sources.jar!/" />
+    </SOURCES>
+  </library>
+</component>
\ No newline at end of file
diff --git a/.idea/vcs.xml b/.idea/vcs.xml
new file mode 100644
index 0000000..94a25f7
--- /dev/null
+++ b/.idea/vcs.xml
@@ -0,0 +1,6 @@
+<?xml version="1.0" encoding="UTF-8"?>
+<project version="4">
+  <component name="VcsDirectoryMappings">
+    <mapping directory="$PROJECT_DIR$" vcs="Git" />
+  </component>
+</project>
\ No newline at end of file
diff --git a/.idea/workspace.xml b/.idea/workspace.xml
index ceff811..55ff008 100644
--- a/.idea/workspace.xml
+++ b/.idea/workspace.xml
@@ -1,527 +1,482 @@
 <?xml version="1.0" encoding="UTF-8"?>
 <project version="4">
   <component name="ChangeListManager">
-    <list default="true" id="47acfe13-5157-4ee2-8bc7-df92e9ae137a" name="Default Changelist" comment="" />
+    <list default="true" id="47acfe13-5157-4ee2-8bc7-df92e9ae137a" name="Default Changelist" comment="">
+      <change afterPath="$PROJECT_DIR$/.idea/libraries/Maven__mysql_mysql_connector_java_8_0_16.xml" afterDir="false" />
+      <change afterPath="$PROJECT_DIR$/.idea/vcs.xml" afterDir="false" />
+      <change afterPath="$PROJECT_DIR$/src/main/java/net/javaguides/springboot/websocket/controller/ThirdApiController.java" afterDir="false" />
+      <change afterPath="$PROJECT_DIR$/src/main/java/net/javaguides/springboot/websocket/model/ThirdApi.java" afterDir="false" />
+      <change afterPath="$PROJECT_DIR$/src/main/java/net/javaguides/springboot/websocket/repository/ThirdApiRepository.java" afterDir="false" />
+      <change afterPath="$PROJECT_DIR$/src/main/resources/application.properties" afterDir="false" />
+      <change beforePath="$PROJECT_DIR$/.idea/workspace.xml" beforeDir="false" afterPath="$PROJECT_DIR$/.idea/workspace.xml" afterDir="false" />
+      <change beforePath="$PROJECT_DIR$/pom.xml" beforeDir="false" afterPath="$PROJECT_DIR$/pom.xml" afterDir="false" />
+      <change beforePath="$PROJECT_DIR$/springboot-stomp-websocket.iml" beforeDir="false" afterPath="$PROJECT_DIR$/springboot-stomp-websocket.iml" afterDir="false" />
+      <change beforePath="$PROJECT_DIR$/src/main/java/net/javaguides/springboot/websocket/Application.java" beforeDir="false" afterPath="$PROJECT_DIR$/src/main/java/net/javaguides/springboot/websocket/Application.java" afterDir="false" />
+      <change beforePath="$PROJECT_DIR$/src/main/java/net/javaguides/springboot/websocket/controller/CurrentPilotsController.java" beforeDir="false" afterPath="$PROJECT_DIR$/src/main/java/net/javaguides/springboot/websocket/controller/PilotsController.java" afterDir="false" />
+      <change beforePath="$PROJECT_DIR$/src/main/java/net/javaguides/springboot/websocket/controller/UpdateController.java" beforeDir="false" afterPath="$PROJECT_DIR$/src/main/java/net/javaguides/springboot/websocket/controller/UpdateController.java" afterDir="false" />
+    </list>
     <ignored path="$PROJECT_DIR$/classes/" />
     <ignored path="$PROJECT_DIR$/target/" />
     <option name="EXCLUDED_CONVERTED_TO_IGNORED" value="true" />
     <option name="SHOW_DIALOG" value="false" />
     <option name="HIGHLIGHT_CONFLICTS" value="true" />
     <option name="HIGHLIGHT_NON_ACTIVE_CHANGELIST" value="false" />
     <option name="LAST_RESOLUTION" value="IGNORE" />
   </component>
   <component name="DefaultGradleProjectSettings">
     <option name="isMigrated" value="true" />
   </component>
   <component name="FileEditorManager">
     <leaf SIDE_TABS_SIZE_LIMIT_KEY="300">
-      <file pinned="false" current-in-tab="false">
-        <entry file="file://$PROJECT_DIR$/src/main/java/net/javaguides/springboot/websocket/config/WebSocketConfig.java">
-          <provider selected="true" editor-type-id="text-editor">
-            <state relative-caret-position="288">
-              <caret line="22" column="1" selection-start-line="22" selection-start-column="1" selection-end-line="22" selection-end-column="1" />
-              <folding>
-                <element signature="imports" expanded="true" />
-              </folding>
-            </state>
-          </provider>
-        </entry>
-      </file>
-      <file pinned="false" current-in-tab="false">
-        <entry file="file://$PROJECT_DIR$/src/main/java/net/javaguides/springboot/websocket/controller/UpdateController.java">
-          <provider selected="true" editor-type-id="text-editor">
-            <state relative-caret-position="210">
-              <caret line="18" column="28" selection-start-line="18" selection-start-column="28" selection-end-line="18" selection-end-column="28" />
-              <folding>
-                <element signature="imports" expanded="true" />
-              </folding>
-            </state>
-          </provider>
-        </entry>
-      </file>
-      <file pinned="false" current-in-tab="false">
-        <entry file="file://$PROJECT_DIR$/src/main/java/net/javaguides/springboot/websocket/controller/CurrentPilotsController.java">
-          <provider selected="true" editor-type-id="text-editor">
-            <state relative-caret-position="227">
-              <caret line="44" column="53" lean-forward="true" selection-start-line="44" selection-start-column="53" selection-end-line="44" selection-end-column="53" />
-              <folding>
-                <element signature="imports" expanded="true" />
-              </folding>
-            </state>
-          </provider>
-        </entry>
-      </file>
-      <file pinned="false" current-in-tab="false">
-        <entry file="file://$PROJECT_DIR$/src/main/java/net/javaguides/springboot/websocket/repository/PilotRepository.java">
-          <provider selected="true" editor-type-id="text-editor">
-            <state relative-caret-position="119">
-              <caret line="7" column="69" lean-forward="true" selection-start-line="7" selection-start-column="69" selection-end-line="7" selection-end-column="69" />
-              <folding>
-                <element signature="imports" expanded="true" />
-              </folding>
-            </state>
-          </provider>
-        </entry>
-      </file>
-      <file pinned="false" current-in-tab="false">
-        <entry file="file://$PROJECT_DIR$/src/main/java/net/javaguides/springboot/websocket/Application.java">
-          <provider selected="true" editor-type-id="text-editor">
-            <state relative-caret-position="176">
-              <caret line="56" selection-start-line="56" selection-end-line="56" />
-            </state>
-          </provider>
-        </entry>
-      </file>
       <file pinned="false" current-in-tab="true">
-        <entry file="file://$PROJECT_DIR$/src/main/java/net/javaguides/springboot/websocket/model/Pilot.java">
+        <entry file="file://$PROJECT_DIR$/src/main/java/net/javaguides/springboot/websocket/controller/PilotsController.java">
           <provider selected="true" editor-type-id="text-editor">
-            <state relative-caret-position="196">
-              <caret line="15" column="19" selection-start-line="15" selection-start-column="19" selection-end-line="15" selection-end-column="19" />
+            <state relative-caret-position="74">
+              <caret line="73" column="33" selection-start-line="73" selection-start-column="33" selection-end-line="73" selection-end-column="33" />
               <folding>
                 <element signature="imports" expanded="true" />
+                <element signature="e#467#468#0" expanded="true" />
+                <element signature="e#511#512#0" expanded="true" />
+                <element signature="e#956#957#0" expanded="true" />
+                <element signature="e#1015#1016#0" expanded="true" />
+                <element signature="e#1301#1302#0" expanded="true" />
+                <element signature="e#1359#1360#0" expanded="true" />
               </folding>
             </state>
           </provider>
         </entry>
       </file>
     </leaf>
   </component>
   <component name="FileTemplateManagerImpl">
     <option name="RECENT_TEMPLATES">
       <list>
         <option value="Class" />
       </list>
     </option>
   </component>
   <component name="FindInProjectRecents">
     <findStrings>
       <find>respon</find>
       <find>topic</find>
       <find>data</find>
       <find>greeting</find>
       <find>GreetingContro</find>
       <find>hello</find>
       <find>HelloMess</find>
       <find>Update data</find>
       <find>update</find>
       <find>savePilot</find>
       <find>List</find>
       <find>current</find>
       <find>bestLap</find>
       <find>updateAll</find>
       <find>coucou</find>
+      <find>8080</find>
       <find>videoProblems</find>
+      <find>Paris</find>
     </findStrings>
+    <dirStrings>
+      <dir>C:\Users\Mathis\Documents\EPFL\essai WS\backend\springboot-stomp-websocket\src\main</dir>
+    </dirStrings>
+  </component>
+  <component name="Git.Settings">
+    <option name="RECENT_GIT_ROOT_PATH" value="$PROJECT_DIR$" />
   </component>
   <component name="IdeDocumentHistory">
     <option name="CHANGED_PATHS">
       <list>
         <option value="$PROJECT_DIR$/src/main/java/net/javaguides/springboot/websocket/repository/PilotRepository.java" />
         <option value="$PROJECT_DIR$/src/main/java/net/javaguides/springboot/websocket/controller/GreetingController.java" />
         <option value="$PROJECT_DIR$/src/main/java/net/javaguides/springboot/websocket/config/WebSocketConfig.java" />
         <option value="$PROJECT_DIR$/src/main/java/net/javaguides/springboot/websocket/model/ApiAdress.java" />
         <option value="$PROJECT_DIR$/src/main/java/net/javaguides/springboot/websocket/config/RestConfig.java" />
-        <option value="$PROJECT_DIR$/pom.xml" />
         <option value="$PROJECT_DIR$/src/main/java/net/javaguides/springboot/websocket/model/Heat.java" />
         <option value="$PROJECT_DIR$/src/main/java/net/javaguides/springboot/websocket/model/Car.java" />
         <option value="$PROJECT_DIR$/src/main/java/net/javaguides/springboot/websocket/controller/ApiController.java" />
         <option value="$PROJECT_DIR$/src/main/java/net/javaguides/springboot/websocket/model/Race.java" />
         <option value="$PROJECT_DIR$/src/main/java/net/javaguides/springboot/websocket/repository/RunRepository.java" />
         <option value="$PROJECT_DIR$/src/main/java/net/javaguides/springboot/websocket/controller/RunController.java" />
         <option value="$PROJECT_DIR$/src/main/java/net/javaguides/springboot/websocket/model/Run.java" />
+        <option value="$PROJECT_DIR$/src/main/java/net/javaguides/springboot/websocket/model/Pilot.java" />
+        <option value="$PROJECT_DIR$/pom.xml" />
+        <option value="$PROJECT_DIR$/src/main/resources/application.properties" />
+        <option value="$PROJECT_DIR$/src/main/java/net/javaguides/springboot/websocket/controller/CurrentPilotsController.java" />
+        <option value="$PROJECT_DIR$/src/main/java/net/javaguides/springboot/websocket/model/ThirdApi.java" />
+        <option value="$PROJECT_DIR$/src/main/java/net/javaguides/springboot/websocket/repository/ThirdApiRepository.java" />
         <option value="$PROJECT_DIR$/src/main/java/net/javaguides/springboot/websocket/Application.java" />
         <option value="$PROJECT_DIR$/src/main/java/net/javaguides/springboot/websocket/controller/UpdateController.java" />
-        <option value="$PROJECT_DIR$/src/main/java/net/javaguides/springboot/websocket/controller/CurrentPilotsController.java" />
-        <option value="$PROJECT_DIR$/src/main/java/net/javaguides/springboot/websocket/model/Pilot.java" />
+        <option value="$PROJECT_DIR$/src/main/java/net/javaguides/springboot/websocket/controller/ThirdApiController.java" />
+        <option value="$PROJECT_DIR$/src/main/java/net/javaguides/springboot/websocket/controller/PilotsController.java" />
       </list>
     </option>
   </component>
   <component name="MavenImportPreferences">
     <option name="importingSettings">
       <MavenImportingSettings>
         <option name="importAutomatically" value="true" />
       </MavenImportingSettings>
     </option>
   </component>
   <component name="ProjectFrameBounds" extendedState="6">
-    <option name="x" value="455" />
-    <option name="y" value="-8" />
     <option name="width" value="697" />
-    <option name="height" value="745" />
+    <option name="height" value="738" />
   </component>
+  <component name="ProjectLevelVcsManager" settingsEditedManually="true" />
   <component name="ProjectView">
     <navigator proportions="" version="1">
       <foldersAlwaysOnTop value="true" />
     </navigator>
     <panes>
-      <pane id="PackagesPane" />
       <pane id="Scope" />
       <pane id="ProjectPane">
         <subPane>
           <expand>
             <path>
               <item name="springboot-stomp-websocket" type="b2602c69:ProjectViewProjectNode" />
               <item name="springboot-stomp-websocket" type="462c0819:PsiDirectoryNode" />
             </path>
             <path>
               <item name="springboot-stomp-websocket" type="b2602c69:ProjectViewProjectNode" />
               <item name="springboot-stomp-websocket" type="462c0819:PsiDirectoryNode" />
               <item name="src" type="462c0819:PsiDirectoryNode" />
             </path>
             <path>
               <item name="springboot-stomp-websocket" type="b2602c69:ProjectViewProjectNode" />
               <item name="springboot-stomp-websocket" type="462c0819:PsiDirectoryNode" />
               <item name="src" type="462c0819:PsiDirectoryNode" />
               <item name="main" type="462c0819:PsiDirectoryNode" />
             </path>
             <path>
               <item name="springboot-stomp-websocket" type="b2602c69:ProjectViewProjectNode" />
               <item name="springboot-stomp-websocket" type="462c0819:PsiDirectoryNode" />
               <item name="src" type="462c0819:PsiDirectoryNode" />
               <item name="main" type="462c0819:PsiDirectoryNode" />
               <item name="java" type="462c0819:PsiDirectoryNode" />
             </path>
             <path>
               <item name="springboot-stomp-websocket" type="b2602c69:ProjectViewProjectNode" />
               <item name="springboot-stomp-websocket" type="462c0819:PsiDirectoryNode" />
               <item name="src" type="462c0819:PsiDirectoryNode" />
               <item name="main" type="462c0819:PsiDirectoryNode" />
               <item name="java" type="462c0819:PsiDirectoryNode" />
               <item name="websocket" type="462c0819:PsiDirectoryNode" />
             </path>
             <path>
               <item name="springboot-stomp-websocket" type="b2602c69:ProjectViewProjectNode" />
               <item name="springboot-stomp-websocket" type="462c0819:PsiDirectoryNode" />
               <item name="src" type="462c0819:PsiDirectoryNode" />
               <item name="main" type="462c0819:PsiDirectoryNode" />
               <item name="java" type="462c0819:PsiDirectoryNode" />
               <item name="websocket" type="462c0819:PsiDirectoryNode" />
               <item name="config" type="462c0819:PsiDirectoryNode" />
             </path>
             <path>
               <item name="springboot-stomp-websocket" type="b2602c69:ProjectViewProjectNode" />
               <item name="springboot-stomp-websocket" type="462c0819:PsiDirectoryNode" />
               <item name="src" type="462c0819:PsiDirectoryNode" />
               <item name="main" type="462c0819:PsiDirectoryNode" />
               <item name="java" type="462c0819:PsiDirectoryNode" />
               <item name="websocket" type="462c0819:PsiDirectoryNode" />
               <item name="controller" type="462c0819:PsiDirectoryNode" />
             </path>
             <path>
               <item name="springboot-stomp-websocket" type="b2602c69:ProjectViewProjectNode" />
               <item name="springboot-stomp-websocket" type="462c0819:PsiDirectoryNode" />
               <item name="src" type="462c0819:PsiDirectoryNode" />
               <item name="main" type="462c0819:PsiDirectoryNode" />
               <item name="java" type="462c0819:PsiDirectoryNode" />
               <item name="websocket" type="462c0819:PsiDirectoryNode" />
               <item name="model" type="462c0819:PsiDirectoryNode" />
             </path>
             <path>
               <item name="springboot-stomp-websocket" type="b2602c69:ProjectViewProjectNode" />
               <item name="springboot-stomp-websocket" type="462c0819:PsiDirectoryNode" />
               <item name="src" type="462c0819:PsiDirectoryNode" />
               <item name="main" type="462c0819:PsiDirectoryNode" />
               <item name="java" type="462c0819:PsiDirectoryNode" />
               <item name="websocket" type="462c0819:PsiDirectoryNode" />
               <item name="repository" type="462c0819:PsiDirectoryNode" />
             </path>
+            <path>
+              <item name="springboot-stomp-websocket" type="b2602c69:ProjectViewProjectNode" />
+              <item name="springboot-stomp-websocket" type="462c0819:PsiDirectoryNode" />
+              <item name="src" type="462c0819:PsiDirectoryNode" />
+              <item name="main" type="462c0819:PsiDirectoryNode" />
+              <item name="resources" type="462c0819:PsiDirectoryNode" />
+            </path>
           </expand>
           <select />
         </subPane>
       </pane>
+      <pane id="PackagesPane" />
     </panes>
   </component>
   <component name="PropertiesComponent">
     <property name="RequestMappingsPanelOrder0" value="0" />
     <property name="RequestMappingsPanelOrder1" value="1" />
     <property name="RequestMappingsPanelWidth0" value="75" />
     <property name="RequestMappingsPanelWidth1" value="75" />
+    <property name="SHARE_PROJECT_CONFIGURATION_FILES" value="true" />
     <property name="WebServerToolWindowFactoryState" value="false" />
     <property name="aspect.path.notification.shown" value="true" />
     <property name="last_opened_file_path" value="$PROJECT_DIR$" />
     <property name="nodejs_interpreter_path.stuck_in_default_project" value="undefined stuck path" />
     <property name="nodejs_npm_path_reset_for_default_project" value="true" />
     <property name="restartRequiresConfirmation" value="false" />
   </component>
   <component name="RecentsManager">
     <key name="CopyClassDialog.RECENTS_KEY">
       <recent name="net.javaguides.springboot.websocket.repository" />
       <recent name="net.javaguides.springboot.websocket.controller" />
       <recent name="net.javaguides.springboot.websocket.model" />
     </key>
   </component>
   <component name="RunDashboard">
     <option name="ruleStates">
       <list>
         <RuleState>
           <option name="name" value="ConfigurationTypeDashboardGroupingRule" />
         </RuleState>
         <RuleState>
           <option name="name" value="StatusDashboardGroupingRule" />
         </RuleState>
       </list>
     </option>
   </component>
   <component name="RunManager">
     <configuration name="Application" type="SpringBootApplicationConfigurationType" factoryName="Spring Boot">
       <module name="springboot-stomp-websocket" />
       <option name="SPRING_BOOT_MAIN_CLASS" value="net.javaguides.springboot.websocket.Application" />
       <method v="2">
         <option name="Make" enabled="true" />
       </method>
     </configuration>
   </component>
   <component name="SvnConfiguration">
     <configuration />
   </component>
   <component name="TaskManager">
     <task active="true" id="Default" summary="Default task">
       <changelist id="47acfe13-5157-4ee2-8bc7-df92e9ae137a" name="Default Changelist" comment="" />
       <created>1563541468370</created>
       <option name="number" value="Default" />
       <option name="presentableId" value="Default" />
       <updated>1563541468370</updated>
       <workItem from="1563541472024" duration="8678000" />
       <workItem from="1563781957291" duration="2445000" />
-      <workItem from="1563823339891" duration="34176000" />
+      <workItem from="1563823339891" duration="43609000" />
+      <workItem from="1564557499031" duration="8316000" />
+      <workItem from="1564924198204" duration="2659000" />
     </task>
     <servers />
   </component>
   <component name="TimeTrackingManager">
-    <option name="totallyTimeSpent" value="45299000" />
+    <option name="totallyTimeSpent" value="65707000" />
   </component>
   <component name="ToolWindowManager">
     <frame x="-8" y="-8" width="1382" height="754" extended-state="6" />
     <editor active="true" />
     <layout>
-      <window_info content_ui="combo" id="Project" order="0" visible="true" weight="0.23903178" />
+      <window_info active="true" content_ui="combo" id="Project" order="0" visible="true" weight="0.24659607" />
       <window_info id="Structure" order="1" side_tool="true" weight="0.25" />
       <window_info id="Designer" order="2" />
       <window_info id="Image Layers" order="3" />
       <window_info id="Capture Tool" order="4" />
       <window_info id="UI Designer" order="5" />
       <window_info id="Favorites" order="6" side_tool="true" />
       <window_info id="Web" order="7" side_tool="true" />
       <window_info anchor="bottom" id="Message" order="0" />
       <window_info anchor="bottom" id="Find" order="1" weight="0.32850242" />
-      <window_info active="true" anchor="bottom" id="Run" order="2" visible="true" weight="0.33816424" />
+      <window_info anchor="bottom" id="Run" order="2" visible="true" weight="0.39291465" />
       <window_info anchor="bottom" id="Debug" order="3" weight="0.3993559" />
       <window_info anchor="bottom" id="Cvs" order="4" weight="0.25" />
       <window_info anchor="bottom" id="Inspection" order="5" weight="0.4" />
       <window_info anchor="bottom" id="TODO" order="6" />
       <window_info anchor="bottom" id="Spring" order="7" />
       <window_info anchor="bottom" id="Terminal" order="8" weight="0.32850242" />
       <window_info anchor="bottom" id="Docker" order="9" show_stripe_button="false" />
       <window_info anchor="bottom" id="Event Log" order="10" side_tool="true" />
       <window_info anchor="bottom" id="Messages" order="11" weight="0.32850242" />
       <window_info anchor="bottom" id="Java Enterprise" order="12" />
       <window_info anchor="bottom" id="Database Changes" order="13" />
       <window_info anchor="bottom" id="Version Control" order="14" />
       <window_info anchor="right" id="Commander" internal_type="SLIDING" order="0" type="SLIDING" weight="0.4" />
       <window_info anchor="right" id="Ant Build" order="1" weight="0.25" />
       <window_info anchor="right" content_ui="combo" id="Hierarchy" order="2" weight="0.25" />
       <window_info anchor="right" id="Maven" order="3" />
       <window_info anchor="right" id="Palette" order="4" />
       <window_info anchor="right" id="Capture Analysis" order="5" />
       <window_info anchor="right" id="Database" order="6" />
       <window_info anchor="right" id="Palette&#9;" order="7" />
       <window_info anchor="right" id="Theme Preview" order="8" />
       <window_info anchor="right" id="Bean Validation" order="9" />
     </layout>
   </component>
   <component name="TypeScriptGeneratedFilesManager">
     <option name="version" value="1" />
   </component>
   <component name="editorHistoryManager">
     <entry file="file://$PROJECT_DIR$/src/main/java/net/javaguides/springboot/websocket/model/Greeting.java" />
     <entry file="file://$PROJECT_DIR$/src/main/java/net/javaguides/springboot/websocket/model/HelloMessage.java" />
     <entry file="file://$PROJECT_DIR$/src/main/resources/static/app.js">
       <provider selected="true" editor-type-id="text-editor">
         <state relative-caret-position="340">
           <caret line="20" column="32" selection-start-line="20" selection-start-column="32" selection-end-line="20" selection-end-column="32" />
         </state>
       </provider>
     </entry>
-    <entry file="file://$PROJECT_DIR$/src/main/java/net/javaguides/springboot/websocket/model/ApiAdress.java">
-      <provider selected="true" editor-type-id="text-editor">
-        <state relative-caret-position="255">
-          <caret line="17" column="35" lean-forward="true" selection-start-line="17" selection-start-column="35" selection-end-line="17" selection-end-column="35" />
-          <folding>
-            <element signature="imports" expanded="true" />
-          </folding>
-        </state>
-      </provider>
-    </entry>
+    <entry file="file://$PROJECT_DIR$/src/main/java/net/javaguides/springboot/websocket/model/ApiAdress.java" />
     <entry file="file://$PROJECT_DIR$/src/main/java/net/javaguides/springboot/websocket/config/RestConfig.java">
       <provider selected="true" editor-type-id="text-editor">
         <state relative-caret-position="50">
           <caret line="7" selection-start-line="7" selection-end-line="24" selection-end-column="1" />
           <folding>
             <element signature="imports" expanded="true" />
           </folding>
         </state>
       </provider>
     </entry>
-    <entry file="file://$PROJECT_DIR$/pom.xml">
-      <provider selected="true" editor-type-id="text-editor">
-        <state relative-caret-position="85">
-          <caret line="74" column="21" selection-start-line="74" selection-start-column="21" selection-end-line="74" selection-end-column="21" />
-        </state>
-      </provider>
-    </entry>
-    <entry file="file://$PROJECT_DIR$/src/main/java/net/javaguides/springboot/websocket/model/Heat.java">
+    <entry file="file://$PROJECT_DIR$/src/main/java/net/javaguides/springboot/websocket/model/Heat.java" />
+    <entry file="file://$PROJECT_DIR$/src/main/java/net/javaguides/springboot/websocket/model/Car.java" />
+    <entry file="file://$PROJECT_DIR$/src/main/java/net/javaguides/springboot/websocket/controller/ApiController.java" />
+    <entry file="file://$PROJECT_DIR$/src/main/java/net/javaguides/springboot/websocket/controller/RunController.java" />
+    <entry file="file://$PROJECT_DIR$/src/main/java/net/javaguides/springboot/websocket/model/Run.java" />
+    <entry file="file://$PROJECT_DIR$/src/main/java/net/javaguides/springboot/websocket/repository/RunRepository.java" />
+    <entry file="file://$PROJECT_DIR$/src/main/java/net/javaguides/springboot/websocket/model/Race.java" />
+    <entry file="file://$PROJECT_DIR$/src/main/resources/applicaiton.properties" />
+    <entry file="file://$PROJECT_DIR$/src/main/java/net/javaguides/springboot/websocket/config/WebSocketConfig.java">
       <provider selected="true" editor-type-id="text-editor">
-        <state relative-caret-position="255">
-          <caret line="18" selection-start-line="18" selection-end-line="18" />
+        <state relative-caret-position="306">
+          <caret line="22" column="1" selection-start-line="22" selection-start-column="1" selection-end-line="22" selection-end-column="1" />
           <folding>
             <element signature="imports" expanded="true" />
           </folding>
         </state>
       </provider>
     </entry>
-    <entry file="file://$PROJECT_DIR$/src/main/java/net/javaguides/springboot/websocket/model/Car.java">
-      <provider selected="true" editor-type-id="text-editor">
-        <state relative-caret-position="85">
-          <caret line="5" column="21" selection-start-line="5" selection-start-column="21" selection-end-line="5" selection-end-column="21" />
-          <folding>
-            <element signature="e#153#154#0" expanded="true" />
-            <element signature="e#181#182#0" expanded="true" />
-            <element signature="e#223#224#0" expanded="true" />
-            <element signature="e#257#258#0" expanded="true" />
-            <element signature="e#288#289#0" expanded="true" />
-            <element signature="e#315#316#0" expanded="true" />
-            <element signature="e#355#356#0" expanded="true" />
-            <element signature="e#387#388#0" expanded="true" />
-          </folding>
-        </state>
-      </provider>
+    <entry file="file://$PROJECT_DIR$/.classpath">
+      <provider selected="true" editor-type-id="text-editor" />
     </entry>
-    <entry file="file://$PROJECT_DIR$/src/main/java/net/javaguides/springboot/websocket/controller/ApiController.java">
+    <entry file="file://$PROJECT_DIR$/pom.xml">
       <provider selected="true" editor-type-id="text-editor">
-        <state relative-caret-position="189">
-          <caret line="29" column="5" selection-start-line="29" selection-start-column="5" selection-end-line="29" selection-end-column="5" />
-          <folding>
-            <element signature="imports" expanded="true" />
-          </folding>
+        <state relative-caret-position="1326">
+          <caret line="78" column="27" selection-start-line="78" selection-start-column="27" selection-end-line="78" selection-end-column="27" />
         </state>
       </provider>
     </entry>
-    <entry file="file://$PROJECT_DIR$/src/main/java/net/javaguides/springboot/websocket/controller/RunController.java">
+    <entry file="file://$PROJECT_DIR$/src/main/resources/application.properties">
       <provider selected="true" editor-type-id="text-editor">
-        <state relative-caret-position="86">
-          <caret line="37" column="29" lean-forward="true" selection-start-line="37" selection-start-column="29" selection-end-line="37" selection-end-column="29" />
-          <folding>
-            <element signature="imports" expanded="true" />
-            <element signature="e#328#329#0" expanded="true" />
-            <element signature="e#371#372#0" expanded="true" />
-            <element signature="e#942#943#0" expanded="true" />
-            <element signature="e#999#1000#0" expanded="true" />
-          </folding>
+        <state relative-caret-position="17">
+          <caret line="1" selection-start-line="1" selection-end-line="1" />
         </state>
       </provider>
     </entry>
-    <entry file="file://$PROJECT_DIR$/src/main/java/net/javaguides/springboot/websocket/model/Run.java">
+    <entry file="file://$PROJECT_DIR$/src/main/java/net/javaguides/springboot/websocket/Application.java">
       <provider selected="true" editor-type-id="text-editor">
-        <state relative-caret-position="289">
-          <caret line="27" column="27" lean-forward="true" selection-start-line="16" selection-start-column="4" selection-end-line="27" selection-end-column="27" />
+        <state relative-caret-position="17">
+          <caret line="1" selection-start-line="1" selection-end-line="1" />
           <folding>
             <element signature="imports" expanded="true" />
           </folding>
         </state>
       </provider>
     </entry>
-    <entry file="file://$PROJECT_DIR$/src/main/java/net/javaguides/springboot/websocket/repository/RunRepository.java">
+    <entry file="file://$PROJECT_DIR$/src/main/java/net/javaguides/springboot/websocket/repository/ThirdApiRepository.java">
       <provider selected="true" editor-type-id="text-editor">
         <state relative-caret-position="102">
-          <caret line="6" column="23" selection-start-line="6" selection-start-column="23" selection-end-line="6" selection-end-column="23" />
+          <caret line="6" column="23" lean-forward="true" selection-start-line="6" selection-start-column="23" selection-end-line="6" selection-end-column="23" />
           <folding>
             <element signature="imports" expanded="true" />
           </folding>
         </state>
       </provider>
     </entry>
-    <entry file="file://$PROJECT_DIR$/src/main/java/net/javaguides/springboot/websocket/model/Race.java">
+    <entry file="file://$PROJECT_DIR$/src/main/java/net/javaguides/springboot/websocket/repository/PilotRepository.java">
       <provider selected="true" editor-type-id="text-editor">
-        <state relative-caret-position="238">
-          <caret line="14" column="13" selection-start-line="14" selection-start-column="13" selection-end-line="14" selection-end-column="13" />
+        <state relative-caret-position="119">
+          <caret line="7" column="67" selection-start-line="7" selection-start-column="33" selection-end-line="7" selection-end-column="67" />
           <folding>
             <element signature="imports" expanded="true" />
           </folding>
         </state>
       </provider>
     </entry>
-    <entry file="file://$PROJECT_DIR$/src/main/java/net/javaguides/springboot/websocket/config/WebSocketConfig.java">
+    <entry file="file://$PROJECT_DIR$/src/main/java/net/javaguides/springboot/websocket/model/ThirdApi.java">
       <provider selected="true" editor-type-id="text-editor">
-        <state relative-caret-position="288">
-          <caret line="22" column="1" selection-start-line="22" selection-start-column="1" selection-end-line="22" selection-end-column="1" />
+        <state relative-caret-position="216">
+          <caret line="17" column="23" selection-start-line="17" selection-start-column="23" selection-end-line="17" selection-end-column="23" />
           <folding>
             <element signature="imports" expanded="true" />
           </folding>
         </state>
       </provider>
     </entry>
-    <entry file="file://$PROJECT_DIR$/src/main/java/net/javaguides/springboot/websocket/Application.java">
-      <provider selected="true" editor-type-id="text-editor">
-        <state relative-caret-position="176">
-          <caret line="56" selection-start-line="56" selection-end-line="56" />
-        </state>
-      </provider>
-    </entry>
-    <entry file="file://$PROJECT_DIR$/src/main/java/net/javaguides/springboot/websocket/repository/PilotRepository.java">
+    <entry file="file://$PROJECT_DIR$/src/main/java/net/javaguides/springboot/websocket/model/Pilot.java">
       <provider selected="true" editor-type-id="text-editor">
-        <state relative-caret-position="119">
-          <caret line="7" column="69" lean-forward="true" selection-start-line="7" selection-start-column="69" selection-end-line="7" selection-end-column="69" />
+        <state relative-caret-position="272">
+          <caret line="16" column="20" selection-start-line="14" selection-start-column="4" selection-end-line="16" selection-end-column="20" />
           <folding>
             <element signature="imports" expanded="true" />
           </folding>
         </state>
       </provider>
     </entry>
     <entry file="file://$PROJECT_DIR$/src/main/java/net/javaguides/springboot/websocket/controller/UpdateController.java">
       <provider selected="true" editor-type-id="text-editor">
-        <state relative-caret-position="210">
-          <caret line="18" column="28" selection-start-line="18" selection-start-column="28" selection-end-line="18" selection-end-column="28" />
+        <state relative-caret-position="119">
+          <caret line="7" column="63" selection-start-line="7" selection-start-column="63" selection-end-line="7" selection-end-column="63" />
           <folding>
             <element signature="imports" expanded="true" />
           </folding>
         </state>
       </provider>
     </entry>
-    <entry file="file://$PROJECT_DIR$/src/main/java/net/javaguides/springboot/websocket/controller/CurrentPilotsController.java">
+    <entry file="file://$PROJECT_DIR$/src/main/java/net/javaguides/springboot/websocket/controller/ThirdApiController.java">
       <provider selected="true" editor-type-id="text-editor">
-        <state relative-caret-position="227">
-          <caret line="44" column="53" lean-forward="true" selection-start-line="44" selection-start-column="53" selection-end-line="44" selection-end-column="53" />
+        <state relative-caret-position="193">
+          <caret line="44" column="20" selection-start-line="44" selection-start-column="20" selection-end-line="44" selection-end-column="20" />
           <folding>
             <element signature="imports" expanded="true" />
+            <element signature="e#481#482#0" expanded="true" />
+            <element signature="e#525#526#0" expanded="true" />
+            <element signature="e#683#684#0" expanded="true" />
+            <element signature="e#726#727#0" expanded="true" />
           </folding>
         </state>
       </provider>
     </entry>
-    <entry file="file://$PROJECT_DIR$/src/main/java/net/javaguides/springboot/websocket/model/Pilot.java">
+    <entry file="file://$PROJECT_DIR$/src/main/java/net/javaguides/springboot/websocket/controller/PilotsController.java">
       <provider selected="true" editor-type-id="text-editor">
-        <state relative-caret-position="196">
-          <caret line="15" column="19" selection-start-line="15" selection-start-column="19" selection-end-line="15" selection-end-column="19" />
+        <state relative-caret-position="74">
+          <caret line="73" column="33" selection-start-line="73" selection-start-column="33" selection-end-line="73" selection-end-column="33" />
           <folding>
             <element signature="imports" expanded="true" />
+            <element signature="e#467#468#0" expanded="true" />
+            <element signature="e#511#512#0" expanded="true" />
+            <element signature="e#956#957#0" expanded="true" />
+            <element signature="e#1015#1016#0" expanded="true" />
+            <element signature="e#1301#1302#0" expanded="true" />
+            <element signature="e#1359#1360#0" expanded="true" />
           </folding>
         </state>
       </provider>
     </entry>
   </component>
   <component name="masterDetails">
     <states>
       <state key="ProjectJDKs.UI">
         <settings>
           <last-edited>1.8</last-edited>
           <splitter-proportions>
             <option name="proportions">
               <list>
                 <option value="0.2" />
               </list>
             </option>
           </splitter-proportions>
         </settings>
       </state>
     </states>
   </component>
 </project>
\ No newline at end of file
diff --git a/pom.xml b/pom.xml
index 448b9a8..ce06224 100644
--- a/pom.xml
+++ b/pom.xml
@@ -1,91 +1,97 @@
 <?xml version="1.0" encoding="UTF-8"?>
 <project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
          xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 https://maven.apache.org/xsd/maven-4.0.0.xsd">
     <modelVersion>4.0.0</modelVersion>
 
     <groupId>org.springframework</groupId>
     <artifactId>springboot-stomp-websocket</artifactId>
     <version>0.1.0</version>
 
     <parent>
         <groupId>org.springframework.boot</groupId>
         <artifactId>spring-boot-starter-parent</artifactId>
         <version>2.1.4.RELEASE</version>
     </parent>
 
     <dependencies>
         <dependency>
             <groupId>org.springframework.boot</groupId>
             <artifactId>spring-boot-starter-websocket</artifactId>
         </dependency>
 
         <dependency>
             <groupId>org.webjars</groupId>
             <artifactId>webjars-locator-core</artifactId>
         </dependency>
         <dependency>
             <groupId>org.webjars</groupId>
             <artifactId>sockjs-client</artifactId>
             <version>1.0.2</version>
         </dependency>
         <dependency>
             <groupId>org.webjars</groupId>
             <artifactId>stomp-websocket</artifactId>
             <version>2.3.3</version>
         </dependency>
         <dependency>
             <groupId>org.webjars</groupId>
             <artifactId>bootstrap</artifactId>
             <version>3.3.7</version>
         </dependency>
         <dependency>
             <groupId>org.webjars</groupId>
             <artifactId>jquery</artifactId>
             <version>3.1.0</version>
         </dependency>
 
         <dependency>
             <groupId>org.springframework.boot</groupId>
             <artifactId>spring-boot-starter-test</artifactId>
             <scope>test</scope>
         </dependency>
         <dependency>
             <groupId>org.springframework.boot</groupId>
             <artifactId>spring-boot-starter-data-jpa</artifactId>
         </dependency>
         <dependency>
             <groupId>com.h2database</groupId>
             <artifactId>h2</artifactId>
             <version>1.4.199</version>
         </dependency>
         <dependency>
             <groupId>org.projectlombok</groupId>
             <artifactId>lombok</artifactId>
             <version>1.18.6</version>
         </dependency>
         <dependency>
             <groupId>org.springframework.data</groupId>
             <artifactId>spring-data-rest-core</artifactId>
             <version>3.1.2.RELEASE</version>
         </dependency>
         <dependency>
             <groupId>com.fasterxml.jackson.core</groupId>
             <artifactId>jackson-databind</artifactId>
             <version>2.9.8</version>
         </dependency>
+        <dependency>
+            <groupId>mysql</groupId>
+            <artifactId>mysql-connector-java</artifactId>
+            <version>8.0.16</version>
+        </dependency>
+
     </dependencies>
 
     <properties>
         <java.version>1.8</java.version>
     </properties>
 
     <build>
         <plugins>
             <plugin>
                 <groupId>org.springframework.boot</groupId>
                 <artifactId>spring-boot-maven-plugin</artifactId>
             </plugin>
         </plugins>
     </build>
 
 </project>
diff --git a/springboot-stomp-websocket.iml b/springboot-stomp-websocket.iml
index 9a5d46f..fd80ac8 100644
--- a/springboot-stomp-websocket.iml
+++ b/springboot-stomp-websocket.iml
@@ -1,116 +1,117 @@
 <?xml version="1.0" encoding="UTF-8"?>
 <module org.jetbrains.idea.maven.project.MavenProjectsManager.isMavenModule="true" type="JAVA_MODULE" version="4">
   <component name="FacetManager">
     <facet type="Spring" name="Spring">
       <configuration />
     </facet>
     <facet type="web" name="Web">
       <configuration>
         <webroots />
       </configuration>
     </facet>
   </component>
   <component name="NewModuleRootManager" LANGUAGE_LEVEL="JDK_1_8">
     <output url="file://$MODULE_DIR$/target/classes" />
     <output-test url="file://$MODULE_DIR$/target/test-classes" />
     <content url="file://$MODULE_DIR$">
       <sourceFolder url="file://$MODULE_DIR$/src/main/java" isTestSource="false" />
       <sourceFolder url="file://$MODULE_DIR$/src/main/resources" type="java-resource" />
       <excludeFolder url="file://$MODULE_DIR$/target" />
     </content>
     <orderEntry type="inheritedJdk" />
     <orderEntry type="sourceFolder" forTests="false" />
     <orderEntry type="library" name="Maven: org.springframework.boot:spring-boot-starter-websocket:2.1.4.RELEASE" level="project" />
     <orderEntry type="library" name="Maven: org.springframework.boot:spring-boot-starter-web:2.1.4.RELEASE" level="project" />
     <orderEntry type="library" name="Maven: org.springframework.boot:spring-boot-starter-json:2.1.4.RELEASE" level="project" />
     <orderEntry type="library" name="Maven: com.fasterxml.jackson.datatype:jackson-datatype-jsr310:2.9.8" level="project" />
     <orderEntry type="library" name="Maven: com.fasterxml.jackson.module:jackson-module-parameter-names:2.9.8" level="project" />
     <orderEntry type="library" name="Maven: org.springframework.boot:spring-boot-starter-tomcat:2.1.4.RELEASE" level="project" />
     <orderEntry type="library" name="Maven: org.apache.tomcat.embed:tomcat-embed-core:9.0.17" level="project" />
     <orderEntry type="library" name="Maven: org.apache.tomcat.embed:tomcat-embed-el:9.0.17" level="project" />
     <orderEntry type="library" name="Maven: org.apache.tomcat.embed:tomcat-embed-websocket:9.0.17" level="project" />
     <orderEntry type="library" name="Maven: org.hibernate.validator:hibernate-validator:6.0.16.Final" level="project" />
     <orderEntry type="library" name="Maven: javax.validation:validation-api:2.0.1.Final" level="project" />
     <orderEntry type="library" name="Maven: org.springframework:spring-web:5.1.6.RELEASE" level="project" />
     <orderEntry type="library" name="Maven: org.springframework:spring-webmvc:5.1.6.RELEASE" level="project" />
     <orderEntry type="library" name="Maven: org.springframework:spring-expression:5.1.6.RELEASE" level="project" />
     <orderEntry type="library" name="Maven: org.springframework:spring-messaging:5.1.6.RELEASE" level="project" />
     <orderEntry type="library" name="Maven: org.springframework:spring-beans:5.1.6.RELEASE" level="project" />
     <orderEntry type="library" name="Maven: org.springframework:spring-websocket:5.1.6.RELEASE" level="project" />
     <orderEntry type="library" name="Maven: org.springframework:spring-context:5.1.6.RELEASE" level="project" />
     <orderEntry type="library" name="Maven: org.webjars:webjars-locator-core:0.35" level="project" />
     <orderEntry type="library" name="Maven: org.slf4j:slf4j-api:1.7.26" level="project" />
     <orderEntry type="library" name="Maven: org.apache.commons:commons-lang3:3.8.1" level="project" />
     <orderEntry type="library" name="Maven: org.apache.commons:commons-compress:1.9" level="project" />
     <orderEntry type="library" name="Maven: com.fasterxml.jackson.core:jackson-core:2.9.8" level="project" />
     <orderEntry type="library" name="Maven: org.webjars:sockjs-client:1.0.2" level="project" />
     <orderEntry type="library" name="Maven: org.webjars:stomp-websocket:2.3.3" level="project" />
     <orderEntry type="library" name="Maven: org.webjars:bootstrap:3.3.7" level="project" />
     <orderEntry type="library" name="Maven: org.webjars:jquery:3.1.0" level="project" />
     <orderEntry type="library" scope="TEST" name="Maven: org.springframework.boot:spring-boot-starter-test:2.1.4.RELEASE" level="project" />
     <orderEntry type="library" name="Maven: org.springframework.boot:spring-boot-starter:2.1.4.RELEASE" level="project" />
     <orderEntry type="library" name="Maven: org.springframework.boot:spring-boot:2.1.4.RELEASE" level="project" />
     <orderEntry type="library" name="Maven: org.springframework.boot:spring-boot-autoconfigure:2.1.4.RELEASE" level="project" />
     <orderEntry type="library" name="Maven: org.springframework.boot:spring-boot-starter-logging:2.1.4.RELEASE" level="project" />
     <orderEntry type="library" name="Maven: ch.qos.logback:logback-classic:1.2.3" level="project" />
     <orderEntry type="library" name="Maven: ch.qos.logback:logback-core:1.2.3" level="project" />
     <orderEntry type="library" name="Maven: org.apache.logging.log4j:log4j-to-slf4j:2.11.2" level="project" />
     <orderEntry type="library" name="Maven: org.apache.logging.log4j:log4j-api:2.11.2" level="project" />
     <orderEntry type="library" name="Maven: org.slf4j:jul-to-slf4j:1.7.26" level="project" />
     <orderEntry type="library" name="Maven: javax.annotation:javax.annotation-api:1.3.2" level="project" />
     <orderEntry type="library" scope="RUNTIME" name="Maven: org.yaml:snakeyaml:1.23" level="project" />
     <orderEntry type="library" scope="TEST" name="Maven: org.springframework.boot:spring-boot-test:2.1.4.RELEASE" level="project" />
     <orderEntry type="library" scope="TEST" name="Maven: org.springframework.boot:spring-boot-test-autoconfigure:2.1.4.RELEASE" level="project" />
     <orderEntry type="library" scope="TEST" name="Maven: com.jayway.jsonpath:json-path:2.4.0" level="project" />
     <orderEntry type="library" scope="TEST" name="Maven: net.minidev:json-smart:2.3" level="project" />
     <orderEntry type="library" scope="TEST" name="Maven: net.minidev:accessors-smart:1.2" level="project" />
     <orderEntry type="library" scope="TEST" name="Maven: org.ow2.asm:asm:5.0.4" level="project" />
     <orderEntry type="library" scope="TEST" name="Maven: junit:junit:4.12" level="project" />
     <orderEntry type="library" scope="TEST" name="Maven: org.assertj:assertj-core:3.11.1" level="project" />
     <orderEntry type="library" scope="TEST" name="Maven: org.mockito:mockito-core:2.23.4" level="project" />
     <orderEntry type="library" name="Maven: net.bytebuddy:byte-buddy:1.9.12" level="project" />
     <orderEntry type="library" scope="TEST" name="Maven: net.bytebuddy:byte-buddy-agent:1.9.12" level="project" />
     <orderEntry type="library" scope="TEST" name="Maven: org.objenesis:objenesis:2.6" level="project" />
     <orderEntry type="library" scope="TEST" name="Maven: org.hamcrest:hamcrest-core:1.3" level="project" />
     <orderEntry type="library" scope="TEST" name="Maven: org.hamcrest:hamcrest-library:1.3" level="project" />
     <orderEntry type="library" scope="TEST" name="Maven: org.skyscreamer:jsonassert:1.5.0" level="project" />
     <orderEntry type="library" scope="TEST" name="Maven: com.vaadin.external.google:android-json:0.0.20131108.vaadin1" level="project" />
     <orderEntry type="library" name="Maven: org.springframework:spring-core:5.1.6.RELEASE" level="project" />
     <orderEntry type="library" name="Maven: org.springframework:spring-jcl:5.1.6.RELEASE" level="project" />
     <orderEntry type="library" scope="TEST" name="Maven: org.springframework:spring-test:5.1.6.RELEASE" level="project" />
     <orderEntry type="library" scope="TEST" name="Maven: org.xmlunit:xmlunit-core:2.6.2" level="project" />
     <orderEntry type="library" name="Maven: org.springframework.boot:spring-boot-starter-data-jpa:2.1.4.RELEASE" level="project" />
     <orderEntry type="library" name="Maven: org.springframework.boot:spring-boot-starter-aop:2.1.4.RELEASE" level="project" />
     <orderEntry type="library" name="Maven: org.springframework:spring-aop:5.1.6.RELEASE" level="project" />
     <orderEntry type="library" name="Maven: org.aspectj:aspectjweaver:1.9.2" level="project" />
     <orderEntry type="library" name="Maven: org.springframework.boot:spring-boot-starter-jdbc:2.1.4.RELEASE" level="project" />
     <orderEntry type="library" name="Maven: com.zaxxer:HikariCP:3.2.0" level="project" />
     <orderEntry type="library" name="Maven: org.springframework:spring-jdbc:5.1.6.RELEASE" level="project" />
     <orderEntry type="library" name="Maven: javax.transaction:javax.transaction-api:1.3" level="project" />
     <orderEntry type="library" name="Maven: javax.xml.bind:jaxb-api:2.3.1" level="project" />
     <orderEntry type="library" name="Maven: javax.activation:javax.activation-api:1.2.0" level="project" />
     <orderEntry type="library" name="Maven: org.hibernate:hibernate-core:5.3.9.Final" level="project" />
     <orderEntry type="library" name="Maven: org.jboss.logging:jboss-logging:3.3.2.Final" level="project" />
     <orderEntry type="library" name="Maven: javax.persistence:javax.persistence-api:2.2" level="project" />
     <orderEntry type="library" name="Maven: org.javassist:javassist:3.23.1-GA" level="project" />
     <orderEntry type="library" name="Maven: antlr:antlr:2.7.7" level="project" />
     <orderEntry type="library" name="Maven: org.jboss:jandex:2.0.5.Final" level="project" />
     <orderEntry type="library" name="Maven: com.fasterxml:classmate:1.4.0" level="project" />
     <orderEntry type="library" name="Maven: org.dom4j:dom4j:2.1.1" level="project" />
     <orderEntry type="library" name="Maven: org.hibernate.common:hibernate-commons-annotations:5.0.4.Final" level="project" />
     <orderEntry type="library" name="Maven: org.springframework.data:spring-data-jpa:2.1.6.RELEASE" level="project" />
     <orderEntry type="library" name="Maven: org.springframework:spring-orm:5.1.6.RELEASE" level="project" />
     <orderEntry type="library" name="Maven: org.springframework:spring-aspects:5.1.6.RELEASE" level="project" />
     <orderEntry type="library" name="Maven: com.h2database:h2:1.4.199" level="project" />
     <orderEntry type="library" name="Maven: org.projectlombok:lombok:1.18.6" level="project" />
     <orderEntry type="library" name="Maven: org.springframework.data:spring-data-rest-core:3.1.2.RELEASE" level="project" />
     <orderEntry type="library" name="Maven: org.springframework:spring-tx:5.1.6.RELEASE" level="project" />
     <orderEntry type="library" name="Maven: org.springframework.hateoas:spring-hateoas:0.25.1.RELEASE" level="project" />
     <orderEntry type="library" name="Maven: org.springframework.data:spring-data-commons:2.1.6.RELEASE" level="project" />
     <orderEntry type="library" name="Maven: org.springframework.plugin:spring-plugin-core:1.2.0.RELEASE" level="project" />
     <orderEntry type="library" name="Maven: org.atteo:evo-inflector:1.2.2" level="project" />
     <orderEntry type="library" name="Maven: com.fasterxml.jackson.core:jackson-annotations:2.9.0" level="project" />
     <orderEntry type="library" name="Maven: com.fasterxml.jackson.datatype:jackson-datatype-jdk8:2.9.8" level="project" />
     <orderEntry type="library" name="Maven: com.fasterxml.jackson.core:jackson-databind:2.9.8" level="project" />
+    <orderEntry type="library" name="Maven: mysql:mysql-connector-java:8.0.16" level="project" />
   </component>
 </module>
\ No newline at end of file
diff --git a/src/main/java/net/javaguides/springboot/websocket/Application.java b/src/main/java/net/javaguides/springboot/websocket/Application.java
index 799526f..b676a00 100644
--- a/src/main/java/net/javaguides/springboot/websocket/Application.java
+++ b/src/main/java/net/javaguides/springboot/websocket/Application.java
@@ -1,61 +1,13 @@
 package net.javaguides.springboot.websocket;
 
-import net.javaguides.springboot.websocket.model.Pilot;
-import net.javaguides.springboot.websocket.repository.PilotRepository;
-import org.springframework.boot.ApplicationRunner;
 import org.springframework.boot.SpringApplication;
 import org.springframework.boot.autoconfigure.SpringBootApplication;
-import org.springframework.context.annotation.Bean;
-
-import java.util.stream.Stream;
 
 @SpringBootApplication
 public class Application {
 
     public static void main(String[] args) {
         SpringApplication.run(Application.class, args);
     }
 
-    private int judge = 0;
-    private int id = 8;
-
-    @Bean
-    ApplicationRunner init(PilotRepository pilotRepository) {
-        return args -> {
-
-            /*
-
-            id = 8;
-
-            judge = 0;
-            Stream.of("azefkjl", "Caover", "azlkef", "azek").forEach(name -> {
-                judge += 1;
-                id += 1;
-                Pilot pilot = new Pilot();
-                pilot.setNickname(name);
-                pilot.setCurrent("current");
-                pilot.setRun("2");
-                pilot.setSeat(judge);
-                pilot.setPilotId(id);
-                pilotRepository.save(pilot);
-            });
-
-            judge = 0;
-            Stream.of("Darkex", "Captain Vanover", "Remco", "BLS").forEach(name -> {
-                judge += 1;
-                id += 1;
-                Pilot pilot = new Pilot();
-                pilot.setNickname(name);
-                pilot.setCurrent("passed");
-                pilot.setRun("1");
-                pilot.setSeat(judge);
-                pilot.setPilotId(id);
-                pilotRepository.save(pilot);
-            });
-
-            pilotRepository.findAll().forEach(System.out::println);
-
-             */
-        };
-    }
 }
diff --git a/src/main/java/net/javaguides/springboot/websocket/controller/CurrentPilotsController.java b/src/main/java/net/javaguides/springboot/websocket/controller/PilotsController.java
similarity index 62%
rename from src/main/java/net/javaguides/springboot/websocket/controller/CurrentPilotsController.java
rename to src/main/java/net/javaguides/springboot/websocket/controller/PilotsController.java
index 55ad0a7..e49035b 100644
--- a/src/main/java/net/javaguides/springboot/websocket/controller/CurrentPilotsController.java
+++ b/src/main/java/net/javaguides/springboot/websocket/controller/PilotsController.java
@@ -1,49 +1,83 @@
 package net.javaguides.springboot.websocket.controller;
 
 import net.javaguides.springboot.websocket.model.Pilot;
 import net.javaguides.springboot.websocket.repository.PilotRepository;
 import org.springframework.web.bind.annotation.*;
-
-import java.util.ArrayList;
 import java.util.Collection;
 import java.util.stream.Collectors;
 
+/**
+ * Manage all pilots
+ */
 @RestController
-public class CurrentPilotsController {
+public class PilotsController {
     private PilotRepository repository;
 
-    public CurrentPilotsController(PilotRepository repository) {
+    public PilotsController(PilotRepository repository) {
         this.repository = repository;
     }
 
+    /**
+     * Get current pilots from bdd
+     * @return list of current pilots
+     */
     @GetMapping("/getCurrentPilots")
     @CrossOrigin
     public Collection<Pilot> getCurrentPilots() {
         return repository.findAll().stream()
                 .filter(this::isCurrent)
                 .collect(Collectors.toList());
     }
 
+    /**
+     * Filter on pilot list
+     * @param pilot
+     * @return pilot only if it is a current pilot
+     */
     private boolean isCurrent(Pilot pilot) {
         return pilot.getCurrent().equals("current");
     }
 
+    /**
+     * Get passed pilots from bdd
+     * @return list of passed pilots
+     */
     @GetMapping("/getPassedPilots")
     @CrossOrigin
     public Collection<Pilot> getPassedPilots() {
         return repository.findAll().stream()
                 .filter(this::isPassed)
                 .collect(Collectors.toList());
     }
 
+    /**
+     * Filter on pilot list
+     * @param pilot
+     * @return pilot only if it is a passed pilot
+     */
     private boolean isPassed(Pilot pilot) {
         return pilot.getCurrent().equals("passed");
     }
 
+    /**
+     * Save pilot in bdd
+     * @param pilot
+     */
     @PostMapping(path = "/savePilot", consumes = "application/json", produces = "application/json")
     @CrossOrigin
     public void savePilot(@RequestBody Pilot pilot) {
         repository.save(pilot);
         System.out.println(pilot);
     }
+
+    /**
+     * Delete all pilots from bdd
+     * @return
+     */
+    @GetMapping("/clearPilots")
+    @CrossOrigin
+    public boolean clearPilots() {
+        repository.deleteAll();
+        return true;
+    }
 }
diff --git a/src/main/java/net/javaguides/springboot/websocket/controller/ThirdApiController.java b/src/main/java/net/javaguides/springboot/websocket/controller/ThirdApiController.java
new file mode 100644
index 0000000..f9b6e14
--- /dev/null
+++ b/src/main/java/net/javaguides/springboot/websocket/controller/ThirdApiController.java
@@ -0,0 +1,53 @@
+package net.javaguides.springboot.websocket.controller;
+
+import net.javaguides.springboot.websocket.model.ThirdApi;
+import net.javaguides.springboot.websocket.repository.ThirdApiRepository;
+import org.springframework.http.MediaType;
+import org.springframework.web.bind.annotation.*;
+
+import java.util.Collection;
+
+/**
+ * Manage the API in bdd
+ */
+@RestController
+public class ThirdApiController {
+    private ThirdApiRepository repository;
+
+    public ThirdApiController(ThirdApiRepository repository) {
+        this.repository = repository;
+    }
+
+    /**
+     * GetThirdApi
+     * @return the Api from bdd
+     */
+    @GetMapping("/getThirdApi")
+    @CrossOrigin
+    public Collection<ThirdApi> getThirdApi() {
+        return repository.findAll();
+    }
+
+    /**
+     * Delete the api in bdd and save new api
+     * @param api
+     */
+    @PostMapping(path = "/saveThirdApi", consumes = MediaType.APPLICATION_JSON_VALUE , produces = "application/json")
+    @CrossOrigin
+    public void saveThirdApi(@RequestBody ThirdApi api) {
+        repository.deleteAll();
+        repository.save(api);
+        System.out.println(api);
+    }
+
+    /**
+     * Delete api in bdd
+     * @return true
+     */
+    @GetMapping("/deleteThirdApi")
+    @CrossOrigin
+    public boolean deleteThirdApi() {
+        repository.deleteAll();
+        return true;
+    }
+}
diff --git a/src/main/java/net/javaguides/springboot/websocket/controller/UpdateController.java b/src/main/java/net/javaguides/springboot/websocket/controller/UpdateController.java
index 843bc4e..c5d22b7 100644
--- a/src/main/java/net/javaguides/springboot/websocket/controller/UpdateController.java
+++ b/src/main/java/net/javaguides/springboot/websocket/controller/UpdateController.java
@@ -1,21 +1,34 @@
 package net.javaguides.springboot.websocket.controller;
 
 import org.springframework.messaging.handler.annotation.MessageMapping;
 import org.springframework.messaging.handler.annotation.SendTo;
 import org.springframework.stereotype.Controller;
 
+/**
+ * Update controller manage websocket message to notify clients
+ */
 @Controller
 public class UpdateController {
 
+    /**
+     * Receive "updateCurrent" message and notify all connected client "updateCurrent"
+     * @return "updateCurrent"
+     * @throws Exception
+     */
     @MessageMapping("/updateCurrent")
     @SendTo("/data/update")
     public String updateCurrent() throws Exception {
         return "updateCurrent";
     }
 
+    /**
+     * Receive "updatePassed" message and notify all connected client "updatePassed"
+     * @return "updatePassed"
+     * @throws Exception
+     */
     @MessageMapping("/updatePassed")
     @SendTo("/data/update")
     public String updatePassed() throws Exception {
         return "updatePassed";
     }
 }
diff --git a/src/main/java/net/javaguides/springboot/websocket/model/ThirdApi.java b/src/main/java/net/javaguides/springboot/websocket/model/ThirdApi.java
new file mode 100644
index 0000000..e7aabf3
--- /dev/null
+++ b/src/main/java/net/javaguides/springboot/websocket/model/ThirdApi.java
@@ -0,0 +1,19 @@
+package net.javaguides.springboot.websocket.model;
+
+import lombok.Data;
+import lombok.NoArgsConstructor;
+import lombok.NonNull;
+
+import javax.persistence.Entity;
+import javax.persistence.GeneratedValue;
+import javax.persistence.Id;
+
+@Entity
+@Data
+@NoArgsConstructor
+public class ThirdApi {
+    @Id
+    @GeneratedValue
+    private Long id;
+    private String url;
+}
diff --git a/src/main/java/net/javaguides/springboot/websocket/repository/ThirdApiRepository.java b/src/main/java/net/javaguides/springboot/websocket/repository/ThirdApiRepository.java
new file mode 100644
index 0000000..b5ae14d
--- /dev/null
+++ b/src/main/java/net/javaguides/springboot/websocket/repository/ThirdApiRepository.java
@@ -0,0 +1,9 @@
+package net.javaguides.springboot.websocket.repository;
+
+import net.javaguides.springboot.websocket.model.ThirdApi;
+import org.springframework.data.jpa.repository.JpaRepository;
+import org.springframework.data.rest.core.annotation.RepositoryRestResource;
+
+@RepositoryRestResource
+public interface ThirdApiRepository extends JpaRepository<ThirdApi, Long> {
+}
diff --git a/src/main/resources/application.properties b/src/main/resources/application.properties
new file mode 100644
index 0000000..edf3b57
--- /dev/null
+++ b/src/main/resources/application.properties
@@ -0,0 +1,15 @@
+server.port 8080
+
+spring.jpa.database-platform=org.hibernate.dialect.MySQL5InnoDBDialect
+spring.jpa.hibernate.ddl-auto=update
+spring.datasource.driverClassName=com.mysql.cj.jdbc.Driver
+spring.datasource.url=jdbc:mysql://localhost:3306/myrace?serverTimezone=Europe/Paris
+spring.datasource.username=root
+spring.datasource.password=
+
+
+
+
+# Configurations H2
+spring.jpa.show-sql=true
+spring.h2.console.enabled=true
\ No newline at end of file