Sql error 42883 error operator does not exist character varying integer

Epoch time stored with bigint format in PostgreSQL. Most of problem when converting this epoch format to date or timestamp is because we deal with time being stored in number format and integer column type.

Epoch time stored with bigint format in PostgreSQL. Most of problem when converting this epoch format to date or timestamp is because we deal with time being stored in number format and integer column type.

When I’m trying to convert epoch time that stored in bigint format, I found several way ready on Stackoverflow but didn’t works. Several script like below is not working for the latest PostgreSQL 13 version.

select *, to_timestamp(time in milli sec / 1000) from mytable

SELECT TIMESTAMP WITH TIME ZONE 'epoch' + 982384720 * INTERVAL '1 second';

SELECT DATE(builds.build_created/ 1000) FROM builds;

You may trying with several approach like to_timestamp, to_date and receive several error results like :

1. Timezone not found
2. Need to cast
3. Or Operator does not exists

Some errors details eg:

SQL Error [42883]: ERROR: operator does not exist: character varying * interval
  Hint: No operator matches the given name and argument types. You might need to add explicit type casts.
  Position: 64

SQL Error [42883]: ERROR: operator does not exist: character varying / integer
  Hint: No operator matches the given name and argument types. You might need to add explicit type casts.
  Position: 33

How to find the solution? What we need apparently just combining Timestamp with epoch, cast field to int to be save and multiple it with INTERVAL.

Here is the query:

SELECT TIMESTAMP 'epoch' + (<table>.field::int) * INTERVAL '1 second' as started_on from <table>;

To make group by by weekly from epoch time

SELECT COUNT(*), another_column, date_trunc('week', TIMESTAMP 'epoch' + (epoch_column::int) * INTERVAL '1 second') AS weekly from builds group by weekly, another_column order by weekly desc;

Hope this can help you.


  • Tags


    Convert epoch time to timestamp in Postgresql, Convert unix epoch time to date postgresql, Convert Unix timestamp to timestamp without time zone
Источник

Приветствую! Начал изучать postgresql и не пойму почему не срабатывает запрос на выборку строк по id с типом данных serial. Запрос выглядит так:
select * from table where id like '133%'
При этом pgAdmin выдаёт ошибку:

ОШИБКА: оператор не существует: integer ~~ unknown
SQL-состояние: 42883
Подсказка: Оператор с данными именем и типами аргументов не найден. Возможно, вам следует добавить явные преобразования типов.
Символ: 29

В подсказке содержится ответ, но я не понимаю, что нужно сделать. Прошу помощи. Спасибо за внимание!


  • Вопрос задан

    более трёх лет назад

  • 8120 просмотров

Пригласить эксперта

Возможно, вам следует добавить явные преобразования типов.

Вы пытаетесь с числом (id) работать как со строкой (like). Приведите число к строке и всё заработает.
Только нет таких ситуаций в реальной жизни, когда нужно id по подстроке фильтровать.

select * from `table` where `id` like 133%

select * from table where id BETWEEN 1330 AND 1340
select * from table where id >= 1330

Придумай, зачем с числом использовать like


  • Показать ещё
    Загружается…

13 февр. 2023, в 18:17

60000 руб./за проект

13 февр. 2023, в 18:13

2000 руб./за проект

13 февр. 2023, в 17:43

3000 руб./за проект

Минуточку внимания

Источник

Hi, I’m trying to migrate from HSQLDB Default Datasource on JBoss 4.0.3rc1 to a Postgresql DB.

When using my app on HSQLDB, no problem. When trying to use pgSql Datasource, got this error:

java.sql.SQLException: ERROR: operator does not exist: character varying = bytea

(see exception stack trace)

You will see I’m using a UserEnumType (enhanced version posted in wiki) to persit an enum called ‘userGroup’.

To terminate, here is my query and ‘create table’ pg script:

// GroupEnum group;

list = (List<User>) em.createQuery(«from User where userGroup = :group»).setParameter(«group», group).getResultList();

CREATE TABLE users — GENERATED BY HIBERNATE

(

id int8 NOT NULL,

disabled bool NOT NULL,

«password» varchar(32),

username varchar(32),

firstconnection timestamp,

lastconnection timestamp,

usergroup varchar(20),

person_id int8,

CONSTRAINT users_pkey PRIMARY KEY (id),

CONSTRAINT fk4d495e8e149448b FOREIGN KEY (person_id) REFERENCES person (id) ON UPDATE NO ACTION ON DELETE NO ACTION,

CONSTRAINT users_username_key UNIQUE (username)

)

