Hi Imran,
  I can surely tell that this exception is because you are trying to use a 
JDBC 2.0 feature which your driver doesn't support. You will have to get the 
latest driver (unfortunately I do not know from where).

  To confirm just try the no argument method of "createStatement". It should 
not throw the Unsupport....Excepiton.

Hope this helps.
cheers
Sachin Gurung.


>From: Imran Rauf <send2imran@u...>
>Reply-To: "Servlets" <servlets@p...>
>To: "Servlets" <servlets@p...>
>Subject: [servlets] error in my servlet code
>Date: 8 Dec 00 07:00:10 MST
>
>Hi to all
>
>I'm new in Enterprise Java. i wrote the following in doPost for testing
>purpose i am useing MS-Access:
>     try {
>       stmt= con.createStatement(ResultSet.TYPE_FORWARD_ONLY,
>                                 ResultSet.CONCUR_UPDATABLE); //Line#1
>       rs=stmt.executeQuery (sql);
>
>       //Check if record is already exist.
>       if(rs.next()) {
>         out.write ("<B>Sory, Userid you have requested is already 
>exist</B>");
>         rs.close ();
>         stmt.close ();
>       }
>       else {
>         //Insert record in table
>         //User defined Function  
>
>         if(insertRecord(stmt,rs, out,req))
>          out.write ("You r succesfully subscribe...");
>         else
>          out.write ("Sory there is some error in ourt site, please try 
>later.");
>
>       }
>     }catch(SQLException ex) {
>       out.write ("Errory.");
>       out.write (ex.getMessage ());
>     }catch(UnsupportedOperationException ex) {
>       out.write ("Unsuported exception.");
>       out.write (ex.getMessage ());
>     }
>   }
>
>I receive error UnsupportedOperationException due to line#1
>please help
>Imran
>