GeeCON Prague 2014*
The moose likes JDBC and the fly likes JDBC connection from Eclipse to MSSQL server using sqljdbc4.jar Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


JavaRanch » Java Forums » Databases » JDBC
Bookmark "JDBC connection from Eclipse to MSSQL server using sqljdbc4.jar" Watch "JDBC connection from Eclipse to MSSQL server using sqljdbc4.jar" New topic
Author

JDBC connection from Eclipse to MSSQL server using sqljdbc4.jar

Saikrishnan Srivatsan
Ranch Hand

Joined: Sep 20, 2013
Posts: 58
Hello all,

I am trying to make a jdbc connection to MS SQL server 2014 using sqljdbc4 from an Eclipse Web project,
without any luck whatsoever.

Here is what I have tried so far:
  • 1. Create a test class outside of the Web project, add jar to classpath and try to make a connection - success
  • 2. Place jar under project's WEB-INF/lib, add jar to classpath with and without adding a Web App Library
    for the project and try to make a connection - failure
  • 3. Place jar under the central Tomcat lib and try to make a connection - failure


  • Most of the forums have users who have succeeded by doing number 2. I am just starting out with JDBC and it took a
    while to figure out to get to this stage.
    But unfortunately, couldn't get any further. I am stuck at this point for close to 5 hours now and the frustrating thing is
    it works every time from a regular java project.
    Why is that so, when any kind of project in an IDE requires the jar to be in its classpath?

    Not sure how much help this will be of, but here is the code that I had come up with that tries to establish the connection.
    And it always leads to an SQLException : No suitable driver found for jdbc:sqlserver on the first line after 'try'.


    Kindly review and help.
    K. Tsang
    Bartender

    Joined: Sep 13, 2007
    Posts: 2452
        
        8

    Looking at your connection string, I'm a bit suspicious how your test app (outside web) works. You seem to be missing the database port.




    K. Tsang JavaRanch SCJP5 SCJD/OCM-JD OCPJP7 OCPWCD5 OCPBCD5
    Saikrishnan Srivatsan
    Ranch Hand

    Joined: Sep 20, 2013
    Posts: 58
    SQL server is the only application running on that host name. The database client I use to connect also connects to that host. That is probably why.

    On an independent note, I have managed to get this working using Connection pool but still would be interested to know why the regular jdbc connection wouldn't work.
     
    GeeCON Prague 2014
     
    subject: JDBC connection from Eclipse to MSSQL server using sqljdbc4.jar