1. Stored proc insert/update/del in hibernate? coderanch.comHi. Similar to the lack of documentation I'm finding on stored proc queries in my other reply on this thread, I'm finding a bit of a lack of documentation on insert/update/delete in hibernate using straight sql calls and stored procedures here: http://www.hibernate.org/hib_docs/v3/reference/en/html/querysql.html Skip down to section 16.4. There it discusses how to set up the mapping file and the stored proc ... |
2. Any sucess using Hibernate, MySQL, and sql-update with stored procedures? coderanch.comI've read the documentation, and even have some working code with Hibernate, MySQL, and calling stored procedures for sql-insert, sql-delete, and somewhat for sql-update. But it wasn't easy because much of the documentation seems inaccurate, and incomplete - at least when using MySQL. I have written several stored procedures that I have tested and are working for inserting, updating and deleting ... |
3. Importance of stored procedure with insert and update query forum.hibernate.orgHi, We had SQLsever 200 Database .We need to use hibernate newly. while i am using hibernate to call stored procedures , i observed that stored procedures with select queries are working fine. But, i had faced a problem while using the stored procedure with insert and update queries having both in the same stored procedure and by depending on the ... |
4. Calling DB2 update stored procedure forum.hibernate.orgHibernate 3.0.5: When calling executeUpdate() on a DB2 stored procedure {?=call soh_updTable1(?,?,?,?)} an ArrayIndexOutOfBoundsException is thrown (shown below). It is possible to work around this Exception using a true OUT parameter in the procedure and call syntax of {call soh_updTable1(?,?,?,?)}, however, when the EntityPersister checks to see if the update was successful using the return value from the executeUpdate() function a ... |
5. Using a stored procedure for updating a column forum.hibernate.orgI have a database table, and I would like to override the SQLUpdate with the following (Hibernate 3): @SQLUpdate = (sql = "UPDATE person_user SET description = ?, facility = ?, person_id = ?, slot_number = ?, modify_date = current_utc_date(), modify_time = current_utc_time() WHERE id = ?") Now, notice that modify_date and time are not using the current values in the ... |