Moved from MySQL to PostgreSQL; Prepared for production

olegshan · olegshan · commit 2ef9e06de13d · 2016-10-16T22:22:51.000+03:00
diff --git a/pom.xml b/pom.xml
@@ -40,13 +40,18 @@
             <artifactId>spring-boot-starter-data-jpa</artifactId>
         </dependency>
 
+        <!--<dependency>
+            <groupId>org.springframework.boot</groupId>
+            <artifactId>spring-boot-starter-tomcat</artifactId>
+            <scope>provided</scope>
+        </dependency>-->
+
         <dependency>
-            <groupId>mysql</groupId>
-            <artifactId>mysql-connector-java</artifactId>
-            <version>6.0.4</version>
+            <groupId>org.postgresql</groupId>
+            <artifactId>postgresql</artifactId>
+            <version>9.4.1211.jre7</version>
         </dependency>
 
-
         <dependency>
             <groupId>org.springframework.boot</groupId>
             <artifactId>spring-boot-starter-test</artifactId>
@@ -71,5 +76,4 @@
         </plugins>
     </build>
 
-
 </project>
diff --git a/src/main/java/com/olegshan/JobParserApplication.java b/src/main/java/com/olegshan/JobParserApplication.java
@@ -2,14 +2,20 @@
 
 import org.springframework.boot.SpringApplication;
 import org.springframework.boot.autoconfigure.SpringBootApplication;
+import org.springframework.boot.builder.SpringApplicationBuilder;
+import org.springframework.boot.web.support.SpringBootServletInitializer;
 import org.springframework.scheduling.annotation.EnableScheduling;
 
 @EnableScheduling
 @SpringBootApplication
-public class JobParserApplication {
+public class JobParserApplication extends SpringBootServletInitializer {
 
     public static void main(String[] args) {
         SpringApplication.run(JobParserApplication.class, args);
+    }
 
+    @Override
+    protected SpringApplicationBuilder configure(SpringApplicationBuilder builder) {
+        return builder.sources(JobParserApplication.class);
     }
 }
diff --git a/src/main/java/com/olegshan/entity/Doc.java b/src/main/java/com/olegshan/entity/Doc.java
@@ -12,7 +12,8 @@ public class Doc {
 
     @Id
     String name;
-    @Column(length = Integer.MAX_VALUE)
+//    @Column(length = Integer.MAX_VALUE)
+    @Column(length = 10485760)
     String doc;
 
     public Doc() {
diff --git a/src/main/java/com/olegshan/entity/Job.java b/src/main/java/com/olegshan/entity/Job.java
@@ -15,7 +15,8 @@ public class Job {
     @Id
     private String url;
     private String title;
-    @Column(length = Integer.MAX_VALUE)
+//    @Column(length = Integer.MAX_VALUE)
+    @Column(length = 10485760)
     private String description;
     private String company;
     private String source;
diff --git a/src/main/resources/application.properties b/src/main/resources/application.properties
@@ -1,8 +1,13 @@
-spring.datasource.url = jdbc:mysql://localhost:3306/jparser
-spring.datasource.username = root
+spring.datasource.url = jdbc:postgresql://localhost:5432/jparser
+spring.datasource.username = postgres
 spring.datasource.password = root
-spring.datasource.testWhileIdle = true
-spring.datasource.validationQuery = SELECT 1
 spring.jpa.show-sql = true
 spring.jpa.hibernate.ddl-auto = update
-spring.jpa.properties.hibernate.dialect = org.hibernate.dialect.MySQL5Dialect
+
+#spring.datasource.url = jdbc:postgresql://${RDS_HOSTNAME}:${RDS_PORT}/${RDS_DB_NAME}
+#spring.datasource.username = ${RDS_USERNAME}
+#spring.datasource.password = ${RDS_PASSWORD}
+#spring.thymeleaf.encoding=UTF-8
+#spring.jpa.hibernate.ddl-auto = update
+#spring.resources.chain.strategy.content.enabled=true
+#spring.resources.chain.strategy.content.paths=/**
