lehungio · June 6, 2019 23:43 · Mar 18, 2017 · Mar 18, 2017 · Mar 18, 2017 · Mar 18, 2017
diff --git a/connectorj-mysql-integration.md b/connectorj-mysql-integration.md
@@ -1,11 +1,13 @@
 Read through: https://www.digitalocean.com/community/tutorials/how-to-install-java-with-apt-get-on-ubuntu-16-04
+
 Then install Oracle Java 8:
 
     sudo add-apt-repository ppa:webupd8team/java
     sudo apt-get update
     sudo apt-get install oracle-java8-installer
 
 Read through: https://help.ubuntu.com/community/JDBCAndMySQL
+
 Then install the connector driver:
 
     sudo apt-get install libmysql-java

diff --git a/connectorj-mysql-integration.md b/connectorj-mysql-integration.md
@@ -1,12 +1,12 @@
 Read through: https://www.digitalocean.com/community/tutorials/how-to-install-java-with-apt-get-on-ubuntu-16-04
-
 Then install Oracle Java 8:
 
     sudo add-apt-repository ppa:webupd8team/java
     sudo apt-get update
     sudo apt-get install oracle-java8-installer
 
-Install the connector driver - https://help.ubuntu.com/community/JDBCAndMySQL:
+Read through: https://help.ubuntu.com/community/JDBCAndMySQL
+Then install the connector driver:
 
     sudo apt-get install libmysql-java
 
@@ -67,7 +67,7 @@ If you get the error:
 
 Check out: http://stackoverflow.com/questions/36746677/table-performance-schema-session-variables-doesnt-exist
 
-I needed to run:
+I personally needed to run:
 
     mysql_upgrade -u root -p --force
 

diff --git a/connectorj-mysql-integration.md b/connectorj-mysql-integration.md
@@ -1,4 +1,6 @@
-Install Oracle Java 8 - https://www.digitalocean.com/community/tutorials/how-to-install-java-with-apt-get-on-ubuntu-16-04:
+Read through: https://www.digitalocean.com/community/tutorials/how-to-install-java-with-apt-get-on-ubuntu-16-04
+
+Then install Oracle Java 8:
 
     sudo add-apt-repository ppa:webupd8team/java
     sudo apt-get update

diff --git a/connectorj-mysql-integration.md b/connectorj-mysql-integration.md
@@ -72,4 +72,6 @@ I needed to run:
 And then:
 
     echo "# JDBC Connection error
-    performance_schema=ON" >> /etc/mysql/mysql.conf.d/mysqld.cnf
+    performance_schema=ON" >> /etc/mysql/mysql.conf.d/mysqld.cnf
+
+You can make use of this to setup a data pipeline between MySQL and Amazon ElasticService by following these instructions here: https://gist.github.com/craigvantonder/8566c6992b930e7d2ac2520e18516e4d
diff --git a/mysql-connectorj-integration.md → connectorj-mysql-integration.md b/mysql-connectorj-integration.md → connectorj-mysql-integration.md
diff --git a/mysql-connectorj-integration.md b/mysql-connectorj-integration.md
@@ -1,6 +1,8 @@
-Install Java SDK and Runtime environment - https://www.digitalocean.com/community/tutorials/how-to-install-java-with-apt-get-on-ubuntu-16-04:
+Install Oracle Java 8 - https://www.digitalocean.com/community/tutorials/how-to-install-java-with-apt-get-on-ubuntu-16-04:
 
-    sudo apt-get install default-jdk
+    sudo add-apt-repository ppa:webupd8team/java
+    sudo apt-get update
+    sudo apt-get install oracle-java8-installer
 
 Install the connector driver - https://help.ubuntu.com/community/JDBCAndMySQL:
 
@@ -60,13 +62,13 @@ Run the test:
 If you get the error:
 
     Exception in thread "main" com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'performance_schema.session_variables' doesn't exist
-    
+
 Check out: http://stackoverflow.com/questions/36746677/table-performance-schema-session-variables-doesnt-exist
- 
-I needed to run: 
+
+I needed to run:
 
     mysql_upgrade -u root -p --force
-    
+
 And then:
 
     echo "# JDBC Connection error

diff --git a/mysql-connectorj-integration.md b/mysql-connectorj-integration.md
@@ -55,4 +55,19 @@ Compile the test:
 
 Run the test:
 
-    java DBDemo
+    java DBDemo
+
+If you get the error:
+
+    Exception in thread "main" com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'performance_schema.session_variables' doesn't exist
+
+Check out: http://stackoverflow.com/questions/36746677/table-performance-schema-session-variables-doesnt-exist
+
+I needed to run: 
+
+    mysql_upgrade -u root -p --force
+
+And then:
+
+    echo "# JDBC Connection error
+    performance_schema=ON" >> /etc/mysql/mysql.conf.d/mysqld.cnf
diff --git a/mysql-connectorj-integration.md b/mysql-connectorj-integration.md
@@ -26,7 +26,7 @@ Create a test script:
       // by adding (say) ?user=craig&password=craig. Not recommended!
 
       private static final String CONNECTION =
