Skip to main content

problems upgrading vertica jdbc

  • November 18, 2015
  • 1 reply
  • 13 views

dafna
Forum|alt.badge.img
  • Participating Frequently

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)

 

 

 

1 reply

dafna
Forum|alt.badge.img
  • Author
  • Participating Frequently
  • November 19, 2015

 

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

Anyone had similar issues?