[hibernate-issues] [Hibernate-JIRA] Created: (HHH-3990) Bulk update statements do not use default schema in generated SQL

Bulk update statements do not use default schema in generated SQL ----------------------------------------------------------------- Key: HHH-3990 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-3990 Project: Hibernate Core Issue Type: Bug Affects Versions: 3.3.1 Environment: Hibernate 3.3.1GA Oracle 10g Reporter: hard hat Priority: Critical When setting the hibernate.default_schema property in hibernate.cfg, the schema is not used when executing buld (hql) update statements. You can test this easily with any existing hibernate mapping + database: Create a second database user, grant select & update rights for the tables in your existing database to that user. Modify your hibernate.cfg to use the new user and set the default schema to the new user. Now, your application should work just as before, except for any bulk updates. You can now try to make a bulk update, for exampe: query = session.createQuery("update versioned Person p SET p.name = :name where p.id = :id"); query.setString("name", "Jack"); query.setLong("id", 42); query.executeUpdate(); This fails with TABLE NOT EXIST error, because the generated SQL does not have the defined default schema as prefix. -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://opensource.atlassian.com/projects/hibernate/secure/Administrators.... - For more information on JIRA, see: http://www.atlassian.com/software/jira