java.sql.SQLException: Collection 770 has no default item READ policies

Sakai JIRA | Claudia Jürgen | 4 years ago
tip
Click on the to mark the solution that helps you, Samebug will learn from it.
As a community member, you’ll be rewarded for you help.
  1. 0

    At the moment it is possible to delete the collection policies: - default_item_read - default_bitstream_read From these the policies of the item are derived during submission. If they are missing, they are not treated as if restricted but lead to an internal system error see below. Either we should make these undeletable similar to the admin group or change the behaviour. ERROR org.dspace.submit.step.CompleteStep @ Caught exception in submission step: java.sql.SQLException: Collection 770 has no default item READ policies at org.dspace.content.Item.inheritCollectionDefaultPolicies(Item.java:2180) at org.dspace.content.InstallItem.installItem(InstallItem.java:167) at org.dspace.content.InstallItem.installItem(InstallItem.java:71) at org.dspace.workflow.WorkflowManager.archive(WorkflowManager.java:660) at org.dspace.workflow.WorkflowManager.doState(WorkflowManager.java:614) at org.dspace.workflow.WorkflowManager.doState(WorkflowManager.java:590) at org.dspace.workflow.WorkflowManager.doState(WorkflowManager.java:554) at org.dspace.workflow.WorkflowManager.doState(WorkflowManager.java:514) at org.dspace.workflow.WorkflowManager.start(WorkflowManager.java:199) at org.dspace.submit.step.CompleteStep.doProcessing(CompleteStep.java:116) at org.dspace.app.webui.submit.JSPStepManager.doStepStart(JSPStepManager.java:331) at org.dspace.app.webui.submit.JSPStepManager.processStep(JSPStepManager.java:278) at org.dspace.app.webui.servlet.SubmissionController.doStep(SubmissionController.java:408) at org.dspace.app.webui.servlet.SubmissionController.doNextStep(SubmissionController.java:478) at org.dspace.app.webui.servlet.SubmissionController.doStep(SubmissionController.java:424) at org.dspace.app.webui.servlet.SubmissionController.doDSPost(SubmissionController.java:344) at org.dspace.app.webui.servlet.DSpaceServlet.processRequest(DSpaceServlet.java:147) at org.dspace.app.webui.servlet.DSpaceServlet.doPost(DSpaceServlet.java:105) at javax.servlet.http.HttpServlet.service(HttpServlet.java:637) at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.dspace.app.webui.filter.RegisteredOnlyFilter.doFilter(RegisteredOnlyFilter.java:98) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.dspace.utils.servlet.DSpaceWebappServletFilter.doFilter(DSpaceWebappServletFilter.java:112) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:525) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293) at org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:190) at org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:291) at org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:769) at org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:698) at org.apache.jk.common.ChannelSocket$SocketConnection.runIt(ChannelSocket.java:891) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:690) at java.lang.Thread.run(Thread.java:619)

    Sakai JIRA | 4 years ago | Claudia Jürgen
    java.sql.SQLException: Collection 770 has no default item READ policies
  2. 0

    At the moment it is possible to delete the collection policies: - default_item_read - default_bitstream_read From these the policies of the item are derived during submission. If they are missing, they are not treated as if restricted but lead to an internal system error see below. Either we should make these undeletable similar to the admin group or change the behaviour. ERROR org.dspace.submit.step.CompleteStep @ Caught exception in submission step: java.sql.SQLException: Collection 770 has no default item READ policies at org.dspace.content.Item.inheritCollectionDefaultPolicies(Item.java:2180) at org.dspace.content.InstallItem.installItem(InstallItem.java:167) at org.dspace.content.InstallItem.installItem(InstallItem.java:71) at org.dspace.workflow.WorkflowManager.archive(WorkflowManager.java:660) at org.dspace.workflow.WorkflowManager.doState(WorkflowManager.java:614) at org.dspace.workflow.WorkflowManager.doState(WorkflowManager.java:590) at org.dspace.workflow.WorkflowManager.doState(WorkflowManager.java:554) at org.dspace.workflow.WorkflowManager.doState(WorkflowManager.java:514) at org.dspace.workflow.WorkflowManager.start(WorkflowManager.java:199) at org.dspace.submit.step.CompleteStep.doProcessing(CompleteStep.java:116) at org.dspace.app.webui.submit.JSPStepManager.doStepStart(JSPStepManager.java:331) at org.dspace.app.webui.submit.JSPStepManager.processStep(JSPStepManager.java:278) at org.dspace.app.webui.servlet.SubmissionController.doStep(SubmissionController.java:408) at org.dspace.app.webui.servlet.SubmissionController.doNextStep(SubmissionController.java:478) at org.dspace.app.webui.servlet.SubmissionController.doStep(SubmissionController.java:424) at org.dspace.app.webui.servlet.SubmissionController.doDSPost(SubmissionController.java:344) at org.dspace.app.webui.servlet.DSpaceServlet.processRequest(DSpaceServlet.java:147) at org.dspace.app.webui.servlet.DSpaceServlet.doPost(DSpaceServlet.java:105) at javax.servlet.http.HttpServlet.service(HttpServlet.java:637) at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.dspace.app.webui.filter.RegisteredOnlyFilter.doFilter(RegisteredOnlyFilter.java:98) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.dspace.utils.servlet.DSpaceWebappServletFilter.doFilter(DSpaceWebappServletFilter.java:112) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:525) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293) at org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:190) at org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:291) at org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:769) at org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:698) at org.apache.jk.common.ChannelSocket$SocketConnection.runIt(ChannelSocket.java:891) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:690) at java.lang.Thread.run(Thread.java:619)

    Sakai JIRA | 4 years ago | Claudia Jürgen
    java.sql.SQLException: Collection 770 has no default item READ policies
  3. 0

    java.sql.SQLException: No value specified for parameter 1解决办法_IT知识问答_希赛网

    educity.cn | 2 years ago
    java.sql.SQLException: No value specified for parameter 1 代码如下 public boolean login(UserInfo user)throws Exception{ //用户登录 boolean flag=false; int userNo=Integer.parseInt(user.getUserNo()); String password=user.getPassword(); //测试是否从现在的user对象中取到了值 System.out.println(userNo+"我是USER对象的userNo"); System.out.println(password+"我是USER对象的password"); DatabaseConnection dbc=new DatabaseConnection();//取得数据库连接和关闭对象; try{ String sql="SELECT userNo FROM userInfo where userNo= and password= "; this.conn=dbc.getConnection(); this.pst=conn.prepareStatement(sql); //this.pst.setInt(1, userNo);//给sql中参数赋值 this.pst.setLong(1, userNo); this.pst.setString(2, password); ResultSet rs=pst.executeQuery(); if(rs.next()){//传入用户账号和对应的密码都存在时为真 flag=true; System.out.println(rs.getString(userNo)+"我是从数据库里取出来的"); System.out.print(flag+"测试flag");//测试flag,看是否进入了if里面,true则进入了 rs.close(); } }catch(Exception e){ e.printStackTrace(); }finally{ if(this.pst!=null){ this.pst.close(); } this.conn.close(); } return flag; } 报的错误信息如:
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    java.sql.SQLException: No suitable driver - Toolbox for IT Groups

    ittoolbox.com | 8 months ago
    java.sql.SQLException: No suitable driver at java.sql.DriverManager.getConnection(DriverManager .java:545) at java.sql.DriverManager.getConnection(DriverManager .java:171) at com.stc.sql.framework.jdbc.DBConnectionFactory.cre ateConnection(DBConnectionFactory.java:372) at com.stc.sql.framework.jdbc.DBConnectionFactory.get Connection(DBConnectionFactory.java:281) at com.stc.etl.engine.impl.SimpleTask.getConnection(S impleTask.java:254) at com.stc.etl.engine.impl.Extractor.getSelectData(Ex tractor.java:376) at com.stc.etl.engine.impl.Extractor.process(Extracto r.java:190) at com.stc.etl.engine.impl.ETLTaskThread.run(ETLTaskT hread.java:147)
  6. 0

    1 more error - Java Programming Help - KnowCoding.com

    knowcoding.com | 2 years ago
    java.sql.SQLException: Protocol violation at oracle.jdbc.dbaccess.DBError.throwSqlException(DBE rror.java:134) at oracle.jdbc.dbaccess.DBError.throwSqlException(DBE rror.java:179) at oracle.jdbc.dbaccess.DBError.check_error(DBError.j ava:1160) at oracle.jdbc.ttc7.Ocommoncall.receive(Ocommoncall.j ava:149) at oracle.jdbc.ttc7.TTC7Protocol.rollback(TTC7Protoco l.java:488) at oracle.jdbc.driver.OracleConnection.rollback(Oracl eConnection.java:1412) at net.sf.hibernate.transaction.JDBCTransaction.rollb ack(JDBCTransaction.java:86) at com.azure.spark.database.hibernate.util.HibernateU til.doSessionWork(HibernateUtil.java:90) at com.azure.spark.database.hibernate.util.HibernateU til.doSessionWork(HibernateUtil.java:59) at com.azure.spark.database.hibernate.util.HibernateU til.get(HibernateUtil.java:569) at com.azure.spark.database.hibernate.util.HibernateS ession.get(HibernateSession.java:340) at com.azure.spark.taskcontroller.TaskControllerCompo nent.taskCompleted(TaskControllerComponent.java:11 54) at com.azure.spark.taskcontroller.TaskControllerCompo nent.onTaskEvent(TaskControllerComponent.java:1111 ) at com.azure.spark.taskcontroller.tasks.AbstractTaskC omponent.run(AbstractTaskComponent.java:354)

    Not finding the right solution?
    Take a tour to get the most out of Samebug.

    Tired of useless tips?

    Automated exception search integrated into your IDE

    Root Cause Analysis

    1. java.sql.SQLException

      Collection 770 has no default item READ policies

      at org.dspace.content.Item.inheritCollectionDefaultPolicies()
    2. DSpace Kernel :: API and Implementation
      CompleteStep.doProcessing
      1. org.dspace.content.Item.inheritCollectionDefaultPolicies(Item.java:2180)
      2. org.dspace.content.InstallItem.installItem(InstallItem.java:167)
      3. org.dspace.content.InstallItem.installItem(InstallItem.java:71)
      4. org.dspace.workflow.WorkflowManager.archive(WorkflowManager.java:660)
      5. org.dspace.workflow.WorkflowManager.doState(WorkflowManager.java:614)
      6. org.dspace.workflow.WorkflowManager.doState(WorkflowManager.java:590)
      7. org.dspace.workflow.WorkflowManager.doState(WorkflowManager.java:554)
      8. org.dspace.workflow.WorkflowManager.doState(WorkflowManager.java:514)
      9. org.dspace.workflow.WorkflowManager.start(WorkflowManager.java:199)
      10. org.dspace.submit.step.CompleteStep.doProcessing(CompleteStep.java:116)
      10 frames
    3. org.dspace.app
      DSpaceServlet.doPost
      1. org.dspace.app.webui.submit.JSPStepManager.doStepStart(JSPStepManager.java:331)
      2. org.dspace.app.webui.submit.JSPStepManager.processStep(JSPStepManager.java:278)
      3. org.dspace.app.webui.servlet.SubmissionController.doStep(SubmissionController.java:408)
      4. org.dspace.app.webui.servlet.SubmissionController.doNextStep(SubmissionController.java:478)
      5. org.dspace.app.webui.servlet.SubmissionController.doStep(SubmissionController.java:424)
      6. org.dspace.app.webui.servlet.SubmissionController.doDSPost(SubmissionController.java:344)
      7. org.dspace.app.webui.servlet.DSpaceServlet.processRequest(DSpaceServlet.java:147)
      8. org.dspace.app.webui.servlet.DSpaceServlet.doPost(DSpaceServlet.java:105)
      8 frames
    4. JavaServlet
      HttpServlet.service
      1. javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
      2. javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
      2 frames
    5. Glassfish Core
      ApplicationFilterChain.doFilter
      1. org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
      2. org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
      2 frames
    6. org.dspace.app
      RegisteredOnlyFilter.doFilter
      1. org.dspace.app.webui.filter.RegisteredOnlyFilter.doFilter(RegisteredOnlyFilter.java:98)
      1 frame
    7. Glassfish Core
      ApplicationFilterChain.doFilter
      1. org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
      2. org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
      2 frames
    8. DSpace Services Framework :: API and Implementation
      DSpaceWebappServletFilter.doFilter
      1. org.dspace.utils.servlet.DSpaceWebappServletFilter.doFilter(DSpaceWebappServletFilter.java:112)
      1 frame
    9. Glassfish Core
      CoyoteAdapter.service
      1. org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
      2. org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
      3. org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
      4. org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
      5. org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:525)
      6. org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
      7. org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
      8. org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
      9. org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)
      9 frames
    10. Embedded GlassFish Web
      ChannelSocket$SocketConnection.runIt
      1. org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:190)
      2. org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:291)
      3. org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:769)
      4. org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:698)
      5. org.apache.jk.common.ChannelSocket$SocketConnection.runIt(ChannelSocket.java:891)
      5 frames
    11. Tomcat Util
      ThreadPool$ControlRunnable.run
      1. org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:690)
      1 frame
    12. Java RT
      Thread.run
      1. java.lang.Thread.run(Thread.java:619)
      1 frame