data connection problem

[Pat Johnson]

Before you say it, I've searched all over for a solution to my problem and I cannot get it resolved.

Platform: Windows 7 64 bit
Problem: Cannot connect to sqlserver database
Knowledge Level: Novice

Background of problem:

I'm writing an application that I want to connected to a sql server data source. I've created a DSN called "pawnDataSource" that uses Windows Authentication and a named instance, but I cannot connect to it. I've read that you need using sql server authentication should solve some problems, but cannot get this type of connection to work (although these are created in the named instance of sqlserver). Since I was getting errors with that connection string in my code, I decided to just use the named instance sqlserver (in this case TOUWORKSTATION) instead of a DSN.

Admittedly, I am relatively new to Java programming (and programming in general), so please go easy on me.

I am now getting the following error when I get to the data access part of my program:

java.sql.SQLException: I/O Error: SSO Failed: Native SSPI library not loaded. Check the java.library.path system property.

Here is the code causing the error:

super class that contains the connection string, etc.

/**
 *
 * @author ME
 */

public class Dao {
    //set up needed strings for database connection that all Data Access Objects (Daos)
    //will use
    private final String SERVER_NAME = "TOUWORKSTATION;";
    private final String UN_PW = "user=;password=";
    //protected strings are accessible to subclasses
    //string to load the driver (Class.forName())
    protected final String DRIVER = "net.sourceforge.jtds.jdbc.Driver";
    protected final String CONNECTION_STRING = "jdbc:jtds:sqlserver://" + SERVER_NAME + UN_PW;
}

subclass that extends the superclass:

import pointofsales.User;
import java.sql.*;

public class UserDao extends Dao {

    private PreparedStatement selectUser;

    public UserDao(){
    }

    public boolean validateUser(String un, String pw) {

        Connection con = null;
        Statement sql = null;
        ResultSet rs = null;
        boolean isValidUser = false;

        try {
            Class.forName(DRIVER);
            System.out.print("success");
            con = DriverManager.getConnection(CONNECTION_STRING, "", "");
            selectUser.setString(1, un);
            selectUser.setString(2, pw);

            //prepare the statement
            selectUser = con.prepareStatement("Select Top 1 * From Users Where Username=? AND Password=?");

            //execute the query
            rs = selectUser.executeQuery();

            if(rs != null){
                isValidUser = true;
            }     
        } catch (Exception e) {
            System.out.println("Error: " + e);
        } finally {
            // Try and close the statement
            if (sql != null) {
                try {
                    sql.close(); // close the Connection to let the database know we're done with it
                } catch (Exception e) {
                    //Print exception
                    System.out.println("Error: " + e);
                }
            }
            // Try and close the connection
            if (con != null) {
                try {
                    con.close(); // close the Connection to let the database know we're done with it
                } catch (Exception e) {
                    System.out.println("Error: " + e);
                }//end try/catch
            }//end if con != null
        }//end finally
        return isValidUser;
    }

Any help or suggestions would be greatly appreciated and thanks in advance!

[Rob Spoor]

1) Moving to the JDBC forum, since that's where we handle database problems.

2) You are providing an empty user name and password. Apparently that makes the driver try to use your Windows login, but for that it needs a DLL (sqljdbc_auth.dll for the SQL Server 2005 driver; it's inside the sqljdbc executable from Microsoft's website) to be on Java's library path. Either do that, or get rid of UN_PW and supply the user name and password in the call to DriverManager.getConnectionString.