0

Connecting with SQLAlchemy

Has anyone ever tried to connect to Incorta externally using the python package SQLAlchemy?  

We're trying to use it along side the python driver psycopg2 and we get the error 'Failed to Parse query' regardless of whatever query we try.  The psycopg2 driver works on it's own though.  

Thanks!

2replies Oldest first
  • Oldest first
  • Newest first
  • Active threads
  • Popular
  • Mike Mascitti -- not that I know of, Mike.  Do you have any other detail on the error?

    Like
  • Hi Dan, in the SQL log I see the following.... It appears that the very first character can not be interpreted.  

    ERROR: [15:20:59] [sqli | incmifhlb@incorta | Protocol]Caused by: net.sf.jsqlparser.parser.ParseException: Encountered "<EOF>" at line 1, column 1.
    Was expecting one of:
        "SET" ...
        "CALL" ...
        "SELECT" ...

     

    (I removed the end... the list goes on)

    This happens with a few different queries, all start with the word 'SELECT'

    Like
Like Follow
  • 13 days agoLast active
  • 2Replies
  • 10Views
  • 2 Following

Product Announcement

Incorta 4.9 is now Generally Available (GA)!!!