title: Hibernate. PSQLException: bad value for type int : admin
body: <p>Well I have a desktop application with JAVA and Hibernate <strong>4.3.1</strong>. For now I have just two entities (User and Role).</p>
  
  <h2>User</h2>
  
  <pre><code>...
  
  @ManyToOne(fetch = FetchType.LAZY)
  @Fetch(FetchMode.JOIN)
  @JoinColumn(nullable = false, name = "fk_role")
  private Role fk_role;
  
  ...
  </code></pre>
  
  <h2>Role</h2>
  
  <pre><code>...
  
  @Column(name = "admin", nullable = false)
  @Type(type = "org.hibernate.type.BooleanType")
  private boolean admin = false;
  
  ...
  </code></pre>
  
  <p>I have tried instead</p>
  
  <pre><code>@Type(type = "org.hibernate.type.BooleanType")
  </code></pre>
  
  <p>this.</p>
  
  <pre><code>@Type(type = "org.hibernate.type.NumericBooleanType")
  </code></pre>
  
  <p>and</p>
  
  <pre><code>@Type(type = "org.hibernate.type.YesNoType")
  </code></pre>
  
  <p>and</p>
  
  <pre><code>@Type(type = "org.hibernate.type.TrueFalseType")
  </code></pre>
  
  <p>As shown here: <a href="http://docs.jboss.org/hibernate/core/3.6/reference/en-US/html/types.html#types-value-basic" rel="noreferrer">http://docs.jboss.org/hibernate/core/3.6/reference/en-US/html/types.html#types-value-basic</a></p>
  
  <p>And nothing. =/</p>
  
  <p>I tried this too: <a href="http://alenovarini.wikidot.com/mapping-a-custom-type-in-hibernate" rel="noreferrer">http://alenovarini.wikidot.com/mapping-a-custom-type-in-hibernate</a></p>
  
  <p>=(
      In the database, the type for column admin is boolean and I use Postgres <strong>9.3</strong>.
      When I run this, I got the following:
      --</p>
  
  <pre><code>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)
  </code></pre>
  
  <p><strong>Caused by: org.postgresql.util.PSQLException: bad value for type int: admin</strong></p>