-                              \"jdbc:mysql://127.0.0.1/mydatabase\";
+                              \"jdbc:mysql://localhost:3306/mydatabase\";
 
       public static void main(String[] args) throws
                                  ClassNotFoundException,SQLException

diff --git a/mysql-connectorj-integration.md b/mysql-connectorj-integration.md
@@ -9,7 +9,7 @@ Install the connector driver - https://help.ubuntu.com/community/JDBCAndMySQL:
 Set classpath globally:
 
     echo "# Set classpath for JDBC & MySQL
-    export CLASSPATH=$CLASSPATH:/usr/share/java/mysql.jar" >> /etc/environment
+    CLASSPATH=\".:/usr/share/java/mysql.jar\"" >> /etc/environment
 
 Create a test script:
 

diff --git a/mysql-connectorj-integration.md b/mysql-connectorj-integration.md
@@ -1,9 +1,8 @@
-
 Install Java SDK and Runtime environment - https://www.digitalocean.com/community/tutorials/how-to-install-java-with-apt-get-on-ubuntu-16-04:
 
     sudo apt-get install default-jdk
 
-Install the connector driver - http://www.wottageek.com/2015/07/how-to-set-up-mysqljdbc-on-ubuntu.html:
+Install the connector driver - https://help.ubuntu.com/community/JDBCAndMySQL:
 
     sudo apt-get install libmysql-java
 
@@ -14,33 +13,46 @@ Set classpath globally:
 
 Create a test script:
 
-    echo "import java.sql.Connection;
-    import java.sql.DriverManager;
+    echo "import java.sql.*;
+    import java.util.Properties;
+
+    public class DBDemo
+    {
+      // The JDBC Connector Class.
+      private static final String dbClassName = \"com.mysql.jdbc.Driver\";
 
-    class JDBCTest {
+      // Connection string. mydatabase is the database the program
+      // is connecting to. You can include user and password after this
+      // by adding (say) ?user=craig&password=craig. Not recommended!
 
-        String url = \"jdbc:mysql://localhost\";
+      private static final String CONNECTION =
+                              \"jdbc:mysql://127.0.0.1/mydatabase\";
 
-        String user = \"username\";
+      public static void main(String[] args) throws
+                                 ClassNotFoundException,SQLException
+      {
+        System.out.println(dbClassName);
+        // Class.forName(xxx) loads the jdbc classes and
+        // creates a drivermanager class factory
+        Class.forName(dbClassName);
 
-        String password = \"password\";
+        // Properties for user and password. Here the user and password are both 'craig'
+        Properties p = new Properties();
+        p.put(\"user\",\"craig\");
+        p.put(\"password\",\"craig\");
 
-        public static void main(String args[]) {
+        // Now try to connect
+        Connection c = DriverManager.getConnection(CONNECTION,p);
 
-            try {
-                Connection con;
-                con = DriverManager.getConnection(url, user, password);
-                System.out.println(\"Success\");
-            } catch (Exception e) {
-                e.printStackTrace();
-            }
+        System.out.println(\"It works !\");
+        c.close();
         }
-    }" > JDBCTest.java
+    }" > DBDemo.java
 
 Compile the test:
 
-    javac JDBCTest.java
+    javac DBDemo.java
 
 Run the test:
 
-    java JDBCTest
+    java DBDemo
diff --git a/mysql-connectorj-integration.md b/mysql-connectorj-integration.md
@@ -10,7 +10,7 @@ Install the connector driver - http://www.wottageek.com/2015/07/how-to-set-up-my
 Set classpath globally:
 
     echo "# Set classpath for JDBC & MySQL
-    export CLASSPATH=$CLASSPATH:/usr/share/java/mysql-connector-java.jar" >> /etc/environment
+    export CLASSPATH=$CLASSPATH:/usr/share/java/mysql.jar" >> /etc/environment
 
 Create a test script:
 

diff --git a/mysql-connectorj-integration.md b/mysql-connectorj-integration.md
@@ -0,0 +1,46 @@
+
+Install Java SDK and Runtime environment - https://www.digitalocean.com/community/tutorials/how-to-install-java-with-apt-get-on-ubuntu-16-04:
+
+    sudo apt-get install default-jdk
+
+Install the connector driver - http://www.wottageek.com/2015/07/how-to-set-up-mysqljdbc-on-ubuntu.html:
+
+    sudo apt-get install libmysql-java
+
+Set classpath globally:
+
+    echo "# Set classpath for JDBC & MySQL
+    export CLASSPATH=$CLASSPATH:/usr/share/java/mysql-connector-java.jar" >> /etc/environment
+
+Create a test script:
+
+    echo "import java.sql.Connection;
+    import java.sql.DriverManager;
+
+    class JDBCTest {
+
+        String url = \"jdbc:mysql://localhost\";
+
+        String user = \"username\";
+
+        String password = \"password\";
+
+        public static void main(String args[]) {
+
+            try {
+                Connection con;
+                con = DriverManager.getConnection(url, user, password);
+                System.out.println(\"Success\");
+            } catch (Exception e) {
+                e.printStackTrace();
+            }
+        }
+    }" > JDBCTest.java
+
+Compile the test:
+
+    javac JDBCTest.java
+
+Run the test:
+
+    java JDBCTest
No results found