Hello.
I’m working with informix (v7, v9, v12, etc).
When I get connection to informix v9, hibernate looks for syssequences table and couldn’t find it, because for this version infromix this system table has name SYSSYNTABLE.
(ERROR: Could not fetch the SequenceInformation from the database
java.sql.SQLException: The specified table (syssequences) is not in the database.)
There is no problem with informix v12. But my app must work with different informix versions (various locations).
How can I override this table in configuration file (for exmaple, in property file)?
<bean id="sessionFactory" class="org.springframework.orm.hibernate5.LocalSessionFactoryBean">
<property name="dataSource" ref="myDataSource" />
<property name="packagesToScan" value="com.company.dep.db.entity" />
<property name="hibernateProperties">
<props>
<prop key="hibernate.id.new_generator_mappings">false</prop>
<prop key="hibernate.dialect">org.hibernate.dialect.InformixDialect </prop>
<prop key="hibernate.show_sql">true</prop>
</props>
</property>
</bean>
Hibernate 5.4.18.Final
Informix jdbc driver 4.50.4.1
HikariCP 3.4.5
spring-webmvc 5.2.7
thanx