question: private void readReference ( ) { String sql ; if ( Env . isBaseLanguage ( Env . getCtx ( ) , "AD_Ref_List" ) ) sql = "SELECT Value, Name, Description FROM AD_Ref_List " + "WHERE AD_Reference_ID=135 ORDER BY Name" ; else sql = "SELECT l.Value, t.Name, t.Description " + "FROM AD_Ref_List l, AD_Ref_List_Trl t " + "WHERE l.AD_Ref_List_ID=t.AD_Ref_List_ID" + " AND t.AD_Language='" + Env . getAD_Language ( Env . getCtx ( ) ) + "'" + " AND l.AD_Reference_ID=135 ORDER BY t.Name" ; ArrayList < String > v_value = new ArrayList < String > ( ) ; ArrayList < String > v_name = new ArrayList < String > ( ) ; ArrayList < String > v_description = new ArrayList < String > ( ) ; try { PreparedStatement pstmt = DB . prepareStatement ( sql , null ) ; ResultSet rs = pstmt . executeQuery ( ) ; while ( rs . next ( ) ) { String value = rs . getString ( 1 ) ; String name = rs . getString ( 2 ) ; String description = rs . getString ( 3 ) ; if ( description == null ) description = "" ; v_value . add ( value ) ; v_name . add ( name ) ; v_description . add ( description ) ; } rs . close ( ) ; pstmt . close ( ) ; } catch ( SQLException e ) { log . log ( Level . SEVERE , sql , e ) ; } int size = v_value . size ( ) ; s_value = new String [ size ] ; s_name = new String [ size ] ; s_description = new String [ size ] ; for ( int i = 0 ; i < size ; i ++ ) { s_value [ i ] = ( String ) v_value . get ( i ) ; s_name [ i ] = ( String ) v_name . get ( i ) ; s_description [ i ] = ( String ) v_description . get ( i ) ; } }
target:  Fill Vector with DocAction Ref_List(135) values