#31 Add a verifyExecutedPreparedSQLStatementParameter function

closed
nobody
5
2008-02-26
2008-02-25
toli
No

Would be great if there was a set of functions to verify the contents of executed prepared statements similar to the verifyPreparedStatementParameter() set of functions in BasicJDBCTestCaseAdapter.

Looking at the JDBCModuleTest.testGetExecutedSQLStatementParameter you have to manually call the getExecutedSQLStatementParameterMap() function on the PreparedSQlStatement result set handler, and then get the right ParameterSets from the map for the prepared statement you are checking, and only then can you verify the parameter itself.

Would be very useful if i could just do "verifyExecutedPreparedSQLStatementParameter(prepStatementIndex, parameterIndex,value)" to verify the right param went out.

Unless, of course, i'm just missing something in the implementation.

Discussion

  • Alwin Ibba
    Alwin Ibba
    2008-02-26

    Logged In: YES
    user_id=804648
    Originator: NO

    Sorry this is not a bug at all but a feature request. I posted a feature request item for this but cannot promise when this will be implemented. Please do not post bug reports for things that are not really bugs.

     
  • Alwin Ibba
    Alwin Ibba
    2008-02-26

    • status: open --> closed
     
  • Alwin Ibba
    Alwin Ibba
    2008-02-26

    Logged In: YES
    user_id=804648
    Originator: NO

    There are methods verifySQLStatementParameter which includes PreparedStatements and CallableStatements. I don't think that methods only for PreparedStatements are necessary. I close the corresponding feature item. Please open a new feature request item if the verifySQLStatementParameter do not fit your needs.