Creating datasource dirver

Question

I try to create a new data source using both Oracle and Microsoft Sql Server databases, but i don't know how to understand wich jdbc driver the server use and what i have to set the value for "driver".

For example i tried this for Sqlserver:

url:  jdbc:jtds:sqlserver://emanager3.galliera.it:1433/emanager

driver: net.sourceforge.jtds.jdbc.Driver

The Error in logs/knowage.out is :

[http-bio-8080-exec-4] 21 giu 2019 15:47:22,526 ERROR it.eng.spagobi.tools.datasource.service.rest.TestConnection.testDataSourceNew:200 - Error testing datasources
java.lang.ClassNotFoundException: net.sourceforge.jtds.jdbc.Driver

Sorry, but I'm not so friendly with java's proejcts...

Thanks

Answer 1

Hi,

first of all you need to copy the JDBC driver's jar file in the tomcat lib directory. Then you can make reference to this driver in your datasource. For example the JDBC Driver for SQL Server can be downloaded here: https://www.microsoft.com/en-us/download/details.aspx?id=57782 and the class name is com.microsoft.sqlserver.jdbc.SQLServerDriverand the url is something like: jdbc:sqlserver://localhost:1433;databaseName=AdventureWorks;user=MyUserName;password=*****

More info here: https://docs.microsoft.com/it-it/sql/connect/jdbc/using-the-jdbc-driver?view=sql-server-2017

Regards.

Comments

Thank you very much!

Reading better documentation I found this solution!