Hibernate:只保存一个以@EmbeddedId为主键的实体

hfyxw5xn  于 2023-03-19  发布在  其他
关注(0)|答案(5)|浏览(144)

我想学习Hibernate的基础知识,但不明白为什么我的应用程序在使用@EmbeddedId复合主键注解向表中添加条目时无法工作:
代表主键的类:

@Embeddable
public class OHLCVKey implements Serializable{

    private static final long serialVersionUID = -3996067621138883817L;

    @Column(name="Symbol")
    protected String symbol;

    @Column(name="Currency")
    protected String currency;

    @Column(name="Datum")
    protected java.sql.Date datum;

    public OHLCVKey() {}

    public OHLCVKey(String symbol, String currency, Date datum) {
        super();
        this.symbol = symbol;
        this.currency = currency;
        this.datum = datum;
    }


    public String getSymbol() {
        return symbol;
    }

    public void setSymbol(String symbol) {
        this.symbol = symbol;
    }

    public String getCurrency() {
        return currency;
    }

    public void setCurrency(String currency) {
        this.currency = currency;
    }

    public java.sql.Date getDatum() {
        return datum;
    }

    public void setDatum(java.sql.Date endTime) {
        this.datum = endTime;
    }

    @Override
    public String toString() {
        return String.format("OHLCKey: {%s %s %s}", symbol, currency, datum);
    }

    @Override
    public int hashCode() {
        final int prime = 31;
        int result = 1;
        result = prime * result + (symbol == null ? 0 : symbol.hashCode());
        result = prime * result + (currency == null ? 0 : currency.hashCode());
        result = prime * result + (datum == null ? 0 : datum.hashCode());
        return result;
    }

    @Override
    public boolean equals(Object obj) {
        if(obj != null || !(obj instanceof OHLCVKey)) {
            OHLCVKey other = (OHLCVKey) obj;
            boolean sameSymbol = this.symbol.equals(other.symbol);
            boolean sameCurrency = this.currency.equals(other.currency);
            boolean endTime = this.datum.equals(other.datum);
            return sameSymbol && sameCurrency && endTime;
        }
        return false;
    }
}

持久性类别:

@Entity
@Table(name = "ohlcv_data")
public class OHLCV implements Serializable {

    /**
     * 
     */
    private static final long serialVersionUID = -742762046516249869L;

    @EmbeddedId
    protected OHLCVKey key;

    @Column(name = "Exchange")
    private String exchange;

    @Column(name = "Open")
    private double open;

    @Column(name = "High")
    private double high;

    @Column(name = "Low")
    private double low;

    @Column(name = "Close")
    private double close;

    @Column(name = "Volume")
    private long volume;

    public OHLCV() {};

    public OHLCV(OHLCVKey key) {
        super();
        this.key = key;
    }

    public OHLCV(OHLCVKey key, String exchange, double open, double high, double low, double close, long volume) {
        super();
        this.key = key;
        this.exchange = exchange;
        this.open = open;
        this.high = high;
        this.low = low;
        this.close = close;
        this.volume = volume;
    }

    public OHLCVKey getKey() {
        return key;
    }

    public void setKey(OHLCVKey key) {
        this.key = key;
    }

    public String getExchange() {
        return exchange;
    }

    public void setExchange(String exchange) {
        this.exchange = exchange;
    }

    public double getOpen() {
        return open;
    }

    public void setOpen(double open) {
        this.open = open;
    }

    public double getHigh() {
        return high;
    }

    public void setHigh(double high) {
        this.high = high;
    }

    public double getLow() {
        return low;
    }

    public void setLow(double low) {
        this.low = low;
    }

    public double getClose() {
        return close;
    }

    public void setClose(double close) {
        this.close = close;
    }

    public long getVolume() {
        return volume;
    }

    public void setVolume(long volume) {
        this.volume = volume;
    }
}

我假设在创建OHLC示例之后,可以使用以下函数(在名为OHLCVDataManager的类中)将其数据添加到数据库表中:

