if ( BinderHelper.isEmptyAnnotationValue( queryAnn.name() ) ) { throw new AnnotationException( "A named query must have a name when used in class or package level" ); String resultSetMapping = queryAnn.resultSetMapping(); if ( !BinderHelper.isEmptyAnnotationValue( resultSetMapping ) ) { query = new NamedSQLQueryDefinitionBuilder().setName( queryAnn.name() ) .setQuery( queryAnn.query() ) .setResultSetRef( resultSetMapping ) .setQuerySpaces( null ) .setCacheable( queryAnn.cacheable() ) .setCacheRegion( BinderHelper.isEmptyAnnotationValue( queryAnn.cacheRegion() ) ? null : queryAnn.cacheRegion() .setTimeout( queryAnn.timeout() < 0 ? null : queryAnn.timeout() ) .setFetchSize( queryAnn.fetchSize() < 0 ? null : queryAnn.fetchSize() ) .setFlushMode( getFlushMode( queryAnn.flushMode() ) ) .setCacheMode( getCacheMode( queryAnn.cacheMode() ) ) .setReadOnly( queryAnn.readOnly() ) .setComment( BinderHelper.isEmptyAnnotationValue( queryAnn.comment() ) ? null : queryAnn.comment() ) .setParameterTypes( null ) .setCallable( queryAnn.callable() ) .createNamedQueryDefinition(); else if ( !void.class.equals( queryAnn.resultClass() ) ) { new NativeSQLQueryRootReturn( "alias1", queryAnn.resultClass().getName(), new HashMap(), LockMode.READ );
@NamedNativeQuery( name = "get_person_phone_count", query = "SELECT pr.name AS name, count(*) AS phoneCount " +
if ( BinderHelper.isDefault( queryAnn.name() ) ) { throw new AnnotationException( "A named query must have a name when used in class or package level" ); String resultSetMapping = queryAnn.resultSetMapping(); if ( !BinderHelper.isDefault( resultSetMapping ) ) { queryAnn.query(), resultSetMapping, null, queryAnn.cacheable(), BinderHelper.isDefault( queryAnn.cacheRegion() ) ? null : queryAnn.cacheRegion(), queryAnn.timeout() < 0 ? null : queryAnn.timeout(), queryAnn.fetchSize() < 0 ? null : queryAnn.fetchSize(), getFlushMode( queryAnn.flushMode() ), getCacheMode( queryAnn.cacheMode() ), queryAnn.readOnly(), BinderHelper.isDefault( queryAnn.comment() ) ? null : queryAnn.comment(), null, queryAnn.callable() ); else if ( !void.class.equals( queryAnn.resultClass() ) ) { new NativeSQLQueryRootReturn( "alias1", queryAnn.resultClass().getName(), new HashMap(), LockMode.READ ); query = new NamedSQLQueryDefinition( queryAnn.query(), new NativeSQLQueryReturn[] { entityQueryReturn }, null, queryAnn.cacheable(),
if ( BinderHelper.isEmptyAnnotationValue( queryAnn.name() ) ) { throw new AnnotationException( "A named query must have a name when used in class or package level" ); String resultSetMapping = queryAnn.resultSetMapping(); if ( !BinderHelper.isEmptyAnnotationValue( resultSetMapping ) ) { queryAnn.name(), queryAnn.query(), resultSetMapping, null, queryAnn.cacheable(), BinderHelper.isEmptyAnnotationValue( queryAnn.cacheRegion() ) ? null : queryAnn.cacheRegion(), queryAnn.timeout() < 0 ? null : queryAnn.timeout(), queryAnn.fetchSize() < 0 ? null : queryAnn.fetchSize(), getFlushMode( queryAnn.flushMode() ), getCacheMode( queryAnn.cacheMode() ), BinderHelper.isEmptyAnnotationValue( queryAnn.comment() ) ? null : queryAnn.comment(), null, queryAnn.callable() ); else if ( !void.class.equals( queryAnn.resultClass() ) ) { new NativeSQLQueryRootReturn( "alias1", queryAnn.resultClass().getName(), new HashMap(), LockMode.READ ); query = new NamedSQLQueryDefinition( queryAnn.name(), queryAnn.query(), new NativeSQLQueryReturn[] { entityQueryReturn },
if ( BinderHelper.isDefault( queryAnn.name() ) ) { throw new AnnotationException( "A named query must have a name when used in class or package level" ); String resultSetMapping = queryAnn.resultSetMapping(); if ( ! BinderHelper.isDefault( resultSetMapping ) ) { queryAnn.query(), resultSetMapping, null, queryAnn.cacheable(), BinderHelper.isDefault( queryAnn.cacheRegion() ) ? null : queryAnn.cacheRegion(), queryAnn.timeout() < 0 ? null : queryAnn.timeout(), queryAnn.fetchSize() < 0 ? null : queryAnn.fetchSize(), getFlushMode( queryAnn.flushMode() ), getCacheMode( queryAnn.cacheMode() ), queryAnn.readOnly(), BinderHelper.isDefault( queryAnn.comment() ) ? null : queryAnn.comment(), null, else if ( ! void.class.equals( queryAnn.resultClass() ) ) { new NativeSQLQueryRootReturn( "alias1", queryAnn.resultClass().getName(), new HashMap(), LockMode.READ ); query = new NamedSQLQueryDefinition( queryAnn.query(), new NativeSQLQueryReturn[]{entityQueryReturn}, null, queryAnn.cacheable(), BinderHelper.isDefault( queryAnn.cacheRegion() ) ? null : queryAnn.cacheRegion(), queryAnn.timeout() < 0 ? null : queryAnn.timeout(),
if ( BinderHelper.isEmptyAnnotationValue( queryAnn.name() ) ) { throw new AnnotationException( "A named query must have a name when used in class or package level" ); String resultSetMapping = queryAnn.resultSetMapping(); if ( !BinderHelper.isEmptyAnnotationValue( resultSetMapping ) ) { queryAnn.name(), queryAnn.query(), resultSetMapping, null, queryAnn.cacheable(), BinderHelper.isEmptyAnnotationValue( queryAnn.cacheRegion() ) ? null : queryAnn.cacheRegion(), queryAnn.timeout() < 0 ? null : queryAnn.timeout(), queryAnn.fetchSize() < 0 ? null : queryAnn.fetchSize(), getFlushMode( queryAnn.flushMode() ), getCacheMode( queryAnn.cacheMode() ), BinderHelper.isEmptyAnnotationValue( queryAnn.comment() ) ? null : queryAnn.comment(), null, queryAnn.callable() ); else if ( !void.class.equals( queryAnn.resultClass() ) ) { new NativeSQLQueryRootReturn( "alias1", queryAnn.resultClass().getName(), new HashMap(), LockMode.READ ); query = new NamedSQLQueryDefinition( queryAnn.name(), queryAnn.query(), new NativeSQLQueryReturn[] { entityQueryReturn },
@Entity(name = "CardWithCustomSQL") @Persister( impl = SingleTableEntityPersister.class ) @Loader(namedQuery = "find_foo_by_id") @NamedNativeQuery( name = "find_foo_by_id", query = "SELECT id, name FROM {h-schema}FOO WHERE id = ?", resultClass = CustomEntity.class ) @SQLInsert(sql = "INSERT INTO {h-schema}FOO (name, id) VALUES (?, ?)") @SQLDelete(sql = "DELETE FROM {h-schema}FOO WHERE id = ?", check = ResultCheckStyle.COUNT) @SQLUpdate(sql = "UPDATE {h-schema}FOO SET name = ? WHERE id = ? ") public static class CustomEntity { @Id public Integer id; private String name; }
if ( BinderHelper.isEmptyAnnotationValue( queryAnn.name() ) ) { throw new AnnotationException( "A named native query must have a name when used in class or package level" ); final String queryName = queryAnn.name(); final String sqlString = queryAnn.query(); .setCacheable( queryAnn.cacheable() ) .setCacheRegion( BinderHelper.isEmptyAnnotationValue( queryAnn.cacheRegion() ) ? null : queryAnn.cacheRegion() .setTimeout( queryAnn.timeout() < 0 ? null : queryAnn.timeout() ) .setFetchSize( queryAnn.fetchSize() < 0 ? null : queryAnn.fetchSize() ) .setFlushMode( getFlushMode( queryAnn.flushMode() ) ) .setCacheMode( getCacheMode( queryAnn.cacheMode() ) ) .setReadOnly( queryAnn.readOnly() ) .setComment( BinderHelper.isEmptyAnnotationValue( queryAnn.comment() ) ? null : queryAnn.comment() ); final String resultSetMappingName = queryAnn.resultSetMapping(); else if ( !void.class.equals( queryAnn.resultClass() ) ) { final ResultSetMappingDefinitionImpl resultSetMappingDefinition = new ResultSetMappingDefinitionImpl( "inline-result-mapping:" + ++inlineResultMappingCount ); final String entityClassName = queryAnn.resultClass().getName(); resultSetMappingDefinition.addResult( new EntityResultDefinitionImpl( null, entityClassName, "alias1" ) );
@NamedNativeQuery( name = "getPerson", query = "{ ? = call fn_person( ? ) }",
@Entity(name = "QueryHolder") @NamedNativeQuery( name = "fn_post_and_comments", query = "{ ? = call fn_post_and_comments( ? ) }",