Hibernate. PSQLException:类型int的错误值:admin

cgvd09ve  于 8个月前  发布在  其他
关注(0)|答案(3)|浏览(73)

好吧,我有一个用JAVA和Hibernate的桌面应用程序4.3.1。现在,我们只需要两个实体(用户和角色)。

用户

...

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

...

角色

...

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

...

我试过了

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

这个

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

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

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

如下所示:http://docs.jboss.org/hibernate/core/3.6/reference/en-US/html/types.html#types-value-basic
什么都没有。=/
我也试过这个:http://alenovarini.wikidot.com/mapping-a-custom-type-in-hibernate
=(在数据库中,列admin的类型是boolean,我使用Postgres9.3。当我运行它时,我得到了以下结果:--

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)

原因:org.postgresql.util.PSQLException:类型int的错误值:管理员

oxiaedzo

oxiaedzo1#

终于找到错误了!
Hibernate返回给我的错误消息是“bad value for type int:但这并不是问题所在。这条消息在这个问题上完全是疯了。**真实的问题是,在数据库中,我的主键(pk_role)是VARCHAR类型,但在我的实体中,我把它作为INTEGER类型。
在Vlad试图帮助我假设jdbc驱动程序的版本后,我把配置完全等于我工作得很好的其他项目,错误是相同的,所以我知道错误是在我自己的代码中,可以肯定。

oymdgrw7

oymdgrw72#

对我来说,问题是在Entity列中使用enum。解决方案是在列定义中添加@Enumerated(EnumType.STRING)

@Enumerated(EnumType.STRING)
drkbr07n

drkbr07n3#

如果您有一个单独的数据库模式,只需将列类型更改为boolean

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

然后Map就这么简单:

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

相关问题