Запрос JPA Criteria с предикатом, который сравнивает поле с аннотацией @Convert, получает ORA-00932 при выполнении

Запрос JPA Criteria с предикатом, который сравнивает поле с аннотацией @Convert, получает ORA-00932 при выполнении ⇐ JAVA

1 сообщение • Страница 1 из 1

Anonymous

Запрос JPA Criteria с предикатом, который сравнивает поле с аннотацией @Convert, получает ORA-00932 при выполнении

Цитата

Сообщение Anonymous » 24 апр 2026, 18:15

Я разрабатываю приложение Java EE 7 (поставщик сохраняемости — Hibernate 4.3.5, БД — Oracle 11g), в котором я использую класс сущности с полем Long, которое представляет миллис даты. Это было сделано таким образом, чтобы избежать проблем с использованием типов данных даты БД (например, обработка часового пояса). Вот соответствующий код класса сущности:

Код: Выделить всё

import java.util.Date;

@Table
@Entity
public class Transference implements Serializable {

private static final long serialVersionUID = 1L;

// ... elided fields

private Date dateTime;

// ... elided setters and getters

@Column(name = "datetime")
@Convert(converter = DateConverter.class)
@NotNull
public Date getDateTime() {
return dateTime;
}

}

Атрибут в классе метамодели:

Код: Выделить всё

public static volatile SingularAttribute dateTime;

Вот простой конвертер JPA 2.1:

Код: Выделить всё

import java.util.Date;

@Converter
public class DateConverter implements AttributeConverter {

@Override
public Long convertToDatabaseColumn(Date attribute) {
return (attribute == null)? null : attribute.getTime();
}

@Override
public Date convertToEntityAttribute(Long dbData) {
return dbData == null? null : new Date(dbData);
}

}

Определение таблицы:

Код: Выделить всё

CREATE TABLE transference (
-- fields ...
datetime NUMBER(20) NOT NULL,
-- constraints...
);

Сохранение и чтение значения поля работает как шарм. Проблема возникает, когда я пытаюсь использовать предикат в CriteriaQuery, который сравнивает поле со значением:

Код: Выделить всё

