To start off, thank you who can help. I have looked through examples, docs, etc. The
forum "almost" helped.
The end problem is that I am doing a addLessThan on a datetime db field using the PB
and it is failing likely because of a type casting problem.
I am using Timestamp in my java code.
Using this for my mapping into a DATETIME field in MySql.
<field-descriptor
name="offerEnds"
column="offerends"
jdbc-type="TIMESTAMP"
/>
Data gets inserted correctly into MySQL or seems to, but when I do
crit.addLessThan("offerends", new Timestamp(System.currentTimeMillis());
When I print out the query, I get:
Query from class com.model.offer.OfferVO where [offerprice
> 0.0, isdisabled = false, offerends < 2004-01-31 21:59:07.89,
> offeredProducts.productid = 1000]
It is the time aspect on this which is failing.
The row should return back data, but is failing to do so.
Thank you again for your help.
John
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
