92 Statement statement = m_conn.createStatement();
93 statement.executeUpdate(PROPERTIES.getProperty(
"drop_base_t3"));
94 statement.executeUpdate(PROPERTIES.getProperty(
"create_base_t3"));
95 statement.executeQuery(
"insert into test_prepare_table3 values(1, 1.1, 'one')");
96 ResultSetMetaData md = null;
98 PreparedStatement pr_select_no_params =
99 m_conn.prepareStatement(
"select aa, bb, cc from test_prepare_table3");
100 md = pr_select_no_params.getMetaData();
102 assertEquals(md.getColumnCount(), 3);
103 assertEquals(md.getColumnName(1),
"aa");
104 assertEquals(md.getColumnType(1), Types.INTEGER);
105 assertEquals(md.getColumnType(2), Types.DOUBLE);
107 PreparedStatement pr_select_with_params = m_conn.prepareStatement(
108 "select bb, aa from test_prepare_table3 where cc <> ? and aa > ?");
109 md = pr_select_with_params.getMetaData();
111 assertEquals(md.getColumnCount(), 2);
112 assertEquals(md.getColumnName(1),
"bb");
113 assertEquals(md.getColumnType(1), Types.DOUBLE);
114 assertEquals(md.getColumnType(2), Types.INTEGER);
116 String commented_sql_statement =
" \n \n"
122 +
"-- comment inside comment\n"
124 +
"-- another /*tricky edge case/*\n"
125 +
" select bb, aa from test_prepare_table3 where cc <> ? and aa > ?";
126 PreparedStatement pr_select_with_params_and_comments =
127 m_conn.prepareStatement(commented_sql_statement);
128 md = pr_select_with_params_and_comments.getMetaData();
130 assertEquals(md.getColumnCount(), 2);
132 PreparedStatement pr_insert = m_conn.prepareStatement(
133 "insert into test_prepare_table3(aa, bb, cc) values (?, ?, ?)");
134 md = pr_insert.getMetaData();
137 PreparedStatement pr_insert_from_select = m_conn.prepareStatement(
138 "insert into test_prepare_table3(aa, bb, cc) select aa, bb, cc from test_prepare_table3 where cc <> ?");
139 md = pr_insert_from_select.getMetaData();
142 statement.executeUpdate(PROPERTIES.getProperty(
"drop_base_t3"));