Hello,I am a fresh man to study the DB2.An error occured when I try t
Run a Java class.

Details of the Error:

Code
-------------------
   
 com.ibm.db2.jcc.b.SqlException:DB2 SQL error:SQLCODE:-204,SQLSTATE:42704, SQLERRMC :DB2ADMIN.TEST

-------------------

Following is the source:

Code
-------------------
   
 /*
 * JDB2.java
 *
 * Created on 2006
 *
 * To change this template, choose Tools | Template Manager
 * and open the template in the editor.
 */
 
 /**
 *
 * @author Administrator
 */
 import java.sql.*;
 public class JDB2{
 //Create the main method
 public static void main(String args[]){
 //Load JDBC Driver
 String Driver="com.ibm.db2.jcc.DB2Driver";
 //Create the URL
 String Url="jdbc:db2://localhost:50000/BD";
 //Use the Class.forName
 try{
 Class.forName(Driver).newInstance();
 }catch (Exception e){
 System.out.println(e);
 }
 //Create Connection
 System.out.println("Conneting...");
 try{
 Connection conn=DriverManager.getConnection(Url,"db2admin","830401");
 
 Statement stmt=conn.createStatement();
 ResultSet rs=stmt.executeQuery("select * from test");
 while(rs.next()) {
 int ID=rs.getInt("id");
 String NAME=rs.getString("name");
 System.out.println("ID"+"\t\t"+"NAME");
 System.out.println(ID+"\t\t"+NAME);
 }
 }catch(SQLException sqle){
 System.err.println(sqle);
 }
 
 }
 }
 

-------------------

--
TurboDis