Hi, I have a problem on my application. We just migrated our application from SAS 12.5.4 to Sybase Adaptive Server Enterprise 16. All works well from previous version, when I just identified a weird behavior. I still don't have clue why the problem appears.
We used java in our application to connect to the database using jconn4.jar. Here's a code snippet from my application. PreparedStatement ps =null; ... more code here// ps.setDouble(12,casualty.getRiskLiabAmt());
casualty.getRiskLiabAmt() has value 1.93. But when this is persisted to Database with column type MONEY the value got truncated to 1.
I need your help guys. Thanks in advance.