Hi Cem,
At first sight it seems to me that you work with the ResultSet properly,
but you do not need to load the database driver class each time the servlet
is called. Put the foloowing code:
try {
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
} catch(java.lang.ClassNotFoundException e) {
System.err.print("ClassNotFoundException: ");
System.err.println(e.getMessage());
}
in servlet's init() method.
In order to speed up the servlet may be you shold use connection pooling.
Regards,
Roussi
-----Original Message-----
From: Cem Vardar [mailto:[EMAIL PROTECTED]]
Sent: Friday, April 28, 2000 10:37 AM
To: [EMAIL PROTECTED]
Subject: Re: Access 97, servlet, illegal operation
hi again, thanks for responses,
My code is below. It works correctly for two or three times when i start the server but then the server closes it self.
Cem
.....
