problems upgrading vertica jdbc

dafna

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)

 

 

 

dafna

 

Looks like the INSERT batch update fails specifically on setting the parameter value for a column of INTERVAL type .

Anyone had similar issues?