Sqljdbc jar in classpath

Asked Apr 01 '17 at 06:49

Active Apr 01 '17 at 06:53

Viewed 721 times

Can anybody guide me how to run a maven project jar along with sqljdbc jar in the classpath from the command prompt??

Im currently running the following command from command prompt :

java -cp streaming-etl-0.1.2-SNAPSHOT.jar:sqljdbc4.jar zDaly.pubsub.app.Application

I have main jar and sqljdbc4.jar in the same directory.

Running the above command is returning the below error :

Error: Could not find or load main class zDaly.pubsub.app.Application

zDaly.pubsub.app.Application is actually present in the main jar.

Running the same command without sqljdbc in classpath will actually run the jar successfully.

Below is the command which runs successfully:

java jar streaming-etl-0.1.2-SNAPSHOT.jar zDaly.pubsub.app.Application

Please someone help me out to run jar with sqljdbc jar. I also tried setting the sqljdbc path in CLASSPATH variable but no luck yet.

edited Apr 01 '17 at 06:53

asked Apr 01 '17 at 06:49

Girish kumar

Which operating system do you use? – Apr 01 '17 at 06:53
can you try this http://stackoverflow.com/questions/18413014/run-a-jar-file-from-the-command-line-and-specify-classpath – Praveen Kumar Apr 01 '17 at 07:07
I use windows and ubuntu. Its not working under both OS – Girish kumar Apr 01 '17 at 07:14
The Microsoft SQL Server JDBC driver is now available from Maven central, so why not just include it in your POM? Also note that on Windows the jars need to be separated by a semi-colon, not a colon. – Mark Rotteveel Apr 01 '17 at 08:38

0 Answers0