java - Hibernate 忽略 @Table 注释
问题描述
我遇到了一个问题,@Table(name = "tableName") 被忽略,而是使用类的名称。
在下面的示例中,它忽略了 tb_users 并试图找到一个名为“user”的表。为什么会这样?
编辑:所以我没有提供足够的信息。这是我的代码:
实体
@Builder
@Getter
@Setter
@Entity
@Table(name = "tb_users")
public class User {
@Id
@GeneratedValue(strategy = GenerationType.AUTO)
@Column(name = "id", nullable = false)
private Long id;
@Column(name = "username", length = 127, nullable = false)
private String username;
@Column(name = "password", length = 127, nullable = false)
private String password;
@Column(name = "balance", nullable = false)
private double balance;
}
数据库配置
@Configuration
@EnableJpaRepositories("com.uci.bank.repository")
public class DatabaseConfig {
@Value("${database.url}")
String url;
@Value("${database.user}")
String user;
@Value("${database.password}")
String password;
@Value("${database.driver}")
String driver;
@Value("${database.persistenceUnit}")
String persistenceUnit;
@Value("${hibernate.dialect}")
String dialect;
@Value("${hibernate.showSql}")
String showSql;
@Value("${hibernate.formatSql}")
String formatSql;
@Value("${hibernate.hbm2ddl}")
String hbm2ddl;
public String getUrl() {
return url;
}
public String getUser() {
return user;
}
public String getPassword() {
return password;
}
public String getDriver() {
return driver;
}
public String getPersistenceUnit() {
return persistenceUnit;
}
public String getDialect() {
return dialect;
}
public String getShowSql() {
return showSql;
}
public String getFormatSql() {
return formatSql;
}
public String getHbm2ddl() {
return hbm2ddl;
}
@Bean
public org.springframework.jdbc.datasource.DriverManagerDataSource dataSource() {
org.springframework.jdbc.datasource.DriverManagerDataSource ds = new org.springframework.jdbc.datasource.DriverManagerDataSource();
ds.setDriverClassName(this.driver);
ds.setUrl(this.url);
ds.setUsername(this.user);
ds.setPassword(this.password);
return ds;
}
@Bean
public org.springframework.orm.jpa.LocalContainerEntityManagerFactoryBean entityManagerFactory() {
org.springframework.orm.jpa.LocalContainerEntityManagerFactoryBean entityManagerFactory = new org.springframework.orm.jpa.LocalContainerEntityManagerFactoryBean();
entityManagerFactory.setDataSource(this.dataSource());
entityManagerFactory.setPersistenceUnitName(this.persistenceUnit);
entityManagerFactory.setJpaVendorAdapter(new org.springframework.orm.jpa.vendor.HibernateJpaVendorAdapter());
Map<String, String> jpaProperties = new HashMap<>();
jpaProperties.put("hibernate.dialect", this.dialect);
jpaProperties.put("hibernate.show_sql", this.showSql);
jpaProperties.put("hibernate.format_sql", this.formatSql);
jpaProperties.put("hibernate.hbm2ddl.auto", this.hbm2ddl);
entityManagerFactory.setJpaPropertyMap(jpaProperties);
return entityManagerFactory;
}
@Bean
public org.springframework.orm.jpa.JpaTransactionManager transactionManager() {
org.springframework.orm.jpa.JpaTransactionManager tm = new org.springframework.orm.jpa.JpaTransactionManager();
tm.setEntityManagerFactory(this.entityManagerFactory().getNativeEntityManagerFactory());
return tm;
}
}
应用程序属性
database.driver=org.sqlite.JDBC
database.url=jdbc:sqlite:bank.db
database.user=USERNAME
database.password=PASSWORD
database.persistenceUnit=jpaData
hibernate.dialect=com.uci.bank.dialect.SQLiteDialect
hibernate.showSql=true
hibernate.formatSql=true
hibernate.hbm2ddl=validate
当我尝试使用传入用户的 JpaRepository 保存方法插入时,我收到以下错误消息:
[SQLITE_ERROR] SQL 错误或缺少数据库(没有这样的表:用户)
我正在使用 SQLite,我必须创建一个方言:
public class SQLiteIdentityColumnSupport extends IdentityColumnSupportImpl {
@Override
public boolean supportsIdentityColumns() {
return true;
}
@Override
public String getIdentitySelectString(String table, String column, int type) throws MappingException {
return "select last_insert_rowid()";
}
@Override
public String getIdentityColumnString(int type) throws MappingException {
return "integer";
}
}
公共类 SQLiteDialect 扩展方言 {
public SQLiteDialect() {
registerColumnType(Types.BIT, "integer");
registerColumnType(Types.TINYINT, "tinyint");
registerColumnType(Types.SMALLINT, "smallint");
registerColumnType(Types.INTEGER, "integer");
registerColumnType(Types.BIGINT, "bigint");
registerColumnType(Types.FLOAT, "float");
registerColumnType(Types.REAL, "real");
registerColumnType(Types.DOUBLE, "double");
registerColumnType(Types.NUMERIC, "numeric");
registerColumnType(Types.DECIMAL, "decimal");
registerColumnType(Types.CHAR, "char");
registerColumnType(Types.VARCHAR, "varchar");
registerColumnType(Types.LONGVARCHAR, "longvarchar");
registerColumnType(Types.DATE, "date");
registerColumnType(Types.TIME, "time");
registerColumnType(Types.TIMESTAMP, "timestamp");
registerColumnType(Types.BINARY, "blob");
registerColumnType(Types.VARBINARY, "blob");
registerColumnType(Types.LONGVARBINARY, "blob");
registerColumnType(Types.BLOB, "blob");
registerColumnType(Types.CLOB, "clob");
registerColumnType(Types.BOOLEAN, "integer");
}
public IdentityColumnSupport getIdentityColumnSupport() {
return new SQLiteIdentityColumnSupport();
}
public boolean hasAlterTable() {
return false;
}
public boolean dropConstraints() {
return false;
}
public String getDropForeignKeyString() {
return "";
}
public String getAddForeignKeyConstraintString(String constraintName, String[] foreignKey, String referencedTable, String[] primaryKey, boolean referencesPrimaryKey) {
return "";
}
public String getAddPrimaryKeyConstraintString(String constraintName) {
return "";
}
public String getForUpdateString() {
return "";
}
public String getAddColumnString() {
return "add column";
}
public boolean supportsOuterJoinForUpdate() {
return false;
}
public boolean supportsIfExistsBeforeTableName() {
return true;
}
public boolean supportsCascadeDelete() {
return false;
}
}
解决方案
@Entity
之前尝试,@Table
这样您的代码将是
@Entity
@Table((name = "tb_users")
public class User {
...
}
推荐阅读
- c++ - 复数乘法:使用 -Ofast 编译时,std::vector 比 Eigen::Matrix 快 2 倍
- python - 即使颜色范围正确,Python 3.7 OpenCV 仍为空掩码
- html - 启用拖放功能以在任何网页上的任何文本框中重新排列文本
- javascript - 未捕获的类型错误:当我运行时无法读取 null 的属性“addEventListener”得到此错误
- html - 2 div 上的倾斜边框
- python - 如何根据条件替换 pandas DataFrame 中的值?
- reactjs - React.js TypeScript 相同的组件和
- node.js - 有没有办法监控 Nodejs 的并发请求
- postgresql - “order by foo, bar”和“order by (foo, bar)”之间的区别(带括号)
- java - 如何创建 android.jar 或者我从哪里得到它,以便我可以在 Java 库中使用 Android 的所有组件