Just build the latest JayBird driver. It seems it is completely broken.

I have been using the older one in production for long time. It seems
working OK. However, the latest one does not work as expected in the
following:

1) do a simple "SELECT THE_DATE FROM MYTABLE" where THE_DATE is
timestamp field type. I could not use resultSet.getString("THE_DATE"),
it is return value "B@1582a7c"

2) PrepareStatement set parameter does not work any more. See example
below:


sb.append("select ")
.append(" WID, FULLNAME, EMAIL, COMPANY, START_DATE, FROM VC ")
.append(" WHERE (START_DATE between ? and ?) ");
ps = c.prepareStatement(sb.toString());
ps.setTimestamp(1, new
java.sql.Timestamp(cal.getThisDate().getTime()));
ps.setTimestamp(2, new
java.sql.Timestamp(cal.getNextDate().getTime()));
rs = ps.executeQuery();

the resultset return nothing. Anyone tested it?

This has been working perfect for a long time. Any insight? I am doing
something wrong or it is newly introduced bugs?

Thanks

jw