private List queryResultList() {
CriteriaBuilder cb = this.entityManager.getCriteriaBuilder();
CriteriaQuery cq = cb.createQuery(Transference.class);
Root root = cq.from(Transference.class);
List
 predicates = new ArrayList();

// Predicates with other fields...

if (this.dateTo != null) {
Path pathDateTo = root.get(Transference_.dateTime);
Predicate predDateTo = cb.greaterThanOrEqualTo(pathDateTo, this.dateTo);
predicates.add(predDateTo);
}

Order orderBy = cb.desc(root.get(Transference_.dateTime));
Predicate[] predicatesArray = {};

cq.select(root).where(predicates.toArray(predicatesArray)).orderBy(orderBy);

TypedQuery tq = this.getEntityManager().createQuery(cq);
return tq.getResultList();  //          a t   s u n . r e f l e c t . N a t i v e M e t h o d A c c e s s o r I m p l . i n v o k e 0 ( N a t i v e   M e t h o d ) < b r   / >         a t   s u n . r e f l e c t . N a t i v e M e t h o d A c c e s s o r I m p l . i n v o k e ( N a t i v e M e t h o d A c c e s s o r I m p l . j a v a : 5 7 ) < b r   / >         a t   s u n . r e f l e c t . D e l e g a t i n g M e t h o d A c c e s s o r I m p l . i n v o k e ( D e l e g a t i n g M e t h o d A c c e s s o r I m p l . j a v a : 4 3 ) < b r   / >         a t   j a v a . l a n g . r e f l e c t . M e t h o d . i n v o k e ( M e t h o d . j a v a : 6 0 6 ) < b r   / >         a t   j a v a x . e l . B e a n E L R e s o l v e r . g e t V a l u e ( B e a n E L R e s o l v e r . j a v a : 3 6 3 ) < b r   / >         a t   c o m . s u n . f a c e s . e l . D e m u x C o m p o s i t e E L R e s o l v e r . _ g e t V a l u e ( D e m u x C o m p o s i t e E L R e s o l v e r . j a v a : 1 7 6 ) < b r   / >         a t   c o m . s u n . f a c e s . e l . D e m u x C o m p o s i t e E L R e s o l v e r . g e t V a l u e ( D e m u x C o m p o s i t e E L R e s o l v e r . j a v a : 2 0 3 ) < b r   / >         a t   c o m . s u n . e l . p a r s e r . A s t V a l u e . g e t V a l u e ( A s t V a l u e . j a v a : 1 4 0 ) < b r   / >         a t   c o m . s u n . e l . p a r s e r . A s t V a l u e . g e t V a l u e ( A s t V a l u e . j a v a : 2 0 4 ) < b r   / >         a t   c o m . s u n . e l . V a l u e E x p r e s s i o n I m p l . g e t V a l u e ( V a l u e E x p r e s s i o n I m p l . j a v a : 2 2 6 ) < b r   / >         a t   o r g . j b o s s . w e l d . e l . W e l d V a l u e E x p r e s s i o n . g e t V a l u e ( W e l d V a l u e E x p r e s s i o n . j a v a : 5 0 ) < b r   / >         a t   o r g . j b o s s . w e l d . e l . W e l d V a l u e E x p r e s s i o n . g e t V a l u e ( W e l d V a l u e E x p r e s s i o n . j a v a : 5 0 ) < b r   / >         a t   c o m . s u n . f a c e s . f a c e l e t s . e l . T a g V a l u e E x p r e s s i o n . g e t V a l u e ( T a g V a l u e E x p r e s s i o n . j a v a : 1 0 9 ) < b r   / >         a t   j a v a x . f a c e s . c o m p o n e n t . C o m p o n e n t S t a t e H e l p e r . e v a l ( C o m p o n e n t S t a t e H e l p e r . j a v a : 1 9 4 ) < b r   / >         a t   j a v a x . f a c e s . c o m p o n e n t . C o m p o n e n t S t a t e H e l p e r . e v a l ( C o m p o n e n t S t a t e H e l p e r . j a v a : 1 8 2 ) < b r   / >         a t   j a v a x . f a c e s . c o m p o n e n t . U I D a t a . g e t V a l u e ( U I D a t a . j a v a : 7 3 2 ) < b r   / >         a t   o r g . p r i m e f a c e s . c o m p o n e n t . a p i . U I D a t a . g e t D a t a M o d e l ( U I D a t a . j a v a : 6 2 9 ) < b r   / >         a t   j a v a x . f a c e s . c o m p o n e n t . U I D a t a . g e t R o w C o u n t ( U I D a t a . j a v a : 3 5 6 ) < b r   / >         a t   o r g . p r i m e f a c e s . c o m p o n e n t . d a t a t a b l e . D a t a T a b l e R e n d e r e r . e n c o d e T b o d y ( D a t a T a b l e R e n d e r e r . j a v a : 7 5 8 ) < b r   / >         a t   o r g . p r i m e f a c e s . c o m p o n e n t . d a t a t a b l e . D a t a T a b l e R e n d e r e r . e n c o d e T b o d y ( D a t a T a b l e R e n d e r e r . j a v a : 7 4 0 ) < b r   / >         a t   o r g . p r i m e f a c e s . c o m p o n e n t . d a t a t a b l e . D a t a T a b l e R e n d e r e r . e n c o d e R e g u l a r T a b l e ( D a t a T a b l e R e n d e r e r . j a v a : 2 6 4 ) < b r   / >         a t   o r g . p r i m e f a c e s . c o m p o n e n t . d a t a t a b l e . D a t a T a b l e R e n d e r e r . e n c o d e M a r k u p ( D a t a T a b l e R e n d e r e r . j a v a : 2 2 6 ) < b r   / >         a t   o r g . p r i m e f a c e s . c o m p o n e n t . d a t a t a b l e . D a t a T a b l e R e n d e r e r . e n c o d e E n d ( D a t a T a b l e R e n d e r e r . j a v a : 8 5 ) < b r   / >         a t   j a v a x . f a c e s . c o m p o n e n t . U I C o m p o n e n t B a s e . e n c o d e E n d ( U I C o m p o n e n t B a s e . j a v a : 9 1 9 ) < b r   / >         a t   o r g . p r i m e f a c e s . r e n d e r k i t . C o r e R e n d e r e r . r e n d e r C h i l d ( C o r e R e n d e r e r . j a v a : 8 3 ) < b r   / >         a t   o r g . p r i m e f a c e s . r e n d e r k i t . C o r e R e n d e r e r . r e n d e r C h i l d r e n ( C o r e R e n d e r e r . j a v a : 6 6 ) < b r   / >         a t   o r g . p r i m e f a c e s . c o m p o n e n t . p a n e l . P a n e l R e n d e r e r . e n c o d e C o n t e n t ( P a n e l R e n d e r e r . j a v a : 2 0 6 ) < b r   / >         a t   o r g . p r i m e f a c e s . c o m p o n e n t . p a n e l . P a n e l R e n d e r e r . e n c o d e M a r k u p ( P a n e l R e n d e r e r . j a v a : 1 2 3 ) < b r   / >         a t   o r g . p r i m e f a c e s . c o m p o n e n t . p a n e l . P a n e l R e n d e r e r . e n c o d e E n d ( P a n e l R e n d e r e r . j a v a : 5 8 ) < b r   / >         a t   j a v a x . f a c e s . c o m p o n e n t . U I C o m p o n e n t B a s e . e n c o d e E n d ( U I C o m p o n e n t B a s e . j a v a : 9 1 9 ) < b r   / >         a t   j a v a x . f a c e s . c o m p o n e n t . U I C o m p o n e n t . e n c o d e A l l ( U I C o m p o n e n t . j a v a : 1 8 6 4 ) < b r   / >         a t   c o m . s u n . f a c e s . c o n t e x t . P a r t i a l V i e w C o n t e x t I m p l $ P h a s e A w a r e V i s i t C a l l b a c k . v i s i t ( P a r t i a l V i e w C o n t e x t I m p l . j a v a : 5 9 9 ) < b r   / >         a t   c o m . s u n . f a c e s . c o m p o n e n t . v i s i t . P a r t i a l V i s i t C o n t e x t . i n v o k e V i s i t C a l l b a c k ( P a r t i a l V i s i t C o n t e x t . j a v a : 1 8 3 ) < b r   / >         a t   j a v a x . f a c e s . c o m p o n e n t . U I C o m p o n e n t . v i s i t T r e e ( U I C o m p o n e n t . j a v a : 1 6 9 0 ) < b r   / >         a t   j a v a x . f a c e s . c o m p o n e n t . U I C o m p o n e n t . v i s i t T r e e ( U I C o m p o n e n t . j a v a : 1 7 0 1 ) < b r   / >         a t   j a v a x . f a c e s . c o m p o n e n t . U I F o r m . v i s i t T r e e ( U I F o r m . j a v a : 3 7 1 ) < b r   / >         a t   j a v a x . f a c e s . c o m p o n e n t . U I C o m p o n e n t . v i s i t T r e e ( U I C o m p o n e n t . j a v a : 1 7 0 1 ) < b r   / >         a t   j a v a x . f a c e s . c o m p o n e n t . U I C o m p o n e n t . v i s i t T r e e ( U I C o m p o n e n t . j a v a : 1 7 0 1 ) < b r   / >         a t   j a v a x . f a c e s . c o m p o n e n t . U I C o m p o n e n t . v i s i t T r e e ( U I C o m p o n e n t . j a v a : 1 7 0 1 ) < b r   / >         a t   j a v a x . f a c e s . c o m p o n e n t . U I C o m p o n e n t . v i s i t T r e e ( U I C o m p o n e n t.java:1701)
at com.sun.faces.context.PartialViewContextImpl.processComponents(PartialViewContextImpl.java:406)
at com.sun.faces.context.PartialViewContextImpl.processPartial(PartialViewContextImpl.java:325)
at javax.faces.context.PartialViewContextWrapper.processPartial(PartialViewContextWrapper.java:219)
at org.primefaces.context.PrimePartialViewContext.processPartial(PrimePartialViewContext.java:60)
at javax.faces.component.UIViewRoot.encodeChildren(UIViewRoot.java:1004)
at javax.faces.component.UIComponent.encodeAll(UIComponent.java:1857)
at com.sun.faces.application.view.FaceletViewHandlingStrategy.renderView(FaceletViewHandlingStrategy.java:435)
at com.sun.faces.application.view.MultiViewHandler.renderView(MultiViewHandler.java:133)
at javax.faces.application.ViewHandlerWrapper.renderView(ViewHandlerWrapper.java:337)
at javax.faces.application.ViewHandlerWrapper.renderView(ViewHandlerWrapper.java:337)
at javax.faces.application.ViewHandlerWrapper.renderView(ViewHandlerWrapper.java:337)
at javax.faces.application.ViewHandlerWrapper.renderView(ViewHandlerWrapper.java:337)
at com.sun.faces.lifecycle.RenderResponsePhase.execute(RenderResponsePhase.java:120)
at com.sun.faces.lifecycle.Phase.doPhase(Phase.java:101)
at com.sun.faces.lifecycle.LifecycleImpl.render(LifecycleImpl.java:219)
at org.apache.deltaspike.jsf.impl.listener.request.DeltaSpikeLifecycleWrapper.render(DeltaSpikeLifecycleWrapper.java:111)
at javax.faces.lifecycle.LifecycleWrapper.render(LifecycleWrapper.java:92)
at javax.faces.webapp.FacesServlet.service(FacesServlet.java:647)
at io.undertow.servlet.handlers.ServletHandler.handleRequest(ServletHandler.java:85)
at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:130)
at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:60)
at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:132)
at io.undertow.servlet.handlers.FilterHandler.handleRequest(FilterHandler.java:85)
at io.undertow.servlet.handlers.security.ServletSecurityRoleHandler.handleRequest(ServletSecurityRoleHandler.java:61)
at io.undertow.servlet.handlers.ServletDispatchingHandler.handleRequest(ServletDispatchingHandler.java:36)
at org.wildfly.extension.undertow.security.SecurityContextAssociationHandler.handleRequest(SecurityContextAssociationHandler.java:78)
at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:25)
at io.undertow.servlet.handlers.security.SSLInformationAssociationHandler.handleRequest(SSLInformationAssociationHandler.java:113)
at io.undertow.servlet.handlers.security.ServletAuthenticationCallHandler.handleRequest(ServletAuthenticationCallHandler.java:56)
at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:25)
at io.undertow.security.handlers.AbstractConfidentialityHandler.handleRequest(AbstractConfidentialityHandler.java:45)
at io.undertow.servlet.handlers.security.ServletConfidentialityConstraintHandler.handleRequest(ServletConfidentialityConstraintHandler.java:61)
at io.undertow.security.handlers.AuthenticationMechanismsHandler.handleRequest(AuthenticationMechanismsHandler.java:58)
at io.undertow.servlet.handlers.security.CachedAuthenticatedSessionHandler.handleRequest(CachedAuthenticatedSessionHandler.java:70)
at io.undertow.security.handlers.SecurityInitialHandler.handleRequest(SecurityInitialHandler.java:76)
at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:25)
at org.wildfly.extension.undertow.security.jacc.JACCContextIdHandler.handleRequest(JACCContextIdHandler.java:61)
at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:25)
at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:25)
at io.undertow.servlet.handlers.ServletInitialHandler.handleFirstRequest(ServletInitialHandler.java:240)
at io.undertow.servlet.handlers.ServletInitialHandler.dispatchRequest(ServletInitialHandler.java:227)
at io.undertow.servlet.handlers.ServletInitialHandler.access$000(ServletInitialHandler.java:73)
at io.undertow.servlet.handlers.ServletInitialHandler$1.handleRequest(ServletInitialHandler.java:146)
at io.undertow.server.Connectors.executeRootHandler(Connectors.java:177)
at io.undertow.server.HttpServerExchange$1.run(HttpServerExchange.java:727)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
at java.lang.Thread.run(Thread.java:745)
Caused by:  org.hibernate.exception.SQLGrammarException: could not extract ResultSet
at org.hibernate.exception.internal.SQLExceptionTypeDelegate.convert(SQLExceptionTypeDelegate.java:80)
at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:49)
at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:126)
at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:112)
at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetReturnImpl.java:89)
at org.hibernate.loader.Loader.getResultSet(Loader.java:2065)
at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1862)
at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1838)
at org.hibernate.loader.Loader.doQuery(Loader.java:909)
at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:354)
at org.hibernate.loader.Loader.doList(Loader.java:2553)
at org.hibernate.loader.Loader.doList(Loader.java:2539)
at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2369)
at org.hibernate.loader.Loader.list(Loader.java:2364)
at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:496)
at org.hibernate.hql.internal.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:387)
at org.hibernate.engine.query.spi.HQLQueryPlan.performList(HQLQueryPlan.java:231)
at org.hibernate.internal.SessionImpl.list(SessionImpl.java:1264)
at org.hibernate.internal.QueryImpl.list(QueryImpl.java:103)
at org.hibernate.jpa.internal.QueryImpl.list(QueryImpl.java:573)
at org.hibernate.jpa.internal.QueryImpl.getResultList(QueryImpl.java:449)
... 105 more
Caused by: java.sql.SQLSyntaxErrorException: ORA-00932: inconsistent datatypes: expected NUMBER got TIMESTAMP

