prepared statements are not inserted i am new to JDBC and trying following code. Could not find the error in it 

try{     
        Connection con = ConnectionProvider.getCon();
        stmt=con.prepareStatement("insert into create_request values((select count(reqno) from create_request)+1,?,?,?,?,?");
        stmt.setString(1,obj_Leaverequest.getUser_name());
        stmt.setString(2,obj_Leaverequest.getLeave_Type());
        stmt.setInt(3,obj_Leaverequest.getLeave_Units());
        stmt.setString(4,obj_Leaverequest.getLeave_Reason());
        stmt.setString(5,"pending");
        count=stmt.executeUpdate();
        if(count&gt;0){
            status=true;
        }
    }


Getters are working fine, i could print their values . i guess i am wrong with the query.Please point out my mistake. Thanks in advance!!
I guess you have forgotten a ')'.

try this: 

stmt=con.prepareStatement("insert into create_request values((select count(reqno) from create_request)+1),?,?,?,?,?");