I ran with below
spring.jpa.hibernate.ddl-auto=update
have an entity
import org.hibernate.envers.Audited;
@Audited
@Entity
@Getter
@Setter
@Table(name = "code_value")
public class CodeValue extends BaseEntity {
@Column(length = 100)
private String code;
@Column(length = 200)
private String value;
}
The Base Entity is below
import lombok.Getter;
import lombok.Setter;
import org.hibernate.annotations.CreationTimestamp;
import org.hibernate.annotations.UpdateTimestamp;
import org.hibernate.envers.Audited;
import org.springframework.data.annotation.CreatedBy;
import org.springframework.data.annotation.LastModifiedBy;
import org.springframework.data.jpa.domain.support.AuditingEntityListener;
import javax.persistence.Column;
import javax.persistence.EntityListeners;
import javax.persistence.GeneratedValue;
import javax.persistence.GenerationType;
import javax.persistence.Id;
import javax.persistence.MappedSuperclass;
import javax.persistence.Temporal;
import javax.persistence.TemporalType;
import java.io.Serializable;
import java.util.Date;
import java.util.UUID;
@Audited
@MappedSuperclass
@Getter
@Setter
@EntityListeners(AuditingEntityListener.class)
public class BaseEntity implements Serializable {
private static final long serialVersionUID = -1305858937096468628L;
@Id
@GeneratedValue(strategy= GenerationType.IDENTITY)
@Column(name = "id", length = 20)
private long id;
@Column(name = "uuid", updatable = false, nullable = false)
// @Transient does not persist uuid
private String uuid = UUID.randomUUID().toString();
@CreatedBy
@Column(name = "created_by", length = 50, updatable = false)
private String createdBy;
@CreationTimestamp
@Temporal(TemporalType.TIMESTAMP)
@Column(name = "created_date", length = 25, updatable = false)
private Date createdDate;
@LastModifiedBy
@Column(name = "updated_by", length = 50)
private String updatedBy;
@UpdateTimestamp
@Temporal(TemporalType.TIMESTAMP)
@Column(name = "updated_date", length = 25)
private Date updatedDate;
@Column(name = "is_enabled", nullable = false, columnDefinition="boolean DEFAULT true")
private boolean isEnabled = true;
@Override
public boolean equals(Object o) {
return super.equals(o);
}
@Override
public int hashCode() {
return super.hashCode();
}
}
This is my Hibernate Config class
import org.hibernate.MultiTenancyStrategy;
import org.hibernate.cfg.Environment;
import org.hibernate.context.spi.CurrentTenantIdentifierResolver;
import org.hibernate.engine.jdbc.connections.spi.MultiTenantConnectionProvider;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.boot.autoconfigure.orm.jpa.JpaProperties;
import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Configuration;
import org.springframework.orm.jpa.JpaVendorAdapter;
import org.springframework.orm.jpa.LocalContainerEntityManagerFactoryBean;
import org.springframework.orm.jpa.vendor.HibernateJpaVendorAdapter;
import javax.sql.DataSource;
import java.util.HashMap;
import java.util.Map;
@Configuration
public class HibernateConfig {
@Autowired
private JpaProperties jpaProperties;
@Bean
JpaVendorAdapter jpaVendorAdapter() {
return new HibernateJpaVendorAdapter();
}
@Bean
LocalContainerEntityManagerFactoryBean entityManagerFactory(
DataSource dataSource,
MultiTenantConnectionProvider multiTenantConnectionProviderImpl,
CurrentTenantIdentifierResolver currentTenantIdentifierResolverImpl
) {
Map<String, Object> jpaPropertiesMap = new HashMap<>(jpaProperties.getProperties());
jpaPropertiesMap.put(Environment.MULTI_TENANT, MultiTenancyStrategy.SCHEMA);
jpaPropertiesMap.put(Environment.MULTI_TENANT_CONNECTION_PROVIDER, multiTenantConnectionProviderImpl);
jpaPropertiesMap.put(Environment.MULTI_TENANT_IDENTIFIER_RESOLVER, currentTenantIdentifierResolverImpl);
jpaPropertiesMap.put(Environment.FORMAT_SQL, true);
jpaPropertiesMap.put(Environment.SHOW_SQL, true);
LocalContainerEntityManagerFactoryBean em = new LocalContainerEntityManagerFactoryBean();
em.setDataSource(dataSource);
em.setJpaVendorAdapter(this.jpaVendorAdapter());
em.setJpaPropertyMap(jpaPropertiesMap);
return em;
}
}
When I run the app, it generated a table named in lowercase as code_value_aud
However, when I run my application, and trigger an API, I receive the errors below
SQLSyntaxErrorException: Table 'REVINFO' doesn't exist"
SQLSyntaxErrorException: Table 'code_value_AUD' doesn't exist"
I can't use the solution from https://stackoverflow.com/a/39194169, i.e.
spring.jpa.hibernate.naming.physical-strategy=org.hibernate.boot.model.naming.PhysicalNamingStrategyStandardImpl
because the naming convention stipulated by my company is that all table names must be in lower case.
How do I ensure that when my Spring app reads from a table, it reads the table name all in lower case, i.e. code_value_aud instead of code_value_AUD (and revinfo instead of REVINFO)?