Subject | Re: [Firebird-Java] Problems with latest update - please help |
---|---|
Author | Blas Rodriguez Somoza |
Post date | 2002-11-01T00:32:42Z |
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
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/
>
>
>