[hibernate-issues] [Hibernate-JIRA] Issue Comment Edited: (HHH-5692) Invalid {h-schema} replacement in native sql queries

[ http://opensource.atlassian.com/projects/hibernate/browse/HHH-5692?page=c... ] Greg Maczuga edited comment on HHH-5692 at 10/26/10 7:33 AM: ------------------------------------------------------------- Workaround for Spring is to use LocalSessionFactoryBean and override postProcessConfiguration method {code:title=LocalSessionFactoryBean.java} @SuppressWarnings("unchecked") @Override protected void postProcessConfiguration(Configuration config) throws HibernateException { String defaultSchema = config.getProperty(DEFAULT_SCHEMA_PROPERTY_NAME); Set<String> queriesNames = config.getNamedSQLQueries().keySet(); for (String name : queriesNames) { NamedSQLQueryDefinition namedSQLQuery = (NamedSQLQueryDefinition) config.getNamedSQLQueries().get(name); if (namedSQLQuery.getQuery().contains(SCHEMA_PLACEHOLDER)) { String query = namedSQLQuery.getQuery().replace(SCHEMA_PLACEHOLDER, defaultSchema + "."); NamedSQLQueryDefinition newQuery = new NamedSQLQueryDefinition(query, namedSQLQuery.getQueryReturns(), namedSQLQuery.getQuerySpaces(), namedSQLQuery.isCacheable(), namedSQLQuery.getCacheRegion(), namedSQLQuery.getTimeout(), namedSQLQuery.getFetchSize(), namedSQLQuery.getFlushMode(), namedSQLQuery.getCacheMode(), namedSQLQuery.isReadOnly(), namedSQLQuery.getComment(), namedSQLQuery.getParameterTypes(), namedSQLQuery.isCallable()); // replace named query definition config.getNamedSQLQueries().put(name, newQuery); } } } {code} was (Author: gmaczuga): Workaround for Spring is to use LocalSessionFactoryBean and override postProcessConfiguration method <code> @SuppressWarnings("unchecked") @Override protected void postProcessConfiguration(Configuration config) throws HibernateException { String defaultSchema = config.getProperty(DEFAULT_SCHEMA_PROPERTY_NAME); Set<String> queriesNames = config.getNamedSQLQueries().keySet(); for (String name : queriesNames) { NamedSQLQueryDefinition namedSQLQuery = (NamedSQLQueryDefinition) config.getNamedSQLQueries().get(name); if (namedSQLQuery.getQuery().contains(SCHEMA_PLACEHOLDER)) { String query = namedSQLQuery.getQuery().replace(SCHEMA_PLACEHOLDER, defaultSchema + "."); NamedSQLQueryDefinition newQuery = new NamedSQLQueryDefinition(query, namedSQLQuery.getQueryReturns(), namedSQLQuery.getQuerySpaces(), namedSQLQuery.isCacheable(), namedSQLQuery.getCacheRegion(), namedSQLQuery.getTimeout(), namedSQLQuery.getFetchSize(), namedSQLQuery.getFlushMode(), namedSQLQuery.getCacheMode(), namedSQLQuery.isReadOnly(), namedSQLQuery.getComment(), namedSQLQuery.getParameterTypes(), namedSQLQuery.isCallable()); // replace named query definition config.getNamedSQLQueries().put(name, newQuery); } } } </code> -- 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