Subject Re: [Firebird-Java] Problems with latest update - please help
Author Blas Rodriguez Somoza
Hello

There is bug in getString & getObject in Timestamp field that returns array of bytes instead java.sql.Timestamp. I've commited a
patch that solves this bug.

About the second error I don't if it is related with the first one.

Please, can you test now to see if the second bug is related with the first one?.

Regards
Blas Rodriguez Somoza

----- Original Message -----
From: "jwcanada" <jwcanada@...>
To: <Firebird-Java@yahoogroups.com>
Sent: Thursday, October 31, 2002 2:58 AM
Subject: [Firebird-Java] Problems with latest update - please help


> 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
>
>
>
>
>
>
>
> To unsubscribe from this group, send an email to:
> Firebird-Java-unsubscribe@yahoogroups.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>