OJB DB2 UDB, retrieving DATE ????

[ABOU LINA <am...@gmail.com>]

Hi;

AS400 as server.
DB2 UDB as database .

in a table we have a record whith the date "2999-12-31".
when using ojb to retreive this record, the value of date is returned null.

with an sql tool we have be able to get this date with the instruction
select char(datetoshow, "ISO")...
we have also verify that ojb generate select datetoshow without char(...,
"ISO").

best regards,

Re: OJB DB2 UDB, retrieving DATE ????

[Vasily Ivanov <ba...@gmail.com>]

Hi,

Try this:

ReportQueryByCriteria query =
QueryFactory.newReportQuery(YourClass.class, criteria);
query.setAttributes(new String[] { "char(dateField, 'ISO')", "anotherField" });
yourPersistenceManager.getBroker().getReportQueryIteratorByQuery(query);

I didn't test, but it should work.

On 3/31/06, ABOU LINA <am...@gmail.com> wrote:
> Hi;
>
> AS400 as server.
> DB2 UDB as database .
>
> in a table we have a record whith the date "2999-12-31".
> when using ojb to retreive this record, the value of date is returned null.
>
> with an sql tool we have be able to get this date with the instruction
> select char(datetoshow, "ISO")...
> we have also verify that ojb generate select datetoshow without char(...,
> "ISO").
>
> best regards,
>
>

---------------------------------------------------------------------
To unsubscribe, e-mail: ojb-user-unsubscribe@db.apache.org
For additional commands, e-mail: ojb-user-help@db.apache.org