[ https://issues.apache.org/jira/browse/TRAFODION-2686?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
王宏伟 updated TRAFODION-2686: --------------------------- Description: {color:#59afe1}use setCursorName(String name) of Statement to set Cursor Name fail:{color} stmt.setCursorName("rsCursor"); {color:#d04437}*assertEquals("rsCursor", rs.getCursorName());* expected:*rsCursor*,but was:*SQL_CUR_5*{color} {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"); {color:#d04437}assertEquals("rsCursor", rs.getCursorName());{color} } catch (ClassNotFoundException e) { e.printStackTrace(); } catch (SQLException e) { e.printStackTrace(); } finally { stmt.execute("drop table " + schema + "." + tableName ); stmt.close(); conn.close(); } } } was: {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(); } } } > 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"); > {color:#d04437}*assertEquals("rsCursor", rs.getCursorName());* > expected:*rsCursor*,but was:*SQL_CUR_5*{color} > {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"); > {color:#d04437}assertEquals("rsCursor", > rs.getCursorName());{color} > } 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)