Hi, I'm having a problem migrating a hibernate 3.0 app to 3.1 for a few queries. I'll post others later, but the first one I'm tackling concerns using postgres functions using hibernate. I'm not going to be posting map files, since there aren't really all that important, but the bolded lines in this query cause the following problems to happen below. ...
Suppose I have a query: SELECT * FROM exchange_pp WHERE TIMESTAMPDIFF(hour, last_updt_dt,now()) <96, which will get data for the past 96 hours. TIMESTAMPDIFF is mysql built in functoin. I have POJO for this table with field last_updt_dt. How could I create Hiberante query to get the same data as I used above query.
Hi, I hope someone can help me. I am new to Hibernate and I am trying to set up the example program eg (the Auction example). When test data is being inserted I get the following exception (The driver does not support this function). I am using the jt400.jar for DB2 on iSeries. Does anyone know what this means, what the ...
i want to count how many specialy string in the field. oracle used to next sentence. 'instr(field, findString, offset, count)' hibernate can resolve to use native sql by session.createSQLQuery or Restrictions.sqlRestrictions(). but this method was jsatified with oracle database, just. I want to use this function at global database. how can resolve this problem? thank you.
I m using postgresql db , I m facing with following problem 19:21:59,625 INFO [STDOUT] [2008-03-20 19:21:59,624] org.hibernate.util.JDBCExceptionReporter WARN org.apache.commons.logging.impl.Log4JLogger.warn(Log4JLogger.java:104) - SQL Error: 0, SQLState: null 19:21:59,626 INFO [STDOUT] [2008-03-20 19:21:59,625] org.hibernate.util.JDBCExceptionReporter ERROR org.apache.commons.logging.impl.Log4JLogger.error(Log4JLogger.java:114) - Batch entry 0 select * from createUser ('Testaa',2) as result was aborted. Call getNextException to see the cause. 19:21:59,626 INFO [STDOUT] [2008-03-20 19:21:59,626] org.hibernate.util.JDBCExceptionReporter WARN org.apache.commons.logging.impl.Log4JLogger.warn(Log4JLogger.java:104) ...