WITH OIDS;

Any idea?

Thx,

Renaud

—————-

Hibernate version: 3.1alpha [JBoss 4.0.3RC1 w/EJB3]

Mapping documents:

package be.sysmedit.model.core.app;

import java.io.Serializable;

import java.util.Date;

import java.util.HashSet;

import java.util.Set;

import javax.persistence.CascadeType;

import javax.persistence.Column;

import javax.persistence.Entity;

import javax.persistence.FetchType;

import javax.persistence.GeneratorType;

import javax.persistence.Id;

import javax.persistence.ManyToMany;

import javax.persistence.ManyToOne;

import javax.persistence.Table;

import javax.persistence.Transient;

import org.apache.commons.lang.builder.HashCodeBuilder;

import org.apache.commons.lang.builder.ToStringBuilder;

import org.hibernate.annotations.Parameter;

import org.hibernate.annotations.Type;

import org.hibernate.annotations.TypeDef;

import org.hibernate.annotations.TypeDefs;

import be.sysmedit.model.core.Person;

import be.sysmedit.model.itrequest.Request;

import be.sysmedit.persistence.types.EnumUserType;

/**

* Represents the application user.

*

* @todo Ajouter une spécialisation ItUser dans .model.itrequest et transférer

* watches

*/

@TypeDefs( {

@TypeDef(name = «group», typeClass = EnumUserType.class, parameters = {

@Parameter(name = «enumClassName», value = «be.sysmedit.model.core.app.GroupEnum»)

})

})

@Entity

// Needed by postgresql since it’s a reserved word and hibernate don’t care:

@Table (name = «USERS»)

public class User implements Serializable {

private Long id;

private String userName;

private String password;

private boolean disabled;

private Date firstConnection;

private Date lastConnection;

private GroupEnum userGroup;

public Person person;

public Set<Request> requestWatches = new HashSet<Request>();

public User() {

}

public User(String userName, String password) {

this.userName = userName;

this.password = password;

this.disabled = false;

this.firstConnection = this.lastConnection = new Date();

}

public User(String userName, String password, GroupEnum userGroup) {

this.userName = userName;

this.password = password;

this.userGroup = userGroup;

this.disabled = false;

this.firstConnection = this.lastConnection = new Date();

}

@Id(generate = GeneratorType.AUTO)

public Long getId() {

return id;

}

private void setId(Long id) {

this.id = id;

}

@Column(length = 32, unique = true)

public String getUserName() {

return userName;

}

public void setUserName(String userName) {

this.userName = userName;

}

@Column(length = 32)

public String getPassword() {

return password;

}

public void setPassword(String password) {

this.password = password;

}

public boolean isDisabled() {

return disabled;

}

public void setDisabled(boolean disabled) {

this.disabled = disabled;

}

public Date getFirstConnection() {

return firstConnection;

}

public void setFirstConnection(Date firstConnection) {

this.firstConnection = firstConnection;

}

public Date getLastConnection() {

return lastConnection;

}

public void setLastConnection(Date lastConnection) {

this.lastConnection = lastConnection;

}

@ManyToOne(fetch = FetchType.EAGER, cascade = { CascadeType.PERSIST,

CascadeType.MERGE, CascadeType.REFRESH })

public Person getPerson() {

return person;

}

public void setPerson(Person person) {

this.person = person;

}

@Type(type = «group»)

@Column(length = 20)

public GroupEnum getUserGroup() {

return userGroup;

}

public void setUserGroup(GroupEnum userGroup) {

this.userGroup = userGroup;

}

/**

* Promouvoit ou dégrade un utilisateur. Pour ce faire, l’utilisateur source

* doit avoir au moins les droits qu’il tente d’attribuer

*

* @todo considérer le cas de la dégradation (source doit avoir au moins les

* droits de l’utilisateur)

* @param source

* Utilisateur à l’origine du changement

* @param promotion

* Nouveau groupe

*/

@Transient

public void promoteUser(User source, GroupEnum promotion)

throws AccessRightsViolationException {

if (source.getUserGroup().compareTo(promotion) >= 0) { // La source

// doit avoir au

// moins les

// droits de la

// promotion

this.userGroup = promotion;

} else {

throw new AccessRightsViolationException(«User »

+ source.getUserName() + » can’t promote with » + promotion);

}

}

@ManyToMany(fetch = FetchType.LAZY, cascade = { CascadeType.ALL }, mappedBy = «userWatches»)

public Set<Request> getRequestWatches() {

return requestWatches;

}

public void setRequestWatches(Set<Request> requestWatches) {

this.requestWatches = requestWatches;

}

@Transient

public void addRequestWatch(Request request) {

if (!this.requestWatches.contains(request)) {

this.requestWatches.add(request);

request.addWatch(this);

}

}

@Transient

public void removeRequestWatch(Request request) {

requestWatches.remove(request);

request.removeWatch(this);

}

@Transient

public boolean isWatching(Request request) {

return this.requestWatches.contains(request);

}

@Transient

public boolean isPromotable() {

return (userGroup.isItAdmin() || userGroup.isItUser());

}

@Transient

public boolean isDegradable() {

return (userGroup.isItAdmin() || userGroup.isSuperUser());

}

@Transient

public void promote() {

if (userGroup.isItAdmin())

userGroup = GroupEnum.SUPERUSER;

else if (userGroup.isItUser())

userGroup = GroupEnum.ITREQUEST_ADMIN;

}

@Transient

public void degrade() {

if (userGroup.isItAdmin())

userGroup = GroupEnum.ITREQUEST_USER;

else if (userGroup.isSuperUser())

userGroup = GroupEnum.ITREQUEST_ADMIN;

}

@Override

public int hashCode() {

if (id != null) {

return new HashCodeBuilder().append(id).toHashCode();

} else {

return super.hashCode();

}

}

@Override

@Transient

public String toString() {

return new ToStringBuilder(this).append(«userName», userName).append(

«disabled», disabled).toString();

}

@Override

@Transient

public boolean equals(Object o) {

if (o instanceof User) {

User user = (User) o;

return (id != null) ? id.equals(user.getId())

: super.equals(o);

}

return false;

}

@Transient

public int compareTo(Object obj) {

User user = (User) obj;

return this.userName.compareTo(user.getUserName());

}

}

