problems upgrading vertica jdbc
Hi Vertica experts,
We are working on Vertica v7.1.1-7.
I am trying to upgrade the vertica jdbc driver that we are using in our Java code from 6.1.3 to 7.1.2.
On some INSERT statements I am getting a 'Driver not capable' error with the new driver.
I can't figure out what is the reason for this.
Any ideas on what can cause this on jdbc 7.1.2 or how to investigate this issue?
full error:
[Vertica][JDBC](10220) Driver not capable.; nested exception is java.sql.SQLFeatureNotSupportedException: [Vertica][JDBC](10220) Driver not capable.
at org.springframework.jdbc.support.SQLExceptionSubclassTranslator.doTranslate(SQLExceptionSubclassTranslator.java:94)
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:73)
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81)
at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:660)
at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:673)
at org.springframework.jdbc.core.JdbcTemplate.batchUpdate(JdbcTemplate.java:989)
at org.springframework.jdbc.core.namedparam.NamedParameterBatchUpdateUtils.executeBatchUpdateWithNamedParameters(NamedParameterBatchUpdateUtils.java:40)
at org.springframework.jdbc.core.namedparam.NamedParameterJdbcTemplate.batchUpdate(NamedParameterJdbcTemplate.java:361)
at org.springframework.jdbc.core.namedparam.NamedParameterJdbcTemplate.batchUpdate(NamedParameterJdbcTemplate.java:355)
Comments
Looks like the INSERT batch update fails specifically on setting the parameter value for a column of INTERVAL type .
Anyone had similar issues?