王宏伟 created TRAFODION-2686: ------------------------------ Summary: use setCursorName(String name) of Statement to set Cursor Name fail Key: TRAFODION-2686 URL: https://issues.apache.org/jira/browse/TRAFODION-2686 Project: Apache Trafodion Issue Type: Bug Components: client-jdbc-t4 Reporter: 王宏伟
{color:#59afe1}use setCursorName(String name) of Statement to set Cursor Name fail:{color} stmt.setCursorName("rsCursor"); *assertEquals("rsCursor", rs.getCursorName());* expected:*rsCursor*,but was:*SQL_CUR_5* {color:#59afe1}test code as following:{color} public class TestSetCursorName { public static String driver = "xxxx"; public static String url = "xxx"; public static String user = "xx"; public static String password = "xx"; public static Connection conn = null; protected ResultSet rs = null; public static Statement stmt = null; private String select_dml = null; private String create_ddl = ""; private String insert_dml = ""; @Test public void testSetCursorName() throws SQLException{ String tableName = "testsetCursorName"; String schema = "testsSchema"; try { Class.forName(driver); conn = DriverManager.getConnection(url, user, password); stmt = conn.createStatement(); create_ddl = "create table " + schema + "." + tableName + "(" + "c_char char(30),"+ "c_integer integer" + ")"; stmt.execute(create_ddl); insert_dml = "insert into " + schema + "." + tableName +"" + " values(" + "'test char'," + 123 + ")"; stmt.executeUpdate(insert_dml); select_dml = "select * from " + schema + "." + tableName; stmt.execute(select_dml); rs = stmt.getResultSet(); assertNotNull(rs.getCursorName()); stmt.setCursorName("rsCursor"); assertEquals("rsCursor", rs.getCursorName()); } catch (ClassNotFoundException e) { e.printStackTrace(); } catch (SQLException e) { e.printStackTrace(); } finally { stmt.execute("drop table " + schema + "." + tableName ); stmt.close(); conn.close(); } } } -- This message was sent by Atlassian JIRA (v6.4.14#64029)