How can a Java method returns more than one value

One of my friends asks me this question, can a java method returns than more value?
- you can achieve this task through a work around

Consider this example

    public static java.math.BigDecimal pmsGetActRetB(java.math.BigDecimal P_ID, java.math.BigDecimal P_HON_ID,
                                                     oracle.jbo.domain.Date P_DATE,
                                                     java.math.BigDecimal P_NAV[]) throws java.sql.SQLException {
        java.math.BigDecimal __jPt_result = null;
        CallableStatement __sJT_st = null;
        try {
       
                    String theSqlTS =
                        "BEGIN :1 := IAIGC.\"PMS_RET_PKG\".PMS_GET_ACT_RET_B(\n       :2  ,\n       :3  ,\n       :4  ,\n       :5  )  \n; END;";
                   
                    __sJT_st.registerOutParameter(1, oracle.jdbc.OracleTypes.NUMERIC);
                    __sJT_st.registerOutParameter(5, oracle.jdbc.OracleTypes.NUMERIC);
                    // set IN parameters
                    __sJT_st.setBigDecimal(2, P_ID);
                    __sJT_st.setBigDecimal(3, P_HON_ID);
                    __sJT_st.setObject(4, P_DATE);
                    __sJT_st.setBigDecimal(5, P_NAV[0]);
                    // execute statement
                    __sJT_st.executeUpdate();
                    // retrieve OUT parameters
                    __jPt_result = __sJT_st.getBigDecimal(1);
                    P_NAV[0] = __sJT_st.getBigDecimal(5);
                } finally {
                    __sJT_st.close();
                }
         
        return __jPt_result;
    }

This example call a database function that contains out parameter and return a number value too.

Comments

Post a Comment

Popular posts from this blog

Detail entity with row key null cannot find or invalidate its owning entity.

Image
in the model project go to the association. double click on the association and expand the behavior node under relationship tab. make sure that the primary key column is set to DBsequance, if you have a sequence on the database or a function that generate the db sequence from a trigger 3- check on composition association and cascade update key attribute 4- When an entity row is created it's row status is STATUS_NEW . This means row is added in the transaction's list of changes to be validated or posted or committed. This is fine and expected in most of the cases. However, during complex business objects like master-detail there comes the situation where you may want to turn off these validations until both master and detail are available. For such situations to remove the row from transactions's list of changes ADF exposes an api setNewRowStatus(ROW.STATUS_INITIALIZED). This is specifically helpful when master-detail association ...
Read more

Another user has changed the row with primary key oracle.jbo.Key[12 ].

Image
Try these solutions:  make sure that you check "refresh after insert" and refresh after update" for the primary key column in you entity object. in the application module tab Click the Properties tab and select jbo.locking.mode. Double click the “pessimistic”value next to the property to open the field editor and type “optimistic” over the value.Press enter. if error still exist then you must set "refresh after insert" and refresh after update" as true for all attributes in the entity object another way is to execute the View Object after the commit operation to bring back updated data to ViewObject. For this we need to override the  afterCommit()  of ViewObject class as follows:                  public void afterCommit(TransactionEvent){                         executeQuery();                  ...
Read more

setDomainEnv file in weblogic

@ECHO OFF @REM WARNING: This file is created by the Configuration Wizard. @REM Any changes to this script may be lost when adding extensions to this configuration. @REM ************************************************************************* @REM This script is used to setup the needed environment to be able to start Weblogic Server in this domain. @REM @REM This script initializes the following variables before calling commEnv to set other variables: @REM @REM WL_HOME         - The BEA home directory of your WebLogic installation. @REM JAVA_VM         - The desired Java VM to use. You can set this environment variable before calling @REM                   this script to switch between Sun or BEA or just have the default be set. @REM JAVA_HOME       - Location of the version of Java used to start WebLogic @REM                   ...
Read more