Name is required.
Email address is required.
Invalid email address
Answer is required.
Exceeding max length of 5KB

JDBC connection


i m using JDBC Load Component in Matillion ETL For Snowflake...Please help....
I m getting the following error while i connect ....

Exception caught whilst testing connection: No suitable driver found for jdbc:jtds:sqlserver:/------------/database_name ;domain=dname;integratedSecurity=true;

I tried uploading the downloaded file from

https://redshiftsupport.matillion.com/customer/portal/articles/2406136?b_id=8914

but i m getting the error...

Exception loading driver class [com.microsoft.sqlserver.jdbc.SQLServerDriver].
jtds-1.31.jar file is the i m uploading

1 Community Answers

Matillion Agent  

Ian Funnell —

Hi Sarath,

Matillion ships with the JTDS driver version 1.3.1 by default, so you should not need to upload anything. Note this is not the Microsoft SQL Server driver, which we are not permitted to redistribute.

Make sure your JDBC URL matches this pattern:

jdbc:jtds:sqlserver://<host>/<database>

Please can you try putting your additional options in the Connection Properties rather than in the URL.

Best regards,
Ian

Post Your Community Answer

To add an answer please login