1. HQL(hibernate) timestamp range match stackoverflow.comI need to write a query to get an object between a range of time, currently the query looks like this: |
2. JAVA hibernate/webservice - Problem with Timestamp stackoverflow.comIn one of my hibernate classes I've a Timestamp variable. Now everything was alright when I used only the hibernate stuff on the server. But now I'm implementing webservice with wsgen. I ... |
3. Hibernate "ON UDPATE CURRENT TIMESTAMP" column stackoverflow.comIn MySQL it is possible to make a TIMESTAMP row being updated on every update operation. Is there a way to realize this for a column with Hibernate and map it ... |
4. type-safe jpa2 handling dates with no timestamp stackoverflow.comHow do we set date in the criteria when using type-safe jpa. I just need to compare using the mm/dd/yyyy and no time-stamp. When using JPQL I used to specify: .setParameter("date",new Date(), ... |
5. Java TIMESTAMP has trailing zeros, how do I remove? stackoverflow.comI'm using Java with hibernate and am in the early stages of learning how everything works. I'm getting there slowly but I have had some trouble with dates in Java. My current ... |
6. Retreving date from Hibernate TImestamp stackoverflow.comI have a field with temporal type as Timestamp to save both date and time to the database. |
7. Hibernate Problem : TimeStamp in Hibernate coderanch.com |
8. Timestamping in Hibernate coderanch.comHello guys, Iv got some delimma on how to check timestamping using Hibernate. Here's the situation: Iv got a table: USER with columns [username, password, lastModified, lastModifiedBy] *Note that lastModified is timestamp (sql data type) and the default value is CURRENT_TIMESTAMP. Pretty much I let sql do the updating of USER.lastModified field, by setting lastModified into null when I save an ... |
9. JPA problem with Timestamp java.net@Column(name = "timestamp2", nullable = false) @Temporal(TemporalType.TIMESTAMP) public Date timestamp2; ........ sql query works: select id from table where MONTH( DATE(timestamp1) - DATE(timestamp2) ) > 3 ........ but how I can write in Java? I't doesnt wrk: Query query = em.createQuery("SELECT id FROM table WHERE MONTH( DATE(timestamp1) - DATE(timestamp2) ) > 3 ") |
10. JPQ operators on time values (Time, Date, Timestamp) forum.hibernate.orgHi, I am trying to write a Java Persistent Query. I would like to compute average price of some records based on a comparison between a Timestamp value and Time value. So I tried to add CURRENT_DATE to time value but I did not succeed: Executing a query Code: SELECT avg(t.price*t.volume)/sum(t.volume) FROM Transaction t WHERE ... |
11. HQL timestamp - minutes forum.hibernate.org |
12. timestamp question in Hibernate 2.x forum.hibernate.org |
13. Use of "current_timestamp()" in Hibernate v2 forum.hibernate.orgI have to modify some Java Code, and a portion of it uses Hibernate to query an Oracle database. I am VERY familiar with Oracle, fairly familiar with Java and Eclipse(used for this project), and very little with Hibernate. I have read some of the documentation on Hibernate, and I believe I found the function that I needed, but I want ... |
14. Timestamp explanation forum.hibernate.orgHi all, Im quite new to Hibernate. I need to know some details about timestamp property in hibernate? What is the purpose of this? is it as an alternative to versioning? Could you please provide me some link to get my self clear on the need for timestamp? simply im asking why timestamp? thanks in advance saj |
15. Hibernate sybase to Oracle timestamp issue forum.hibernate.orgHi, In our application we are retrieving data from sybase db table to Oracle db table, in which one column is date format. In sybase we use it as datetime and in oracle timestamp. It is storing values perfectly till the year of timestamp value is 2049. But if it goes beyond that it stores as 19XX, for example if the ... |
16. Getting back timestamp column with millisecond precision forum.hibernate.orgI've got a named query which has a date comparison in the where clause ( x.statusdate <= :systemDate). The systemDate is a named parameter and is a java.util.Date. The x.statusdate is a java.util.Date and is mapped with type=java.util.Date in the hbm file. So, the query needs to select entries of which the statusdate (up to the millisecond precision !!!) is smaller ... |
17. TimeStamp and Daylight Savings Issue. forum.hibernate.orgHi Experts, Our application has some back-end jobs that are triggered by a set of 4 external Schedulers. So, at every half-hour all 4 schedulers send requests to our app for triggering the job. The requirement is that only one out of these 4 requests should do the actual processing, rest three should not do anything. To achieve this, I tried ... |
18. HB 2.1.b3 (b) |
19. deactivate timestamp forum.hibernate.orghi, can I dynamically remove and set the timestamp property of versioned data ? The idea behind is I have persistent object with versioned data and want to transfer these object from a remote database to a local database in our application. So I want to do this transfer as initial step and then switch from the original application server/database to ... |
20. unsaved-value problems with |
21. need help with Date and Timestamp from String forum.hibernate.orgOK let say I'm fine with dat.. now I have a problem extracting data from the database. I wanna run a method whose arguments are String, so I could parse the String into a Date then retrieve it. since '1970-01-01 21:46:00.000' is recorded in DB, then I assume this is the query would look like : SELECT tx.* FROM TRANSACTION as ... |
22. best hook for "lastUpdateDate" timestamping? forum.hibernate.orgHello, Well I've been using Hibernate for a couple of years, but my problem doesn't seem to thematically "fit" into one of the other forums, so I guess I'll have to post it here ;) In Hibernate 2.1.2, I have a persistent class that has a persistent property: "lastUpdateDate". The semantic of this property is the conventional one: every time there ... |
23. timestamp problem forum.hibernate.orgI am facing a stange problem. I have createdDate method as java.util.Date. However, in the hbm mapping, I define it as type "timestamp". I am trying to insert a graph of objects (bidirectional using Set) with Flush mode as commit. Each of these objects have the createdDate set/get I have an Interceptor that sets createdDate in the onSave method. The inserts ... |
24. Problems with timestamp and Postgres forum.hibernate.orgHi, I have a serious problem with PostgreSQL and Timestamps mapping to a java.util.Date. I get a StringArrayOutOfBoundsException. This is the physical content of the field: 2004-05-11 09:47:31.869 Here is a trace: java.lang.StringIndexOutOfBoundsException: String index out of range: 23 at java.lang.String.charAt(String.java:444) at org.postgresql.jdbc2.ResultSet.toTimestamp(Unknown Source) at org.postgresql.jdbc2.ResultSet.getTimestamp(Unknown Source) at org.postgresql.jdbc2.ResultSet.getTimestamp(Unknown Source) at com.mchange.v2.c3p0.impl.C3P0ResultSet.getTimestamp(C3P0ResultSet.java:363) at net.sf.hibernate.type.TimestampType.get(TimestampType.java:22) at net.sf.hibernate.type.NullableType.nullSafeGet(NullableType.java:62) at net.sf.hibernate.type.NullableType.nullSafeGet(NullableType.java:53) at net.sf.hibernate.type.AbstractType.hydrate(AbstractType.java:66) at ... |
25. OracleDialect and timestamp forum.hibernate.org |
26. Handling timestamp using Mckoi dialect forum.hibernate.orgAuthor Message kcrimson Post subject: Handling timestamp using Mckoi dialect Posted: Thu Aug 05, 2004 5:08 am Newbie Joined: Thu Aug 05, 2004 4:45 am Posts: 3 Hello! I'm using McKoiDb 1.0.2 with hibernate 2.1.5 and I have problem with queries with timestamp values in where clause. Here is my code Code: final Query query = session ... |
27. May I ask what's the defect of the timestamp tag? forum.hibernate.orgpublic String getCreator() { if(creator!=null){ return creator.trim(); }else{ return null; ... |
28. SUM() with TIMESTAMP forum.hibernate.org |
29. How can I turn off expry for the timestamp cache? forum.hibernate.orgNewbie Joined: Fri Sep 17, 2004 2:53 pm Posts: 7 Hi, I really need help for my EhCache caching issue. I am using EhCache with Hibernate. I did whatever the document said to config the cache but can not get the cached records used. It still goes back to database everytime a query issued. I turned on the debug info for ... |
30. timestamp forum.hibernate.orgHibernate version: 2.0 Given the following in a |
31. Domain Objects returning Timestamp (Expecting Just Date) HB3 forum.hibernate.orgI am experiencing some differences between version 2.1 and 3.0A data mapped fields. It seems that my mapping, although defined as java.util.Date, returns java.sql.Timestamp. The Java2 API suggests that Date and Timestamp objects should never be compared. So, two questions, 1. Will Hibernate 3.0 now return java.sql.Timestamps for properties mapped as Date 2. What is the best practice when dealing with ... |
32. Timestamp and HSQLDB forum.hibernate.orgHi, I have a problem with HSQLDB and Hibernate. With this String I want to get the number of objects that are stored in the database with some certain properties: String hql="select count(*) from " +TRANSFER +" where art='" +trf.getClass().getName() +"' and startOrt='" +trf.getStartOrt() +"' and zielOrt='" +trf.getZielOrt() +"' and ankunftsZeit='" +trf.getAnkunftsZeit() // (*) +"' and startZeit='" +trf.getStartZeit() //(**) +"' and ... |
33. StaleObjectException while using timestamp forum.hibernate.orgNewbie Joined: Wed Jan 12, 2005 6:30 am Posts: 12 Hibernate version:2.1.3 Hi, I am using timestamp tag to map a property in the persitent class to a Timestamp field of a table in the database. In my code i have a Set(collection) of persistent object which are mapped to this table. My code retrieves the rows from this table and ... |
34. Timestamp problem forum.hibernate.orgHi, just started to use hibernate. I have a problem with a field with type timestamp. I use a DB2 database. I get this error : Caused by: net.sf.hibernate.PropertyAccessException: IllegalArgumentException occurred while calling setter of dk.te.deb.pojo.Player.draft_date at net.sf.hibernate.property.BasicPropertyAccessor$BasicSetter.set(BasicPropertyAccessor.java:68) at net.sf.hibernate.persister.AbstractEntityPersister.setPropertyValues(AbstractEntityPersister.java:229) at net.sf.hibernate.impl.SessionImpl.initializeEntity(SessionImpl.java:2224) at net.sf.hibernate.loader.Loader.initializeEntitiesAndCollections(Loader.java:319) at net.sf.hibernate.loader.Loader.doQuery(Loader.java:309) at net.sf.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:138) my setter method lookes like this : /** * @hibernate.property * column="DRAFT_DATE" * ... |
35. Timestamp and StaleObjectStateException forum.hibernate.orgI've set a timestamp in my hbm.xml, but I'm not getting the exception when two users change the same data. I'm getting "last saved wins". Is there more than setting the |
36. Hibernate 2.1.5 and Oracle 9.2 timestamp trouble forum.hibernate.orgHi all, Does anyone know to manage the timestamp format of Oracle With Hibernate ? I always this error message : ORA-01843: ce n'est pas un mois valide (in englis it means 'No valid month'). I created my table like that : create table test ( id int, pdate timestamp); The exception is throw when i try to retrieve the table ... |
37. Oracle timestamp with local time zone forum.hibernate.orgDiederich wrote: Hibernate version:2.1.7 Could not find any issue with that topic, so I ask: if the DB contains a column "timestamp with local time zone", the Oracle JDBC driver (Oracle 10g) complains that the Session Time Zone is not set. Any way to do this? (I will switch to "timestamp with time zone" anyway, just wondering) Thanks in advance, Thomas ... |
38. TimeStamp forum.hibernate.org |
39. Comparing a timestamp date with a string date forum.hibernate.orgHi all, I've the following code: Query query = dbSession.createQuery("from Job as job where job.dateCollected >= :dateStart"); query.setTimestamp("dateStart", DateTimeUtil.parse((String) request.getParameter("dateStart")).toDate()); It works fine if the dateCollected field is a Date Object in my Job class Due to unforseen stuff, dateCollected has to be changed to a String Object. How should i change the query? The dateStart parameter is gotten from a ... |
40. Comparing a timestamp date with a string date forum.hibernate.orgHi all, I've the following code: Query query = dbSession.createQuery("from Job as job where job.dateCollected >= :dateStart"); query.setTimestamp("dateStart", DateTimeUtil.parse((String) request.getParameter("dateStart")).toDate()); It works fine if the dateCollected field is a Date Object in my Job class Due to unforseen stuff, dateCollected has to be changed to a String Object. How should i change the query? The dateStart parameter is gotten from a ... |
41. I want a modified timestamp that works! forum.hibernate.orgI'm using 3.0.5 My entities have a modified timestamp on them. I've been setting it in an Interceptor in the methods onSave() and onFlushDirty(). Unfortunately, that fails me in one case... when a parent entity is updated, and only a collection has been modified, onFlushDirty() is never called. I suppose what I want is for the entity passed to session.update() to ... |
42. Problem: Timestamp forum.hibernate.org |
43. Filter is treating timestamp param as date forum.hibernate.orgI've defined a filterdef that takes a timestamp as a parameter, but whenever I try to enable the filter, and set that parameter with a java.sql.Timestamp, Hibernate is dropping the time portion of the timestamp and only querying with the date. In my example below, the startTime and endTime columns are both timestamps in the database. Any idea what I might ... |
44. Get current timestamp from sysibm.sysdummy1 forum.hibernate.org |
45. HQL Timestamp forum.hibernate.orgHello all, its my first post. Im having problems with an HQL. I use PostgreSQL 8.1, and I need to make a select that returns every Timestamp field that has an hour, lets say, afte 7:00. Tryed using to_date, but it doesnt seem to work this way: to_date('07:00','HH:mi') anyone got any idea? I want to verify the time of every date ... |
46. Time conversion and one hour off with java TimeStamp & m forum.hibernate.orgI have a field of type 'datetime' in a MySQL (5.0) table but when I persist any date/time information, the time is off by one hour in the database but when I print out the information about the object that was persisted, it shows the correct date/time until I re-load it from the database. Is there someplace in the mapping file ... |
47. Oracle 10g and Timestamp forum.hibernate.orgHi everybody, I was using oracle 9i and hibernate 3.1 with the following code: Code: Query qPub = sessApolo.createQuery("select m from MovimentoProcesso m where m.codigoProcesso = :codigoProcesso and m.codigoSecao = :codigoSecao and m.dataMovimento = :dataMovimento"); qPub.setInteger("codigoProcesso",sp.getCodigoProcesso()); qPub.setInteger("codigoSecao",sp.getCodigoSecao()); ... |
48. Hibernate persists Date / Timestamp object 2 hours off forum.hibernate.orgHibernate version: Hi, I'm using Hibernate 3.1.3 with annotations on Oracle 9i. I have thoroughly found with no success in the forum and the Internet before submitting this post. The problem I have is that when I persist a Date or Timestamp (I tried both) the database value is (exactly) 2 hours off. The way this is carrying out is really ... |
49. Problem when using Timestamp type in Hibernate forum.hibernate.orgHi, I am getting: "java.lang.UnsupportedOperationException: cannot perform lookups on timestamps " My Data type in the Database for a column is the Timestamp type. In the POJO, I set the mapping to java.sql.Timestamp wrapper class. Similarly, in the hbm file, I set the type as "timestamp". However, it throws the "java.lang.UnsupportedOperationException: cannot perform lookups on timestamps " when doing an operation ... |
50. How to store a GMT timestamp? forum.hibernate.orgNeed help with Hibernate? Read this first: http://www.hibernate.org/ForumMailingli ... AskForHelp Hibernate version: 3.1 and 3.2 We have a few applications where we read/write to the same tables from C++ and Java. In our C++ applications we always convert to and work with timestamps as GMT. On the Java side of things, it appears as though there is a conversion happening before ... |
51. EJB3 comparing Date and Timestamp forum.hibernate.org |
52. unix_timestamp hibernate 3.2 problem forum.hibernate.orgWith hibernate 3.2. I am using an HQL query. It has no problem accepting mysql's "unix_timestamp" function. However, it fails miserably when using a DB other than MYSQL. My question is two fold 1. If HQL query does not really support unix_timestamp() why does it allow it with my sql (this is not a native query after all!) 2. Can anybody ... |
53. Hibernate constructor is not accepting Timestamp object forum.hibernate.orgHibernate constructor is not taking the Timestamp object . when i try to pass the Timestamp object while executing the query it is throwing the exception stating in appropriate constructor.So in order to fetch the timestamp object from DB , what is the best solution. can any one suggest why it is throwing exception. reply to this posting is appreciated thnx ... |
54. how truncate a timestamp forum.hibernate.org |
55. How to store Date with Timestamp in Oracle forum.hibernate.orgI have a POJO generated by hbm2java in which I have a property Date. I need to insert date with timestamp in Oracle using the setter method. I tried the following ways: obj.setPwdChangeDt( new java.util.Date() ) and obj.setPwdChangeDt( new Timestamp( System.currentTimeMillis() )); But neither is working, only inserting Date. How to insert date with timestamp. |
56. TimeStamp 000000000000 problem forum.hibernate.org |
57. Timestamp month condition forum.hibernate.orgHi at all. I need to set a where condition to obtain the follow SQL statement select to_char(insert_date,'MM'),count(*) from rs_requests group by to_char(insert_date,'MM') In other words I need to count the number of requests per month. (insert_date is a Timestamp field mapped to insertDate property of Request class) Hiberante version: select to_char(insertDate,'MM'), count(*) from Request group by to_char(insertDate,'MM') The problem of ... |
58. creation timestamp on JoinTable forum.hibernate.orgI have a join table with a name like "baker_buns" generated from an @ManyToMany mapping which has two columns: bakers_id and buns_id. How can I get hibernate to also add a timestamp column to this table which will be set to current time whenever a row is added to the table? The annotated code looks something like this: Code: @Entity public ... |
59. how to achieve timestamp with time zone forum.hibernate.orgHi there, I'm new to Hibernate so allow me to first state how impressed I am with this toolkit. I'm totally blown away with how Hibernate has allowed me to derive an RDBMS schema that was actually better than the non-ORM schema that I had! :-) Kudos to the Hibernate contributors. One thing that has tripped me up though is around ... |
60. Problems using timestamp triggers forum.hibernate.orgHi all I am experiencing some problems using timestamp triggers both with H2 & MySQL mappings 1) If I move the last-modified property block after any other hbm2ddl fails badly with Executing Hibernate Tool with a Standard Configuration 1. task: hbm2ddl (Generates database schema) 14:40:56,850 ERROR XMLHelper:61 - Error parsing XML: XML InputStream(65) The content of element type "class" must match ... |
61. storing timestamp forum.hibernate.orgI have a column in a table with datatype Date. And in the mapping file, i mentioned the type="timestamp" The associated POJO for my table generates the column with Date. Its setter() is accepting only Date as a parameter. But when i persist, i am able to save only Date and i am unable to save the time along with date. ... |
62. extract month from timestamp forum.hibernate.org |
63. Oracle dilemma - Date or Timestamp forum.hibernate.orgHi I apologize if this question has been answered already. I posted this wrongly in the Tools forum and rightly got no response so I'm hoping I get some help here. I am running an Oracle 9i database and using a 10G driver - ojdbc14_10-2-0-3.jar (copied to lib folder) , we are upgrading our database to 10G soon. All my tables ... |
64. Difference between timestamp forum.hibernate.orgHi all, How can a get the difference of two timestamp and sum all them up. Is there a function to get the millisecond out of a timestamp field (I could not find it on the documentation)? This is the query I'm trying to run and I get a "Wrong data type in statement": Code: select str(year(startTime))||' '||str(month(startTime))||' '||str(day(startTime)), sum( lastUpdate ... |
65. timestamp and oracle forum.hibernate.orgHi, Hibernate version: 3.2 Name and version of the database you are using: oracle express 10g Hi, I'm trying to migrate my postgresql database to oracle express 10 on rhel 5. All seems ok. My application use tomcat and hibernate to access database. I have a problem between java timestamp and oracle timestamp. When I set hibernate in verbose mode, I ... |
66. store the timestamp in UTC forum.hibernate.org |
67. How to get uninicialized Timestamp? forum.hibernate.orgI have table in database (mysql) with column endDate Timestamp. It can ce null, but as a default database puts such value '0000-00-00 00:00:00'. In mapping file I have: |
68. timestamp check with HQL forum.hibernate.org |
69. How to do aggregation grouped by calc result of timestamp? forum.hibernate.orgI have a table with lots of system performance data, with the following columns: IID: unique id TIMESTAMPT ITIME: date/time when the data was collected VARCHAR(16) ITYPE: type of data INTEGER IVAL: data value The class looks like: class PerfData{ Date time; String type; int val; } When ITYPE="CPU", it means performance data of CPU. Now I want to show average ... |
70. TemporalType.TIMESTAMP forum.hibernate.orgWhen I use MyEclipse to generate my data objects. The problem I am having is that it does not appear to translate the MySQL5.1 datetime to the correct TemporalType of TIMESTAMP. If I have a field name of start_date I get the following: @Temporal(TemporalType.DATE) @Column(name = "START_DATE", length = 0) public Date getStartDate() { return this.startDate; } I then have to ... |
71. Hibernate timestamping checking forum.hibernate.orgHello guys, Ok, ill rephrase my entire post. hehe i am working on a project which involve intensive monetary transactions, thus i really need to secure each transaction. I want to perform a record locking and timestamping on each transaction. for instance, user1 and user2 access a single record at the same time. then, user1 saves his changes. While user1's transaction ... |
72. Problem with createCriteria, Restrictions and TimeStamp forum.hibernate.org |