Java SqlServer 2k5 Coonnection Error

Question

This is my Code:

public static void addRecord(String name, int index) throws IllegalAccessException, InstantiationException, SQLException, ClassNotFoundException {
  //  Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver").newInstance();

    String dbURL = "jdbc:sqlserver://localhost\\sqlexpress";
    String user = "sa";
    String pass = "mypass";
    Connection conn = DriverManager.getConnection(dbURL, user, pass);
    PreparedStatement Prep = conn.prepareStatement("insert into tblAll(AdSoyad,SiraNo) values(?,?);");
    Prep.setString(2, name);
    Prep.setInt(3, index);
    Prep.execute();
    Prep.close();
    Prep = null;
    conn.close();
    conn = null;
}

The following is the error i am getting:

Exception in thread "main" com.microsoft.sqlserver.jdbc.SQLServerException: The index 3 is out of range.
    at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(SQLServerException.java:171)
    at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.setterGetParam(SQLServerPreparedStatement.java:700)
    at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.setValue(SQLServerPreparedStatement.java:709)
    at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.setInt(SQLServerPreparedStatement.java:870)
    at jmssql.JMsSQL.addRecord(JMsSQL.java:29)
    at jmssql.JMsSQL.main(JMsSQL.java:19)

if i add dbUrl "integratedSecurity=true;" part;

error is that;

com.microsoft.sqlserver.jdbc.AuthenticationJNI <clinit>
WARNING: Failed to load the sqljdbc_auth.dll cause :- no sqljdbc_auth in java.library.path

i could not find any idea fix it, how can i fix it?

SpringLearner · Accepted Answer · 2013-09-05 06:42:26Z

1

Error is in this line

 PreparedStatement Prep = conn.prepareStatement("insert into tblAll(AdSoyad,SiraNo) values(?,?);");
Prep.setString(2, name);
    Prep.setInt(3, index);

change to

PreparedStatement Prep = conn.prepareStatement("insert into tblAll(AdSoyad,SiraNo) values(?,?);");
    Prep.setString(1, name);
    Prep.setInt(2, index);

answered Sep 5, 2013 at 6:42

SpringLearner

13.9k20 gold badges82 silver badges117 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

oneProgrammer Over a year ago

Thanks for helping, i've changed my code as u tell and add "databaseName=myDB;" to dbUrl. Then i fix it, thanx dude.

Collectives™ on Stack Overflow

Java SqlServer 2k5 Coonnection Error

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related