Using Sybase database in Flow.

[Chris M3]

Hello,

I am wondering if anyone has successfully setup a Sybase Connection through Integration Hub/Flow.  I am attempting to setup our Netcool connection, which is currently accomplished through script includes, as flow actions.  I have setup the connection by re-enabling the Sybase database format choice, and setting the connection up in the same method as the Netcool interface.  When I attempt to do a simple query through a new action (JDBC Step), I get the below error.  I have also attempted to build the connection in-line on the action as the 'Custom' database type and received the same error.

SQLException: Cannot invoke "java.sql.Statement.setQueryTimeout(int)" because "statement" is null

Below is the connection info (sanitized), I have also tried putting com.sybase.jdbc3.jdbc.SybDriver into the JDBC driver field

Any thoughts or help would be appreciated

[Runjay Patel]

Hi @Chris M3 ,

From connection url remove db name and then try.

Please Mark Correct if this solves your query and also mark Helpful if you find my response worthy based on the impact.

[Chris M3]

No change to the error message

[Runjay Patel]

Hi @Chris M3 ,

your error states that you are not passing any sql statement. In same form either you have to write query or select entire records from table.

after adding the sql statement try again.

Please Mark Correct if this solves your query and also mark Helpful if you find my response worthy based on the impact.

[Chris M3]

Yes, I have a SQL statement in there.  I have tried several different simple queries.  I have also put in an invalid syntax and receive the same error.