at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:450)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:399)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1017)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:655)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:249)
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:566)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:215)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:58)
at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:776)
at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:897)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1034)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3820)
at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3867)
at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1502)
at org.jboss.jca.adapters.jdbc.WrappedPreparedStatement.executeQuery(WrappedPreparedStatement.java:462)
at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetReturnImpl.java:80)
... 121 more

Как правильно использовать такое поле в предикате критерийного запроса? Конвертер работает только для чтения/сохранения. Я искал способ и не смог, даже в спецификации JPA 2.1 (которая, кстати, очень большая). Что мне здесь не хватает?

1777043751

Anonymous

Я разрабатываю приложение Java EE 7 (поставщик сохраняемости — Hibernate 4.3.5, БД — Oracle 11g), в котором я использую класс сущности с полем Long, которое представляет миллис даты. Это было сделано таким образом, чтобы избежать проблем с использованием типов данных даты БД (например, обработка часового пояса). Вот соответствующий код класса сущности:
[code]import java.util.Date;

@Table
@Entity
public class Transference implements Serializable {

private static final long serialVersionUID = 1L;

// ... elided fields

private Date dateTime;

// ... elided setters and getters

@Column(name = "datetime")
@Convert(converter = DateConverter.class)
@NotNull
public Date getDateTime() {
return dateTime;
}

}
[/code]
Атрибут в классе метамодели:
[code]public static volatile SingularAttribute dateTime;
[/code]
Вот простой конвертер JPA 2.1:
[code]import java.util.Date;

