Code:
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
Connection conn = DriverManager.getConnection("jdbc:microsoft:sqlserver://vasic\\msde:1433","sa","pass");
PreparedStatement ps = conn.prepareStatement("SELECT * FROM log");
ResultSet rs = ps.executeQuery();
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
Connection conn = DriverManager.getConnection("jdbc:microsoft:sqlserver://vasic\\msde:1433","sa","pass");
PreparedStatement ps = conn.prepareStatement("SELECT * FROM log");
ResultSet rs = ps.executeQuery();
kada treba da se izvrsi query tj. na dijelu "ResultSet rs = ps.executeQuery();" izbaci mi sledecu gresku:
"java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]Invalid object name 'log'."
"log" je tabela u bazi
Koristio sam "Microsoft SQL Server 2000 Driver for JDBC" i "MSDE server".