KickJava   Java API By Example, From Geeks To Geeks.

Java > Open Source Codes > org > h2 > test > cases > TestCompatibiliyMySQL


1 /*
2  * Copyright 2004-2006 H2 Group. Licensed under the H2 License, Version 1.0 (http://h2database.com/html/license.html).
3  * Initial Developer: H2 Group
4  */

5 package org.h2.test.cases;
6 import java.sql.*;
7
8 public class TestCompatibiliyMySQL {
9
10     public static void main(String JavaDoc[] args) throws Exception JavaDoc {
11         testWith("org.postgresql.Driver", "jdbc:postgresql:jpox2", "sa", "sa");
12         testWith("com.mysql.jdbc.Driver", "jdbc:mysql://localhost/test", "sa", "sa");
13         testWith("org.hsqldb.jdbcDriver", "jdbc:hsqldb:test", "sa", "");
14         testWith("org.h2.Driver", "jdbc:h2:test", "sa", "sa");
15     }
16     static void testWith(String JavaDoc driver, String JavaDoc url, String JavaDoc user, String JavaDoc password)
17             throws Exception JavaDoc {
18         Class.forName(driver);
19         System.out.println("URL: " + url);
20         Connection connection = DriverManager.getConnection(url, user, password);
21 // Class.forName("com.mysql.jdbc.Driver");
22
// Connection connection = DriverManager.getConnection( "jdbc:mysql://localhost/test", "sa", "sa");
23
Statement statement = connection.createStatement();
24         try {
25             statement.execute("DROP TABLE PEOPLE");
26         } catch(SQLException e) {}
27         statement.execute("CREATE TABLE PEOPLE (ID BIGINT, NAME VARCHAR(32))");
28         statement.execute("INSERT INTO PEOPLE (ID, NAME) VALUES (1, 'Adam')");
29         ResultSet rs = statement.executeQuery("SELECT PEOPLE.NAME FROM PEOPLE");
30         rs.next();
31         assertEquals("Adam", rs.getString(1));
32         assertEquals("Adam", rs.getString("NAME"));
33         rs = statement.executeQuery("SELECT PEOPLE.NAME FROM PEOPLE");
34         rs.next();
35 // assertEquals( "Adam", rs.getString("PEOPLE.NAME"));
36
statement.executeQuery("SELECT PEOPLE.NAME FROM PEOPLE");
37         statement.executeQuery("SELECT PEOPLE.NAME FROM PEOPLE;");
38         statement.executeQuery("SELECT PEOPLE.NAME FROM PEOPLE /* comment */");
39 // try {
40
// connection.createStatement().executeQuery("SELECT PEOPLE.NAME FROM PEOPLE; /* comment */");
41
// throw new Error("error");
42
// } catch(SQLException e) {
43
// // expected
44
// }
45
connection.createStatement().executeQuery("SELECT PEOPLE.NAME FROM PEOPLE /* comment */ ;");
46     }
47
48     private static void assertEquals(String JavaDoc a, String JavaDoc b) {
49         if(!a.equals(b)) {
50             throw new Error JavaDoc("a=" + a + " b="+b);
51         }
52     }
53 }
54
Popular Tags