1. How to do regular database cleanup in a JPA application? stackoverflow.comShort background: I have a software that regularly downloads files. The Statistics of these downloads are stored in the database as a DownloadResult entity, which is in turn associated to the entity ... |
2. Providing support for access to stored procedures for data transformation product stackoverflow.comI work a data transformation product that has a GUI interface that maps one type of object to another. So it has a bunch of elements on the left that maps ... |
3. problem using hibernate and stored procedures for reading portion of data from database coderanch.comHi... I am trying to read one column of the table using hibernate and stored procedures.But I got the following error Hibernate: {call sample(?,?)} Exception in thread "main" org.hibernate.exception.GenericJDBCException: could not execute query at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:103) at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:91) at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43) at org.hibernate.loader.Loader.doList(Loader.java:2223) at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2104) at org.hibernate.loader.Loader.list(Loader.java:2099) at org.hibernate.loader.custom.CustomLoader.list(CustomLoader.java:289) at org.hibernate.impl.SessionImpl.listCustomQuery(SessionImpl.java:1695) at org.hibernate.impl.AbstractSessionImpl.list(AbstractSessionImpl.java:142) at org.hibernate.impl.SQLQueryImpl.list(SQLQueryImpl.java:152) at org.hibernate.impl.AbstractQueryImpl.uniqueResult(AbstractQueryImpl.java:811) at TestDAO.main(TestDAO.java:20) Caused by: java.sql.SQLException: Invalid ... |
5. How to call stored procedure and insert in db correctly forum.hibernate.orgFrom the ref docs, section 16.4: The order of the positional parameters are currently vital, as they must be in the same sequence as Hibernate expects them. You can see the expected order by enabling debug logging for the org.hibernate.persister.entity level. With this level enabled Hibernate will print out the static SQL that is used to create, update, delete etc. entities. ... |
6. Using Stored Procedures to insert data in Mysql DB forum.hibernate.orgHi! I need some help because I'm having some trouble using stored procedures on a Mysql DB. I want to change the hibernate generated SQL insert function to a custom SP (stored procedure). I also want the DB to generate the data id with a simple auto-incemented counter. The problem is that Hibernate does not find the generated id after the ... |