Skip to main content

[Vertica][JDBC](10220) Driver not capable

  • May 6, 2015
  • 8 replies
  • 32 views
Teeka
  • Teeka
  • Participating Frequently

hi,

 

We am trying to establish DB connection to Vertica from HP Operations Orchestation.  When we try to execute the flow, here's the error that we are witnessing:

 

Vertica JDBC used: vertica-jdbc-7.0.1-0.jar

 

--------------------------------------------------------------------------------------------------------------------------------

ERROR [debug-runpool-1-thread-10] (00:35:58,175) com.iconclude.dharma.model.operations.WebOperation - RAS-side exception occurred while executing IAction 'com/iconclude/content/actions/sql/SQLCommand.class':'java.sql.SQLFeatureNotSupportedException: [Vertica][JDBC](10220) Driver not capable.
at com.vertica.exceptions.ExceptionConverter.toSQLException(Unknown Source)
at com.vertica.jdbc.common.SConnection.createStatement(Unknown Source)
at com.iconclude.content.actions.sql.SQL.executeSqlCommand(SQL.java:419)
at com.iconclude.content.actions.sql.SQLCommand.execute(SQLCommand.java:43)
at com.iconclude.webservices.ras.classLoadedIaction.execute(JavaExtensionService.java:578)
at com.iconclude.webservices.ras.JavaExtensionService.executeFromThisDelegator(JavaExtensionService.java:260)
at com.iconclude.webservices.ras.ExtensionServiceDelegator.execute(ExtensionServiceDelegator.java:58)
at com.iconclude.webservices.ras.RCAgentServiceSoapBindingImpl.execute(RCAgentServiceSoapBindingImpl.java:48)
at com.iconclude.webservices.ras.RCAgentServiceSoapBindingSkeleton.execute(RCAgentServiceSoapBindingSkeleton.java:238)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)

--------------------------------------------------------------------------------------------------------------------------------

 

Could anyone help us fix this issue?

 

thanks in advance

 

teeka

    8 replies

    SruthiA
    Forum|alt.badge.img+1
    • SruthiA
    • Participating Frequently
    • May 6, 2015

    Could you please turn on debugging and share me with the log files?

     

    Please turn on log information setting according to the documentation http://my.vertica.com/docs/7.1.x/HTML/index.htm#Authoring/ConnectingToHPVertica/ClientJDBC/JDBCConnectionProperties.htm%3FTocPath%3DConnecting%2520to%2520HP%2520Vertica|Client%2520Libraries|Programming%2520JDBC%2520Client%2520Applications|Creating%2520and%2520Configuring%2520a%2520Connection|_____1

     

    -Regards,

     Sruthi

    Teeka
    • Teeka
    • Author
    • Participating Frequently
    • May 6, 2015

    hi Sruthi,

    thanks for your quick response...

     

    i turned the logging and attached the log file.  please let me know if this can help...

     

     

    Teeka
    • Teeka
    • Author
    • Participating Frequently
    • May 6, 2015

    this is how i enabled logging.  please correct me.

     

    uncommented log4j.degub line from properties file under location C:\Program Files\Hewlett-Packard\Operations Orchestration\Studio\conf

     

    # uncomment this if you want to see what log4j does when it reads this file.
    log4j.debug=true

    log4j.rootLogger=ERROR, stdout, R

     

     

     

    Teeka
    • Teeka
    • Author
    • Participating Frequently
    • May 6, 2015

    more logs here:

     

     

    SruthiA
    Forum|alt.badge.img+1
    • SruthiA
    • Participating Frequently
    • May 7, 2015

    I checked logs and looks like there is some issue related to connection statement you are trying to issue.(ERROR [debug-runpool-1-thread-9] (00:34:16,028) com.iconclude.dharma.model.operations.WebOperation - RAS-side exception occurred while executing IAction 'com/iconclude/content/actions/sql/SQLCommand.class':'java.sql.SQLException: No database URL was provided 

     

     

    In order to investigate further, could you please share me with code that you are using to connect to vertica from HP Orchestration?

     

    -Regards,

    Sruthi

    Teeka
    • Teeka
    • Author
    • Participating Frequently
    • May 7, 2015

    hi Sruti,

     

    attached is the snapshot from flow properties...

     

    teeka

    Teeka
    • Teeka
    • Author
    • Participating Frequently
    • May 7, 2015

    hi Sruti,

    even i work for hp. is it possible to reply to teeka(at)hp(dot)com

     

    thanks,

    teeka

    swettdj
    • swettdj
    • New Participant
    • October 3, 2016

    Hi, I have the same problem and I can't find a solution.

     

    I'm using a jdbc connection on WebSphere 8.5 and WebSphere liberty.

    The configurations are ok, I tested the connection through websphere.

    When I try to call the jndi resource into my war by SmartGWT configuration properties:

    sql.Vertica.driver.name: jdbc/vertica
    sql.Vertica.database.type: generic
    sql.Vertica.interface.type: jndi

    Mapped into web.xml:

     

    <resource-ref>
      <description>VERTICA</description>
      <res-ref-name>jdbc/vertica</res-ref-name>
      <res-type>javax.sql.DataSource</res-type>
      <res-auth>Container</res-auth>
    </resource-ref>

     

     

    I obtain the following error:

    [Vertica][JDBC](10220) Driver non in grado. DSRA0010E: Stato SQL = HYC00, Codice errore = 10.220
        at com.vertica.exceptions.ExceptionConverter.toSQLException(Unknown Source)

     Could anyone help me?

    Still scrolling?
    Ask a question
    Terms & ConditionsAccessibility statement