java - Query enum in hibernate throws DataException: Bad value for type int : t -

-

i have table enum type attribute mapped this:

@enumerated(enumtype.ordinal) @column(name = "status") private enums.status status;

where enums.status is

public enum status {     checked(1),     disabled(2),     inactive(3);     int id;     // constructor + getter }

and column status database stored type int4

i querying table following hql:

query q = session.createquery(" users status=:account"); query.setparameter("account", enums.status.checked); list<users> users = query.list();

the above code works fine on testing server, when on production server throws following exception:

org.hibernate.exception.dataexception: bad value type int : t     @ org.hibernate.exception.internal.sqlstateconversiondelegate.convert(sqlstateconversiondelegate.java:134)     @ org.hibernate.exception.internal.standardsqlexceptionconverter.convert(standardsqlexceptionconverter.java:49)     @ org.hibernate.engine.jdbc.spi.sqlexceptionhelper.convert(sqlexceptionhelper.java:125)     @ org.hibernate.engine.jdbc.spi.sqlexceptionhelper.convert(sqlexceptionhelper.java:110)     @ org.hibernate.engine.jdbc.internal.proxy.abstractresultsetproxyhandler.continueinvocation(abstractresultsetproxyhandler.java:108)     @ org.hibernate.engine.jdbc.internal.proxy.abstractproxyhandler.invoke(abstractproxyhandler.java:81)     @ com.sun.proxy.$proxy30.getint(unknown source)     @ org.hibernate.type.enumtype$ordinalenumvaluemapper.getvalue(enumtype.java:358)     @ org.hibernate.type.enumtype.nullsafeget(enumtype.java:105)     @ org.hibernate.type.customtype.nullsafeget(customtype.java:127)     @ org.hibernate.type.abstracttype.hydrate(abstracttype.java:106)     @ org.hibernate.persister.entity.abstractentitypersister.hydrate(abstractentitypersister.java:2873)     @ org.hibernate.loader.loader.loadfromresultset(loader.java:1668)     @ org.hibernate.loader.loader.instancenotyetloaded(loader.java:1600)     @ org.hibernate.loader.loader.getrow(loader.java:1500)     @ org.hibernate.loader.loader.getrowfromresultset(loader.java:712)     @ org.hibernate.loader.loader.processresultset(loader.java:940)     @ org.hibernate.loader.loader.doquery(loader.java:910)

i tried replacing enum parameter .ordinal() value, received exception. tried looking differences between testing server , production server, both use same java version, hibernate library, datatypes table , table content.

has ever encountered similar issue or has idea how fixed?

with java enums, term ordinal not refer id property, built in property of enum class. see javadocs ordinal() method.

returns ordinal of enumeration constant (its position in enum declaration, initial constant assigned ordinal of zero). programmers have no use method. designed use sophisticated enum-based data structures, such enumset , enummap.

note first ordinal 0 (zero) not 1

don't calling ordinal() method yourself; let hibernate that.


Comments

Post a Comment

Popular posts from this blog

Ansible - ERROR! the field 'hosts' is required but was not set -

-
i've error when launch playbook don't found why.... error! field 'hosts' required not set there main.yml : --- - hosts: hosts - vars: - elasticsearch_java_home: /usr/lib/jmv/jre-1.7.0 - elasticsearch_http_port: 8443 - tasks: - include: tasks/main.yml - handlers: - include: handlers/main.yml and /etc/ansible/hosts : [hosts] 10.23.108.182 10.23.108.183 10.23.108.184 10.23.108.185 when test ping, : [root@poste08-08-00 elasticsearch]# ansible hosts -m ping 10.23.108.183 | success => { "changed": false, "ping": "pong" } 10.23.108.182 | success => { "changed": false, "ping": "pong" } 10.23.108.185 | success => { "changed": false, "ping": "pong" } 10.23.108.184 | success => { "changed": false, "ping": "pong" } please, me :) regards, you have syntax error in playbook.
Read more

customize file_field button ruby on rails -

-
i'm trying rid of ugly button rails has default file upload. want add glyphicon <%= f.file_field :image_url, class:"glyphicon glyphicon-camera" %> this didn't work , have tried other things in different post saw on page, don't attach file. as suggested here bootstrap filestyle , can use bootstrap's filestyle style file upload buttons. step-1: add layout application.html.erb i have added bootstrap filestyle library cdn. should make sure have both jquery , boostrap loaded. <script type="text/javascript" src="https://cdn.jsdelivr.net/bootstrap.filestyle/1.1.0/js/bootstrap-filestyle.min.js"> </script> step-2: add corresponding js file: $(":file").filestyle({input: false}); step-3: image_url file field follows: <%= f.file_field :image_url,class: "filestyle", "data-input" => false %>
Read more

SoapUI on windows 10 - high DPI/4K scaling issue -

-
Image
soapui doesn't seem dpi-aware , displays small on high dpi screen (tiny text , buttons). other applications running fine (screen resolution 3840 x 2160). version : soapui 5.1.2 os : windows 10 i have tried: configure soapui run "disable display scaling on high dpi settings" - parts of soapui looking bigger , don't display (image) changing resolution changing font size (preferences > editor settings > select font...) therefore assume, soapui pretends dpi-aware, not scale itself. have same issue? this workaround until developers round making version dpi-aware. step 1: add registry key hkey_local_machine\software\microsoft\windows\currentversion\sidebyside\preferexternalmanifest (dword) 1 step 2: add manifest file 'soapui-5.2.1.exe.manifest' in same directory 'soapui-5.2.1.exe' content of manifest file: <?xml version="1.0" encoding="utf-8" standalone="yes"?> <assembly xml
Read more