Code between sessionFactory.openSession() and session.close():

N/A

Full stack trace of any exception that occurs:

_Exception:_

javax.ejb.EJBTransactionRolledbackException: null; CausedByException is:

could not execute query

at org.jboss.ejb3.tx.Ejb3TxPolicy.handleInCallerTx(Ejb3TxPolicy.java:65)

at org.jboss.aspects.tx.TxPolicy.invokeInCallerTx(TxPolicy.java:117)

at org.jboss.aspects.tx.TxInterceptor$Required.invoke(TxInterceptor.java:138)

at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:88)

at org.jboss.aspects.tx.TxPropagationInterceptor.invoke(TxPropagationInterceptor.java:72)

at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:88)

at org.jboss.ejb3.stateless.StatelessInstanceInterceptor.invoke(StatelessInstanceInterceptor.java:39)

at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:88)

at org.jboss.aspects.security.AuthenticationInterceptor.invoke(AuthenticationInterceptor.java:63)

at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:88)

at org.jboss.ejb3.asynchronous.AsynchronousInterceptor.invoke(AsynchronousInterceptor.java:93)

at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:88)

at org.jboss.ejb3.stateless.StatelessContainer.localInvoke(StatelessContainer.java:148)

at org.jboss.ejb3.stateless.StatelessLocalProxy.invoke(StatelessLocalProxy.java:65)

at $Proxy82.findByGroup(Unknown Source)

at be.sysmedit.services.itrequest.ApplicationServiceBean.checkAdmin(ApplicationServiceBean.java:249)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

at java.lang.reflect.Method.invoke(Method.java:585)

at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:99)

at org.jboss.ejb3.AllowedOperationsInterceptor.invoke(AllowedOperationsInterceptor.java:33)

at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:88)

at org.jboss.aspects.tx.TxPolicy.invokeInOurTx(TxPolicy.java:66)

at org.jboss.aspects.tx.TxInterceptor$Required.invoke(TxInterceptor.java:134)

at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:88)

at org.jboss.aspects.tx.TxPropagationInterceptor.invoke(TxPropagationInterceptor.java:72)

at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:88)

at org.jboss.ejb3.stateless.StatelessInstanceInterceptor.invoke(StatelessInstanceInterceptor.java:39)

at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:88)

at org.jboss.aspects.security.AuthenticationInterceptor.invoke(AuthenticationInterceptor.java:63)

at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:88)

at org.jboss.ejb3.asynchronous.AsynchronousInterceptor.invoke(AsynchronousInterceptor.java:93)

at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:88)

at org.jboss.ejb3.stateless.StatelessContainer.dynamicInvoke(StatelessContainer.java:183)