public void addOHLCV(OHLCV ohlcv) { // line 50
    Session session = factory.openSession();
    Transaction tx = null;
    try {
        tx = session.beginTransaction();
        session.save(ohlcv); // line 55
        tx.commit();
        log.info("Added {} to database!", key.toString());
    } catch(Exception e) {
        if(tx != null) {
            tx.rollback();
        }
        e.printStackTrace();
    } finally {
        session.close();
        System.exit(2); //TODO remove, exit Spring application
    }
}

但我得到了以下带有堆栈跟踪的PropertyAccessException/IllegalArgumentException:

org.hibernate.property.access.spi.PropertyAccessException: Error accessing field [protected OHLCVKey OHLCV.key] by reflection for persistent property [OHLCV#key] : OHLCV@46479254
2018-11-03 18:43:57.567  INFO 18384 --- [       Thread-9] ConfigServletWebServerApplicationContext : Closing org.springframework.boot.web.servlet.context.AnnotationConfigServletWebServerApplicationContext@7582b66f: startup date [Sat Nov 03 18:43:53 CET 2018]; root of context hierarchy
    at org.hibernate.property.access.spi.GetterFieldImpl.get(GetterFieldImpl.java:75)
    at org.hibernate.tuple.entity.AbstractEntityTuplizer.getIdentifier(AbstractEntityTuplizer.java:224)
    at org.hibernate.persister.entity.AbstractEntityPersister.getIdentifier(AbstractEntityPersister.java:4931)
    at org.hibernate.mapping.Component$StandardGenerationContextLocator.locateGenerationContext(Component.java:480)
    at org.hibernate.id.CompositeNestedGeneratedValueGenerator.generate(CompositeNestedGeneratedValueGenerator.java:93)
    at org.hibernate.event.internal.AbstractSaveEventListener.saveWithGeneratedId(AbstractSaveEventListener.java:123)
    at org.hibernate.event.internal.DefaultSaveOrUpdateEventListener.saveWithGeneratedOrRequestedId(DefaultSaveOrUpdateEventListener.java:192)
    at org.hibernate.event.internal.DefaultSaveEventListener.saveWithGeneratedOrRequestedId(DefaultSaveEventListener.java:38)
    at org.hibernate.event.internal.DefaultSaveOrUpdateEventListener.entityIsTransient(DefaultSaveOrUpdateEventListener.java:177)
    at org.hibernate.event.internal.DefaultSaveEventListener.performSaveOrUpdate(DefaultSaveEventListener.java:32)
    at org.hibernate.event.internal.DefaultSaveOrUpdateEventListener.onSaveOrUpdate(DefaultSaveOrUpdateEventListener.java:73)
    at org.hibernate.internal.SessionImpl.fireSave(SessionImpl.java:709)
    at org.hibernate.internal.SessionImpl.save(SessionImpl.java:701)
    at org.hibernate.internal.SessionImpl.save(SessionImpl.java:696)
    at OHLCVDataManager.addOHLCV(OHLCVDataManager.java:55)
    at OHLCVDataManager.addOHLCV(OHLCVDataManager.java:70)
    at ServerApplication.main(ServerApplication.java:16)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    at java.lang.reflect.Method.invoke(Method.java:498)
    at org.springframework.boot.devtools.restart.RestartLauncher.run(RestartLauncher.java:49)
Caused by: java.lang.IllegalArgumentException: Can not set OHLCVKey field OHLCV
    at sun.reflect.UnsafeFieldAccessorImpl.throwSetIllegalArgumentException(UnsafeFieldAccessorImpl.java:167)
    at sun.reflect.UnsafeFieldAccessorImpl.throwSetIllegalArgumentException(UnsafeFieldAccessorImpl.java:171)
    at sun.reflect.UnsafeFieldAccessorImpl.ensureObj(UnsafeFieldAccessorImpl.java:58)
    at sun.reflect.UnsafeObjectFieldAccessorImpl.get(UnsafeObjectFieldAccessorImpl.java:36)
    at java.lang.reflect.Field.get(Field.java:393)
    at org.hibernate.property.access.spi.GetterFieldImpl.get(GetterFieldImpl.java:71)

编辑1:

ohlcvDataManager.addOHLCV("TEST", "USD", new java.sql.Date(2018, 1, 1), "TEST", 1, 1, 1, 1, 1);

// OHLCDataManager#addOHLCV call:    
public void addOHLCV(String symbol, String currency, java.sql.Date date, 
String exchange, double open, double high, double low, double close, long volume) {
    addOHLCV(new OHLCV(new OHLCVKey(symbol,currency, date),exchange, open, high, low, close, volume));
}

**EDIT 2:**我测试了使用java 1.8的休眠内核版本5.3.7和5.4
**EDIT 2:**在我的类路径中只有一个OHLCV类和一个OHLCVKey类,我还尝试重命名这些类。

vptzau2j

vptzau2j1#

我认为您遇到了一个在hib5.0和5.1中将组合键Map为EmbedID的错误,应该在5.1.1 https://hibernate.atlassian.net/browse/HHH-10618中修复
尝试更改休眠版本。另外,我可以在其中一条评论中看到@K.Nicholas说同样的代码对他也有效。这就是为什么我更倾向于认为您遇到了这个bug。

doinxwow

doinxwow2#

降级到版本
4.3.11.Final
工作...

5q4ezhmt

5q4ezhmt3#

我已经有一段时间没有使用hib了,但是从错误信息来看,它似乎无法访问[protected OHLCVKey OHLCV.key]这个字段。为了缩小范围,我建议做两件事。首先,看看是否可以删除OHLCVKey key = (OHLCVKey) session.save(ohlcv); // line 55这一行中的强制转换,并将其改为session.save(ohlcv),以排除是强制转换还是保存本身导致了它。其次,尽管这没有多大意义,但请尝试将此处的访问修饰符更改为private。

@EmbeddedId
    protected OHLCVKey key;

如果这两种方法都不起作用,请尝试使用HQL并查看。

eit6fx6z

eit6fx6z4#

Caused by: java.lang.IllegalArgumentException: Can not set OHLCVKey field OHLCV
    at sun.reflect.UnsafeFieldAccessorImpl.throwSetIllegalArgumentException(UnsafeFieldAccessorImpl.java:167)
    at sun.reflect.UnsafeFieldAccessorImpl.throwSetIllegalArgumentException(UnsafeFieldAccessorImpl.java:171)
    at sun.reflect.UnsafeFieldAccessorImpl.ensureObj(UnsafeFieldAccessorImpl.java:58)
    at sun.reflect.UnsafeObjectFieldAccessorImpl.get(UnsafeObjectFieldAccessorImpl.java:36)
    at java.lang.reflect.Field.get(Field.java:393)
    at org.hibernate.property.access.spi.GetterFieldImpl.get(GetterFieldImpl.java:71)

stacktrace的平静意味着Hibernate试图为某个对象设置一个字段值,但是它们的类是不兼容的:

protected void ensureObj(Object object) {
    if (!this.field.getDeclaringClass().isAssignableFrom(object.getClass())) {
        this.throwSetIllegalArgumentException(object);
    }
}

这意味着Hibernate从不同的类加载了元数据,而不是从您试图保存的对象的类加载。请检查应用程序的类路径中是否只有一个类OHLCV,因为您提供的示例工作正常。

o2rvlv0m

o2rvlv0m5#

我没有降级,而是使用@IdClass重建实体
继续这个例子,你可以删除@Embeddable和@EmbeddedId注解,然后在类级别为OHLCV添加以下注解:

org.hibernate.annotations.@Immutable
javax.persistence.@IdClass(OHLCVKey.class)

复制变量从这OHLCVKey类到你的OHLCV类并且添加下面的注解到每个他们!
@Id
然后从键类中删除列注解。不要忘记每个类都需要一个Equal和hashCode实现!
一个小的自定义示例:
x一个一个一个一个x一个一个二个x

相关问题