1 package com.omnisci.jdbc;
3 import static org.junit.Assert.assertEquals;
4 import static org.junit.Assert.assertNotEquals;
9 import java.util.HashMap;
10 import java.util.Properties;
12 import javax.xml.transform.Result;
16 static final String
url = PROPERTIES.getProperty(
"default_db_connection_url");
17 static final String
user = PROPERTIES.getProperty(
"default_super_user");
18 static final String
password = PROPERTIES.getProperty(
"default_user_password");
28 new Answer(java.sql.Types.FLOAT,
"FLOAT"),
29 new Answer(java.sql.Types.OTHER,
"POINT"),
30 new Answer(java.sql.Types.OTHER,
"LINESTRING"),
31 new Answer(java.sql.Types.OTHER,
"POLYGON"),
32 new Answer(java.sql.Types.OTHER,
"MULTIPOLYGON")};
37 assertNotEquals(null, conn);
38 Statement statement = conn.createStatement();
40 statement.executeUpdate(PROPERTIES.getProperty(
"drop_base_db"));
41 }
catch (SQLException sQ) {
44 statement.executeUpdate(PROPERTIES.getProperty(
"create_base_db"));
47 conn = DriverManager.getConnection(
48 PROPERTIES.getProperty(
"base_db_connection_url"), user,
password);
49 statement = conn.createStatement();
50 statement.executeUpdate(PROPERTIES.getProperty(
"drop_base_table1"));
51 statement.executeUpdate(PROPERTIES.getProperty(
"create_base_table1"));
53 ResultSet rs = statement.executeQuery(PROPERTIES.getProperty(
"select_base_table1"));
54 ResultSetMetaData rs_md = rs.getMetaData();
55 int col_cnt = rs_md.getColumnCount();
57 int type = rs_md.getColumnType(col_cnt);
58 String
name = rs_md.getColumnTypeName(col_cnt--);
59 assertEquals(type,
answers[col_cnt].type);
60 assertEquals(name,
answers[col_cnt].name);
62 statement.executeUpdate(PROPERTIES.getProperty(
"drop_base_table1"));
63 statement.executeUpdate(PROPERTIES.getProperty(
"drop_base_db"));
static Properties PROPERTIES
static final String password