at org.jboss.aop.Dispatcher.invoke(Dispatcher.java:107)

at org.jboss.aspects.remoting.IsLocalInterceptor.invoke(IsLocalInterceptor.java:30)

at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:88)

at org.jboss.ejb3.stateless.StatelessRemoteProxy.invoke(StatelessRemoteProxy.java:79)

at $Proxy94.checkAdmin(Unknown Source)

at be.sysmedit.web.admin.ApplicationBean.verifySetup(ApplicationBean.java:50)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

at java.lang.reflect.Method.invoke(Method.java:585)

at org.apache.myfaces.el.MethodBindingImpl.invoke(MethodBindingImpl.java:138)

at oracle.adf.view.faces.component.UIXComponentBase.__broadcast(UIXComponentBase.java:1097)

at oracle.adf.view.faces.component.UIXCommand.broadcast(UIXCommand.java:204)

at javax.faces.component.UIViewRoot._broadcastForPhase(UIViewRoot.java:110)

at javax.faces.component.UIViewRoot.processApplication(UIViewRoot.java:184)

at org.apache.myfaces.lifecycle.LifecycleImpl.invokeApplication(LifecycleImpl.java:271)

at org.apache.myfaces.lifecycle.LifecycleImpl.execute(LifecycleImpl.java:102)

at javax.faces.webapp.FacesServlet.service(FacesServlet.java:109)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)

at oracle.adfinternal.view.faces.webapp.AdfFacesFilterImpl._doFilterImpl(AdfFacesFilterImpl.java:310)

at oracle.adfinternal.view.faces.webapp.AdfFacesFilterImpl.doFilter(AdfFacesFilterImpl.java:183)

at oracle.adf.view.faces.webapp.AdfFacesFilter.doFilter(AdfFacesFilter.java:87)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)

at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:81)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)

at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)

at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)

at org.jboss.web.tomcat.security.CustomPrincipalValve.invoke(CustomPrincipalValve.java:39)

at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:153)

at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:59)

at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)

at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)

at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)

at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)

at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:856)

at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:744)

at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)

at org.apache.tomcat.util.net.MasterSlaveWorkerThread.run(MasterSlaveWorkerThread.java:112)

at java.lang.Thread.run(Thread.java:595)

org.hibernate.exception.SQLGrammarException: could not execute query

at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:59)

at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)

at org.hibernate.loader.Loader.doList(Loader.java:1861)

at org.hibernate.loader.Loader.list(Loader.java:1842)

at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:407)

at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:273)

at org.hibernate.impl.SessionImpl.list(SessionImpl.java:850)

at org.hibernate.impl.QueryImpl.list(QueryImpl.java:74)

at org.hibernate.ejb.QueryImpl.getResultList(QueryImpl.java:41)

at be.sysmedit.persistence.core.app.UserDAOBean.findByGroup(UserDAOBean.java:109)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

at java.lang.reflect.Method.invoke(Method.java:585)

at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:99)

at org.jboss.ejb3.AllowedOperationsInterceptor.invoke(AllowedOperationsInterceptor.java:33)

at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:88)

at org.jboss.aspects.tx.TxPolicy.invokeInCallerTx(TxPolicy.java:113)

at org.jboss.aspects.tx.TxInterceptor$Required.invoke(TxInterceptor.java:138)

at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:88)

at org.jboss.aspects.tx.TxPropagationInterceptor.invoke(TxPropagationInterceptor.java:72)

at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:88)

at org.jboss.ejb3.stateless.StatelessInstanceInterceptor.invoke(StatelessInstanceInterceptor.java:39)

at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:88)

at org.jboss.aspects.security.AuthenticationInterceptor.invoke(AuthenticationInterceptor.java:63)

at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:88)

at org.jboss.ejb3.asynchronous.AsynchronousInterceptor.invoke(AsynchronousInterceptor.java:93)

at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:88)

at org.jboss.ejb3.stateless.StatelessContainer.localInvoke(StatelessContainer.java:148)

at org.jboss.ejb3.stateless.StatelessLocalProxy.invoke(StatelessLocalProxy.java:65)

at $Proxy82.findByGroup(Unknown Source)

at be.sysmedit.services.itrequest.ApplicationServiceBean.checkAdmin(ApplicationServiceBean.java:249)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

at java.lang.reflect.Method.invoke(Method.java:585)

at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:99)

at org.jboss.ejb3.AllowedOperationsInterceptor.invoke(AllowedOperationsInterceptor.java:33)

