|
From: Ian B. <ie...@tf...> - 2003-10-27 17:57:53
|
Looks like we have an error in the SQL statement for moving a folder. I'll get someone to have a look at it here and see if we can reproduce the behaviour. Ian Leonardo Hernandez wrote: > > Hi, > > I've added some material to a course and created a folder, and when I > try to move one material to that folder, I'm prompted to select what > folder I want the material to be moved and then I get an "Error 500" > from tomcat server. Anyway, material es moved to the folder I select, > but I can't make this error dissappear. > It seems that for some reasons, the database connection resets. > Do you have any idea what can be causing this? > I copy some log at the end of this message. > > - Leonardo > > > ----------------------------------------------- > TOMCAT ERROR 500 LOG: > ----------------------------------------------- > java.lang.NullPointerException > at AdminCourseMaterials.doPost(AdminCourseMaterials.java:415) > at javax.servlet.http.HttpServlet.service(HttpServlet.java:760) > at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) > at > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:247) > > at > org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193) > > at > org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:256) > > at > org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643) > > at > org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480) > at > org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) > at > org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191) > > at > org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643) > > at > org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480) > at > org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) > at > org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2416) > at > org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180) > > at > org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643) > > at > org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:171) > > at > org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641) > > at > org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:172) > > at > org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641) > > at > org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480) > at > org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) > at > org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:174) > > at > org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643) > > at > org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480) > at > org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) > at > org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java:223) > at > org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:261) > at org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:360) > at org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:604) > at > org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:562) > > at org.apache.jk.common.SocketConnection.runIt(ChannelSocket.java:679) > at > org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:619) > > at java.lang.Thread.run(Thread.java:534) > ----------------------------------------------- > > > > > > > > ----------------------------------------------- > CATALINA.OUT: > ----------------------------------------------- > 27 Oct 2003 12:42:58,111 -- DEBUG [Thread-21] > (AdminCourseMaterials.java:153) - agree = yes > 27 Oct 2003 12:42:58,114 -- DEBUG [Thread-21] (CoreDTLObject.java:236) - > ***** admin_coursematerials_move = > /usr/local/tomcat/webapps/coursework/WEB-INF/dtl/coursematerials/admin/move.dtl > > 27 Oct 2003 12:42:58,155 -- DEBUG [Thread-21] > (CourseMaterialController.java:176) - setting sort to 9 > 27 Oct 2003 12:43:02,043 -- DEBUG [Thread-21] (CoreDTLObject.java:236) - > ***** admin_coursematerials_byfolder = > /usr/local/tomcat/webapps/coursework/WEB-INF/dtl/coursematerials/admin/byfolder.dtl > > 27 Oct 2003 12:43:02,087 -- DEBUG [Thread-21] (CoreDTLObject.java:236) - > ***** admin_coursematerials_bydate = > /usr/local/tomcat/webapps/coursework/WEB-INF/dtl/coursematerials/admin/bydate.dtl > > 27 Oct 2003 12:43:02,306 -- DEBUG [Thread-21] > (CourseMaterialController.java:745) - -- by date: adding 15060 to date > folder > 27 Oct 2003 12:43:02,475 -- DEBUG [Thread-21] > (CourseMaterialController.java:745) - -- by date: adding 15080 to date > folder > 27 Oct 2003 12:43:02,674 -- DEBUG [Thread-21] > (CourseMaterialController.java:745) - -- by date: adding 15081 to date > folder > 27 Oct 2003 12:43:02,821 -- DEBUG [Thread-21] > (CourseMaterialController.java:745) - -- by date: adding 15100 to date > folder > 27 Oct 2003 12:43:02,990 -- DEBUG [Thread-21] > (CourseMaterialController.java:745) - -- by date: adding 15101 to date > folder > 27 Oct 2003 12:43:03,159 -- DEBUG [Thread-21] > (CourseMaterialController.java:745) - -- by date: adding 15102 to date > folder > 27 Oct 2003 12:43:03,346 -- DEBUG [Thread-21] > (CourseMaterialController.java:745) - -- by date: adding 15120 to date > folder > 27 Oct 2003 12:43:03,514 -- DEBUG [Thread-21] > (CourseMaterialController.java:745) - -- by date: adding 15121 to date > folder > 27 Oct 2003 12:43:03,723 -- DEBUG [Thread-21] > (CourseMaterialController.java:745) - -- by date: adding 15122 to date > folder > 27 Oct 2003 12:43:03,861 -- DEBUG [Thread-21] > (CourseMaterialController.java:745) - -- by date: adding 15123 to date > folder > 27 Oct 2003 12:43:04,030 -- DEBUG [Thread-21] > (CourseMaterialController.java:745) - -- by date: adding 15124 to date > folder > 27 Oct 2003 12:43:04,034 -- DEBUG [Thread-21] (CoreDTLObject.java:236) - > ***** admin_coursematerials_bytitle = > /usr/local/tomcat/webapps/coursework/WEB-INF/dtl/coursematerials/admin/bytitle.dtl > > 27 Oct 2003 12:43:04,284 -- DEBUG [Thread-21] > (CourseMaterialController.java:621) - -- by title: adding 15080 to folder A > 27 Oct 2003 12:43:04,461 -- DEBUG [Thread-21] > (CourseMaterialController.java:621) - -- by title: adding 15081 to folder B > 27 Oct 2003 12:43:04,690 -- DEBUG [Thread-21] > (CourseMaterialController.java:621) - -- by title: adding 15101 to folder C > 27 Oct 2003 12:43:04,798 -- DEBUG [Thread-21] > (CourseMaterialController.java:621) - -- by title: adding 15100 to folder J > 27 Oct 2003 12:43:04,977 -- DEBUG [Thread-21] > (CourseMaterialController.java:621) - -- by title: adding 15122 to folder P > 27 Oct 2003 12:43:05,155 -- DEBUG [Thread-21] > (CourseMaterialController.java:621) - -- by title: adding 15123 to folder P > 27 Oct 2003 12:43:05,322 -- DEBUG [Thread-21] > (CourseMaterialController.java:621) - -- by title: adding 15124 to folder P > 27 Oct 2003 12:43:05,502 -- DEBUG [Thread-21] > (CourseMaterialController.java:621) - -- by title: adding 15060 to folder S > 27 Oct 2003 12:43:05,684 -- DEBUG [Thread-21] > (CourseMaterialController.java:621) - -- by title: adding 15120 to folder T > 27 Oct 2003 12:43:05,839 -- DEBUG [Thread-21] > (CourseMaterialController.java:621) - -- by title: adding 15121 to folder T > 27 Oct 2003 12:43:06,008 -- DEBUG [Thread-21] > (CourseMaterialController.java:621) - -- by title: adding 15102 to folder V > 27 Oct 2003 12:43:06,011 -- DEBUG [Thread-21] (CoreDTLObject.java:236) - > ***** admin_coursematerials_bytype = > /usr/local/tomcat/webapps/coursework/WEB-INF/dtl/coursematerials/admin/bytype.dtl > > 27 Oct 2003 12:43:06,228 -- DEBUG [Thread-21] > (CourseMaterialController.java:691) - -- by resourcetype: adding 15100 > to folder Reference > 27 Oct 2003 12:43:06,396 -- DEBUG [Thread-21] > (CourseMaterialController.java:691) - -- by resourcetype: adding 15101 > to folder Web Resource > 27 Oct 2003 12:43:06,565 -- DEBUG [Thread-21] > (CourseMaterialController.java:691) - -- by resourcetype: adding 15124 > to folder Other > 27 Oct 2003 12:43:06,752 -- DEBUG [Thread-21] > (CourseMaterialController.java:679) - -- by resourcetype: adding 15123 > to folder Other > 27 Oct 2003 12:43:06,920 -- DEBUG [Thread-21] > (CourseMaterialController.java:679) - -- by resourcetype: adding 15122 > to folder Other > 27 Oct 2003 12:43:07,090 -- DEBUG [Thread-21] > (CourseMaterialController.java:679) - -- by resourcetype: adding 15120 > to folder Other > 27 Oct 2003 12:43:07,284 -- DEBUG [Thread-21] > (CourseMaterialController.java:679) - -- by resourcetype: adding 15102 > to folder Other > 27 Oct 2003 12:43:07,454 -- DEBUG [Thread-21] > (CourseMaterialController.java:679) - -- by resourcetype: adding 15081 > to folder Other > 27 Oct 2003 12:43:07,622 -- DEBUG [Thread-21] > (CourseMaterialController.java:679) - -- by resourcetype: adding 15080 > to folder Other > 27 Oct 2003 12:43:07,800 -- DEBUG [Thread-21] > (CourseMaterialController.java:679) - -- by resourcetype: adding 15060 > to folder Other > 27 Oct 2003 12:43:07,978 -- DEBUG [Thread-21] > (CourseMaterialController.java:679) - -- by resourcetype: adding 15121 > to folder Other > 27 Oct 2003 12:43:07,981 -- DEBUG [Thread-21] (CoreDTLObject.java:236) - > ***** admin_coursematerials_bymimetype = > /usr/local/tomcat/webapps/coursework/WEB-INF/dtl/coursematerials/admin/bymimetype.dtl > > 27 Oct 2003 12:43:08,231 -- DEBUG [Thread-21] > (CourseMaterialController.java:794) - mimetype is application/msword > 27 Oct 2003 12:43:08,272 -- DEBUG [Thread-21] > (CourseMaterialController.java:810) - -- by mimetype: adding 15102to > folder Microsoft Word > 27 Oct 2003 12:43:08,450 -- DEBUG [Thread-21] > (CourseMaterialController.java:794) - mimetype is > audio/x-pn-realaudio-plugin > 27 Oct 2003 12:43:08,492 -- DEBUG [Thread-21] > (CourseMaterialController.java:810) - -- by mimetype: adding 15124to > folder Real Player > 27 Oct 2003 12:43:08,732 -- DEBUG [Thread-21] > (CourseMaterialController.java:794) - mimetype is > audio/x-pn-realaudio-plugin > 27 Oct 2003 12:43:08,736 -- DEBUG [Thread-21] > (CourseMaterialController.java:796) - -- by mimetype: adding 15123to > folder Real Player > 27 Oct 2003 12:43:08,831 -- DEBUG [Thread-21] > (CourseMaterialController.java:794) - mimetype is > audio/x-pn-realaudio-plugin > 27 Oct 2003 12:43:08,835 -- DEBUG [Thread-21] > (CourseMaterialController.java:796) - -- by mimetype: adding 15122to > folder Real Player > 27 Oct 2003 12:43:09,017 -- DEBUG [Thread-21] > (CourseMaterialController.java:794) - mimetype is image/gif > 27 Oct 2003 12:43:09,059 -- DEBUG [Thread-21] > (CourseMaterialController.java:810) - -- by mimetype: adding 15081to > folder GIF Image > 27 Oct 2003 12:43:09,220 -- DEBUG [Thread-21] > (CourseMaterialController.java:794) - mimetype is image/gif > 27 Oct 2003 12:43:09,224 -- DEBUG [Thread-21] > (CourseMaterialController.java:796) - -- by mimetype: adding 15080to > folder GIF Image > 27 Oct 2003 12:43:09,389 -- DEBUG [Thread-21] > (CourseMaterialController.java:794) - mimetype is text/html > 27 Oct 2003 12:43:09,432 -- DEBUG [Thread-21] > (CourseMaterialController.java:810) - -- by mimetype: adding 15101to > folder HTML Document > 27 Oct 2003 12:43:09,617 -- DEBUG [Thread-21] > (CourseMaterialController.java:794) - mimetype is text/html > 27 Oct 2003 12:43:09,621 -- DEBUG [Thread-21] > (CourseMaterialController.java:796) - -- by mimetype: adding 15060to > folder HTML Document > 27 Oct 2003 12:43:09,786 -- DEBUG [Thread-21] > (CourseMaterialController.java:794) - mimetype is text/plain > 27 Oct 2003 12:43:09,827 -- DEBUG [Thread-21] > (CourseMaterialController.java:810) - -- by mimetype: adding 15120to > folder Text Document > 27 Oct 2003 12:43:09,998 -- DEBUG [Thread-21] > (CourseMaterialController.java:794) - mimetype is text/plain > 27 Oct 2003 12:43:10,001 -- DEBUG [Thread-21] > (CourseMaterialController.java:796) - -- by mimetype: adding 15100to > folder Text Document > 27 Oct 2003 12:43:10,183 -- DEBUG [Thread-21] > (CourseMaterialController.java:794) - mimetype is text/plain > 27 Oct 2003 12:43:10,186 -- DEBUG [Thread-21] > (CourseMaterialController.java:796) - -- by mimetype: adding 15121to > folder Text Document > 27 Oct 2003 12:43:10,190 -- DEBUG [Thread-21] > (CourseMaterialController.java:921) - adding folder for byfolder to DTL > 27 Oct 2003 12:43:10,193 -- DEBUG [Thread-21] (Folder.java:386) - > getting subfolders for 5040 > 27 Oct 2003 12:43:10,354 -- DEBUG [Thread-21] (Folder.java:367) - > getting coursematerials for 5040 > 27 Oct 2003 12:43:11,992 -- DEBUG [Thread-21] (Folder.java:386) - > getting subfolders for 5061 > 27 Oct 2003 12:43:12,069 -- DEBUG [Thread-21] (Folder.java:367) - > getting coursematerials for 5061 > 27 Oct 2003 12:43:12,323 -- DEBUG [Thread-21] (Folder.java:386) - > getting subfolders for 5061 > 27 Oct 2003 12:43:12,416 -- DEBUG [Thread-21] (Folder.java:386) - > getting subfolders for 5062 > 27 Oct 2003 12:43:12,500 -- DEBUG [Thread-21] (Folder.java:367) - > getting coursematerials for 5062 > 27 Oct 2003 12:43:12,755 -- DEBUG [Thread-21] (Folder.java:386) - > getting subfolders for 5062 > 27 Oct 2003 12:43:12,912 -- DEBUG [Thread-21] > (CourseMaterialController.java:921) - adding folder for bydate to DTL > 27 Oct 2003 12:43:12,941 -- DEBUG [Thread-21] > (CourseMaterialController.java:921) - adding folder for bytitle to DTL > 27 Oct 2003 12:43:12,976 -- DEBUG [Thread-21] > (CourseMaterialController.java:921) - adding folder for bytype to DTL > 27 Oct 2003 12:43:13,031 -- DEBUG [Thread-21] > (CourseMaterialController.java:921) - adding folder for bymimetype to DTL > 27 Oct 2003 12:43:13,062 -- DEBUG [Thread-21] > (AdminCourseMaterials.java:413) - saving material 15101 into folder 5040 > 27 Oct 2003 12:43:13,065 -- WARN [Thread-21] > (FolderController.java:614) - SQLException:Connection is closed. > Oct 27, 2003 12:43:13 PM org.apache.jk.server.JkCoyoteHandler action > INFO: RESET > ----------------------------------------------- > > > > > ------------------------------------------------------- > This SF.net email is sponsored by: The SF.net Donation Program. > Do you like what SourceForge.net is doing for the Open > Source Community? Make a contribution, and help us add new > features and functionality. Click here: http://sourceforge.net/donate/ > _______________________________________________ > Coursework-help mailing list > Cou...@li... > https://lists.sourceforge.net/lists/listinfo/coursework-help > |
