Auf Thema antworten

Hallo, hab jetzt diesen code zusammenbebaut:


package jdbcdb2;

 

 

import java.sql.*;

import java.sql.Connection;

import com.ibm.db2.jcc.*;

 

 

[code=Java]public class Main

        {

    public static void main(String[] args) throws Exception {


   

        */

        // JDBC-Treiber laden

try {


    /*

Class.forName("com.ibm.db2.jdbc.net.DB2Driver");

} catch (ClassNotFoundException exc) {

System.err.println("Could not load DB2Driver:" + exc.toString());

System.exit(1);

}

*/


      Class.forName("com.ibm.db2.jcc.DB2Driver");

        } catch(java.lang.ClassNotFoundException e) {

            System.err.print("ClassNotFoundException: ");

            System.err.println(e.getMessage());

        }


// Verbindung zur Datenbank herstellen


try {

String url = "jdbc:db2://localhost:50000/TESTDB";

Connection con = null;

con = DriverManager.getConnection(url, "db2user", "12345");



Statement stmt = con.createStatement();

String query = ("SELECT * FROM auto");

ResultSet rs = stmt.executeQuery(query);


while ( rs.next() )

        System.out.printf( rs.getString(1));

                           //rs.getString(2), rs.getString(3) );





rs.close();

stmt.close();

con.close();



} catch (SQLException exc) {

System.out.println("JDBC/SQL error: " + exc.toString());

return;




}

    }

}

[/code]


bekomme aber diese Fehlermeldung:

run:

JDBC/SQL error: com.ibm.db2.jcc.am.io: DB2 SQL Error: SQLCODE=-204, SQLSTATE=42704, SQLERRMC=DB2USER.AUTO, DRIVER=3.57.82

BUILD SUCCESSFUL (total time: 2 seconds)


Kann mir einer das erklären? user ist angelegt, richtiges kennwort, richtige tabelle richtige rechte...

verstehe wer will..



Oben