🚀 go-pugleaf

Dear Guys;

I just begin in the role of DB2 and IBM VAJ Programmer. I have 3 questions
about the DB2 implementation with IBM VAJA4.0EE

(1) These are the same problems but the different output when I created a
new project in VAJ4.0EE and also imported some package below:

(1.1)
imported package COM.ibm.db2.jdbc.app into my project, it was successed ;
however, I also got any 3 errors.
These are errors that found in All Problems TAB in IBM VAJA4.
DB2Constants                     ;Superclass
COM.ibm.db2.jdbc.DB2BaseConstants is missing
EJSTADB2Connection          ;Field type
com.ibm.db2.jdbc.app.stdext.udb.DB2PooledConnection is missing
SQLExceptionGenerator       ;Field type COM.ibm.db2.mri.DB2Messages is
missing

(1.2)
imported package COM.ibm.db2.jdbc
DB2Trace                            ;(1 of 3 field type) Field type
COM.ibm.db2.jdbc.net.DB2socket is missing

(1.3)
imported package COM.ibm.db2.sqlj
DB2SQLJInstaller                  ;Superclass
sqlj.runtime.profile.util.DataCustomizer  is missing
DB2SQLJProfilePrinter           ;Superclass
sqlj.runtime.profile.util.ProfilePrinter is missing

I try to setup DB2 again and also create a new project but I have got a same
errors. Which one are missing or DB2 package is missing?


(2) These are my JAVA code;

import java.sql.*;
import java.math.BigDecimal;
public class testJDBC {

    public static void main(String[] args) throws java.sql.SQLException {
         System.out.println("TEST................................");
         try{
             Class.forName("COM.ibm.db2.jdbc.app.DB2Driver").newInstance();
         }catch(Exception e){ e.printStackTrace();
System.out.println("Something Errors!!!");}
         System.out.println("Class forName successful");
         Connection con =
DriverManager.getConnection("jdbc:DB2:sample","admin","password");
         System.out.println("OK");
         try{
              CallableStatement callStmt=con.prepareCall("CALL davesp");
              callStmt.execute();
         } catch(SQLException e){}
 }
}
These code,when I start this program, the debugger windows will open up and
show any errors
Void DB2Connection.connect(String,Properties,DB2Driver,int,boolean); --> and
in the source pane window will show "Source not available".
and more ...
What I'm did missing and how should I do for furthur step?

(3) I also did setup classpath both of Windows Environment and IBM VAJA in
        menu Options->Resources->Workspace Classpath ->c:\Program
Files\SQLLIB\Java\db2java.zip;c:\Program Files\SQLLIB\Java\sqlj.zip;
    Is it need to set or what should I do more ?

I though,these are easy code and I also did setup step by step as the DB2
manuals but I didn't known something missing. Everyone guys who know please
kindly let me know.

Regards,
Kobchai Niyomthum