hello, i want to connect to my db2 with jdbc.
PHP Code:
package jdbcdb2;
import java.sql.*;
import java.sql.Connection;
//import com.ibm.db2.jcc.*;
public class Main
{
public static void main(String[] args) throws Exception {
/*
DB2DataSource datasource = new DB2DataSource();
datasource.setServerName("localhost");
datasource.setUser("db2user");
datasource.setPassword("12345");
datasource.setDriverType(4); //Type 4 pure Java JDBC Driver
datasource.setPortNumber(50000);
datasource.setDatabaseName("TESTDB");
//Die Funktion getConnection() liefert ein Connection Objekt das die
//verbindung zur DB repräsentiert.
Connection con = datasource.getConnection();
Statement stmt = con.createStatement();
String query = ("SELECT * FROM TEST_TABELLE");
ResultSet rs ;
con.close();
*/
// 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", "Start123");
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;
}
}
}
but i becom an error
PHP Code:
run:
JDBC/SQL error: com.ibm.db2.jcc.am.io: DB2 SQL Error: SQLCODE=-104, SQLSTATE=42601, SQLERRMC='auto';SELECT * FROM ;<table_ref_list>, DRIVER=3.57.82
BUILD SUCCESSFUL (total time: 2 seconds)
anybody knows this error?
dBforums
>
connect with jdbc to db2
11-04-10, 05:47
Linear Mode
