I have a problem with getDate() ?

[Elahe Shafie]

Dear Friends,
fixedDate is Date type how can I get this field is this correct?"fixedDate = rs.getDate(3);"

 
rs =stmt.executeQuery("select ID,bdesc,fixedDate from bugt ");
    int ID;
    String bdesc;
    Date fixedDate;
            
    while (rs.next()) {
    ID = rs.getInt(1);
    bdesc = rs.getString(2);
    fixedDate = rs.getDate(3);
....

[Corey McGlone]

Well, you might have a little more luch asking questions like this in the JDBC forum, but this looks fine to me. Are you having problems with this? As far as I can tell, the code you wrote should work.
If you're looking for more info on JDBC, check out this tutorial.
Hope that helps,
Corey

[Elahe Shafie]

So as you said it is correct I can ask my next question I want to read data from one trable to another and this time both table are EXACTLY the same do you have any idea why it is not working and gives me this error?
Many thanks,
Elahe
java.lang.NoClassDefFoundError: WEB-INF/classes/com/srs/bugtrack/Rdate (wrong name: com/srs/bugtrack/Rdate)
at java.lang.ClassLoader.defineClass0(Native Method)
at java.lang.ClassLoader.defineClass(ClassLoader.java:486)
...
Exception in thread "main"
---------------------

...
rs =stmt.executeQuery("select ID,bdesc,submittedDate,fixedDate,userID,contact,bugNumber from bugt ");
            int ID;
            int bugNumber;
            String bdesc;
            java.sql.Date submittedDate;
            java.sql.Date fixedDate;
            int userID;
            String contact;
            
            while (rs.next()) {
                ID = rs.getInt(1);
                bdesc = rs.getString(2);
                submittedDate = rs.getDate(3);
                fixedDate = rs.getDate(4);
                userID = rs.getInt(5);
                contact = rs.getString(6);
                bugNumber = rs.getInt(7);
                
                try {
                    PreparedStatement s =con.prepareStatement("insert into bug values (?,?,?,?,?,?,?)");
                    s.setInt(1,ID);
                    s.setString(2,bdesc);
                    s.setDate(3,submittedDate);
                    s.setDate(4,fixedDate);
                    s.setInt(5,userID);
                    s.setString(6,contact);
                    s.setInt(7,bugNumber);
                    s.executeUpdate();
                }
                catch( Exception x ) {
                }
            }
...