[jira] [Created] (TRAFODION-2686) use setCursorName(String name) of Statement to set Cursor Name fail

["王宏伟 (JIRA)" <ji...@apache.org>]

王宏伟 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)