Fix for java to allow password, european dates,from Peter T Mount

1 files changed, 96 insertions, 50 deletions

diff --git a/src/interfaces/jdbc/JDBC_Test.java b/src/interfaces/jdbc/JDBC_Test.java
index 30cda33304a..2453e4ca949 100644
--- a/src/interfaces/jdbc/JDBC_Test.java
+++ b/src/interfaces/jdbc/JDBC_Test.java
@@ -4,58 +4,104 @@ import java.sql.*;
 
 class JDBC_Test
 {
-        public JDBC_Test() 
+  public JDBC_Test() 
+  {
+  }
+  
+  public static void main(String argv[])
+  {
+    String url = new String(argv[0]);
+    String usr = new String(argv[1]);
+    String pwd = new String(argv[2]);
+    Connection db;
+    Statement s;
+    ResultSet rs;
+    
+    // This line outputs debug information to stderr. To enable this, simply
+    // remove the //
+    DriverManager.setLogStream(System.err);
+    
+    // Load the driver
+    try {
+      Class.forName("postgresql.Driver");
+    } catch (ClassNotFoundException e) {
+      System.err.println("Exception: " + e.toString());
+    }
+    
+    // Lets do a few things -- it doesn't do everything, but
+    // it tests out basic functionality
+    try {
+      System.out.println("Connecting to Database URL = " + url);
+      db = DriverManager.getConnection(url, usr, pwd);
+      System.out.println("Connected...Now creating a statement");
+      s = db.createStatement();
+      
+      // test Date & Warnings
+      System.out.println("Ok... now set European date style");
+      s.executeUpdate("set datestyle='european'");
+      
+      System.out.println("and see what style we are now using (handled by warnings)");
+      s.executeUpdate("show datestyle");
+      SQLWarning sw = db.getWarnings();
+      while(sw!=null) {
+	System.out.println("--> "+sw.getMessage());
+	sw=sw.getNextWarning();
+      }
+      db.clearWarnings();
+      
+      System.out.println("Ok...now we will create a table");
+      s.executeUpdate("create table test (a int2, b int2,c timestamp,d date)");
+      
+      System.out.println("Now we will insert some columns");
+      s.executeUpdate("insert into test values (1, 1,'now','now')");
+      s.executeUpdate("insert into test values (2, 1,'now','01-11-1997')"); // As we are in european, this should mean 1 November 1997
+      s.executeUpdate("insert into test values (3, 1,'now','11-01-1997')"); // As we are in european, this should mean 11 January 1997
+      System.out.println("Inserted some data");
+      
+      System.out.println("Now lets try a select");
+      rs = s.executeQuery("select a, b,c,d from test");
+      System.out.println("Back from the select...the following are results");
+      System.out.println("row	a	b	c                    	d          'd as string'");
+      int i = 0;
+      while (rs.next())
 	{
+	  int a = rs.getInt("a");	// Example of retriving by column name
+	  int b = rs.getInt("b");
+	  Timestamp c = rs.getTimestamp(3); // Example of by column number
+	  java.sql.Date d = rs.getDate(4);  // Note, java.sql.Date here
+	  System.out.println("row " + i + "	" + a + "	" + b + "	" + c + "	" + d + " '"+rs.getString(4)+"'");
+	  i++;
 	}
-
-	public static void main(String argv[])
+      
+      // This is a bug at the moment... when you use set datestyle
+      // it must be followed by show datestyle
+      System.out.println("Now switch to US date format");
+      s.executeUpdate("set datestyle='US'");
+      s.executeUpdate("show datestyle");
+      
+      System.out.println("Now lets try a select");
+      rs = s.executeQuery("select a, b,c,d from test");
+      System.out.println("Back from the select...the following are results");
+      //int i = 0;
+      System.out.println("row	a	b	c                    	d          'd as string'");
+      while (rs.next())
 	{
-		String url = new String(argv[0]);
-		Connection db;
-		Statement s;
-		ResultSet rs;
-
-		// Load the driver
-		try
-		{
-			Class.forName("postgresql.Driver");
-		} catch (ClassNotFoundException e) {
-			System.err.println("Exception: " + e.toString());
-		}
-
-		// Lets do a few things -- it doesn't do everything, but
-		// it tests out basic functionality
-		try
-		{
-		System.out.println("Connecting to Database URL = " + url);
-		db = DriverManager.getConnection(url, "adrian", "");
-		System.out.println("Connected...Now creating a statement");
-		s = db.createStatement();
-		System.out.println("Ok...now we will create a table");
-		s.executeUpdate("create table test (a int2, b int2)");
-		System.out.println("Now we will insert some columns");
-		s.executeUpdate("insert into test values (1, 1)");
-		s.executeUpdate("insert into test values (2, 1)");
-		s.executeUpdate("insert into test values (3, 1)");
-		System.out.println("Inserted some data");
-		System.out.println("Now lets try a select");
-		rs = s.executeQuery("select a, b from test");
-		System.out.println("Back from the select...the following are results");
-		int i = 0;
-		while (rs.next())
-		{
-			int a = rs.getInt("a");
-			int b = rs.getInt("b");
-			System.out.println("row " + i + "	" + a + "	" + b);
-			i++;
-		}
-		System.out.println("Ok...dropping the table");
-		s.executeUpdate("drop table test");
-		System.out.println("Now closing the connection");
-		s.close();
-		db.close();
-		} catch (SQLException e) {
-		System.out.println("Exception: " + e.toString());
-		}
+	  int a = rs.getInt("a");	// Example of retriving by column name
+	  int b = rs.getInt("b");
+	  Timestamp c = rs.getTimestamp(3); // Example of by column number
+	  java.sql.Date d = rs.getDate(4);  // Note, java.sql.Date here
+	  System.out.println("row " + i + "	" + a + "	" + b + "	" + c + "	" + d + " '"+rs.getString(4)+"'");
+	  i++;
 	}
+      
+      System.out.println("Ok...dropping the table");
+      s.executeUpdate("drop table test");
+      
+      System.out.println("Now closing the connection");
+      s.close();
+      db.close();
+    } catch (SQLException e) {
+      System.out.println("Exception: " + e.toString());
+    }
+  }
 }