This week's book giveaway is in the Java 8 forum.
We're giving away four copies of Java 8 in Action and have Raoul-Gabriel Urma, Mario Fusco, and Alan Mycroft on-line!
See this thread for details.
The moose likes JBoss/WildFly and the fly likes CMP Date sybase Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Java 8 in Action this week in the Java 8 forum!
JavaRanch » Java Forums » Products » JBoss/WildFly
Bookmark "CMP Date sybase" Watch "CMP Date sybase" New topic
Author

CMP Date sybase

Jeffrey.Boon.Hock Ng
Greenhorn

Joined: Jan 27, 2005
Posts: 1
Has anyone able to find record using date?
- CMP
- JBoss4
- has tried using Jboss-ql and ejb-ql (both return no result)
- select object(c) from tableX as c where c.recDate=?1
- have change the recDate to have all hh:mm:ss to 00:00:00
- date element remain enchanged.
- calendar.set(Calendar.DAY_OF_MONTH, 10)
- calendar.set(Calendar.MONTH,10) [November]
- calendar.set(Calendar.YEAR, 2000)

or is there any other way to find record by date?

understand that sybase require the exact timestamp but apparently in real situations, the search with exact time requirement is not required and unnecessary. Use of convert is not allowed in jboss-cmp

please advise
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: CMP Date sybase
 
Similar Threads
SQL vs EJB QL
Date comparison
CMP/BMP Platform independant??
EJB 2.0: EJB QL + XDoclet = using EJB on more projects!
Comparing dates