hello


i have a jsp form, from that i have insert my data to the database, and also the insert values shows on the other jsp file.

i have used jdbc for that.

My problem is that when i made the dulicate entry for the partocular on field value, it doesnot shows error on jsp file.

The error is shown in tomcat server, but not in any file.

i have also made that paticulay field not null.

my sql table is as follows:

Name Null? Type
----------------------------------------- -------- -------------
GL_CODE NOT NULL NUMBER(4)
GL_DESCR NOT NULL VARCHAR2(80)
DB_AMT NUMBER(15,2)
CR_AMT NUMBER(15,2)
GL_TYPE VARCHAR2(2)
GL_PCT NUMBER(4,2)

plz help me..

plz provide me query for that..

thanx