大家好,我遇到这个问题,将数据库连接mysql 的时候能自动生成表,换成oracle 的时候就不能自动生成表了
大家帮我看看是什么原因
oracle中的 sequence 已经创建
sql 脚本create sequence S_ALARM_DEAL_INFO
minvalue 1
maxvalue 999999999999999999999999999
start with 1
increment by 1
cache 20//实体类
@Entity
@Table(name = "xuan_user")
public class Users {
private int id;
private String name;
private Groups groups;
@ManyToOne (cascade={CascadeType.ALL})
@JoinColumn(name="groupnumber")
public Groups getGroups() {
return groups;
}
public void setGroups(Groups groups) {
this.groups = groups;
}
@Id
@SequenceGenerator(name = "generator_user" ,sequenceName = "generator_user",allocationSize = 1,initialValue = 0)
@GeneratedValue(strategy = GenerationType.AUTO,generator = "generator_user")
public int getId() {
return id;
}
public void setId(int id) {
this.id = id;
}
public String getName() {
return name;
}
public void setName(String name) {
this.name = name;
}
}
spring 配置文件
<bean id="mySessionFactory"
class="org.springframework.orm.hibernate3.annotation.AnnotationSessionFactoryBean">
<property name="dataSource" ref="oracleSource" />
<property name="mappingLocations">
<list>
<value>classpath:/com/xuan/model/*.hbm.xml</value>
</list>
</property>
<property name="packagesToScan">
<list>
<value>com.xuan.model</value>
</list>
</property>
<property name="hibernateProperties">
<props>
<!--
<prop key="hibernate.dialect">org.hibernate.dialect.MySQLDialect</prop>
-->
<prop key="hibernate.dialect">org.hibernate.dialect.Oracle9iDialect</prop>
<prop key="hibernate.show_sql">true</prop>
<prop key="hibernate.format_sql">true</prop>
<prop key="hibernate.hbm2ddl.auto">create</prop>
</props>
</property>
</bean>
大家帮我看看是什么原因
oracle中的 sequence 已经创建
sql 脚本create sequence S_ALARM_DEAL_INFO
minvalue 1
maxvalue 999999999999999999999999999
start with 1
increment by 1
cache 20//实体类
@Entity
@Table(name = "xuan_user")
public class Users {
private int id;
private String name;
private Groups groups;
@ManyToOne (cascade={CascadeType.ALL})
@JoinColumn(name="groupnumber")
public Groups getGroups() {
return groups;
}
public void setGroups(Groups groups) {
this.groups = groups;
}
@Id
@SequenceGenerator(name = "generator_user" ,sequenceName = "generator_user",allocationSize = 1,initialValue = 0)
@GeneratedValue(strategy = GenerationType.AUTO,generator = "generator_user")
public int getId() {
return id;
}
public void setId(int id) {
this.id = id;
}
public String getName() {
return name;
}
public void setName(String name) {
this.name = name;
}
}
spring 配置文件
<bean id="mySessionFactory"
class="org.springframework.orm.hibernate3.annotation.AnnotationSessionFactoryBean">
<property name="dataSource" ref="oracleSource" />
<property name="mappingLocations">
<list>
<value>classpath:/com/xuan/model/*.hbm.xml</value>
</list>
</property>
<property name="packagesToScan">
<list>
<value>com.xuan.model</value>
</list>
</property>
<property name="hibernateProperties">
<props>
<!--
<prop key="hibernate.dialect">org.hibernate.dialect.MySQLDialect</prop>
-->
<prop key="hibernate.dialect">org.hibernate.dialect.Oracle9iDialect</prop>
<prop key="hibernate.show_sql">true</prop>
<prop key="hibernate.format_sql">true</prop>
<prop key="hibernate.hbm2ddl.auto">create</prop>
</props>
</property>
</bean>
解决方案 »
- jsp中button按钮是否可以携带数据跳转到另一个页面?
- 小弟跪求 手机wap如何实现mp3下载功能 在线等
- JAVA实现用户打卡签到连续登录天数
- struts1的ActionForm用List接收值出错
- 求助hibernate3.2的各插件
- 高难度问题 ^_^
- JAVA反射方面的问题
- 在启动TOMCAT时出现java.lang.ClassCastException: org.apache.naming.resources.FileDirContext错误
- 在线求助,jbuilder下axis的web service文件传送(只能够上传,返回文件时候报错)
- 问题!我在用iReport时出现编译错误
- 如何解决 编辑器中的引号和jsp页面引号冲突问题
- js控制iframe跳转
create-drop: 表存在删除后创建
validate: 核对实体类配置
update: 如果表不存在就创建,存在的话核对表结构,若增加属性会自动增加字段
<property name="driverClass">
<value>oracle.jdbc.driver.OracleDriver</value>
</property>
<property name="jdbcUrl">
<value>jdbc:oracle:thin:@172.7.123.111:1521:orcl</value>
</property>
<property name="user" value="ivms8200"/>
<property name="password" value="ivms8200"/>
<property name="initialPoolSize"><value>10</value></property>
<property name="minPoolSize"><value>10</value></property>
<property name="maxPoolSize"><value>30</value></property>
<property name="acquireIncrement"><value>5</value></property>
<property name="maxIdleTime"><value>180</value></property>
<property name="maxStatements"><value>0</value></property>
</bean>这个用户是存在的 oracle 有数据库这一说么?