Javaweb-the CannotCreateBean error is reported at the DAO layer using the DButils query statement... Query :...

# Error message: java. SQL. SQLException: CannotcreateBean. privilege: Bean. privilegeQuery: selectp. * fromprivilegep, privilege_roleprwherep.idpr.p_idandpr.r_id? Parameters: [007] atorg. apache. commons. dbutils. AbstractQueryRunner. rethrow (AbstractQ... javawebmysql

Error message:

Java. SQL. SQLException: Cannot create Bean. privilege: Bean. privilege Query: select p. * from privilege p, privilege_role pr where p. id = pr. p_id and pr. r_id =? Parameters: [007]
At org. apache. commons. dbutils. AbstractQueryRunner. rethrow (AbstractQueryRunner. java: 392)
At org. apache. commons. dbutils. QueryRunner. query (QueryRunner. java: 351)
At org. apache. commons. dbutils. QueryRunner. query (QueryRunner. java: 180)
At dao. privilegeDao. getRoleprivileges (privilegeDao. java: 80)
At service. BussinessService. getRolePrivileges (BussinessService. java: 89)
At servlet. showRolePriUIServlet. doPost (showRolePriUIServlet. java: 64)
At servlet. showRolePriUIServlet. doGet (showRolePriUIServlet. java: 46)
At javax. servlet. http. HttpServlet. service (HttpServlet. java: 624)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:731)at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)at filter.CharacterFilter.doFilter(CharacterFilter.java:28)at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)at filter.RoleFilter.doFilter(RoleFilter.java:50)at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:220)at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122)at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:505)at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:170)at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:957)at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:423)at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1079)at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:620)at org.apache.tomcat.util.net.AprEndpoint$SocketProcessor.doRun(AprEndpoint.java:2516)at org.apache.tomcat.util.net.AprEndpoint$SocketProcessor.run(AprEndpoint.java:2505)at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)at java.lang.Thread.run(Thread.java:619)

DAO query statement

    public List
   
     getRoleprivileges(String Rid){        try{            QueryRunner qr = new QueryRunner();            String sql = "select p.* from privilege p,privilege_role pr where p.id=pr.p_id and pr.r_id=? ";            return (List
    
     ) qr.query(JDBCUtils.getconnection(),sql,Rid,new BeanListHandler
     
      (privilege.class));        }        catch(Exception e){            e.printStackTrace();            throw new RuntimeException();        }    } 
     
    
   

PrivilegeBean