Problem trying to register JDBC Driver in EXAOperation

Contributor

Hello, community!

I am trying to register the JDBC Driver for SQL Server, following this LINK 

But I get an error and do not know how to solve it. Apparently the file is in the wrong format or something I am not able to understand. Appreciate any suggestions.

Hugo.

1 ACCEPTED SOLUTION

Xpert

Hi,

you have to first create the jdbc driver by clicking add if you want to upload a non default jdbc driver:

 

 

Charlie_2-1597642087839.png

Then select the new driver (in my example jdbc3) and select the jar file you'd like to upload.

Charlie_3-1597642167765.png

 

 

 

 



View solution in original post

2 REPLIES 2

Xpert

Hi,

you have to first create the jdbc driver by clicking add if you want to upload a non default jdbc driver:

 

 

Charlie_2-1597642087839.png

Then select the new driver (in my example jdbc3) and select the jar file you'd like to upload.

Charlie_3-1597642167765.png

 

 

 

 



View solution in original post

Contributor

Thanks a lot, Charlie. Solved.

My confusion was related to the steps indicated in the GitHub repository, and also I did not try alternative ways to solve it (my fault). Thanks for your help!

Hugo.

The steps that confused me are in https://github.com/exasol/virtual-schemas/blob/master/doc/dialects/sql_server.md

Now register the driver in EXAOperation:

  1. Click "Software"
  2. Switch to tab "JDBC Drivers"
  3. Click "Browse..."
  4. Select JDBC driver file
  5. Click "Upload" (suggest put this as Step 7)
  6. Click "Add" (suggest put this as Step 5)
  7. In a dialog "Add EXACluster JDBC driver" configure the JDBC driver