SQL Server on Solaris

CloverDX Platform
1

Has anyone used Clover to connect to SQL Server from a UNIX box? I am trying to use Microsoft’s JDBC driver but I keep getting errors.

Here is my config file:
dbDriver=com.microsoft.jdbc.sqlserver.SQLServerDriver
dbURL=jdbc:microsoft:sqlserver://#######:1433
user= ****
password=****
defaultRowPrefetch=10

I am just trying to analyze the metadata:
java -cp cloverETL.rel-1-1-5 org.jetel.database.AnalyzeDB -config cloverETL.rel-1-1-5/cloverExamples.rel-1-1-3/db/sqlserver.cfg -q “select * from tbl#####”

Here is the error I am getting:
[Error] Can’t load DB driver :com.microsoft.jdbc.sqlserver.SQLServerDriver

Here is my CLASSPATH:
:/home/####/msSQLjdbc/lib/mssqlserver.jar:/home/####/msSQLjdbc/lib/msbase.jar::/home/####/msSQLjdbc/lib/msutil.jar:.

This is my first attempt at Clover, so bear with me.

Any help is appreciated.

Thanks!

2

The problem is your classpath settings are overriden by -cp argument (see manual page for java). Either add all jar files to CLASSPATH, or set them all on command line.

3

Hi !
I don’t have experience with MSSQL JDBC driver, but the error message leads me following speculation:

It looks like Java can’t find the class specified as dbDriver in your classpath. You may try to put the section you described as your classpath directly to “-cp” option of java command.

Also try to look inside the jars that the class is present somewhere.

One more question - are you sure that the Microsoft JDBC driver is pure Java ? It may depend on some Windows specific dll which is probably not present on Solaris.
There should be free implementation of the protocol MS SQL and Sybase DBs use to communicate between server and client.
Have a look at http://jtds.sourceforge.net/