You are viewing a plain text version of this content. The canonical link for it is here.
Posted to torque-dev@db.apache.org by dl...@apache.org on 2003/06/19 05:26:35 UTC

cvs commit: db-torque README.txt

dlr         2003/06/18 20:26:35

  Modified:    .        README.txt
  Log:
  * README.txt
    profile/, notes/: Added brief descriptions of directories.
  
    build/: Removed, since it no longer exists.
  
  Revision  Changes    Path
  1.8       +2 -1      db-torque/README.txt
  
  Index: README.txt
  ===================================================================
  RCS file: /home/cvs/db-torque/README.txt,v
  retrieving revision 1.7
  retrieving revision 1.8
  diff -u -u -r1.7 -r1.8
  --- README.txt	7 Nov 2002 19:02:11 -0000	1.7
  +++ README.txt	19 Jun 2003 03:26:35 -0000	1.8
  @@ -4,9 +4,10 @@
   
   Torque is an Object/Relational persistence layer.
   
  +profile/    RDBMS-specific configuration profiles.
   target/     Temporary directory for building the project.
  -build/      Location of Ant build.xml and build.properties files.
   examples/   Example XML Torque schemas that are part of the distribution.
  +notes/      Misc. notes.
   src/        Location of Java sources and Torque templates.
   xdocs/      Torque documention in Anakia formatted tags.
   
  
  
  

addDate garbage

Posted by Alexander Fedorenko <af...@informex.net>.
Hello

I use 

//

Calendar cal = Calendar.getInstance(locale) ;

selectCriteria.addDate(TranPeer.TRANS_TIME,
                             cal.get(Calendar.YEAR),
                             cal.get(Calendar.MONTH),
                             cal.get(Calendar.DAY_OF_MONTH),
                             Criteria.EQUAL);
//

... and resulting query is 

SELECT TRAN.TRAN_ID, TRAN.OP_TYPE, ... FROM TRAN WHERE
TRAN.TRANS_TIME=java.util.GregorianCalendar[time=?,areFieldsSet=false,ar
eAllFieldsSet=false,lenient=true,zone=sun.util.calendar.ZoneInfo[id="Eur
ope/Kiev",offset=7200000,dstSavings=3600000,useDaylight=true,transitions
=119,lastRule=java.util.SimpleTimeZone[id=Europe/Kiev,offset=7200000,dst
Savings=3600000,useDaylight=true,startYear=0,startMode=2,startMonth=2,st
artDay=-1,startDayOfWeek=1,startTime=3600000,startTimeMode=2,endMode=2,e
ndMonth=9,endDay=endDayOfWeek=1,endTime=3600000,endTimeMode=2]],firstDay
OfWeek=1,minimalDaysInFirstWeek=1,ERA=1,YEAR=2003,MONTH=5,WEEK_OF_YEAR=?
,WEEK_OF_MONTH=?,DAY_OF_MONTH=12,DAY_OF_YEAR=?,DAY_OF_WEEK=?,DAY_OF_WEEK
_IN_MONTH=?,AM_PM=?,HOUR=?,HOUR_OF_DAY=?,MINUTE=?,SECOND=?,MILLISECOND=?
,ZONE_OFFSET=?,DST_OFFSET=?] ORDER BY TRAN.TRAN_ID ASC LIMIT 10


What is the right way to work with TIMESTAMP fields in database ?

Thank you.