Expand all | Collapse all

Python JDBC wrapper

  • 1.  Python JDBC wrapper

    Posted 05-15-2017 09:05

    Hi, I was getting this error while connecting a notebook (and running sample code) …

    jpype._jexception.SQLExceptionPyRaisable: java.sql.SQLException: Connection failed invalid protocol option- .

    I changed the following line in the connection wrapper (w/o the extra . param) and it works but not sure if that was right or if this was due to JayDeBeApi compatibility:

    return jaydebeapi.connect(‘com.mapd.jdbc.MapDDriver’,
    ‘jdbc:mapd:{}:{}:.’.format(host, dbname)

    return jaydebeapi.connect(‘com.mapd.jdbc.MapDDriver’,
    ‘jdbc:mapd:{}:{}:’.format(host, dbname)

  • 2.  RE: Python JDBC wrapper

    Posted 05-15-2017 17:29

    Your edit was correct. There is a typo in the sample program. I’ll get a revised version posted shortly.
    Thanks for pointing this out.