I'm using a set of JDBC statements to insert a record into a database(Access2000). I'm writing these statements in the scriptlet tag of a jsp page. The problem is, the JDBC statements written in the scriptlet tag are not getting executed at all. But when I write normal statements(such as out.println(..)), i have no problem. I have written the Class.forName(..) and getConnection(..) statements in the jspInit() method, which is kept in the declaration section. The scriptlet tag containg only the statements, which retrieve the encrypted data and insert it into a databse. Where could be the error? The same code(written in scriptlet tag) is working fine, when I write it as a servlet. I'm using JDK1.2.1 and JavaWebServer2.0. Can anybody please explain me with a simple example, using some set of JDBC statements(written in the scriptlet tag) to insert a record into a database.
Please reply asap, with a simple example. regds, Sandeep.