Re: strange problem
basically this is what my store proc does with
IF EXISTS( select nb_pool_number from nb_pool_info where nb_pool_number = nb_pool_number_gb and nb_factor_date = nb_factor_date_gb ) THEN
UPDATE nb_pool_info
SET
nb_wac = nb_wac_gb,
nb_warm = nb_warm_gb,
nb_wala = nb_wala_gb,
nb_waocs = nb_waocs_gb,
nb_waoltv = nb_waoltv_gb,
nb_aols = nb_aols_gb,
nb_waolt = nb_waolt_gb,
nb_waols = nb_waols_gb
WHERE
nb_pool_number = nb_pool_number_gb AND
nb_factor_date = nb_factor_date_gb;
ELSE
INSERT INTO nb_pool_info(
nb_pool_number,
nb_factor_date,
nb_wac,
nb_warm,
nb_wala,
nb_waocs,
nb_waoltv,
nb_aols,
nb_waolt,
nb_waols
)VALUES(
nb_pool_number_gb.
nb_factor_date_gb,
nb_wac_gb,
nb_warm_gb,
nb_wala_gb,
nb_waocs_gb,
nb_waoltv_gb,
nb_aols_gb,
nb_waolt_gb,
nb_waols_gb
);
END IF;
END IF;
END IF;
with all the "_gb" as input parameters. The table it updates is
+---------------------- -----+-----------+------+-----+-------------------+-------+
| Field | Type | Null | Key | Default | Extra |
+---------------------------+-----------+------+-----+-------------------+-------+
| nb_pool_number | char(6) | NO | PRI | | |
| nb_factor_date | date | NO | PRI | | |
| nb_wac | double | NO | | | |
| nb_warm | int(11) | NO | | | |
| nb_wala | int(11) | NO | | | |
| nb_waocs | int(11) | NO | | | |
| nb_waoltv | int(11) | NO | | | |
| nb_aols | int(11) | NO | | | |
| nb_waolt | int(11) | NO | | | |
| nb_waols | double | NO | | | |
| nb_wamtam | double | NO | | | |
| nb_current_unpaid_balance | double | NO | | | |
| nb_pool_factor | double | NO | | | |
| nb_nol_est | int(11) | NO | | | |
| nb_loan_size_est | int(11) | NO | | | |
| nb_prepayment_fee_factor | double | NO | | | |
| nb_nol | int(11) | NO | | | |
| nb_loan_size | int(11) | NO | | | |
| nb_sched_balance | double | NO | | | |
| nb_last_update_date | timestamp | YES | | CURRENT_TIMESTAMP | |
+---------------------------+-----------+------+-----+-------------------+-------+
Is it a JDBC problem or a mysql problem ?