Ive trying to get that MySchool/Teacher example working, but I all get is "Errors trying to obtain data list" error in the middle of the page. I just followed the steps in the tutorial. Any ideas?
I think there is a problem with my database, it seems that the SQL in my-school-db.script is not used at all. When I try to execute them manually, it says "invalid schema name in statement ".
Thanks in advance.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
There is nothing in the logs folder except a file named "catalina.out" and there is only three letters in it : "log".
However on the console I get very long list of warnings and exceptions, it's probably too long to copy here but starts like this:
Mar 26, 2010 11:50:42 PM org.apache.tomcat.util.digester.SetPropertiesRule begin
WARNING: {Server/Service/Engine/Host/Context} Setting property 'source' to 'org.eclipse.jst.j2ee.server:MySchool' did not find a matching property.
Mar 26, 2010 11:50:42 PM org.apache.tomcat.util.digester.SetPropertiesRule begin
WARNING: {Server/Service/Engine/Host/Context} Setting property 'source' to 'org.eclipse.jst.j2ee.server:OpenXavaTest' did not find a matching property.
Mar 26, 2010 11:50:42 PM org.apache.tomcat.util.digester.SetPropertiesRule begin
WARNING: {Server/Service/Engine/Host/Context} Setting property 'source' to 'org.eclipse.jst.j2ee.server:AccessTracking' did not find a matching property.
Mar 26, 2010 11:50:42 PM org.apache.tomcat.util.digester.SetPropertiesRule begin
WARNING: {Server/Service/Engine/Host/Context} Setting property 'source' to 'org.eclipse.jst.j2ee.server:MiEscuela' did not find a matching property.
Mar 26, 2010 11:50:42 PM org.apache.catalina.core.AprLifecycleListener init
INFO: The APR based Apache Tomcat Native library which allows optimal performance in production environments was not found on the java.library.path: /usr/lib/jvm/java-6-sun-1.6.0.15/jre/lib/i386/client:/usr/lib/jvm/java-6-sun-1.6.0.15/jre/lib/i386:/usr/lib/jvm/java-6-sun-1.6.0.15/jre/../lib/i386:/usr/lib/jvm/java-6-sun-1.6.0.15/jre/lib/i386/client:/usr/lib/jvm/java-6-sun-1.6.0.15/jre/lib/i386:/usr/lib/xulrunner-addons:/usr/lib/xulrunner-addons:/usr/lib/xulrunner-addons:/usr/java/packages/lib/i386:/lib:/usr/lib
Mar 26, 2010 11:50:42 PM org.apache.coyote.http11.Http11Protocol init
INFO: Initializing Coyote HTTP/1.1 on http-8080
Mar 26, 2010 11:50:42 PM org.apache.catalina.startup.Catalina load
INFO: Initialization processed in 536 ms
Mar 26, 2010 11:50:42 PM org.apache.catalina.core.StandardService start
INFO: Starting service Catalina
Mar 26, 2010 11:50:42 PM org.apache.catalina.core.StandardEngine start
INFO: Starting Servlet Engine: Apache Tomcat/6.0.20
Mar 26, 2010 11:50:42 PM org.apache.catalina.core.ApplicationContext log
INFO: Marking servlet dwrInvoker as unavailable
Mar 26, 2010 11:50:42 PM org.apache.catalina.core.ApplicationContext log
SEVERE: Error loading WebappClassLoader
delegate: false
repositories:
/WEB-INF/classes/
-------> Parent Classloader:
org.apache.catalina.loader.StandardClassLoader@1cd8669
org.directwebremoting.servlet.DwrServlet
java.lang.ClassNotFoundException: org.directwebremoting.servlet.DwrServlet
at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1387)
at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1233)
at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1095)
at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:993)
at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:4149)
at org.apache.catalina.core.StandardContext.start(StandardContext.java:4458)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045)
at org.apache.catalina.core.StandardHost.start(StandardHost.java:722)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045)
at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443)
at org.apache.catalina.core.StandardService.start(StandardService.java:516)
at org.apache.catalina.core.StandardServer.start(StandardServer.java:710)
at org.apache.catalina.startup.Catalina.start(Catalina.java:583)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:288)
at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:413)
Mar 26, 2010 11:50:42 PM org.apache.catalina.core.StandardContext loadOnStartup
SEVERE: Servlet /OpenXavaTest threw load() exception
java.lang.ClassNotFoundException: org.directwebremoting.servlet.DwrServlet
at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1387)
at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1233)
at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1095)
at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:993)
at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:4149)
at org.apache.catalina.core.StandardContext.start(StandardContext.java:4458)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045)
at org.apache.catalina.core.StandardHost.start(StandardHost.java:722)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045)
at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443)
at org.apache.catalina.core.StandardService.start(StandardService.java:516)
at org.apache.catalina.core.StandardServer.start(StandardServer.java:710)
at org.apache.catalina.startup.Catalina.start(Catalina.java:583)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:288)
at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:413)
Mar 26, 2010 11:50:43 PM org.directwebremoting.util.CommonsLoggingOutput info
INFO: DWR Version 2.0.5 starting.
Mar 26, 2010 11:50:43 PM org.directwebremoting.util.CommonsLoggingOutput info
INFO: - Servlet Engine: Apache Tomcat/6.0.20
Mar 26, 2010 11:50:43 PM org.directwebremoting.util.CommonsLoggingOutput info
INFO: - Java Version: 1.6.0_15
Mar 26, 2010 11:50:43 PM org.directwebremoting.util.CommonsLoggingOutput info
INFO: - Java Vendor: Sun Microsystems Inc.
Mar 26, 2010 11:50:43 PM org.directwebremoting.util.CommonsLoggingOutput info
INFO: Probably not an issue: org.jdom.Document is not available so the jdom converter will not load. This is only an problem if you wanted to use it.
Mar 26, 2010 11:50:43 PM org.directwebremoting.util.CommonsLoggingOutput info
INFO: Probably not an issue: org.jdom.Element is not available so the jdom converter will not load. This is only an problem if you wanted to use it.
Mar 26, 2010 11:50:43 PM org.apache.catalina.core.ApplicationContext log
INFO: Marking servlet dwrInvoker as unavailable
Mar 26, 2010 11:50:43 PM org.apache.catalina.core.ApplicationContext log
SEVERE: Error loading WebappClassLoader
delegate: false
repositories:
/WEB-INF/classes/
-------> Parent Classloader:
org.apache.catalina.loader.StandardClassLoader@1cd8669
org.directwebremoting.servlet.DwrServlet
java.lang.ClassNotFoundException: org.directwebremoting.servlet.DwrServlet
at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1387)
at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1233)
at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1095)
at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:993)
at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:4149)
at org.apache.catalina.core.StandardContext.start(StandardContext.java:4458)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045)
at org.apache.catalina.core.StandardHost.start(StandardHost.java:722)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045)
at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443)
at org.apache.catalina.core.StandardService.start(StandardService.java:516)
at org.apache.catalina.core.StandardServer.start(StandardServer.java:710)
at org.apache.catalina.startup.Catalina.start(Catalina.java:583)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:288)
at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:413)
Mar 26, 2010 11:50:43 PM org.apache.catalina.core.StandardContext loadOnStartup
SEVERE: Servlet /AccessTracking threw load() exception
java.lang.ClassNotFoundException: org.directwebremoting.servlet.DwrServlet
at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1387)
at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1233)
at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1095)
at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:993)
at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:4149)
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Ive trying to get that MySchool/Teacher example working, but I all get is "Errors trying to obtain data list" error in the middle of the page. I just followed the steps in the tutorial. Any ideas?
I think there is a problem with my database, it seems that the SQL in my-school-db.script is not used at all. When I try to execute them manually, it says "invalid schema name in statement ".
Thanks in advance.
Hi Pall,
Strange! Did you follow the tutorial step by step?
Anyways, put here the stacktrace from the log file (from tomcat/logs) in order I can give you some tip.
Learn OpenXava by examples: Get the book
There is nothing in the logs folder except a file named "catalina.out" and there is only three letters in it : "log".
However on the console I get very long list of warnings and exceptions, it's probably too long to copy here but starts like this:
Mar 26, 2010 11:50:42 PM org.apache.tomcat.util.digester.SetPropertiesRule begin
WARNING: {Server/Service/Engine/Host/Context} Setting property 'source' to 'org.eclipse.jst.j2ee.server:MySchool' did not find a matching property.
Mar 26, 2010 11:50:42 PM org.apache.tomcat.util.digester.SetPropertiesRule begin
WARNING: {Server/Service/Engine/Host/Context} Setting property 'source' to 'org.eclipse.jst.j2ee.server:OpenXavaTest' did not find a matching property.
Mar 26, 2010 11:50:42 PM org.apache.tomcat.util.digester.SetPropertiesRule begin
WARNING: {Server/Service/Engine/Host/Context} Setting property 'source' to 'org.eclipse.jst.j2ee.server:AccessTracking' did not find a matching property.
Mar 26, 2010 11:50:42 PM org.apache.tomcat.util.digester.SetPropertiesRule begin
WARNING: {Server/Service/Engine/Host/Context} Setting property 'source' to 'org.eclipse.jst.j2ee.server:MiEscuela' did not find a matching property.
Mar 26, 2010 11:50:42 PM org.apache.catalina.core.AprLifecycleListener init
INFO: The APR based Apache Tomcat Native library which allows optimal performance in production environments was not found on the java.library.path: /usr/lib/jvm/java-6-sun-1.6.0.15/jre/lib/i386/client:/usr/lib/jvm/java-6-sun-1.6.0.15/jre/lib/i386:/usr/lib/jvm/java-6-sun-1.6.0.15/jre/../lib/i386:/usr/lib/jvm/java-6-sun-1.6.0.15/jre/lib/i386/client:/usr/lib/jvm/java-6-sun-1.6.0.15/jre/lib/i386:/usr/lib/xulrunner-addons:/usr/lib/xulrunner-addons:/usr/lib/xulrunner-addons:/usr/java/packages/lib/i386:/lib:/usr/lib
Mar 26, 2010 11:50:42 PM org.apache.coyote.http11.Http11Protocol init
INFO: Initializing Coyote HTTP/1.1 on http-8080
Mar 26, 2010 11:50:42 PM org.apache.catalina.startup.Catalina load
INFO: Initialization processed in 536 ms
Mar 26, 2010 11:50:42 PM org.apache.catalina.core.StandardService start
INFO: Starting service Catalina
Mar 26, 2010 11:50:42 PM org.apache.catalina.core.StandardEngine start
INFO: Starting Servlet Engine: Apache Tomcat/6.0.20
Mar 26, 2010 11:50:42 PM org.apache.catalina.core.ApplicationContext log
INFO: Marking servlet dwrInvoker as unavailable
Mar 26, 2010 11:50:42 PM org.apache.catalina.core.ApplicationContext log
SEVERE: Error loading WebappClassLoader
delegate: false
repositories:
/WEB-INF/classes/
-------> Parent Classloader:
org.apache.catalina.loader.StandardClassLoader@1cd8669
org.directwebremoting.servlet.DwrServlet
java.lang.ClassNotFoundException: org.directwebremoting.servlet.DwrServlet
at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1387)
at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1233)
at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1095)
at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:993)
at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:4149)
at org.apache.catalina.core.StandardContext.start(StandardContext.java:4458)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045)
at org.apache.catalina.core.StandardHost.start(StandardHost.java:722)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045)
at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443)
at org.apache.catalina.core.StandardService.start(StandardService.java:516)
at org.apache.catalina.core.StandardServer.start(StandardServer.java:710)
at org.apache.catalina.startup.Catalina.start(Catalina.java:583)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:288)
at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:413)
Mar 26, 2010 11:50:42 PM org.apache.catalina.core.StandardContext loadOnStartup
SEVERE: Servlet /OpenXavaTest threw load() exception
java.lang.ClassNotFoundException: org.directwebremoting.servlet.DwrServlet
at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1387)
at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1233)
at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1095)
at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:993)
at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:4149)
at org.apache.catalina.core.StandardContext.start(StandardContext.java:4458)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045)
at org.apache.catalina.core.StandardHost.start(StandardHost.java:722)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045)
at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443)
at org.apache.catalina.core.StandardService.start(StandardService.java:516)
at org.apache.catalina.core.StandardServer.start(StandardServer.java:710)
at org.apache.catalina.startup.Catalina.start(Catalina.java:583)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:288)
at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:413)
Mar 26, 2010 11:50:43 PM org.directwebremoting.util.CommonsLoggingOutput info
INFO: DWR Version 2.0.5 starting.
Mar 26, 2010 11:50:43 PM org.directwebremoting.util.CommonsLoggingOutput info
INFO: - Servlet Engine: Apache Tomcat/6.0.20
Mar 26, 2010 11:50:43 PM org.directwebremoting.util.CommonsLoggingOutput info
INFO: - Java Version: 1.6.0_15
Mar 26, 2010 11:50:43 PM org.directwebremoting.util.CommonsLoggingOutput info
INFO: - Java Vendor: Sun Microsystems Inc.
Mar 26, 2010 11:50:43 PM org.directwebremoting.util.CommonsLoggingOutput info
INFO: Probably not an issue: org.jdom.Document is not available so the jdom converter will not load. This is only an problem if you wanted to use it.
Mar 26, 2010 11:50:43 PM org.directwebremoting.util.CommonsLoggingOutput info
INFO: Probably not an issue: org.jdom.Element is not available so the jdom converter will not load. This is only an problem if you wanted to use it.
Mar 26, 2010 11:50:43 PM org.apache.catalina.core.ApplicationContext log
INFO: Marking servlet dwrInvoker as unavailable
Mar 26, 2010 11:50:43 PM org.apache.catalina.core.ApplicationContext log
SEVERE: Error loading WebappClassLoader
delegate: false
repositories:
/WEB-INF/classes/
-------> Parent Classloader:
org.apache.catalina.loader.StandardClassLoader@1cd8669
org.directwebremoting.servlet.DwrServlet
java.lang.ClassNotFoundException: org.directwebremoting.servlet.DwrServlet
at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1387)
at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1233)
at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1095)
at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:993)
at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:4149)
at org.apache.catalina.core.StandardContext.start(StandardContext.java:4458)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045)
at org.apache.catalina.core.StandardHost.start(StandardHost.java:722)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045)
at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443)
at org.apache.catalina.core.StandardService.start(StandardService.java:516)
at org.apache.catalina.core.StandardServer.start(StandardServer.java:710)
at org.apache.catalina.startup.Catalina.start(Catalina.java:583)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:288)
at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:413)
Mar 26, 2010 11:50:43 PM org.apache.catalina.core.StandardContext loadOnStartup
SEVERE: Servlet /AccessTracking threw load() exception
java.lang.ClassNotFoundException: org.directwebremoting.servlet.DwrServlet
at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1387)
at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1233)
at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1095)
at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:993)
at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:4149)
Hmm, it seems that I didnt even configured the tomcat properly, the Teacher example works fine.
Now I just need to figure out how to apply the same thing to my own entities :)