Ziskani dat z MS SQL SERVERU – Java – Fórum – Programujte.com

Zdravim,
mam jednoduchy programek, pomoci ktereho nacitam data z MS SQL Serveru. Kdyz ho spustim, tak mi to vyhodi tuhle chybu (viz. nize). nekdo co s tim???

Za radu predem diky


Exception in thread "main" java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]Invalid object name 'osoba'.
at com.microsoft.jdbc.base.BaseExceptions.createException(Unknown Source)
at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source)
at com.microsoft.jdbc.sqlserver.tds.TDSRequest.processErrorToken(Unknown Source)
at com.microsoft.jdbc.sqlserver.tds.TDSRequest.processReplyToken(Unknown Source)
at com.microsoft.jdbc.sqlserver.tds.TDSExecuteRequest.processReplyToken(Unknown Source)
at com.microsoft.jdbc.sqlserver.tds.TDSRequest.processReply(Unknown Source)
at com.microsoft.jdbc.sqlserver.SQLServerImplStatement.getNextResultType(Unknown Source)
at com.microsoft.jdbc.base.BaseStatement.commonTransitionToState(Unknown Source)
at com.microsoft.jdbc.base.BaseStatement.postImplExecute(Unknown Source)
at com.microsoft.jdbc.base.BaseStatement.commonExecute(Unknown Source)
at com.microsoft.jdbc.base.BaseStatement.executeQueryInternal(Unknown Source)
at com.microsoft.jdbc.base.BaseStatement.executeQuery(Unknown Source)
at Test.main(Test.java:23)


Zdrojak programu je:

import java.sql.*;
import javax.sql.*;


public class Test {


public static void main (String[]arg) throws ClassNotFoundException, SQLException {
Statement pozadavek;
ResultSet vysledek;

Connection dB1; // dB odkaz na spojeni s DB

Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");

dB1 = DriverManager.getConnection ("jdbc:microsoft:sqlserver://MACHIS:1433;User=tomas;Password=tomas");


String dotaz= ("SELECT jmeno FROM osoba WHERE id= '1'");

pozadavek = dB1.createStatement();

vysledek = pozadavek.executeQuery(dotaz);

vysledek.close();
dB1.close();

boolean zaznam= vysledek.next();
if(!zaznam){
System.out.println("xxx");
return;
}
else{
do{
String jmeno = vysledek.getString("jmeno");
System.out.println("jmeno je _:"+ jmeno);
}while(vysledek.next());
}


}
}

ASi mas v mysql databazi nastaveny pristup jen z localhostu :)