log4j:WARN No appenders could be found for logger (org.hibernate.cfg.Environment).
log4j:WARN Please initialize the log4j system properly.
sa
sa
Hibernate:
insert
into
dbo.xiao_lei
(X_SEX, X_NAME)
values
(?, ?)
Exception in thread "main" org.hibernate.exception.SQLGrammarException: Could not execute JDBC batch update
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:67)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:202)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:235)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:139)
at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:297)
at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27)
at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:985)
at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:333)
at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:106)
at dao.SelectAll.addUser(SelectAll.java:43)
at test.test.main(test.java:44)
Caused by: java.sql.BatchUpdateException: ORA-00942: table or view does not exist at oracle.jdbc.dbaccess.DBError.throwBatchUpdateException(DBError.java:459)
at oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java:3907)
at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:58)
at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:195)
... 9 moreXML是这样布置的..<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd"><hibernate-mapping>
<class name="struts.login" table="xiao_lei" schema="dbo">
<id name="uname" type="java.lang.String">
<column name="X_NAME" length="50"/>
<!-- 用户指派 -->
<generator class="assigned"/>
</id>
<property name="pwd" type="java.lang.String">
<column name="X_SEX" length="10"></column>
</property>
</class></hibernate-mapping>代码是这样的 Configuration cfg; SessionFactory factory; Session session; Query query; public SelectAll(){
cfg=new Configuration().configure();
factory=cfg.buildSessionFactory();
}
public void addUser(login user){
session=factory.openSession();
transaction=session.beginTransaction();
System.out.println(user.getPwd());
System.out.println(user.getUname());
//使用对象操作替代sql操作
session.save(user);
//事物提交
transaction.commit();
session.close();
}
log4j:WARN Please initialize the log4j system properly.
sa
sa
Hibernate:
insert
into
dbo.xiao_lei
(X_SEX, X_NAME)
values
(?, ?)
Exception in thread "main" org.hibernate.exception.SQLGrammarException: Could not execute JDBC batch update
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:67)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:202)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:235)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:139)
at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:297)
at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27)
at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:985)
at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:333)
at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:106)
at dao.SelectAll.addUser(SelectAll.java:43)
at test.test.main(test.java:44)
Caused by: java.sql.BatchUpdateException: ORA-00942: table or view does not exist at oracle.jdbc.dbaccess.DBError.throwBatchUpdateException(DBError.java:459)
at oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java:3907)
at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:58)
at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:195)
... 9 moreXML是这样布置的..<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd"><hibernate-mapping>
<class name="struts.login" table="xiao_lei" schema="dbo">
<id name="uname" type="java.lang.String">
<column name="X_NAME" length="50"/>
<!-- 用户指派 -->
<generator class="assigned"/>
</id>
<property name="pwd" type="java.lang.String">
<column name="X_SEX" length="10"></column>
</property>
</class></hibernate-mapping>代码是这样的 Configuration cfg; SessionFactory factory; Session session; Query query; public SelectAll(){
cfg=new Configuration().configure();
factory=cfg.buildSessionFactory();
}
public void addUser(login user){
session=factory.openSession();
transaction=session.beginTransaction();
System.out.println(user.getPwd());
System.out.println(user.getUname());
//使用对象操作替代sql操作
session.save(user);
//事物提交
transaction.commit();
session.close();
}
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货