You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-commits@db.apache.org by km...@apache.org on 2013/04/09 18:57:50 UTC
svn commit: r1466130 - in /db/derby/code/branches/10.8.3.1_testcompat: ./
java/testing/org/apache/derbyTesting/functionTests/tests/jdbcapi/PrepStmtMetaDataTest.java
java/testing/org/apache/derbyTesting/functionTests/tests/lang/AlterTableTest.java
Author: kmarsden
Date: Tue Apr 9 16:57:49 2013
New Revision: 1466130
URL: http://svn.apache.org/r1466130
Log:
DERBY-5459 correct client result set metadata after recompilation of statement
Modified:
db/derby/code/branches/10.8.3.1_testcompat/ (props changed)
db/derby/code/branches/10.8.3.1_testcompat/java/testing/org/apache/derbyTesting/functionTests/tests/jdbcapi/PrepStmtMetaDataTest.java
db/derby/code/branches/10.8.3.1_testcompat/java/testing/org/apache/derbyTesting/functionTests/tests/lang/AlterTableTest.java
Propchange: db/derby/code/branches/10.8.3.1_testcompat/
------------------------------------------------------------------------------
Merged /db/derby/code/trunk:r1205426,1330200
Modified: db/derby/code/branches/10.8.3.1_testcompat/java/testing/org/apache/derbyTesting/functionTests/tests/jdbcapi/PrepStmtMetaDataTest.java
URL: http://svn.apache.org/viewvc/db/derby/code/branches/10.8.3.1_testcompat/java/testing/org/apache/derbyTesting/functionTests/tests/jdbcapi/PrepStmtMetaDataTest.java?rev=1466130&r1=1466129&r2=1466130&view=diff
==============================================================================
--- db/derby/code/branches/10.8.3.1_testcompat/java/testing/org/apache/derbyTesting/functionTests/tests/jdbcapi/PrepStmtMetaDataTest.java (original)
+++ db/derby/code/branches/10.8.3.1_testcompat/java/testing/org/apache/derbyTesting/functionTests/tests/jdbcapi/PrepStmtMetaDataTest.java Tue Apr 9 16:57:49 2013
@@ -115,18 +115,20 @@ public class PrepStmtMetaDataTest extend
assertEquals(java.sql.Types.INTEGER, rsmd.getColumnType(1));
assertEquals("C11", rsmd.getColumnName(1));
+ s.executeUpdate("alter table bug4579 add column c12 int");
+
+ if (usingDerbyNetClient()) {
// DERBY-2402 Client does not report added columns.
// Take out check when DERBY-2402 is fixed
- if (usingDerbyNetClient())
- return;
-
- s.executeUpdate("alter table bug4579 add column c12 int");
+ //
+ } else {
rsmd = ps.getMetaData();
assertEquals(2, rsmd.getColumnCount());
assertEquals(java.sql.Types.INTEGER, rsmd.getColumnType(1));
assertEquals("C11", rsmd.getColumnName(1));
assertEquals(java.sql.Types.INTEGER, rsmd.getColumnType(2));
assertEquals("C12", rsmd.getColumnName(2));
+ }
// ResultSetMetaData for select * after alter table and
// executeQuery.
@@ -140,6 +142,17 @@ public class PrepStmtMetaDataTest extend
assertEquals("C12", rsmd.getColumnName(2));
assertEquals(java.sql.Types.INTEGER, rsmd.getColumnType(3));
assertEquals("C13", rsmd.getColumnName(3));
+
+ // Check ps metadata again
+ rsmd = ps.getMetaData();
+ assertEquals(3, rsmd.getColumnCount());
+ assertEquals(java.sql.Types.INTEGER, rsmd.getColumnType(1));
+ assertEquals("C11", rsmd.getColumnName(1));
+ assertEquals(java.sql.Types.INTEGER, rsmd.getColumnType(2));
+ assertEquals("C12", rsmd.getColumnName(2));
+ assertEquals(java.sql.Types.INTEGER, rsmd.getColumnType(3));
+ assertEquals("C13", rsmd.getColumnName(3));
+
rs.close();
ps.close();
s.executeUpdate("drop table bug4579");
Modified: db/derby/code/branches/10.8.3.1_testcompat/java/testing/org/apache/derbyTesting/functionTests/tests/lang/AlterTableTest.java
URL: http://svn.apache.org/viewvc/db/derby/code/branches/10.8.3.1_testcompat/java/testing/org/apache/derbyTesting/functionTests/tests/lang/AlterTableTest.java?rev=1466130&r1=1466129&r2=1466130&view=diff
==============================================================================
--- db/derby/code/branches/10.8.3.1_testcompat/java/testing/org/apache/derbyTesting/functionTests/tests/lang/AlterTableTest.java (original)
+++ db/derby/code/branches/10.8.3.1_testcompat/java/testing/org/apache/derbyTesting/functionTests/tests/lang/AlterTableTest.java Tue Apr 9 16:57:49 2013
@@ -20,11 +20,8 @@ limitations under the License.
package org.apache.derbyTesting.functionTests.tests.lang;
import java.io.InputStream;
-import java.sql.Blob;
import java.sql.ResultSetMetaData;
import java.sql.Statement;
-import java.sql.CallableStatement;
-import java.sql.Clob;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLWarning;
@@ -45,17 +42,6 @@ import junit.framework.Assert;
public final class AlterTableTest extends BaseJDBCTestCase {
- ResultSet rs = null;
- ResultSetMetaData rsmd;
- DatabaseMetaData dbmd;
- SQLWarning sqlWarn = null;
- PreparedStatement pSt;
- CallableStatement cSt;
- //Statement st;
- Connection conn;
- String[][] expRS;
- String[] expColNames;
-
/**
* Public constructor required for running test as standalone JUnit.
*/
@@ -70,7 +56,7 @@ public final class AlterTableTest extend
}
private void createTestObjects(Statement st) throws SQLException {
- conn = getConnection();
+ Connection conn = getConnection();
conn.setAutoCommit(false);
CleanDatabaseTestSetup.cleanDatabase(conn, false);
@@ -105,21 +91,16 @@ public final class AlterTableTest extend
private void checkWarning(Statement st, String expectedWarning)
throws Exception {
- if ((sqlWarn == null) && (st != null)) {
- sqlWarn = st.getWarnings();
- }
- if (sqlWarn == null) {
- sqlWarn = getConnection().getWarnings();
- }
+ SQLWarning sqlWarn = (st == null) ?
+ getConnection().getWarnings() : st.getWarnings();
assertNotNull("Expected warning but found none", sqlWarn);
assertSQLState(expectedWarning, sqlWarn);
- sqlWarn = null;
}
public void testAddColumn() throws Exception {
Statement st = createStatement();
createTestObjects(st);
- conn.commit();
+ commit();
// add column negative tests alter a non-existing table
assertStatementError("42Y55", st,
@@ -178,11 +159,11 @@ public final class AlterTableTest extend
st.executeUpdate("alter table t1 add column c4 int check(c4 = 1)");
// Newly-added column does not appear in existing view:
- rs = st.executeQuery("select * from v1");
+ ResultSet rs = st.executeQuery("select * from v1");
JDBC.assertColumnNames(rs, new String[]{"C1"});
JDBC.assertFullResultSet(rs, new String[][]{{"1"}, {"2"}});
- pSt = prepareStatement("select * from t2");
+ PreparedStatement pSt = prepareStatement("select * from t2");
rs = pSt.executeQuery();
JDBC.assertColumnNames(rs, new String[]{"C1"});
@@ -199,19 +180,12 @@ public final class AlterTableTest extend
// select * prepared statements do see added columns after
// alter table
- if (usingEmbedded()) // client/server doesn't keep cursor open.
- {
rs = pSt.executeQuery();
JDBC.assertColumnNames(rs, new String[]{"C1", "C2"});
JDBC.assertFullResultSet(rs, new String[][]{
{"1", null},
{"2", null}
});
- } else {
- rs = pSt.executeQuery();
- JDBC.assertColumnNames(rs, new String[]{"C1"});
- JDBC.assertFullResultSet(rs, new String[][]{{"1"}, {"2"}});
- }
// add non-nullable column to 0 row table and verify
st.executeUpdate("alter table t0 add column c2 int not null default 0");
@@ -222,7 +196,7 @@ public final class AlterTableTest extend
JDBC.assertFullResultSet(rs, new String[][]{{"1", "0"}});
st.executeUpdate("drop table t0");
- conn.rollback();
+ rollback();
rs = st.executeQuery(" select * from t0");
JDBC.assertColumnNames(rs, new String[]{"C1"});
JDBC.assertDrainResults(rs, 0);
@@ -243,7 +217,7 @@ public final class AlterTableTest extend
JDBC.assertColumnNames(rs, new String[]{"C1", "C2"});
JDBC.assertFullResultSet(rs, new String[][]{{"1", "1"}});
- conn.rollback();
+ rollback();
// add unique constraint to 0 and 1 row tables and verify
@@ -277,7 +251,7 @@ public final class AlterTableTest extend
"SYSCS_UTIL.SYSCS_CHECK_TABLE('" + DerbyConstants.TEST_DBO +
"', tablename) from " + "sys.systables where tabletype = 'T'");
- expRS = new String[][]{
+ String[][] expRS = {
{"T0", "1"},
{"T0_1", "1"},
{"T0_2", "1"},
@@ -291,7 +265,7 @@ public final class AlterTableTest extend
JDBC.assertUnorderedResultSet(rs, expRS, true);
- conn.rollback();
+ rollback();
st.executeUpdate(
" create function countopens() returns varchar(128) " +
@@ -299,7 +273,7 @@ public final class AlterTableTest extend
"'org.apache.derbyTesting.functionTests.util.T_ConsistencyChecker." +
"countOpens'");
- conn.commit();
+ commit();
// do consistency check on scans, etc.
rs = st.executeQuery("values countopens()");
@@ -349,7 +323,7 @@ public final class AlterTableTest extend
// tr1 is dropped, tr2 still OK
st.executeUpdate("drop trigger tr1");
- rs = st.executeQuery("select * from tab5");
+ ResultSet rs = st.executeQuery("select * from tab5");
JDBC.assertColumnNames(rs, new String[]{"C1"});
JDBC.assertDrainResults(rs, 0);
@@ -369,7 +343,7 @@ public final class AlterTableTest extend
rs = st.executeQuery("select * from tab2");
- expColNames = new String[]{"C1", "C2", "C3", "C4", "C5"};
+ String[] expColNames = {"C1", "C2", "C3", "C4", "C5"};
JDBC.assertColumnNames(rs, expColNames);
JDBC.assertDrainResults(rs, 0);
@@ -398,7 +372,7 @@ public final class AlterTableTest extend
expColNames = new String[]{"C2", "C3", "C4"};
JDBC.assertColumnNames(rs, expColNames);
- expRS = new String[][]{
+ String[][] expRS = {
{"9", "2.5", "88"},
{"10", "3.5", "99"},
{"8", "4.4", "8"},
@@ -497,7 +471,7 @@ public final class AlterTableTest extend
st.executeUpdate("drop view vw4");
- conn.rollback();
+ rollback();
// check that dropping a column will drop backing index on
// referencing table
@@ -529,7 +503,7 @@ public final class AlterTableTest extend
"t.tablename = 'REFTT1'");
JDBC.assertSingleValueResultSet(rs, "1");
- conn.rollback();
+ rollback();
}
public void testAddConstraint() throws Exception {
@@ -577,7 +551,7 @@ public final class AlterTableTest extend
//duplicating a key value in a primary key not allowed
assertStatementError("23505", st, "insert into t0_1 values (1, 1)");
- rs = st.executeQuery("select * from t0_1");
+ ResultSet rs = st.executeQuery("select * from t0_1");
JDBC.assertColumnNames(rs, new String[]{"C1", "C2"});
JDBC.assertFullResultSet(rs, new String[][]{{"1", "1"}});
@@ -647,10 +621,10 @@ public final class AlterTableTest extend
rs = st.executeQuery(
" select * from t0_1");
- expColNames = new String[]{"C1", "C2"};
+ String[] expColNames = {"C1", "C2"};
JDBC.assertColumnNames(rs, expColNames);
- expRS = new String[][]{
+ String[][] expRS = {
{"1", "1"},
{"2", "2"},
{"2", "2"},
@@ -729,7 +703,8 @@ public final class AlterTableTest extend
assertCompileError("42Y55", "alter table xxx add check(c2 = 1)");
st.executeUpdate("create table xxx(c1 int, c2 int)");
- pSt = prepareStatement("alter table xxx add check(c2 = 1)");
+ PreparedStatement pSt =
+ prepareStatement("alter table xxx add check(c2 = 1)");
assertUpdateCount(pSt, 0);
st.executeUpdate("drop table xxx");
st.executeUpdate("create table xxx(c1 int)");
@@ -807,15 +782,15 @@ public final class AlterTableTest extend
// verify the consistency of the indexes on the user tables
- rs = st.executeQuery(
+ ResultSet rs = st.executeQuery(
"select tablename, " + "SYSCS_UTIL.SYSCS_CHECK_TABLE('" +
DerbyConstants.TEST_DBO + "', tablename) from " +
"sys.systables where tabletype = 'T' and tablename = 'T0_1'");
- expColNames = new String[]{"TABLENAME", "2"};
+ String[] expColNames = {"TABLENAME", "2"};
JDBC.assertColumnNames(rs, expColNames);
- expRS = new String[][]{
+ String[][] expRS = {
{"T0_1", "1"}
};
@@ -823,7 +798,8 @@ public final class AlterTableTest extend
// verify that alter table works after drop/recreate of table
- pSt = prepareStatement("alter table t0_1 drop constraint p2");
+ PreparedStatement pSt =
+ prepareStatement("alter table t0_1 drop constraint p2");
assertUpdateCount(pSt, 0);
@@ -967,7 +943,7 @@ public final class AlterTableTest extend
// schemaname should be DerbyConstants.TEST_DBO
- rs = st.executeQuery(
+ ResultSet rs = st.executeQuery(
"select schemaname, constraintname from " +
"sys.sysconstraints c, sys.sysschemas s where " +
"s.schemaid = c.schemaid order by 1");
@@ -1103,12 +1079,12 @@ public final class AlterTableTest extend
st.executeUpdate("alter table t1 drop primary key");
st.executeUpdate("insert into t1 values (1, 1)");
- rs = st.executeQuery("select * from t1");
+ ResultSet rs = st.executeQuery("select * from t1");
- expColNames = new String[]{"C1", "C2"};
+ String[] expColNames = {"C1", "C2"};
JDBC.assertColumnNames(rs, expColNames);
- expRS = new String[][]{
+ String[][] expRS = {
{"1", "1"},
{"1", "1"}
};
@@ -1133,7 +1109,7 @@ public final class AlterTableTest extend
" alter table t1 add constraint C1_PLUS_C2 check " +
"((c1 + c2) < 100)");
- pSt = prepareStatement(
+ PreparedStatement pSt = prepareStatement(
"alter table t1 drop constraint C1_PLUS_C2");
st.executeUpdate(
@@ -1251,12 +1227,12 @@ public final class AlterTableTest extend
st.executeUpdate("insert into atmcn_1 values (1,1)");
- rs = st.executeQuery("select * from atmcn_1");
+ ResultSet rs = st.executeQuery("select * from atmcn_1");
- expColNames = new String[]{"A", "B"};
+ String[] expColNames = {"A", "B"};
JDBC.assertColumnNames(rs, expColNames);
- expRS = new String[][]{
+ String[][] expRS = {
{"1", "1"}
};
@@ -1450,7 +1426,7 @@ public final class AlterTableTest extend
st.executeUpdate("rename column renc_2.c1 to c2");
- dbmd = conn.getMetaData();
+ DatabaseMetaData dbmd = getConnection().getMetaData();
rs = dbmd.getColumns(null, null, "RENC_2", "C2");
assertTrue(rs.next());
assertEquals("C2", rs.getString("COLUMN_NAME"));
@@ -1464,7 +1440,7 @@ public final class AlterTableTest extend
assertFalse(rs.next());
if (usingEmbedded()) {
- dbmd = conn.getMetaData();
+ dbmd = getConnection().getMetaData();
rs = dbmd.getIndexInfo(null, null, "RENC_2", false, false);
assertTrue(rs.next());
assertEquals("RENC_2", rs.getString("TABLE_NAME"));
@@ -1493,7 +1469,7 @@ public final class AlterTableTest extend
st.executeUpdate(
"rename column renc_3.b to newbie");
- dbmd = conn.getMetaData();
+ dbmd = getConnection().getMetaData();
rs = dbmd.getColumns(null, null, "RENC_3", "NEWBIE");
assertTrue(rs.next());
assertEquals("NEWBIE", rs.getString("COLUMN_NAME"));
@@ -1507,7 +1483,7 @@ public final class AlterTableTest extend
assertFalse(rs.next());
if (usingEmbedded()) {
- dbmd = conn.getMetaData();
+ dbmd = getConnection().getMetaData();
rs = dbmd.getIndexInfo(null, null, "RENC_3", false, false);
assertTrue(rs.next());
assertEquals("RENC_3", rs.getString("TABLE_NAME"));
@@ -1561,7 +1537,7 @@ public final class AlterTableTest extend
"rename column renc_4.c1 to unq_c1");
if (usingEmbedded()) {
- dbmd = conn.getMetaData();
+ dbmd = getConnection().getMetaData();
rs = dbmd.getIndexInfo(null, null, "RENC_4", false, false);
assertTrue(rs.next());
assertEquals("RENC_4", rs.getString("TABLE_NAME"));
@@ -1586,7 +1562,7 @@ public final class AlterTableTest extend
"rename column renc_5.c5 to unq_c5");
if (usingEmbedded()) {
- dbmd = conn.getMetaData();
+ dbmd = getConnection().getMetaData();
rs = dbmd.getIndexInfo(null, null, "RENC_5", false, false);
assertTrue(rs.next());
assertEquals("RENC_5", rs.getString("TABLE_NAME"));
@@ -1706,12 +1682,13 @@ public final class AlterTableTest extend
// prepared statement on it. The rename of the column will
// be successful; the open statement will get errors when
// it tries to re-execute.
- conn.setAutoCommit(false);
- pSt = prepareStatement("select * from renc_6 where a = ?");
+ setAutoCommit(false);
+ PreparedStatement pSt =
+ prepareStatement("select * from renc_6 where a = ?");
rs = st.executeQuery("values (30)");
rs.next();
- rsmd = rs.getMetaData();
+ ResultSetMetaData rsmd = rs.getMetaData();
for (int i = 1;
i <= rsmd.getColumnCount(); i++) {
pSt.setObject(i, rs.getObject(i));
@@ -1737,8 +1714,7 @@ public final class AlterTableTest extend
assertStatementError(
"42X04", pSt);
- conn.setAutoCommit(
- true);
+ setAutoCommit(true);
// Demonstrate that you cannot rename a column in a
// synonym, and demonstrate that renaming a column in the
@@ -1799,7 +1775,7 @@ public final class AlterTableTest extend
// cause the following test to fail. Right now, the following
// test accepts the incorrect metadata length obtained through
// the resultset's metadata after ALTER TABLE has been performed.
- conn.setAutoCommit(false);
+ setAutoCommit(false);
//Create table and load data
st.executeUpdate(
"create table derby_3823_t1 (c11 int, c12 varchar(5))");
@@ -1809,7 +1785,7 @@ public final class AlterTableTest extend
ps.setInt(1, i);
ps.executeUpdate();
}
- conn.commit();
+ commit();
//Open a resultset on the table which will be altered because
// the resultset has been exhausted. The alter table will fail
// in embedded mode because of the open resulset but will succeed
@@ -2120,7 +2096,7 @@ public final class AlterTableTest extend
JDBC.assertFullResultSet(st.executeQuery(" select * from atdc_1"),
new String[][]{{"1", "1"}});
- rs =
+ ResultSet rs =
st.executeQuery(
" select columnname,columnnumber,columndatatype from " +
"sys.syscolumns where referenceid in (select tableid " +
@@ -2223,20 +2199,9 @@ public final class AlterTableTest extend
st.executeUpdate("alter table atdc_1_01 drop column c cascade");
if (usingEmbedded()) {
- if ((sqlWarn == null) && (st != null)) {
- sqlWarn = st.getWarnings();
+ checkWarning(st, "01500");
}
- if (sqlWarn == null) {
- sqlWarn = getConnection().getWarnings();
- }
-
- assertNotNull("Expected warning but found none", sqlWarn);
- assertSQLState("01500", sqlWarn);
- sqlWarn =
- null;
- }
-
st.executeUpdate(
" create table atdc_1_02 (a int not null primary key, b int)");
@@ -2248,35 +2213,9 @@ public final class AlterTableTest extend
" alter table atdc_1_02 drop column a cascade");
if (usingEmbedded()) {
- if ((sqlWarn == null) && (st != null)) {
- sqlWarn = st.getWarnings();
+ checkWarning(st, "01500");
}
- if (sqlWarn == null) {
- sqlWarn = getConnection().getWarnings();
- }
-
- assertNotNull("Expected warning but found none", sqlWarn);
- assertSQLState("01500", sqlWarn);
- sqlWarn =
- null;
- }
-
- if (usingEmbedded()) {
- if ((sqlWarn == null) && (st != null)) {
- sqlWarn = st.getWarnings();
- }
-
- if (sqlWarn == null) {
- sqlWarn = getConnection().getWarnings();
- }
-
- assertNotNull("Expected warning but found none", sqlWarn);
- assertSQLState("01500", sqlWarn);
- sqlWarn =
- null;
- }
-
// drop column restrict should fail because column is used
// in a constraint:
st.executeUpdate(
@@ -2493,8 +2432,7 @@ public final class AlterTableTest extend
rs =
st.executeQuery("select * from atdc_vw_1");
- expColNames =
- new String[]{"VW_B"};
+ String[] expColNames = {"VW_B"};
JDBC.assertColumnNames(rs, expColNames);
JDBC.assertDrainResults(rs, 0);
@@ -3236,7 +3174,7 @@ public final class AlterTableTest extend
"create table d3175 (x varchar(12), y varchar(12), " +
"id int primary key generated by default as identity)");
- rs =
+ ResultSet rs =
st.executeQuery(
" select COLUMNNAME, COLUMNNUMBER, COLUMNDATATYPE, " +
" COLUMNDEFAULT, AUTOINCREMENTVALUE, AUTOINCREMENTSTART, " +
@@ -3325,7 +3263,7 @@ public final class AlterTableTest extend
"Message_Data_ID INTEGER NOT NULL , CONSTRAINT " +
"d3177_MESSAGES_id_pk PRIMARY KEY(id) )");
- rs =
+ ResultSet rs =
st.executeQuery(
" select COLUMNNAME, COLUMNNUMBER, COLUMNDATATYPE, " +
" COLUMNDEFAULT, AUTOINCREMENTVALUE, AUTOINCREMENTSTART, " +
@@ -3630,16 +3568,15 @@ public final class AlterTableTest extend
//increase the maximum size of the clob
- Clob clob = null;
- Blob blob=null;
int val = 1;
int size = 15 * 1024;
InputStream stream;
st.executeUpdate("create table clob_tab(c1 int,clob_col clob(10K))");
- conn.commit();
+ commit();
- pSt=conn.prepareStatement("INSERT INTO clob_tab values (?,?)");
+ PreparedStatement pSt =
+ prepareStatement("INSERT INTO clob_tab values (?,?)");
stream = new TestInputStream(size, val);
//this insert fails(size>10K)
@@ -3648,12 +3585,12 @@ public final class AlterTableTest extend
assertStatementError("XJ001", pSt);
pSt.close();
- conn.rollback();
+ rollback();
st.executeUpdate("ALTER TABLE clob_tab ALTER COLUMN "
+"clob_col SET DATA TYPE clob(20K)");
- pSt=conn.prepareStatement("INSERT INTO clob_tab values (?,?)");
+ pSt = prepareStatement("INSERT INTO clob_tab values (?,?)");
stream = new TestInputStream(size, val);
//this insert succeed (maximum blob size not increased to 20K)
@@ -3668,9 +3605,9 @@ public final class AlterTableTest extend
st.executeUpdate("CREATE TABLE blob_tab ( C1 INTEGER," +
"blob_col BLOB(10K) NOT NULL)");
- conn.commit();
+ commit();
- pSt=conn.prepareStatement("INSERT INTO blob_tab values (?,?)");
+ pSt = prepareStatement("INSERT INTO blob_tab values (?,?)");
stream = new TestInputStream(size, val);
//this insert fails(size>10K)
@@ -3679,12 +3616,12 @@ public final class AlterTableTest extend
assertStatementError("22001", pSt);
pSt.close();
- conn.rollback();
+ rollback();
st.executeUpdate("ALTER TABLE blob_tab ALTER COLUMN "
+"blob_col SET DATA TYPE blob(20K)");
- pSt=conn.prepareStatement("INSERT INTO blob_tab values (?,?)");
+ pSt = prepareStatement("INSERT INTO blob_tab values (?,?)");
stream = new TestInputStream(size, val);
//this insert succeed (maximum blob size not increased to 20K)
@@ -3693,7 +3630,7 @@ public final class AlterTableTest extend
pSt.executeUpdate();
pSt.close();
- conn.rollback();
+ rollback();
}
/**