Connecting NiFi with Sybase database erroring

Asked Aug 23 '22 at 07:30

Active Aug 23 '22 at 17:59

Viewed 64 times

Could you please help me with the correct URL format to connect to Sybase using the DBCP connection pool of NiFi?

The URL format that I have tried is - jdbc:sybase:Tds://host:port

I keep getting this error - failed to create Poolable Connection Factory. Incorrect URL format.

Thank you in advance.

edited Aug 23 '22 at 17:59

markp-fuso

asked Aug 23 '22 at 07:30

olivia

which jdbc driver you are using? – daggett Aug 23 '22 at 08:33
2

https://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.help.sqlanywhere.12.0.1/dbprogramming/url-using-jdbc.html – daggett Aug 23 '22 at 08:47
Hi @daggett - I'm using com.sybase.jdbc4.jdbc.SybDriver I'm using the same URL format as mentioned in the above doc but I'm still getting the same error – olivia Aug 23 '22 at 09:32
your url in question a bit different. should be without slash: `jdbc:sybase:Tds:host:port` – daggett Aug 23 '22 at 09:37
@daggett - tried without the slash too and I get the same error. – olivia Aug 23 '22 at 09:54
Please show the full stack trace from log file. – daggett Aug 23 '22 at 12:18
which Sybase RDBMS product (ASE? IQ? SQLAnywhere? Advantage?) and version? – markp-fuso Aug 23 '22 at 14:42
@markp-fuso - we're using ASE version 16.0 – olivia Aug 23 '22 at 17:53

0 Answers0