首页
学习
活动
专区
工具
TVP
发布
社区首页 >问答首页 >在hibernate中使用标识插入数据时出错

在hibernate中使用标识插入数据时出错
EN

Stack Overflow用户
提问于 2018-06-01 04:06:59
回答 1查看 177关注 0票数 1

我遇到了在数据库中插入数据的问题,其中STOCK_ID是identity,STOCK_NAME是string。当在数据库中插入数据时,它显示了一个异常,如下所述。请指导我纠正这个问题。

代码语言:javascript
复制
Hibernate: insert into mkyongdb.system.STOCK (STOCK_NAME) values (?)
Exception in thread "main" org.hibernate.exception.SQLGrammarException: could not insert: [com.mkyong.user.Stock]
    at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:92)
    at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
    at org.hibernate.id.insert.AbstractSelectingDelegate.performInsert(AbstractSelectingDelegate.java:64)
    at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2345)
    at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2852)
    at org.hibernate.action.EntityIdentityInsertAction.execute(EntityIdentityInsertAction.java:71)
    at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:273)
    at org.hibernate.event.def.AbstractSaveEventListener.performSaveOrReplicate(AbstractSaveEventListener.java:320)
    at org.hibernate.event.def.AbstractSaveEventListener.performSave(AbstractSaveEventListener.java:203)
    at org.hibernate.event.def.AbstractSaveEventListener.saveWithGeneratedId(AbstractSaveEventListener.java:129)
    at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.saveWithGeneratedOrRequestedId(DefaultSaveOrUpdateEventListener.java:210)
    at org.hibernate.event.def.DefaultSaveEventListener.saveWithGeneratedOrRequestedId(DefaultSaveEventListener.java:56)
    at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.entityIsTransient(DefaultSaveOrUpdateEventListener.java:195)
    at org.hibernate.event.def.DefaultSaveEventListener.performSaveOrUpdate(DefaultSaveEventListener.java:50)
    at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.onSaveOrUpdate(DefaultSaveOrUpdateEventListener.java:93)
    at org.hibernate.impl.SessionImpl.fireSave(SessionImpl.java:713)
    at org.hibernate.impl.SessionImpl.save(SessionImpl.java:701)
    at org.hibernate.impl.SessionImpl.save(SessionImpl.java:697)
    at com.mkyong.common.App.main(App.java:45)
Caused by: java.sql.SQLSyntaxErrorException: ORA-00926: missing VALUES keyword

    at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:440)
    at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396)
    at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:837)
    at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:445)
    at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:191)
    at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:523)
    at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:207)
    at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:1010)
    at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1315)
    at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3576)
    at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3657)
    at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeUpdate(OraclePreparedStatementWrapper.java:1350)
    at org.hibernate.id.insert.AbstractSelectingDelegate.performInsert(AbstractSelectingDelegate.java:57)
    ... 16 more

Stock.hbm.xml

代码语言:javascript
复制
<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
<hibernate-mapping>
    <class name="com.mkyong.user.Stock" table="STOCK" catalog="mkyongdb">
        <id name="stockId" type="java.lang.Integer">
            <column name="STOCK_ID" />
            <generator class="identity" />
        </id>
        <property name="stockName" type="string">
            <column name="STOCK_NAME" length="10"  />
        </property>

        <!-- <one-to-one name="stockDetail" class="com.mkyong.user.StockDetail"
            cascade="save-update"></one-to-one> -->
    </class>
</hibernate-mapping>

hibernate.cfg.xml

代码语言:javascript
复制
<?xml version="1.0" encoding="utf-8"?>
<!DOCTYPE hibernate-configuration PUBLIC
"-//Hibernate/Hibernate Configuration DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd">
<hibernate-configuration>
    <session-factory>
        <property name="hibernate.connection.driver_class">oracle.jdbc.driver.OracleDriver</property>
        <property name="hibernate.connection.url">jdbc:oracle:thin:@127.0.0.1:1521/xe</property>
        <property name="hibernate.connection.username">system</property>
        <property name="hibernate.connection.password">admin</property>
        <property name="hibernate.dialect">org.hibernate.dialect.Oracle10gDialect</property>

        <property name="show_sql">true</property>
        <property name="hibernate.default_schema">system</property> 
        <property name="hibernate.hbm2ddl.auto">validate</property>
        <mapping resource="com/mkyong/user/DBUser.hbm.xml"></mapping>
        <mapping resource="com/mkyong/user/Stock.hbm.xml" />
    <mapping resource="com/mkyong/user/StockDetails.hbm.xml" />
    </session-factory>
</hibernate-configuration>

Stock.java

代码语言:javascript
复制
package com.mkyong.user;

public class Stock implements java.io.Serializable {

    private Integer stockId;
    private String stockName;
    //private StockDetail stockDetail;

    /*public StockDetail getStockDetail() {
        return stockDetail;
    }
    public void setStockDetail(StockDetail stockDetail) {
        this.stockDetail = stockDetail;
    }*/

    public Stock() {
        //super();
        // TODO Auto-generated constructor stub
    }
    public Stock(Integer stockId, String stockName) {
        super();
        this.stockId = stockId;
        this.stockName = stockName;
    }
    public Integer getStockId() {
        return stockId;
    }

    public void setStockId(Integer stockId) {
        this.stockId = stockId;
    }
    public String getStockName() {
        return stockName;
    }
    public void setStockName(String stockName) {
        this.stockName = stockName;
    }






}

Main.java

代码语言:javascript
复制
Session session = HibernateUtil.getSessionFactory().openSession();

        session.beginTransaction();

        Stock stock = new Stock();

        stock.setStockName("sam");


        session.save(stock);
        session.getTransaction().commit();

创建查询:

代码语言:javascript
复制
CREATE TABLE STOCK
(
  STOCK_ID numeric(10) not null,
  STOCK_NAME varchar2(50) not null,
  CONSTRAINT STOCK_PK PRIMARY KEY (STOCK_ID)
);
EN

回答 1

Stack Overflow用户

发布于 2018-06-01 04:22:44

  • 我认为mkyongdb是你的模式,它有一个名为STOCK的表。因此,在statement.
  • STOCK_ID中使用mkyongdb.STOCK而不是mkyongdb.system.STOCK insert是一个必填字段,在insert语句中缺少该字段。

(顺便说一句,如果您使用Oracle12c,则此字段可能不会包含在insert语句中,前提是在create table DDL语句中直接定义为STOCK_ID numeric(10) GENERATED by default on null as IDENTITY,而不需要任何其他机制,如触发器。如果您的版本早于12c,则可以创建包含:new.STOCK_ID := seq_stock_id.nextval;语句的before insert触发器,其中seq_stock_id是一个序列)

票数 1
EN
页面原文内容由Stack Overflow提供。腾讯云小微IT领域专用引擎提供翻译支持
原文链接:

https://stackoverflow.com/questions/50632007

复制
相关文章

相似问题

领券
问题归档专栏文章快讯文章归档关键词归档开发者手册归档开发者手册 Section 归档