Question

我有一个储存程序,有一个单一的分类输出段和5个变体输入参数,不管我所尝试的是什么,我似乎无法收回产出。我先拿 d子,然后拿数据回来,因此,我可以看一看我做的错误。

是否有任何人知道如何从简单的jdbcert中恢复产出?

我有这样的情况:

    SimpleJdbcCall simpleJdbcCall =
        new SimpleJdbcCall( getDatasourceForEnvironment() ).withProcedureName( "_Get_Id" ).declareParameters(
            new SqlParameter( "MyID", Types.VARCHAR ), new SqlParameter( "MySourceID", Types.VARCHAR ),
            new SqlParameter( "MyLocationID", Types.VARCHAR ), new SqlParameter( "MyVisitID", Types.VARCHAR ),
            new SqlParameter( "MyVisitDate", Types.VARCHAR ) );

    HashMap< String, String > input = new HashMap< String, String >();
    input.put( "MyID", myObj.getMyID() );
    input.put( "MySourceID", myObj.getMySourceID() );
    input.put( "MyLocationID", myObj.getMyLocationID() );
    input.put( "MyVisitID", myObj.getMyVisitID() );
    input.put( "MyVisitDate", myObj.getMyVisitDate() );

    System.out.println( simpleJdbcCall.execute( input ) );

Answer 1

我有两点错误:

I was connected to the wrong database. Writing a more granular unit test revealed my error.
Since the return from "execute" is a map, the output params are case sensitive.

简言之,你需要做的事情不多——春天包括产出部分,否则。此外,是采用这些方法的更清洁的方法。

友情链接