Java i MS SQL Server komunikacija
21.08.2003. u 20:45 · pre 282 meseci
#1
Kako uspostaviti vezu izmedju Java aplikacije i MS SQL Servera?
U ovom primeru koji sam radio uvek prijavljuje istu gresku.
java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]Login failed for user 'zoran'. Reason: Not associated with a trusted SQL Server connection.
Da li neko moze da mi pomogne u cemu gresim. Nemam bas iskustva u radu sa SQL Serverom.
import java.sql.*;
public class Demo1 {
public static void main(String[] args) {
try{
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
Connection conn=DriverManager.getConnection(
"jdbc:microsoft:sqlserver://localhost:1433;User=zoran");
String query="SELECT ime,prezime FROM MojaTabela";
Statement stmt=conn.createStatement();
ResultSet rset=stmt.executeQuery(query);
while(rset.next()){
System.out.println(rset.getString(1)+" "+
rset.getString(2));
}
rset.close();
stmt.close();
conn.close();
}
catch (Exception ex){
ex.printStackTrace();
}
}
}
U ovom primeru koji sam radio uvek prijavljuje istu gresku.
java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]Login failed for user 'zoran'. Reason: Not associated with a trusted SQL Server connection.
Da li neko moze da mi pomogne u cemu gresim. Nemam bas iskustva u radu sa SQL Serverom.
import java.sql.*;
public class Demo1 {
public static void main(String[] args) {
try{
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
Connection conn=DriverManager.getConnection(
"jdbc:microsoft:sqlserver://localhost:1433;User=zoran");
String query="SELECT ime,prezime FROM MojaTabela";
Statement stmt=conn.createStatement();
ResultSet rset=stmt.executeQuery(query);
while(rset.next()){
System.out.println(rset.getString(1)+" "+
rset.getString(2));
}
rset.close();
stmt.close();
conn.close();
}
catch (Exception ex){
ex.printStackTrace();
}
}
}