@Converter
public class DateConverter implements AttributeConverter {

@Override
public Long convertToDatabaseColumn(Date attribute) {
return (attribute == null)? null : attribute.getTime();
}

@Override
public Date convertToEntityAttribute(Long dbData) {
return dbData == null? null : new Date(dbData);
}

}
[/code]
Определение таблицы:
[code]CREATE TABLE transference (
-- fields ...
datetime NUMBER(20) NOT NULL,
-- constraints...
);
[/code]
Сохранение и чтение значения поля работает как шарм. Проблема возникает, когда я пытаюсь использовать предикат в CriteriaQuery, который сравнивает поле со значением:
[code]private List queryResultList() {
CriteriaBuilder cb = this.entityManager.getCriteriaBuilder();
CriteriaQuery cq = cb.createQuery(Transference.class);
Root root = cq.from(Transference.class);
List
 predicates = new ArrayList();

// Predicates with other fields...

if (this.dateTo != null) {
Path pathDateTo = root.get(Transference_.dateTime);
Predicate predDateTo = cb.greaterThanOrEqualTo(pathDateTo, this.dateTo);
predicates.add(predDateTo);
}

Order orderBy = cb.desc(root.get(Transference_.dateTime));
Predicate[] predicatesArray = {};

cq.select(root).where(predicates.toArray(predicatesArray)).orderBy(orderBy);

TypedQuery tq = this.getEntityManager().createQuery(cq);
return tq.getResultList();  //          a t   s u n . r e f l e c t . N a t i v e M e t h o d A c c e s s o r I m p l . i n v o k e 0 ( N a t i v e   M e t h o d ) < b r   / >         a t   s u n . r e f l e c t . N a t i v e M e t h o d A c c e s s o r I m p l . i n v o k e ( N a t i v e M e t h o d A c c e s s o r I m p l . j a v a : 5 7 ) < b r   / >         a t   s u n . r e f l e c t . D e l e g a t i n g M e t h o d A c c e s s o r I m p l . i n v o k e ( D e l e g a t i n g M e t h o d A c c e s s o r I m p l . j a v a : 4 3 ) < b r   / >         a t   j a v a . l a n g . r e f l e c t . M e t h o d . i n v o k e ( M e t h o d . j a v a : 6 0 6 ) < b r   / >         a t   j a v a x . e l . B e a n E L R e s o l v e r . g e t V a l u e ( B e a n E L R e s o l v e r . j a v a : 3 6 3 ) < b r   / >         a t   c o m . s u n . f a c e s . e l . D e m u x C o m p o s i t e E L R e s o l v e r . _ g e t V a l u e ( D e m u x C o m p o s i t e E L R e s o l v e r . j a v a : 1 7 6 ) < b r   / >         a t   c o m . s u n . f a c e s . e l . D e m u x C o m p o s i t e E L R e s o l v e r . g e t V a l u e ( D e m u x C o m p o s i t e E L R e s o l v e r . j a v a : 2 0 3 ) < b r   / >         a t   c o m . s u n . e l . p a r s e r . A s t V a l u e . g e t V a l u e ( A s t V a l u e . j a v a : 1 4 0 ) < b r   / >         a t   c o m . s u n . e l . p a r s e r . A s t V a l u e . g e t V a l u e ( A s t V a l u e . j a v a : 2 0 4 ) < b r   / >         a t   c o m . s u n . e l . V a l u e E x p r e s s i o n I m p l . g e t V a l u e ( V a l u e E x p r e s s i o n I m p l . j a v a : 2 2 6 ) < b r   / >         a t   o r g . j b o s s . w e l d . e l . W e l d V a l u e E x p r e s s i o n . g e t V a l u e ( W e l d V a l u e E x p r e s s i o n . j a v a : 5 0 ) < b r   / >         a t   o r g . j b o s s . w e l d . e l . W e l d V a l u e E x p r e s s i o n . g e t V a l u e ( W e l d V a l u e E x p r e s s i o n . j a v a : 5 0 ) < b r   / >         a t   c o m . s u n . f a c e s . f a c e l e t s . e l . T a g V a l u e E x p r e s s i o n . g e t V a l u e ( T a g V a l u e E x p r e s s i o n . j a v a : 1 0 9 ) < b r   / >         a t   j a v a x . f a c e s . c o m p o n e n t . C o m p o n e n t S t a t e H e l p e r . e v a l ( C o m p o n e n t S t a t e H e l p e r . j a v a : 1 9 4 ) < b r   / >         a t   j a v a x . f a c e s . c o m p o n e n t . C o m p o n e n t S t a t e H e l p e r . e v a l ( C o m p o n e n t S t a t e H e l p e r . j a v a : 1 8 2 ) < b r   / >         a t   j a v a x . f a c e s . c o m p o n e n t . U I D a t a . g e t V a l u e ( U I D a t a . j a v a : 7 3 2 ) < b r   / >         a t   o r g . p r i m e f a c e s . c o m p o n e n t . a p i . U I D a t a . g e t D a t a M o d e l ( U I D a t a . j a v a : 6 2 9 ) < b r   / >         a t   j a v a x . f a c e s . c o m p o n e n t . U I D a t a . g e t R o w C o u n t ( U I D a t a . j a v a : 3 5 6 ) < b r   / >         a t   o r g . p r i m e f a c e s . c o m p o n e n t . d a t a t a b l e . D a t a T a b l e R e n d e r e r . e n c o d e T b o d y ( D a t a T a b l e R e n d e r e r . j a v a : 7 5 8 ) < b r   / >         a t   o r g . p r i m e f a c e s . c o m p o n e n t . d a t a t a b l e . D a t a T a b l e R e n d e r e r . e n c o d e T b o d y ( D a t a T a b l e R e n d e r e r . j a v a : 7 4 0 ) < b r   / >         a t   o r g . p r i m e f a c e s . c o m p o n e n t . d a t a t a b l e . D a t a T a b l e R e n d e r e r . e n c o d e R e g u l a r T a b l e ( D a t a T a b l e R e n d e r e r . j a v a : 2 6 4 ) < b r   / >         a t   o r g . p r i m e f a c e s . c o m p o n e n t . d a t a t a b l e . D a t a T a b l e R e n d e r e r . e n c o d e M a r k u p ( D a t a T a b l e R e n d e r e r . j a v a : 2 2 6 ) < b r   / >         a t   o r g . p r i m e f a c e s . c o m p o n e n t . d a t a t a b l e . D a t a T a b l e R e n d e r e r . e n c o d e E n d ( D a t a T a b l e R e n d e r e r . j a v a : 8 5 ) < b r   / >         a t   j a v a x . f a c e s . c o m p o n e n t . U I C o m p o n e n t B a s e . e n c o d e E n d ( U I C o m p o n e n t B a s e . j a v a : 9 1 9 ) < b r   / >         a t   o r g . p r i m e f a c e s . r e n d e r k i t . C o r e R e n d e r e r . r e n d e r C h i l d ( C o r e R e n d e r e r . j a v a : 8 3 ) < b r   / >         a t   o r g . p r i m e f a c e s . r e n d e r k i t . C o r e R e n d e r e r . r e n d e r C h i l d r e n ( C o r e R e n d e r e r . j a v a : 6 6 ) < b r   / >         a t   o r g . p r i m e f a c e s . c o m p o n e n t . p a n e l . P a n e l R e n d e r e r . e n c o d e C o n t e n t ( P a n e l R e n d e r e r . j a v a : 2 0 6 ) < b r   / >         a t   o r g . p r i m e f a c e s . c o m p o n e n t . p a n e l . P a n e l R e n d e r e r . e n c o d e M a r k u p ( P a n e l R e n d e r e r . j a v a : 1 2 3 ) < b r   / >         a t   o r g . p r i m e f a c e s . c o m p o n e n t . p a n e l . P a n e l R e n d e r e r . e n c o d e E n d ( P a n e l R e n d e r e r . j a v a : 5 8 ) < b r   / >         a t   j a v a x . f a c e s . c o m p o n e n t . U I C o m p o n e n t B a s e . e n c o d e E n d ( U I C o m p o n e n t B a s e . j a v a : 9 1 9 ) < b r   / >         a t   j a v a x . f a c e s . c o m p o n e n t . U I C o m p o n e n t . e n c o d e A l l ( U I C o m p o n e n t . j a v a : 1 8 6 4 ) < b r   / >         a t   c o m . s u n . f a c e s . c o n t e x t . P a r t i a l V i e w C o n t e x t I m p l $ P h a s e A w a r e V i s i t C a l l b a c k . v i s i t ( P a r t i a l V i e w C o n t e x t I m p l . j a v a : 5 9 9 ) < b r   / >         a t   c o m . s u n . f a c e s . c o m p o n e n t . v i s i t . P a r t i a l V i s i t C o n t e x t . i n v o k e V i s i t C a l l b a c k ( P a r t i a l V i s i t C o n t e x t . j a v a : 1 8 3 ) < b r   / >         a t   j a v a x . f a c e s . c o m p o n e n t . U I C o m p o n e n t . v i s i t T r e e ( U I C o m p o n e n t . j a v a : 1 6 9 0 ) < b r   / >         a t   j a v a x . f a c e s . c o m p o n e n t . U I C o m p o n e n t . v i s i t T r e e ( U I C o m p o n e n t . j a v a : 1 7 0 1 ) < b r   / >         a t   j a v a x . f a c e s . c o m p o n e n t . U I F o r m . v i s i t T r e e ( U I F o r m . j a v a : 3 7 1 ) < b r   / >         a t   j a v a x . f a c e s . c o m p o n e n t . U I C o m p o n e n t . v i s i t T r e e ( U I C o m p o n e n t . j a v a : 1 7 0 1 ) < b r   / >         a t   j a v a x . f a c e s . c o m p o n e n t . U I C o m p o n e n t . v i s i t T r e e ( U I C o m p o n e n t . j a v a : 1 7 0 1 ) < b r   / >         a t   j a v a x . f a c e s . c o m p o n e n t . U I C o m p o n e n t . v i s i t T r e e ( U I C o m p o n e n t . j a v a : 1 7 0 1 ) < b r   / >         a t   j a v a x . f a c e s . c o m p o n e n t . U I C o m p o n e n t . v i s i t T r e e ( U I C o m p o n e n t.java:1701)
at com.sun.faces.context.PartialViewContextImpl.processComponents(PartialViewContextImpl.java:406)
at com.sun.faces.context.PartialViewContextImpl.processPartial(PartialViewContextImpl.java:325)
at javax.faces.context.PartialViewContextWrapper.processPartial(PartialViewContextWrapper.java:219)
at org.primefaces.context.PrimePartialViewContext.processPartial(PrimePartialViewContext.java:60)
at javax.faces.component.UIViewRoot.encodeChildren(UIViewRoot.java:1004)
at javax.faces.component.UIComponent.encodeAll(UIComponent.java:1857)
at com.sun.faces.application.view.FaceletViewHandlingStrategy.renderView(FaceletViewHandlingStrategy.java:435)
at com.sun.faces.application.view.MultiViewHandler.renderView(MultiViewHandler.java:133)
at javax.faces.application.ViewHandlerWrapper.renderView(ViewHandlerWrapper.java:337)
at javax.faces.application.ViewHandlerWrapper.renderView(ViewHandlerWrapper.java:337)
at javax.faces.application.ViewHandlerWrapper.renderView(ViewHandlerWrapper.java:337)
at javax.faces.application.ViewHandlerWrapper.renderView(ViewHandlerWrapper.java:337)
at com.sun.faces.lifecycle.RenderResponsePhase.execute(RenderResponsePhase.java:120)
at com.sun.faces.lifecycle.Phase.doPhase(Phase.java:101)
at com.sun.faces.lifecycle.LifecycleImpl.render(LifecycleImpl.java:219)
at org.apache.deltaspike.jsf.impl.listener.request.DeltaSpikeLifecycleWrapper.render(DeltaSpikeLifecycleWrapper.java:111)
at javax.faces.lifecycle.LifecycleWrapper.render(LifecycleWrapper.java:92)
at javax.faces.webapp.FacesServlet.service(FacesServlet.java:647)
at io.undertow.servlet.handlers.ServletHandler.handleRequest(ServletHandler.java:85)
at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:130)
at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:60)
at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:132)
at io.undertow.servlet.handlers.FilterHandler.handleRequest(FilterHandler.java:85)
at io.undertow.servlet.handlers.security.ServletSecurityRoleHandler.handleRequest(ServletSecurityRoleHandler.java:61)
at io.undertow.servlet.handlers.ServletDispatchingHandler.handleRequest(ServletDispatchingHandler.java:36)
at org.wildfly.extension.undertow.security.SecurityContextAssociationHandler.handleRequest(SecurityContextAssociationHandler.java:78)
at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:25)
at io.undertow.servlet.handlers.security.SSLInformationAssociationHandler.handleRequest(SSLInformationAssociationHandler.java:113)
at io.undertow.servlet.handlers.security.ServletAuthenticationCallHandler.handleRequest(ServletAuthenticationCallHandler.java:56)
at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:25)
at io.undertow.security.handlers.AbstractConfidentialityHandler.handleRequest(AbstractConfidentialityHandler.java:45)
at io.undertow.servlet.handlers.security.ServletConfidentialityConstraintHandler.handleRequest(ServletConfidentialityConstraintHandler.java:61)
at io.undertow.security.handlers.AuthenticationMechanismsHandler.handleRequest(AuthenticationMechanismsHandler.java:58)
at io.undertow.servlet.handlers.security.CachedAuthenticatedSessionHandler.handleRequest(CachedAuthenticatedSessionHandler.java:70)
at io.undertow.security.handlers.SecurityInitialHandler.handleRequest(SecurityInitialHandler.java:76)
at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:25)
at org.wildfly.extension.undertow.security.jacc.JACCContextIdHandler.handleRequest(JACCContextIdHandler.java:61)
at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:25)
at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:25)
at io.undertow.servlet.handlers.ServletInitialHandler.handleFirstRequest(ServletInitialHandler.java:240)
at io.undertow.servlet.handlers.ServletInitialHandler.dispatchRequest(ServletInitialHandler.java:227)
at io.undertow.servlet.handlers.ServletInitialHandler.access$000(ServletInitialHandler.java:73)
at io.undertow.servlet.handlers.ServletInitialHandler$1.handleRequest(ServletInitialHandler.java:146)
at io.undertow.server.Connectors.executeRootHandler(Connectors.java:177)
at io.undertow.server.HttpServerExchange$1.run(HttpServerExchange.java:727)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
at java.lang.Thread.run(Thread.java:745)
Caused by:  org.hibernate.exception.SQLGrammarException: could not extract ResultSet
at org.hibernate.exception.internal.SQLExceptionTypeDelegate.convert(SQLExceptionTypeDelegate.java:80)
at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:49)
at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:126)
at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:112)
at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetReturnImpl.java:89)
at org.hibernate.loader.Loader.getResultSet(Loader.java:2065)
at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1862)
at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1838)
at org.hibernate.loader.Loader.doQuery(Loader.java:909)
at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:354)
at org.hibernate.loader.Loader.doList(Loader.java:2553)
at org.hibernate.loader.Loader.doList(Loader.java:2539)
at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2369)
at org.hibernate.loader.Loader.list(Loader.java:2364)
at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:496)
at org.hibernate.hql.internal.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:387)
at org.hibernate.engine.query.spi.HQLQueryPlan.performList(HQLQueryPlan.java:231)
at org.hibernate.internal.SessionImpl.list(SessionImpl.java:1264)
at org.hibernate.internal.QueryImpl.list(QueryImpl.java:103)
at org.hibernate.jpa.internal.QueryImpl.list(QueryImpl.java:573)
at org.hibernate.jpa.internal.QueryImpl.getResultList(QueryImpl.java:449)
... 105 more
Caused by: java.sql.SQLSyntaxErrorException: ORA-00932: inconsistent datatypes: expected NUMBER got TIMESTAMP

at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:450)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:399)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1017)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:655)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:249)
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:566)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:215)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:58)
at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:776)
at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:897)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1034)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3820)
at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3867)
at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1502)
at org.jboss.jca.adapters.jdbc.WrappedPreparedStatement.executeQuery(WrappedPreparedStatement.java:462)
at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetReturnImpl.java:80)
... 121 more
[/code]
Как правильно использовать такое поле в предикате критерийного запроса? Конвертер работает только для чтения/сохранения. Я искал способ и не смог, даже в спецификации JPA 2.1 (которая, кстати, очень большая). Что мне здесь не хватает?