I've created a GUI application (a database editor) that uses DatabaseLink and it is currently working fine on my PC (M10.02, Windows 7) and on a clients's PC (CDF Player Pro 10.02, Windiws 8). While using it on a third computer (CDF Player Pro 10.02, Windows 7) the app fails after a couple of clicks. The database is MySQL and I have tested the app on a local database (on my PC, and on the 1st client PC) and also on a cloud based database (on my PC and on the third PC where the error is generated). The message it generates is this:
DatabaseLink`JDBC::error:Illegalvalue:DatabaseLink`SQLDateTime[{2015,8,7,0,0,0.0}]
Initially the app seems to work fine (SQLSelect used and results with dates displayed fine), but once this warning message appears the app apparently looses the capability of handling dates correctly. It is not clear yet when in the process the message appears for the first time or what triggers the error or bug. What is clear is that the error is only generated on that third computer.
At this point I have no idea what could be causing the problem as the date itself doesn't seem to be the problem. The code is thousands of lines long, so I won't be able to share it. I hope that this information is enough for experienced and knowledgeable developers. Any hint will be appreciated.
TIMESTAMP
into aDATE
field? Is this error in the middle of a transaction? If so, does rolling back fix the issue (at least the "it apparently looses the capability of handling dates correctly." part) $\endgroup$ – rm -rf♦ Aug 8 '15 at 14:42