一个hibernate的bug. hibernateoraclejdbc 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 Caused by: java.sql.BatchUpdateException: ORA-00903: 表名无效表名有问题~检查一下你hbm文件配置的table~ //创建表的用法 private static void createTable()throws Exception { Connection conn = Tools.getConnection(); String sql = "create table et1402(" + "eid number primary key," + "ename varchar2(20)," + "gender varchar2(2)," + "phone varchar2(11)," + "QQ varchar2(10)" + ")"; //获得执行对象 Statement state = conn.createStatement(); boolean b = state.execute(sql); if(!b){ System.out.println("创建成功!"); } Tools.close(conn, state, null); } 这是我的User.hbm.xml的程序: 没问题吧?<?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 package="cn.itcast.hibernate.domain"> <class name="User" > <id name="id"> <generator class="native"/> </id> <property name="name"/> <property name="birthday"/> </class> </hibernate-mapping> 你的hibernate.cfg.xml里配置这个属性没有?<property name="hibernate.hbm2ddl.auto">update</property> 我的hibernate.cfg.xml配置改了下: 报错现在没有了,但是数据库中我没有看见创建的表。<hibernate-configuration> <session-factory > <property name="hibernate.connection.driver_class">oracle.jdbc.driver.OracleDriver</property> <property name="connection.url">jdbc:oracle:thin:@localhost:1521:orcl</property> <property name="connection.username">scott</property> <property name="connection.password">tiger</property> <property name="dialect">org.hibernate.dialect.OracleDialect</property> <property name="hbm2ddl.auto">create</property> <property name="show_sql">true</property> <property name="format_sql">true</property> <property name="connection_pool_size">20</property> <mapping resource="cn/itcast/hibernate/domain/User.hbm.xml"></mapping> </session-factory></hibernate-configuration> 我在30天学通Java Web项目案例开发中,有段代码报错,不知道怎么改,请高手指教.. 从服务器指定路径下载一个文件到d:/ 根目录下面 java 基本知识 在TOMCAT中部署J2EE项目时出的问题 关于gmail的IMAP协议与第三方程序交互的问题 关于搭建J2EE开发环境的问题(帮顶的都有分啦,火了) 客户端如何一直连接socket? +++谁是J2EE/WebLogic的高手啊!有好消息告诉你哦!急啊!+++ 求评分的JS的实现。。 请教配置webservices服务 jbpm 启动流程调用signal()报错 大神们求助
表名有问题~检查一下你hbm文件配置的table~
private static void createTable()throws Exception {
Connection conn = Tools.getConnection();
String sql = "create table et1402(" +
"eid number primary key," +
"ename varchar2(20)," +
"gender varchar2(2)," +
"phone varchar2(11)," +
"QQ varchar2(10)" +
")";
//获得执行对象
Statement state = conn.createStatement();
boolean b = state.execute(sql);
if(!b){
System.out.println("创建成功!");
} Tools.close(conn, state, null);
}
<?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
package="cn.itcast.hibernate.domain"> <class name="User" >
<id name="id">
<generator class="native"/>
</id> <property name="name"/>
<property name="birthday"/> </class>
</hibernate-mapping>
<property name="hibernate.hbm2ddl.auto">update</property>
<hibernate-configuration>
<session-factory >
<property name="hibernate.connection.driver_class">oracle.jdbc.driver.OracleDriver</property>
<property name="connection.url">jdbc:oracle:thin:@localhost:1521:orcl</property>
<property name="connection.username">scott</property>
<property name="connection.password">tiger</property>
<property name="dialect">org.hibernate.dialect.OracleDialect</property>
<property name="hbm2ddl.auto">create</property>
<property name="show_sql">true</property>
<property name="format_sql">true</property>
<property name="connection_pool_size">20</property>
<mapping resource="cn/itcast/hibernate/domain/User.hbm.xml"></mapping>
</session-factory>
</hibernate-configuration>