postgresql-jdbc.git / summary / log / commit / refs

commit    52d215d31ea3d01db3b9461ff9bdf539ca67fa70
Author:   Kris Jurka <books@ejurka.com>
Date:     Tue Sep 30 04:36:10 2008 +0000

    Forgot to add this test case in the previous commit.


 org/postgresql/test/jdbc4/UUIDTest.java | 61 +++++++++++++++++++++++++++++++++
 1 file changed, 61 insertions(+)

diff --git a/org/postgresql/test/jdbc4/UUIDTest.java b/org/postgresql/test/jdbc4/UUIDTest.java
new file mode 100644
index 00000000..29af2e7d
--- /dev/null
+++ b/org/postgresql/test/jdbc4/UUIDTest.java
@@ -0,0 +1,61 @@
+/*-------------------------------------------------------------------------
+*
+* Copyright (c) 2007-2008, PostgreSQL Global Development Group
+*
+* IDENTIFICATION
+*   $PostgreSQL$
+*
+*-------------------------------------------------------------------------
+*/
+package org.postgresql.test.jdbc4;
+
+import java.sql.*;
+import java.util.UUID;
+
+import junit.framework.TestCase;
+
+import org.postgresql.test.TestUtil;
+
+public class UUIDTest extends TestCase {
+
+    private Connection _conn;
+
+    public UUIDTest(String name) {
+        super(name);
+    }
+
+    protected void setUp() throws Exception {
+        _conn = TestUtil.openDB();
+        Statement stmt = _conn.createStatement();
+        stmt.execute("CREATE TEMP TABLE uuidtest(id uuid)");
+        stmt.close();
+    }
+
+    protected void tearDown() throws SQLException {
+        Statement stmt = _conn.createStatement();
+        stmt.execute("DROP TABLE uuidtest");
+        stmt.close();
+        TestUtil.closeDB(_conn);
+    }
+
+    public void testUUID() throws SQLException {
+        UUID uuid = UUID.randomUUID();
+        PreparedStatement ps = _conn.prepareStatement("INSERT INTO uuidtest VALUES (?)");
+        ps.setObject(1, uuid, Types.OTHER);
+        ps.executeUpdate();
+        ps.close();
+
+        Statement stmt = _conn.createStatement();
+        ResultSet rs = stmt.executeQuery("SELECT id FROM uuidtest");
+        assertTrue(rs.next());
+
+        UUID uuid2 = (UUID)rs.getObject(1);
+        assertEquals(uuid, rs.getObject(1));
+        assertEquals(uuid.toString(), rs.getString(1));
+
+        rs.close();
+        stmt.close();
+    }
+
+}
+


[parent: 5bfa2e7a6fbe]