Geek Answers Handbook

Hibernate PSQLException: invalid value for type int: admin

Well, I have a desktop application with JAVA and Hibernate 4.3.1 . At the moment, I have only two objects (User and Role).

User

... @ManyToOne(fetch = FetchType.LAZY) @Fetch(FetchMode.JOIN) @JoinColumn(nullable = false, name = "fk_role") private Role fk_role; ...

Role

 ... @Column(name = "admin", nullable = false) @Type(type = "org.hibernate.type.BooleanType") private boolean admin = false; ...

I tried instead

 @Type(type = "org.hibernate.type.BooleanType")

.

 @Type(type = "org.hibernate.type.NumericBooleanType")

and

 @Type(type = "org.hibernate.type.YesNoType")

and

 @Type(type = "org.hibernate.type.TrueFalseType")

As shown here: http://docs.jboss.org/hibernate/core/3.6/reference/en-US/html/types.html#types-value-basic

And nothing. = /

I also tried: http://alenovarini.wikidot.com/mapping-a-custom-type-in-hibernate

= (In the database, the type for the column administrator is boolean, and I'm using Postgres 9.3 . When I run this, I got the following: -

 org.hibernate.exception.DataException: could not execute query at org.hibernate.exception.internal.SQLStateConversionDelegate.convert(SQLStateConversionDelegate.java:135) at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:49) at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:126) at org.hibernate.loader.Loader.doList(Loader.java:2554) at org.hibernate.loader.Loader.doList(Loader.java:2537) at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2367) at org.hibernate.loader.Loader.list(Loader.java:2362) at org.hibernate.loader.custom.CustomLoader.list(CustomLoader.java:353) at org.hibernate.internal.SessionImpl.listCustomQuery(SessionImpl.java:1869) at org.hibernate.internal.AbstractSessionImpl.list(AbstractSessionImpl.java:311) at org.hibernate.internal.SQLQueryImpl.list(SQLQueryImpl.java:141) at com.print.model.schemaPublic.gateway.UserGateway.list(UserGateway.java:61) at com.print.model.schemaPublic.UserBusiness.list(UserBusiness.java:22) at com.print.controller.MenuController.fileNovoAction(MenuController.java:22) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:606) at com.library.core.ActionListenerDelegate.actionPerformed(ActionListenerDelegate.java:48) at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:2018) at javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2341) at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:402) at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:259) at javax.swing.AbstractButton.doClick(AbstractButton.java:376) at javax.swing.plaf.basic.BasicMenuItemUI.doClick(BasicMenuItemUI.java:833) at javax.swing.plaf.basic.BasicMenuItemUI$Handler.mouseReleased(BasicMenuItemUI.java:877) at java.awt.Component.processMouseEvent(Component.java:6516) at javax.swing.JComponent.processMouseEvent(JComponent.java:3320) at java.awt.Component.processEvent(Component.java:6281) at java.awt.Container.processEvent(Container.java:2229) at java.awt.Component.dispatchEventImpl(Component.java:4872) at java.awt.Container.dispatchEventImpl(Container.java:2287) at java.awt.Component.dispatchEvent(Component.java:4698) at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4832) at java.awt.LightweightDispatcher.processMouseEvent(Container.java:4492) at java.awt.LightweightDispatcher.dispatchEvent(Container.java:4422) at java.awt.Container.dispatchEventImpl(Container.java:2273) at java.awt.Window.dispatchEventImpl(Window.java:2719) at java.awt.Component.dispatchEvent(Component.java:4698) at java.awt.EventQueue.dispatchEventImpl(EventQueue.java:735) at java.awt.EventQueue.access$200(EventQueue.java:103) at java.awt.EventQueue$3.run(EventQueue.java:694) at java.awt.EventQueue$3.run(EventQueue.java:692) at java.security.AccessController.doPrivileged(Native Method) at java.security.ProtectionDomain$1.doIntersectionPrivilege(ProtectionDomain.java:76) at java.security.ProtectionDomain$1.doIntersectionPrivilege(ProtectionDomain.java:87) at java.awt.EventQueue$4.run(EventQueue.java:708) at java.awt.EventQueue$4.run(EventQueue.java:706) at java.security.AccessController.doPrivileged(Native Method) at java.security.ProtectionDomain$1.doIntersectionPrivilege(ProtectionDomain.java:76) at java.awt.EventQueue.dispatchEvent(EventQueue.java:705) at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:242) at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:161) at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:150) at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:146) at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:138) at java.awt.EventDispatchThread.run(EventDispatchThread.java:91)

Called: org.postgresql.util.PSQLException: invalid value for type int: admin

+5
source share
2 answers

Finally, I found a mistake!

The error message returned to me by Hibernate was "an invalid value for the int: admin type", but the problem was not . This post was completely crazy about the problem. The real problem was that in the database my primary key (pk_role) is of type VARCHAR, but in my essence I put as type INTEGER.

After Vlad tried to help me guess the version of the jdbc driver, I set up the configuration exactly like in another project, I worked very well, and the error was the same, so I knew that the error was in my own code, for sure.

+6
source

If you have a separate database schema, just change the column type to boolean :

 ALTER TABLE role ALTER COLUMN admin TYPE boolean default false; ALTER TABLE role MODIFY admin NOT NULL;

and then the display is as simple as this:

 @Column(name = "admin", nullable = false) private boolean admin = false;
+1
source

More articles:


All Articles