I'm inserting data of datatype DECIMAL.
To give a brief explanation when capturing the data from my app if the last value I capture is an INTEGER then it changes all my previously captured values to INTEGER.
Note: This only happens if I specify my last captured value as an INTEGER. If I specify any other value as Integer as long as the last one is Decimal then it keeps the format of my data as I have captured it.
I am assuming that it is a bug in the JDBC driver
Has anyone else come across a problem like this.
If something is unclear in my explanation pls let me know.
Thnx