Hello Yaroslav!

The column "createdAt" was introduced in Camel 2.8.0. Do you use Camel
2.8.0 or a newer version?
I'm not familiar with Micosoft SQLServer, but the problem looks related to
the "createdAt" column.

What we do is something like this:

String INSERT_STRING = "INSERT INTO CAMEL_MESSAGEPROCESSED (processorName,
messageId, createdAt) VALUES (?, ?, ?)";
String processorName = "test";
String messageId = "1";

jdbcTemplate.update(INSERT_STRING, processorName, messageId, new
Timestamp(System.currentTimeMillis()));

Could you please test whether you get the same exception with a simple test
case which use this code snippets?
Could you please also check the Micosoft SQLServer documentation whether
they support the Timestamp type (I guess, because you could create the
column) and which java type you have to use? It looks like Microsoft
doesn't "like" the javax.sql.Timestamp type... :-(

Best,
Christian

Reply via email to