April 2020 - hibernate-issues - Jboss List Archives

[JIRA] (HHH-13957) org.hibernate.QueryException: Ordinal parameter not bound : 1

by Sergey Smith (JIRA)

Sergey Smith ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=5e9b5e4... ) *created* an issue Hibernate ORM ( https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiZmE2N2M0MDBj... ) / Bug ( https://hibernate.atlassian.net/browse/HHH-13957?atlOrigin=eyJpIjoiZmE2N2... ) HHH-13957 ( https://hibernate.atlassian.net/browse/HHH-13957?atlOrigin=eyJpIjoiZmE2N2... ) org.hibernate.QueryException: Ordinal parameter not bound : 1 ( https://hibernate.atlassian.net/browse/HHH-13957?atlOrigin=eyJpIjoiZmE2N2... ) Issue Type: Bug Affects Versions: 5.4.14 Assignee: Unassigned Components: hibernate-core Created: 18/Apr/2020 13:48 PM Priority: Minor Reporter: Sergey Smith ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=5e9b5e4... ) "reserveFirstParameter" boolean parameter is being ignored in QueryParameterBindingsImpl#verifyParametersBound and this leads to throw new QueryException( "Ordinal parameter not bound : " + parameter.getPosition() ); when the first parameter is being checked. Initial conditions: 1. Have the following Oracle procedure: PROCEDURE LoadValuesUsingOracleRefCursor( returning_values IN OUT SYS_REFCURSOR, some_parameters IN CLOB ) AS BEGIN ... END LoadValuesUsingOracleRefCursor; 2. Have the following named query in a hbm.xml file: <sql-query name="load_values_from_db" callable="true"> {call LoadValuesUsingOracleRefCursor(?, ?)} </sql-query> Test case: NativeQuery query = entityManager.unwrap(Session.class).getNamedNativeQuery("load_values_from_db"); query.setParameter(2, "A_STRING_VALUE"); query.list; Actual result: Following exception is thwrown: Caused by: org.hibernate.QueryException: Ordinal parameter not bound : 1 at org.hibernate.query.internal.QueryParameterBindingsImpl.verifyParametersBound(QueryParameterBindingsImpl.java:213) at org.hibernate.query.internal.AbstractProducedQuery.beforeQuery(AbstractProducedQuery.java:1425) at org.hibernate.query.internal.NativeQueryImpl.beforeQuery(NativeQueryImpl.java:249) at org.hibernate.query.internal.AbstractProducedQuery.list(AbstractProducedQuery.java:1531) Sometime it's impossible to use StoredProcedureQuery with its registerStoredProcedureParameter(1, Class.class, ParameterMode.REF_CURSOR), because WebLogic 12.2.1 still uses JDBC 4.0 Oracle driver, not 4.2. ( https://hibernate.atlassian.net/browse/HHH-13957#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-13957#add-comment?atlOrigin=ey... ) Get Jira notifications on your phone! Download the Jira Cloud app for Android ( https://play.google.com/store/apps/details?id=com.atlassian.android.jira.... ) or iOS ( https://itunes.apple.com/app/apple-store/id1006972087?pt=696495&ct=EmailN... ) This message was sent by Atlassian Jira (v1001.0.0-SNAPSHOT#100124- sha1:93e2dd3 )

5 years, 12 months

1
0
0 / 0

[JIRA] (HHH-13932) Trying to set an unused parameter causes a NullPointerException, instread of throwing a more sensible error.

by George Katiforis (JIRA)

George Katiforis ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=5b485f5... ) *commented* on HHH-13932 ( https://hibernate.atlassian.net/browse/HHH-13932?atlOrigin=eyJpIjoiMzdhNj... ) Re: Trying to set an unused parameter causes a NullPointerException, instread of throwing a more sensible error. ( https://hibernate.atlassian.net/browse/HHH-13932?atlOrigin=eyJpIjoiMzdhNj... ) Thank you for pointing this out. PR: https://github.com/hibernate/hibernate-orm/pull/3355 ( https://hibernate.atlassian.net/browse/HHH-13932#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-13932#add-comment?atlOrigin=ey... ) Get Jira notifications on your phone! Download the Jira Cloud app for Android ( https://play.google.com/store/apps/details?id=com.atlassian.android.jira.... ) or iOS ( https://itunes.apple.com/app/apple-store/id1006972087?pt=696495&ct=EmailN... ) This message was sent by Atlassian Jira (v1001.0.0-SNAPSHOT#100124- sha1:93e2dd3 )

5 years, 12 months

1
0
0 / 0

[JIRA] (HHH-13932) Trying to set an unused parameter causes a NullPointerException, instread of throwing a more sensible error.

by George Katiforis (JIRA)

5 years, 12 months

1
0
0 / 0

[JIRA] (HSEARCH-3897) Support explain query while changing the index name

by Fabio Massimo Ercoli (JIRA)

5 years, 12 months

1
0
0 / 0

[JIRA] (HSEARCH-3897) Support explain query while changing the index name

by Fabio Massimo Ercoli (JIRA)

Fabio Massimo Ercoli ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *created* an issue Hibernate Search ( https://hibernate.atlassian.net/browse/HSEARCH?atlOrigin=eyJpIjoiMmJiNGFj... ) / Task ( https://hibernate.atlassian.net/browse/HSEARCH-3897?atlOrigin=eyJpIjoiMmJ... ) HSEARCH-3897 ( https://hibernate.atlassian.net/browse/HSEARCH-3897?atlOrigin=eyJpIjoiMmJ... ) Support explain query while changing the index name ( https://hibernate.atlassian.net/browse/HSEARCH-3897?atlOrigin=eyJpIjoiMmJ... ) Issue Type: Task Affects Versions: 6.0.0.Beta6 Assignee: Unassigned Components: backend-lucene Created: 18/Apr/2020 06:41 AM Fix Versions: 6.0.0.Beta-backlog-high-priority Priority: Major Reporter: Fabio Massimo Ercoli ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) It seems we cannot do an explain query using the Lucene extension if we change the index name, e.g: setting the name attribute of an @Index annotation. On attach I will leave a patch to reproduce the case, it targets the showcase IT module, I didn’t have the time to understand if the issue is due by the mapper or by the backend side. E.g: changing the index name from Book to book (all lowercase) the error message will be: org.hibernate.search.util.common.SearchException: HSEARCH600077: Document with id '1' does not exist in index 'book' and thus its match cannot be explained. ( https://hibernate.atlassian.net/browse/HSEARCH-3897#add-comment?atlOrigin... ) Add Comment ( https://hibernate.atlassian.net/browse/HSEARCH-3897#add-comment?atlOrigin... ) Get Jira notifications on your phone! Download the Jira Cloud app for Android ( https://play.google.com/store/apps/details?id=com.atlassian.android.jira.... ) or iOS ( https://itunes.apple.com/app/apple-store/id1006972087?pt=696495&ct=EmailN... ) This message was sent by Atlassian Jira (v1001.0.0-SNAPSHOT#100124- sha1:93e2dd3 )

5 years, 12 months

1
0
0 / 0

[JIRA] (HBX-2004) Update freemarker version to 2.3.30

by Koen Aers (JIRA)

5 years, 12 months

1
0
0 / 0

[JIRA] (HBX-1545) Update version identifier to 6.0.0.Alpha1

by Koen Aers (JIRA)

5 years, 12 months

1
0
0 / 0

[JIRA] (HBX-1545) Update version identifier to 6.0.0.Alpha1

by Koen Aers (JIRA)

5 years, 12 months

1
0
0 / 0

[JIRA] (HHH-13956) Envers entities with @OneToMany relationshipd with @OrderBy fail to read in 5.4.14

by Alex Roytman (JIRA)

Alex Roytman ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *created* an issue Hibernate ORM ( https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiMWQ1ZjI2NWM5... ) / Bug ( https://hibernate.atlassian.net/browse/HHH-13956?atlOrigin=eyJpIjoiMWQ1Zj... ) HHH-13956 ( https://hibernate.atlassian.net/browse/HHH-13956?atlOrigin=eyJpIjoiMWQ1Zj... ) Envers entities with @OneToMany relationshipd with @OrderBy fail to read in 5.4.14 ( https://hibernate.atlassian.net/browse/HHH-13956?atlOrigin=eyJpIjoiMWQ1Zj... ) Issue Type: Bug Affects Versions: 5.4.14 Assignee: Chris Cranford ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) Components: hibernate-envers Created: 17/Apr/2020 12:42 PM Environment: JDK 1.8 Priority: Critical Reporter: Alex Roytman ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) Migrating from Hibernate /Envers 4.3.8 to 5.4.14 one thing breaks consistently is reading an envers revision of my entity at specific revision where the entity has @OneToMany (bidirectional with mappedBy) with @OrderBy under any of the two conditions: 1. @OrderBy includes a ID of the "many" entity 2. @OrderBy includes a field of many entity which is itself a relation (@ManyToOne) it does not seem to matter if that field points to an audited entity or has targetAuditMode = RelationTargetAuditMode.NOT_AUDITED Doing removing @OrderBy from @OneToMany or using any regular field (not matching conditions mentioned above) of the "many" entity works fine it just its ID and ManyToOne relationship fields that fail for example *Engagement *entity has @OneToMany(mappedBy = "work" ,fetch = FetchType.LAZY, cascade = CascadeType.ALL, orphanRemoval = true ) @Cache(usage=CacheConcurrencyStrategy.READ_WRITE) // @OrderBy( "teamWorkRole,engagementTeamId" ) public List<EngagementTeam> getEngagementTeams() { return this.engagementTeams; } Where @Audited @Entity public class EngagementTeam { @ManyToOne(fetch = FetchType.LAZY) @JoinColumn(name = "ENGAGEMENT_ID" ) public Engagement getEngagement() { return work; } @ManyToOne(fetch = FetchType.LAZY) @JoinColumn(name = "TEAM_WORK_ROLE" ) @Audited(targetAuditMode = RelationTargetAuditMode.NOT_AUDITED) public TeamWorkRole getTeamWorkRole() { return teamWorkRole; } } reading it with AuditReader reader = AuditReaderFactory.get(getSession()); AuditQuery query = reader.createQuery().forEntitiesAtRevision(Engagement.class, revisionId); query.add(AuditEntity.id().eq(engagementId)); Engagement eng = (Engagement) query.getSingleResult(); // reading content of eng.getEngagementTeams() will fail with the exception below org.hibernate.QueryException: could not resolve property: teamWorkRole of: gov.gao.ems.model.engagement.EngagementTeam_AUD [select e__ from gov.gao.ems.model.engagement.EngagementTeam_AUD e__ where e__.work_engagementId = :work_engagementId and e__.originalId.REV.id = (select max(e2__.originalId.REV.id) from gov.gao.ems.model.engagement.EngagementTeam_AUD e2__ where e2__.originalId.REV.id <= :revision and e__.originalId.engagementTeamId = e2__.originalId.engagementTeamId) and REVTYPE != :delrevisiontype order by e__.teamWorkRole, e__.engagementTeamId] at org.hibernate.QueryException.generateQueryException(QueryException.java:120) at org.hibernate.QueryException.wrapWithQueryString(QueryException.java:103) at org.hibernate.hql.internal.ast.QueryTranslatorImpl.doCompile(QueryTranslatorImpl.java:220) at org.hibernate.hql.internal.ast.QueryTranslatorImpl.compile(QueryTranslatorImpl.java:144) at org.hibernate.engine.query.spi.HQLQueryPlan.<init>(HQLQueryPlan.java:113) at org.hibernate.engine.query.spi.HQLQueryPlan.<init>(HQLQueryPlan.java:73) at org.hibernate.engine.query.spi.QueryPlanCache.getHQLQueryPlan(QueryPlanCache.java:155) at org.hibernate.internal.AbstractSharedSessionContract.getQueryPlan(AbstractSharedSessionContract.java:604) at org.hibernate.internal.AbstractSharedSessionContract.createQuery(AbstractSharedSessionContract.java:716) ... 8 more Caused by: org.hibernate.QueryException: could not resolve property: teamWorkRole of: gov.gao.ems.model.engagement.EngagementTeam_AUD at org.hibernate.persister.entity.AbstractPropertyMapping.propertyException(AbstractPropertyMapping.java:73) at org.hibernate.persister.entity.AbstractPropertyMapping.toType(AbstractPropertyMapping.java:67) at org.hibernate.persister.entity.AbstractEntityPersister.toType(AbstractEntityPersister.java:2044) at org.hibernate.hql.internal.ast.tree.FromElementType.getPropertyType(FromElementType.java:412) at org.hibernate.hql.internal.ast.tree.FromElement.getPropertyType(FromElement.java:520) at org.hibernate.hql.internal.ast.tree.DotNode.getDataType(DotNode.java:693) at org.hibernate.hql.internal.ast.tree.DotNode.prepareLhs(DotNode.java:268) at org.hibernate.hql.internal.ast.tree.DotNode.resolve(DotNode.java:208) at org.hibernate.hql.internal.ast.HqlSqlWalker.resolve(HqlSqlWalker.java:1053) at org.hibernate.hql.internal.antlr.HqlSqlBaseWalker.expr(HqlSqlBaseWalker.java:1303) at org.hibernate.hql.internal.antlr.HqlSqlBaseWalker.orderExpr(HqlSqlBaseWalker.java:1887) at org.hibernate.hql.internal.antlr.HqlSqlBaseWalker.orderExprs(HqlSqlBaseWalker.java:1681) at org.hibernate.hql.internal.antlr.HqlSqlBaseWalker.orderClause(HqlSqlBaseWalker.java:1654) at org.hibernate.hql.internal.antlr.HqlSqlBaseWalker.query(HqlSqlBaseWalker.java:666) at org.hibernate.hql.internal.antlr.HqlSqlBaseWalker.selectStatement(HqlSqlBaseWalker.java:325) at org.hibernate.hql.internal.antlr.HqlSqlBaseWalker.statement(HqlSqlBaseWalker.java:273) at org.hibernate.hql.internal.ast.QueryTranslatorImpl.analyze(QueryTranslatorImpl.java:272) at org.hibernate.hql.internal.ast.QueryTranslatorImpl.doCompile(QueryTranslatorImpl.java:192) Thank you, alex ( https://hibernate.atlassian.net/browse/HHH-13956#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-13956#add-comment?atlOrigin=ey... ) Get Jira notifications on your phone! Download the Jira Cloud app for Android ( https://play.google.com/store/apps/details?id=com.atlassian.android.jira.... ) or iOS ( https://itunes.apple.com/app/apple-store/id1006972087?pt=696495&ct=EmailN... ) This message was sent by Atlassian Jira (v1001.0.0-SNAPSHOT#100124- sha1:93e2dd3 )

5 years, 12 months

1
0
0 / 0

[JIRA] (HSEARCH-3777) Restore configuration of the Similarity in the Lucene backend

by Yoann Rodière (JIRA)

5 years, 12 months

1
0
0 / 0

2026

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

2008

2007

2006

hibernate-issues April 2020