<hibernate-configuration>
<session-factory>
<!-- Database Connection -->
<property name="hibernate.connection.driver_class">com.mysql.jdbc.Driver</property>
<property name="hibernate.connection.url">jdbc:mysql://127.0.0.1/avalia</property>
<property name="hibernate.connection.username">root</property>
<property name="hibernate.connection.password">paulo</property>
<property name="hibernate.dialect">org.hibernate.dialect.MySQLDialect</property>
<property name="show_sql">true</property>
<property name="format_sql">true</property>
<property name="hb2ddl.auto">update</property>
<mapping class="ao.edu.imag.avalia.bean.PerguntaAluno" />
<mapping class="ao.edu.imag.avalia.bean.PerguntaProfessor" />
<mapping class="ao.edu.imag.avalia.bean.RespostaAluno" />
<mapping class="ao.edu.imag.avalia.bean.Usuario" />
<mapping class="ao.edu.imag.avalia.bean.PapelUsuario" />
</session-factory>
</hibernate-configuration>
11/03/2011 23:48:12 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: C:\Arquivos de programas\Java\jdk1.6.0_22\bin;.;C:\WINDOWS\Sun\Java\bin;C:\WINDOWS\system32;C:\WINDOWS;C:/Arquivos de programas/Java/jdk1.6.0_22/jre/bin/client;C:/Arquivos de programas/Java/jdk1.6.0_22/jre/bin;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\apache-maven-2.2.1\bin;C:\Arquivos de programas\Java\jdk1.6.0_22\bin;C:\ORANT\BIN;
11/03/2011 23:48:12 org.apache.tomcat.util.digester.SetPropertiesRule begin
AVISO: [SetPropertiesRule]{Server/Service/Engine/Host/Context} Setting property 'source' to 'org.eclipse.jst.jee.server:avalia' did not find a matching property.
11/03/2011 23:48:12 org.apache.coyote.http11.Http11Protocol init
INFO: Initializing Coyote HTTP/1.1 on http-8080
11/03/2011 23:48:12 org.apache.catalina.startup.Catalina load
INFO: Initialization processed in 1006 ms
11/03/2011 23:48:12 org.apache.catalina.core.StandardService start
INFO: Starting service Catalina
11/03/2011 23:48:12 org.apache.catalina.core.StandardEngine start
INFO: Starting Servlet Engine: Apache Tomcat/6.0.26
11/03/2011 23:48:13 com.sun.faces.config.ConfigureListener contextInitialized
INFO: Initializing Mojarra (1.2_08-b06-FCS) for context '/avalia'
11/03/2011 11:48:16 net.java.dev.weblets.impl.WebletsContextListenerImpl handlePathPatternWarnings
WARN : JSF Enabled Weblets but path pattern is missing, some relatively referenced resources might not load
11/03/2011 23:48:16 org.apache.coyote.http11.Http11Protocol start
INFO: Starting Coyote HTTP/1.1 on http-8080
11/03/2011 11:48:16 org.ajax4jsf.cache.CacheManager getCacheFactory
INFO : Selected [org.ajax4jsf.cache.LRUMapCacheFactory] cache factory
11/03/2011 11:48:16 org.ajax4jsf.cache.LRUMapCacheFactory createCache
INFO : Creating LRUMap cache instance using parameters: {weblets.CONFIG_FILES=weblets-config.xml, javax.faces.STATE_SAVING_METHOD=server, javax.faces.DEFAULT_SUFFIX=.xhtml}
11/03/2011 11:48:16 org.ajax4jsf.cache.LRUMapCacheFactory createCache
INFO : Creating LRUMap cache instance of default capacity
11/03/2011 11:48:16 org.ajax4jsf.cache.CacheManager getCacheFactory
INFO : Selected [org.ajax4jsf.cache.LRUMapCacheFactory] cache factory
11/03/2011 11:48:16 org.ajax4jsf.cache.LRUMapCacheFactory createCache
INFO : Creating LRUMap cache instance using parameters: {weblets.CONFIG_FILES=weblets-config.xml, javax.faces.STATE_SAVING_METHOD=server, javax.faces.DEFAULT_SUFFIX=.xhtml}
11/03/2011 11:48:16 org.ajax4jsf.cache.LRUMapCacheFactory createCache
INFO : Creating LRUMap cache instance of default capacity
11/03/2011 23:48:16 org.apache.jk.common.ChannelSocket init
INFO: JK: ajp13 listening on /0.0.0.0:8009
11/03/2011 23:48:16 org.apache.jk.server.JkMain start
INFO: Jk running ID=0 time=0/47 config=null
11/03/2011 23:48:16 org.apache.catalina.startup.Catalina start
INFO: Server startup in 4037 ms
11/03/2011 23:51:14 com.sun.facelets.compiler.TagLibraryConfig loadImplicit
INFO: Added Library from: jar:file:/C:/workspace-projeto-final/.metadata/.plugins/org.eclipse.wst.server.core/tmp0/wtpwebapps/avalia/WEB-INF/lib/demoiselle-jsf-ui-1.0.5.jar!/META-INF/demoiselle.taglib.xml
11/03/2011 23:51:14 com.sun.facelets.compiler.TagLibraryConfig loadImplicit
INFO: Added Library from: jar:file:/C:/workspace-projeto-final/.metadata/.plugins/org.eclipse.wst.server.core/tmp0/wtpwebapps/avalia/WEB-INF/lib/demoiselle-jsf-ui-1.0.5.jar!/META-INF/tomahawk.taglib.xml
11/03/2011 23:51:14 com.sun.facelets.compiler.TagLibraryConfig loadImplicit
INFO: Added Library from: jar:file:/C:/workspace-projeto-final/.metadata/.plugins/org.eclipse.wst.server.core/tmp0/wtpwebapps/avalia/WEB-INF/lib/tomahawk-1.1.7.jar!/META-INF/tomahawk.taglib.xml
11/03/2011 23:51:14 com.sun.facelets.compiler.TagLibraryConfig loadImplicit
INFO: Added Library from: jar:file:/C:/workspace-projeto-final/.metadata/.plugins/org.eclipse.wst.server.core/tmp0/wtpwebapps/avalia/WEB-INF/lib/jsf-facelets-1.1.14.jar!/META-INF/jsf-core.taglib.xml
11/03/2011 23:51:14 com.sun.facelets.compiler.TagLibraryConfig loadImplicit
INFO: Added Library from: jar:file:/C:/workspace-projeto-final/.metadata/.plugins/org.eclipse.wst.server.core/tmp0/wtpwebapps/avalia/WEB-INF/lib/jsf-facelets-1.1.14.jar!/META-INF/jsf-html.taglib.xml
11/03/2011 23:51:14 com.sun.facelets.compiler.TagLibraryConfig loadImplicit
INFO: Added Library from: jar:file:/C:/workspace-projeto-final/.metadata/.plugins/org.eclipse.wst.server.core/tmp0/wtpwebapps/avalia/WEB-INF/lib/jsf-facelets-1.1.14.jar!/META-INF/jsf-ui.taglib.xml
11/03/2011 23:51:14 com.sun.facelets.compiler.TagLibraryConfig loadImplicit
INFO: Added Library from: jar:file:/C:/workspace-projeto-final/.metadata/.plugins/org.eclipse.wst.server.core/tmp0/wtpwebapps/avalia/WEB-INF/lib/jsf-facelets-1.1.14.jar!/META-INF/jstl-core.taglib.xml
11/03/2011 23:51:14 com.sun.facelets.compiler.TagLibraryConfig loadImplicit
INFO: Added Library from: jar:file:/C:/workspace-projeto-final/.metadata/.plugins/org.eclipse.wst.server.core/tmp0/wtpwebapps/avalia/WEB-INF/lib/jsf-facelets-1.1.14.jar!/META-INF/jstl-fn.taglib.xml
11/03/2011 23:51:14 com.sun.facelets.compiler.TagLibraryConfig loadImplicit
INFO: Added Library from: jar:file:/C:/workspace-projeto-final/.metadata/.plugins/org.eclipse.wst.server.core/tmp0/wtpwebapps/avalia/WEB-INF/lib/richfaces-ui-3.1.2.GA.jar!/META-INF/a4j.taglib.xml
11/03/2011 23:51:14 com.sun.facelets.compiler.TagLibraryConfig loadImplicit
INFO: Added Library from: jar:file:/C:/workspace-projeto-final/.metadata/.plugins/org.eclipse.wst.server.core/tmp0/wtpwebapps/avalia/WEB-INF/lib/richfaces-ui-3.1.2.GA.jar!/META-INF/ajax4jsf.taglib.xml
11/03/2011 23:51:14 com.sun.facelets.compiler.TagLibraryConfig loadImplicit
INFO: Added Library from: jar:file:/C:/workspace-projeto-final/.metadata/.plugins/org.eclipse.wst.server.core/tmp0/wtpwebapps/avalia/WEB-INF/lib/richfaces-ui-3.1.2.GA.jar!/META-INF/rich.taglib.xml
11/03/2011 11:51:15 org.apache.myfaces.shared_tomahawk.config.MyfacesConfig getBooleanInitParameter
INFO : No context init parameter 'org.apache.myfaces.PRETTY_HTML' found, using default value true
11/03/2011 11:51:15 org.apache.myfaces.shared_tomahawk.config.MyfacesConfig getBooleanInitParameter
INFO : No context init parameter 'org.apache.myfaces.ALLOW_JAVASCRIPT' found, using default value true
11/03/2011 11:51:15 org.apache.myfaces.shared_tomahawk.config.MyfacesConfig getBooleanInitParameter
INFO : No context init parameter 'org.apache.myfaces.READONLY_AS_DISABLED_FOR_SELECTS' found, using default value true
11/03/2011 11:51:15 org.apache.myfaces.shared_tomahawk.config.MyfacesConfig getBooleanInitParameter
INFO : No context init parameter 'org.apache.myfaces.RENDER_VIEWSTATE_ID' found, using default value true
11/03/2011 11:51:15 org.apache.myfaces.shared_tomahawk.config.MyfacesConfig getBooleanInitParameter
INFO : No context init parameter 'org.apache.myfaces.STRICT_XHTML_LINKS' found, using default value true
11/03/2011 11:51:15 org.apache.myfaces.shared_tomahawk.config.MyfacesConfig getLongInitParameter
INFO : No context init parameter 'org.apache.myfaces.CONFIG_REFRESH_PERIOD' found, using default value 2
11/03/2011 11:51:15 org.apache.myfaces.shared_tomahawk.config.MyfacesConfig getBooleanInitParameter
INFO : No context init parameter 'org.apache.myfaces.DETECT_JAVASCRIPT' found, using default value false
11/03/2011 11:51:15 org.apache.myfaces.shared_tomahawk.config.MyfacesConfig getBooleanInitParameter
INFO : No context init parameter 'org.apache.myfaces.AUTO_SCROLL' found, using default value false
11/03/2011 11:51:15 org.apache.myfaces.shared_tomahawk.config.MyfacesConfig getStringInitParameter
INFO : No context init parameter 'org.apache.myfaces.ADD_RESOURCE_CLASS' found, using default value org.apache.myfaces.renderkit.html.util.DefaultAddResource
11/03/2011 11:51:15 org.apache.myfaces.shared_tomahawk.config.MyfacesConfig getStringInitParameter
INFO : No context init parameter 'org.apache.myfaces.RESOURCE_VIRTUAL_PATH' found, using default value /faces/myFacesExtensionResource
11/03/2011 11:51:15 org.apache.myfaces.shared_tomahawk.config.MyfacesConfig getBooleanInitParameter
INFO : No context init parameter 'org.apache.myfaces.CHECK_EXTENSIONS_FILTER' found, using default value true
11/03/2011 11:51:15 org.apache.myfaces.shared_tomahawk.config.MyfacesConfig createAndInitializeMyFacesConfig
INFO : Starting up Tomahawk on the RI-JSF-Implementation.
11/03/2011 23:51:14 com.sun.facelets.compiler.TagLibraryConfig loadImplicit
INFO: Added Library from: jar:file:/C:/workspace-projeto-final/.metadata/.plugins/org.eclipse.wst.server.core/tmp0/wtpwebapps/avalia/WEB-INF/lib/richfaces-ui-3.1.2.GA.jar!/META-INF/richfaces.taglib.xml
11/03/2011 23:51:14 com.sun.facelets.compiler.TagLibraryConfig loadImplicit
INFO: Added Library from: jar:file:/C:/workspace-projeto-final/.metadata/.plugins/org.eclipse.wst.server.core/tmp0/wtpwebapps/avalia/WEB-INF/lib/weblets-api-1.1.jar!/META-INF/weblet.taglib.xml
11/03/2011 11:51:17 org.hibernate.cfg.annotations.Version <clinit>
INFO : Hibernate Annotations 3.2.1.GA
11/03/2011 11:51:17 org.hibernate.cfg.Environment <clinit>
INFO : Hibernate 3.2.2
11/03/2011 11:51:17 org.hibernate.cfg.Environment <clinit>
INFO : hibernate.properties not found
11/03/2011 11:51:17 org.hibernate.cfg.Environment buildBytecodeProvider
INFO : Bytecode provider name : cglib
11/03/2011 11:51:17 org.hibernate.cfg.Environment <clinit>
INFO : using JDK 1.4 java.sql.Timestamp handling
11/03/2011 11:51:18 org.hibernate.cfg.Configuration configure
INFO : configuring from resource: /hibernate.cfg.xml
11/03/2011 11:51:18 org.hibernate.cfg.Configuration getConfigurationInputStream
INFO : Configuration resource: /hibernate.cfg.xml
11/03/2011 11:51:18 org.hibernate.cfg.Configuration doConfigure
INFO : Configured SessionFactory: null
11/03/2011 11:51:18 org.hibernate.cfg.AnnotationBinder bindClass
INFO : Binding entity from annotated class: ao.edu.imag.avalia.bean.PerguntaAluno
11/03/2011 11:51:18 org.hibernate.cfg.annotations.EntityBinder bindTable
INFO : Bind entity ao.edu.imag.avalia.bean.PerguntaAluno on table pergunta_aluno
11/03/2011 11:51:18 org.hibernate.cfg.AnnotationBinder bindClass
INFO : Binding entity from annotated class: ao.edu.imag.avalia.bean.PerguntaProfessor
11/03/2011 11:51:18 org.hibernate.cfg.annotations.EntityBinder bindTable
INFO : Bind entity ao.edu.imag.avalia.bean.PerguntaProfessor on table pergunta_professor
11/03/2011 11:51:18 org.hibernate.cfg.AnnotationBinder bindClass
INFO : Binding entity from annotated class: ao.edu.imag.avalia.bean.RespostaAluno
11/03/2011 11:51:18 org.hibernate.cfg.annotations.EntityBinder bindTable
INFO : Bind entity ao.edu.imag.avalia.bean.RespostaAluno on table resposta_aluno
11/03/2011 11:51:18 org.hibernate.cfg.AnnotationBinder bindClass
INFO : Binding entity from annotated class: ao.edu.imag.avalia.bean.Usuario
11/03/2011 11:51:18 org.hibernate.cfg.annotations.EntityBinder bindTable
INFO : Bind entity ao.edu.imag.avalia.bean.Usuario on table usuario
11/03/2011 11:51:18 org.hibernate.cfg.AnnotationBinder bindClass
INFO : Binding entity from annotated class: ao.edu.imag.avalia.bean.PapelUsuario
11/03/2011 11:51:18 org.hibernate.cfg.annotations.EntityBinder bindTable
INFO : Bind entity ao.edu.imag.avalia.bean.PapelUsuario on table papel
11/03/2011 23:51:20 com.sun.faces.application.ActionListenerImpl processAction
GRAVE: org.hibernate.exception.SQLGrammarException: could not execute query using scroll
javax.faces.el.EvaluationException: org.hibernate.exception.SQLGrammarException: could not execute query using scroll
at javax.faces.component.MethodBindingMethodExpressionAdapter.invoke(MethodBindingMethodExpressionAdapter.java:102)
at com.sun.faces.application.ActionListenerImpl.processAction(ActionListenerImpl.java:102)
at javax.faces.component.UICommand.broadcast(UICommand.java:387)
at org.ajax4jsf.component.AjaxViewRoot.processEvents(AjaxViewRoot.java:184)
at org.ajax4jsf.component.AjaxViewRoot.broadcastEvents(AjaxViewRoot.java:162)
at org.ajax4jsf.component.AjaxViewRoot.processApplication(AjaxViewRoot.java:350)
at com.sun.faces.lifecycle.InvokeApplicationPhase.execute(InvokeApplicationPhase.java:82)
at com.sun.faces.lifecycle.Phase.doPhase(Phase.java:100)
at com.sun.faces.lifecycle.LifecycleImpl.execute(LifecycleImpl.java:118)
at javax.faces.webapp.FacesServlet.service(FacesServlet.java:265)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.myfaces.webapp.filter.ExtensionsFilter.doFilter(ExtensionsFilter.java:246)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.ajax4jsf.webapp.BaseXMLFilter.doXmlFilter(BaseXMLFilter.java:141)
at org.ajax4jsf.webapp.BaseFilter.doFilter(BaseFilter.java:281)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.myfaces.webapp.filter.ExtensionsFilter.doFilter(ExtensionsFilter.java:301)
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:558)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
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:298)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:852)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
at java.lang.Thread.run(Thread.java:662)
Caused by: org.hibernate.exception.SQLGrammarException: could not execute query using scroll
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:67)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
at org.hibernate.loader.Loader.scroll(Loader.java:2319)
at org.hibernate.loader.hql.QueryLoader.scroll(QueryLoader.java:438)
at org.hibernate.hql.ast.QueryTranslatorImpl.scroll(QueryTranslatorImpl.java:390)
at org.hibernate.engine.query.HQLQueryPlan.performScroll(HQLQueryPlan.java:245)
at org.hibernate.impl.SessionImpl.scroll(SessionImpl.java:1206)
at org.hibernate.impl.QueryImpl.scroll(QueryImpl.java:67)
at org.hibernate.impl.QueryImpl.scroll(QueryImpl.java:57)
at br.gov.framework.demoiselle.persistence.hibernate.HibernateGenericDAO.getTotalResults(HibernateGenericDAO.java:177)
at br.gov.framework.demoiselle.persistence.hibernate.HibernateGenericDAO.createPagedResult(HibernateGenericDAO.java:788)
at br.gov.framework.demoiselle.persistence.hibernate.HibernateGenericDAO.findHQL(HibernateGenericDAO.java:482)
at ao.edu.imag.avalia.persistence.dao.implementation.PerguntaAlunoDAO.listar(PerguntaAlunoDAO.java:33)
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 br.gov.framework.demoiselle.util.layer.integration.LazyCreateProxy.invoke(LazyCreateProxy.java:106)
at $Proxy7.listar(Unknown Source)
at ao.edu.imag.avalia.business.implementation.PerguntaAlunoBC.listar(PerguntaAlunoBC.java:49)
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 br.gov.framework.demoiselle.util.layer.integration.LazyCreateProxy.invoke(LazyCreateProxy.java:106)
at $Proxy6.listar(Unknown Source)
at ao.edu.imag.avalia.view.managedbean.PerguntaAlunoMB.atualizaListaAluno(PerguntaAlunoMB.java:145)
at ao.edu.imag.avalia.view.managedbean.PerguntaAlunoMB.listar(PerguntaAlunoMB.java:93)
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.el.parser.AstValue.invoke(AstValue.java:191)
at org.apache.el.MethodExpressionImpl.invoke(MethodExpressionImpl.java:276)
at com.sun.facelets.el.TagMethodExpression.invoke(TagMethodExpression.java:68)
at javax.faces.component.MethodBindingMethodExpressionAdapter.invoke(MethodBindingMethodExpressionAdapter.java:88)
... 32 more
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'avalia.pergunta_aluno' doesn't exist
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:407)
at com.mysql.jdbc.Util.getInstance(Util.java:382)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1052)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3593)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3525)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1986)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2140)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2626)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2111)
at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2273)
at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:186)
at org.hibernate.loader.Loader.getResultSet(Loader.java:1778)
at org.hibernate.loader.Loader.scroll(Loader.java:2284)
... 65 more
11/03/2011 23:51:20 com.sun.faces.lifecycle.InvokeApplicationPhase execute
AVISO: #{perguntaAlunoMB.listar}: org.hibernate.exception.SQLGrammarException: could not execute query using scroll
javax.faces.FacesException: #{perguntaAlunoMB.listar}: org.hibernate.exception.SQLGrammarException: could not execute query using scroll
at com.sun.faces.application.ActionListenerImpl.processAction(ActionListenerImpl.java:118)
at javax.faces.component.UICommand.broadcast(UICommand.java:387)
at org.ajax4jsf.component.AjaxViewRoot.processEvents(AjaxViewRoot.java:184)
at org.ajax4jsf.component.AjaxViewRoot.broadcastEvents(AjaxViewRoot.java:162)
at org.ajax4jsf.component.AjaxViewRoot.processApplication(AjaxViewRoot.java:3511/03/2011 11:51:18 org.hibernate.connection.DriverManagerConnectionProvider configure
INFO : Using Hibernate built-in connection pool (not for production use!)
11/03/2011 11:51:18 org.hibernate.connection.DriverManagerConnectionProvider configure
INFO : Hibernate connection pool size: 20
11/03/2011 11:51:18 org.hibernate.connection.DriverManagerConnectionProvider configure
INFO : autocommit mode: false
11/03/2011 11:51:18 org.hibernate.connection.DriverManagerConnectionProvider configure
INFO : using driver: com.mysql.jdbc.Driver at URL: jdbc:mysql://127.0.0.1/avalia
11/03/2011 11:51:18 org.hibernate.connection.DriverManagerConnectionProvider configure
INFO : connection properties: {user=root, password=****}
11/03/2011 11:51:19 org.hibernate.cfg.SettingsFactory buildSettings
INFO : RDBMS: MySQL, version: 5.1.54-community
11/03/2011 11:51:19 org.hibernate.cfg.SettingsFactory buildSettings
INFO : JDBC driver: MySQL-AB JDBC Driver, version: mysql-connector-java-5.1.14 ( Revision: ${bzr.revision-id} )
11/03/2011 11:51:19 org.hibernate.dialect.Dialect <init>
INFO : Using dialect: org.hibernate.dialect.MySQLDialect
11/03/2011 11:51:19 org.hibernate.transaction.TransactionFactoryFactory buildTransactionFactory
INFO : Using default transaction strategy (direct JDBC transactions)
11/03/2011 11:51:19 org.hibernate.transaction.TransactionManagerLookupFactory getTransactionManagerLookup
INFO : No TransactionManagerLookup configured (in JTA environment, use of read-write or transactional second-level cache is not recommended)
11/03/2011 11:51:19 org.hibernate.cfg.SettingsFactory buildSettings
INFO : Automatic flush during beforeCompletion(): disabled
11/03/2011 11:51:19 org.hibernate.cfg.SettingsFactory buildSettings
INFO : Automatic session close at end of transaction: disabled
11/03/2011 11:51:19 org.hibernate.cfg.SettingsFactory buildSettings
INFO : JDBC batch size: 15
11/03/2011 11:51:19 org.hibernate.cfg.SettingsFactory buildSettings
INFO : JDBC batch updates for versioned data: disabled
11/03/2011 11:51:19 org.hibernate.cfg.SettingsFactory buildSettings
INFO : Scrollable result sets: enabled
11/03/2011 11:51:19 org.hibernate.cfg.SettingsFactory buildSettings
INFO : JDBC3 getGeneratedKeys(): enabled
11/03/2011 11:51:19 org.hibernate.cfg.SettingsFactory buildSettings
INFO : Connection release mode: auto
11/03/2011 11:51:19 org.hibernate.cfg.SettingsFactory buildSettings
INFO : Maximum outer join fetch depth: 2
11/03/2011 11:51:19 org.hibernate.cfg.SettingsFactory buildSettings
INFO : Default batch fetch size: 1
11/03/2011 11:51:19 org.hibernate.cfg.SettingsFactory buildSettings
INFO : Generate SQL with comments: disabled
11/03/2011 11:51:19 org.hibernate.cfg.SettingsFactory buildSettings
INFO : Order SQL updates by primary key: disabled
11/03/2011 11:51:19 org.hibernate.cfg.SettingsFactory createQueryTranslatorFactory
INFO : Query translator: org.hibernate.hql.ast.ASTQueryTranslatorFactory
11/03/2011 11:51:19 org.hibernate.hql.ast.ASTQueryTranslatorFactory <init>
INFO : Using ASTQueryTranslatorFactory
11/03/2011 11:51:19 org.hibernate.cfg.SettingsFactory buildSettings
INFO : Query language substitutions: {}
11/03/2011 11:51:19 org.hibernate.cfg.SettingsFactory buildSettings
INFO : JPA-QL strict compliance: disabled
11/03/2011 11:51:19 org.hibernate.cfg.SettingsFactory buildSettings
INFO : Second-level cache: enabled
11/03/2011 11:51:19 org.hibernate.cfg.SettingsFactory buildSettings
INFO : Query cache: disabled
11/03/2011 11:51:19 org.hibernate.cfg.SettingsFactory createCacheProvider
INFO : Cache provider: org.hibernate.cache.NoCacheProvider
11/03/2011 11:51:19 org.hibernate.cfg.SettingsFactory buildSettings
INFO : Optimize cache for minimal puts: disabled
11/03/2011 11:51:19 org.hibernate.cfg.SettingsFactory buildSettings
INFO : Structured second-level cache entries: disabled
11/03/2011 11:51:19 org.hibernate.cfg.SettingsFactory buildSettings
INFO : Echoing all SQL to stdout
11/03/2011 11:51:19 org.hibernate.cfg.SettingsFactory buildSettings
INFO : Statistics: disabled
11/03/2011 11:51:19 org.hibernate.cfg.SettingsFactory buildSettings
INFO : Deleted entity synthetic identifier rollback: disabled
11/03/2011 11:51:19 org.hibernate.cfg.SettingsFactory buildSettings
INFO : Default entity-mode: pojo
11/03/2011 11:51:19 org.hibernate.cfg.SettingsFactory buildSettings
INFO : Named query checking : enabled
11/03/2011 11:51:19 org.hibernate.impl.SessionFactoryImpl <init>
INFO : building session factory
11/03/2011 11:51:19 org.hibernate.impl.SessionFactoryObjectFactory addInstance
INFO : Not binding factory to JNDI, no JNDI name configured
Hibernate:
select
perguntaal0_.id_pergunta_aluno as id1_0_,
perguntaal0_.nm_pergunta_aluno as nm2_0_
from
pergunta_aluno perguntaal0_
order by
perguntaal0_.id_pergunta_aluno ASC
11/03/2011 11:51:20 org.hibernate.util.JDBCExceptionReporter logExceptions
WARN : SQL Error: 1146, SQLState: 42S02
11/03/2011 11:51:20 org.hibernate.util.JDBCExceptionReporter logExceptions
ERROR: Table 'avalia.pergunta_aluno' doesn't exist
0)
at com.sun.faces.lifecycle.InvokeApplicationPhase.execute(InvokeApplicationPhase.java:82)
at com.sun.faces.lifecycle.Phase.doPhase(Phase.java:100)
at com.sun.faces.lifecycle.LifecycleImpl.execute(LifecycleImpl.java:118)
at javax.faces.webapp.FacesServlet.service(FacesServlet.java:265)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.myfaces.webapp.filter.ExtensionsFilter.doFilter(ExtensionsFilter.java:246)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.ajax4jsf.webapp.BaseXMLFilter.doXmlFilter(BaseXMLFilter.java:141)
at org.ajax4jsf.webapp.BaseFilter.doFilter(BaseFilter.java:281)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.myfaces.webapp.filter.ExtensionsFilter.doFilter(ExtensionsFilter.java:301)
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:558)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
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:298)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:852)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
at java.lang.Thread.run(Thread.java:662)
Caused by: javax.faces.el.EvaluationException: org.hibernate.exception.SQLGrammarException: could not execute query using scroll
at javax.faces.component.MethodBindingMethodExpressionAdapter.invoke(MethodBindingMethodExpressionAdapter.java:102)
at com.sun.faces.application.ActionListenerImpl.processAction(ActionListenerImpl.java:102)
... 31 more
Caused by: org.hibernate.exception.SQLGrammarException: could not execute query using scroll
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:67)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
at org.hibernate.loader.Loader.scroll(Loader.java:2319)
at org.hibernate.loader.hql.QueryLoader.scroll(QueryLoader.java:438)
at org.hibernate.hql.ast.QueryTranslatorImpl.scroll(QueryTranslatorImpl.java:390)
at org.hibernate.engine.query.HQLQueryPlan.performScroll(HQLQueryPlan.java:245)
at org.hibernate.impl.SessionImpl.scroll(SessionImpl.java:1206)
at org.hibernate.impl.QueryImpl.scroll(QueryImpl.java:67)
at org.hibernate.impl.QueryImpl.scroll(QueryImpl.java:57)
at br.gov.framework.demoiselle.persistence.hibernate.HibernateGenericDAO.getTotalResults(HibernateGenericDAO.java:177)
at br.gov.framework.demoiselle.persistence.hibernate.HibernateGenericDAO.createPagedResult(HibernateGenericDAO.java:788)
at br.gov.framework.demoiselle.persistence.hibernate.HibernateGenericDAO.findHQL(HibernateGenericDAO.java:482)
at ao.edu.imag.avalia.persistence.dao.implementation.PerguntaAlunoDAO.listar(PerguntaAlunoDAO.java:33)
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 br.gov.framework.demoiselle.util.layer.integration.LazyCreateProxy.invoke(LazyCreateProxy.java:106)
at $Proxy7.listar(Unknown Source)
at ao.edu.imag.avalia.business.implementation.PerguntaAlunoBC.listar(PerguntaAlunoBC.java:49)
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 br.gov.framework.demoiselle.util.layer.integration.LazyCreateProxy.invoke(LazyCreateProxy.java:106)
at $Proxy6.listar(Unknown Source)
at ao.edu.imag.avalia.view.managedbean.PerguntaAlunoMB.atualizaListaAluno(PerguntaAlunoMB.java:145)
at ao.edu.imag.avalia.view.managedbean.PerguntaAlunoMB.listar(PerguntaAlunoMB.java:93)
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.el.parser.AstValue.invoke(AstValue.java:191)
at org.apache.el.MethodExpressionImpl.invoke(MethodExpressionImpl.java:276)
at com.sun.facelets.el.TagMethodExpression.invoke(TagMethodExpression.java:68)
at javax.faces.component.MethodBindingMethodExpressionAdapter.invoke(MethodBindingMethodExpressionAdapter.java:88)
... 32 more
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'avalia.pergunta_aluno' doesn't exist
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:407)
at com.mysql.jdbc.Util.getInstance(Util.java:382)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1052)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3593)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3525)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1986)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2140)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2626)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2111)
at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2273)
at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:186)
at org.hibernate.loader.Loader.getResultSet(Loader.java:1778)
at org.hibernate.loader.Loader.scroll(Loader.java:2284)
... 65 more
11/03/2011 23:51:20 com.sun.faces.lifecycle.Phase doPhase
GRAVE: JSF1054: (Phase ID: INVOKE_APPLICATION 5, View ID: /private/pages/default.xhtml) Exception thrown during phase execution: javax.faces.event.PhaseEvent[source=com.sun.faces.lifecycle.LifecycleImpl@db5b3f]
11/03/2011 23:51:20 org.apache.catalina.core.StandardWrapperValve invoke
GRAVE: Servlet.service() for servlet Faces Servlet threw exception
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'avalia.pergunta_aluno' doesn't exist
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:407)
at com.mysql.jdbc.Util.getInstance(Util.java:382)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1052)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3593)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3525)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1986)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2140)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2626)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2111)
at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2273)
at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:186)
at org.hibernate.loader.Loader.getResultSet(Loader.java:1778)
at org.hibernate.loader.Loader.scroll(Loader.java:2284)
at org.hibernate.loader.hql.QueryLoader.scroll(QueryLoader.java:438)
at org.hibernate.hql.ast.QueryTranslatorImpl.scroll(QueryTranslatorImpl.java:390)
at org.hibernate.engine.query.HQLQueryPlan.performScroll(HQLQueryPlan.java:245)
at org.hibernate.impl.SessionImpl.scroll(SessionImpl.java:1206)
at org.hibernate.impl.QueryImpl.scroll(QueryImpl.java:67)
at org.hibernate.impl.QueryImpl.scroll(QueryImpl.java:57)
at br.gov.framework.demoiselle.persistence.hibernate.HibernateGenericDAO.getTotalResults(HibernateGenericDAO.java:177)
at br.gov.framework.demoiselle.persistence.hibernate.HibernateGenericDAO.createPagedResult(HibernateGenericDAO.java:788)
at br.gov.framework.demoiselle.persistence.hibernate.HibernateGenericDAO.findHQL(HibernateGenericDAO.java:482)
at ao.edu.imag.avalia.persistence.dao.implementation.PerguntaAlunoDAO.listar(PerguntaAlunoDAO.java:33)
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 br.gov.framework.demoiselle.util.layer.integration.LazyCreateProxy.invoke(LazyCreateProxy.java:106)
at $Proxy7.listar(Unknown Source)
at ao.edu.imag.avalia.business.implementation.PerguntaAlunoBC.listar(PerguntaAlunoBC.java:49)
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 br.gov.framework.demoiselle.util.layer.integration.LazyCreateProxy.invoke(LazyCreateProxy.java:106)
at $Proxy6.listar(Unknown Source)
at ao.edu.imag.avalia.view.managedbean.PerguntaAlunoMB.atualizaListaAluno(PerguntaAlunoMB.java:145)
at ao.edu.imag.avalia.view.managedbean.PerguntaAlunoMB.listar(PerguntaAlunoMB.java:93)
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.el.parser.AstValue.invoke(AstValue.java:191)
at org.apache.el.MethodExpressionImpl.invoke(MethodExpressionImpl.java:276)
at com.sun.facelets.el.TagMethodExpression.invoke(TagMethodExpression.java:68)
at javax.faces.component.MethodBindingMethodExpressionAdapter.invoke(MethodBindingMethodExpressionAdapter.java:88)
at com.sun.faces.application.ActionListenerImpl.processAction(ActionListenerImpl.java:102)
at javax.faces.component.UICommand.broadcast(UICommand.java:387)
at org.ajax4jsf.component.AjaxViewRoot.processEvents(AjaxViewRoot.java:184)
at org.ajax4jsf.component.AjaxViewRoot.broadcastEvents(AjaxViewRoot.java:162)
at org.ajax4jsf.component.AjaxViewRoot.processApplication(AjaxViewRoot.java:350)
at com.sun.faces.lifecycle.InvokeApplicationPhase.execute(InvokeApplicationPhase.java:82)
at com.sun.faces.lifecycle.Phase.doPhase(Phase.java:100)
at com.sun.faces.lifecycle.LifecycleImpl.execute(LifecycleImpl.java:118)
at javax.faces.webapp.FacesServlet.service(FacesServlet.java:265)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.myfaces.webapp.filter.ExtensionsFilter.doFilter(ExtensionsFilter.java:246)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.ajax4jsf.webapp.BaseXMLFilter.doXmlFilter(BaseXMLFilter.java:141)
at org.ajax4jsf.webapp.BaseFilter.doFilter(BaseFilter.java:281)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.myfaces.webapp.filter.ExtensionsFilter.doFilter(ExtensionsFilter.java:301)
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:558)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
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:298)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:852)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
at java.lang.Thread.run(Thread.java:662)