at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:88)

at org.jboss.aspects.tx.TxPolicy.invokeInOurTx(TxPolicy.java:66)

at org.jboss.aspects.tx.TxInterceptor$Required.invoke(TxInterceptor.java:134)

at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:88)

at org.jboss.aspects.tx.TxPropagationInterceptor.invoke(TxPropagationInterceptor.java:72)

at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:88)

at org.jboss.ejb3.stateless.StatelessInstanceInterceptor.invoke(StatelessInstanceInterceptor.java:39)

at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:88)

at org.jboss.aspects.security.AuthenticationInterceptor.invoke(AuthenticationInterceptor.java:63)

at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:88)

at org.jboss.ejb3.asynchronous.AsynchronousInterceptor.invoke(AsynchronousInterceptor.java:93)

at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:88)

at org.jboss.ejb3.stateless.StatelessContainer.dynamicInvoke(StatelessContainer.java:183)

at org.jboss.aop.Dispatcher.invoke(Dispatcher.java:107)

at org.jboss.aspects.remoting.IsLocalInterceptor.invoke(IsLocalInterceptor.java:30)

at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:88)

at org.jboss.ejb3.stateless.StatelessRemoteProxy.invoke(StatelessRemoteProxy.java:79)

at $Proxy94.checkAdmin(Unknown Source)

at be.sysmedit.web.admin.ApplicationBean.verifySetup(ApplicationBean.java:50)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

at java.lang.reflect.Method.invoke(Method.java:585)

at org.apache.myfaces.el.MethodBindingImpl.invoke(MethodBindingImpl.java:138)

at oracle.adf.view.faces.component.UIXComponentBase.__broadcast(UIXComponentBase.java:1097)

at oracle.adf.view.faces.component.UIXCommand.broadcast(UIXCommand.java:204)

at javax.faces.component.UIViewRoot._broadcastForPhase(UIViewRoot.java:110)

at javax.faces.component.UIViewRoot.processApplication(UIViewRoot.java:184)

at org.apache.myfaces.lifecycle.LifecycleImpl.invokeApplication(LifecycleImpl.java:271)

at org.apache.myfaces.lifecycle.LifecycleImpl.execute(LifecycleImpl.java:102)

at javax.faces.webapp.FacesServlet.service(FacesServlet.java:109)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)

at oracle.adfinternal.view.faces.webapp.AdfFacesFilterImpl._doFilterImpl(AdfFacesFilterImpl.java:310)

at oracle.adfinternal.view.faces.webapp.AdfFacesFilterImpl.doFilter(AdfFacesFilterImpl.java:183)

at oracle.adf.view.faces.webapp.AdfFacesFilter.doFilter(AdfFacesFilter.java:87)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)

at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:81)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)

at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)

at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)

at org.jboss.web.tomcat.security.CustomPrincipalValve.invoke(CustomPrincipalValve.java:39)

at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:153)

at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:59)

at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)

at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)

at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)

at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)

at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:856)

at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:744)

at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)

at org.apache.tomcat.util.net.MasterSlaveWorkerThread.run(MasterSlaveWorkerThread.java:112)

at java.lang.Thread.run(Thread.java:595)

Caused by: java.sql.SQLException: ERROR: operator does not exist: character varying = bytea

at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1471)

at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1256)

at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:175)

at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:389)

at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:330)

at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:240)

at org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.executeQuery(WrappedPreparedStatement.java:296)

at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:120)

at org.hibernate.loader.Loader.getResultSet(Loader.java:1537)

at org.hibernate.loader.Loader.doQuery(Loader.java:638)

at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:221)

at org.hibernate.loader.Loader.doList(Loader.java:1858)

… 90 more

Name and version of the database you are using:

PostgreSQL 8.0.3

The generated SQL (show_sql=true):

select user0_.id as id, user0_.disabled as disabled3_, user0_.password as password3_, user0_.userName as userName3_, user0_.firstConnection as firstCon5_3_, user0_.lastConnection as lastConn6_3_, user0_.person_id as person8_3_, user0_.userGroup as userGroup3_ from USERS user0_ where user0_.userGroup=?

Debug level Hibernate log excerpt:

—

Источник

Понравилась статья? Поделить с друзьями:
  • Sql error 42804
  • Sql error 42803 error aggregate functions are not allowed in where
  • Sql error 22023 error cannot extract elements from a scalar
  • Sql error 22008 error date time field value out of range
  • Sql error 22003 ошибка целое вне диапазона