Hi,
I have the following finder
@ejb.finder signature="java.util.Collection
* findByOpenAndOlderThan(java.util.Date d)" query="SELECT
* OBJECT(tx) FROM Transaction AS tx WHERE
tx.merchantTimestamp < ?1
* AND tx.sc=0 AND tx.bankTimestamp IS NULL"
*
The field in DB2 are of type TIMESTAMP. The finder fails with
Find failed: COM.ibm.db2.jdbc.DB2Exception: [IBM][CLI Driver][DB2/LINUX]
SQL0401N The data types of the operands for the operation "<" are not
compatible. SQLSTATE=42818
If I use the db2 prompt to select from the db, it works. Unfortunatly,
I cannot how the String that jboss gives in the SQL looks like,
because the log only shows an ? in the generated SQL instead of the
actual value.
Thanks for any advice,
Stefan
View the original post :
http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3907381#3907381
Reply to the post :
http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=3907381
-------------------------------------------------------
This SF.Net email is sponsored by the JBoss Inc. Get Certified Today
Register for a JBoss Training Course. Free Certification Exam
for All Training Attendees Through End of 2005. For more info visit:
http://ads.osdn.com/?ad_id=7628&alloc_id=16845&op=click
_______________________________________________
JBoss-user mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/jboss-user
