OracleDB compatibility

[EricEttes]

When using the current version of Hibernate (4.2.2.Final) and JPA (Hibernate JPA 1.0.1.Final), the following issues arise:

current on Connector is a reserved keyword. Fixable by adding an @Column annotation with a different name

Table and column names should not exceed 30 characters. At the time of writing, this applies to the operator-api module:

• io.motown.operatorapi.viewmodel.persistence.entities.ChargingStation.localAuthorizations will be generated into table ChargingStation_localAuthorizations
• io.motown.operatorapi.viewmodel.persistence.entities.ChargingStation.configurationItems will be generated into table ChargingStation_configurationItems

Oracle does not support @GeneratedValue(strategy = GenerationType.IDENTITY) until Oracle 12c. For Oracle10g Dialect, use a @SequenceGenerator

example

@Id
@SequenceGenerator(name="seq", allocationSize=1, initialValue=1)
@GeneratedValue(generator="seq")
private Long id;

note
These issues arose with Oracle10g Dialect, configurable in the jpaVendorAdapter as such:

<property name="jpaVendorAdapter">
   <bean class="org.springframework.orm.jpa.vendor.HibernateJpaVendorAdapter">
      <property name="databasePlatform" value="org.hibernate.dialect.Oracle10gDialect" />
      <property name="database" value="${hibernate.dialect}"/>
      <property name="generateDdl" value="true"/>
   </bean>
</property>