[RESOLVIDO] Dúvida sobre Validator (ExtJS 4 + Json + VRaptor 3.4.0)

rubens_inf · Maio 14, 2012, 11:31am

Sem usar o joda-time, ia ser mto dificil fazer soh com esse dateConverter? e outra coisa…;.o ext consegue formatar a data para o que vc quiser, mas nesse sentiodo de formatar o horário…nao ta dando certo…ele erstava em string e estava funcionando corretamente, mudei pra date ferrou tudo…continua com a anotação TIME? ou isso muda tb?

Lucas_Cavalcanti · Maio 14, 2012, 11:47am

dá pra fazer sim… o problema é vc selecionar qdo vai usar data, qdo vai ser hora e qdo vai ser data e hora…

tente criar a classe que eu falei… pra formatar e parsear a data use o SimpleDateFormat com os formatos respectivos

rubens_inf · Maio 14, 2012, 12:48pm

Tentei adicionar uma hora com o timefield do ext, e me vem o seguinte erro.

Caused by: org.springframework.dao.InvalidDataAccessResourceUsageException: could not execute query; SQL [select this_.id_config as id1_46_0_, this_.dia_semana as dia2_46_0_, this_.hr_fim as hr3_46_0_, this_.hr_inicio as hr4_46_0_ from config_hr_funcionamento this_]; nested exception is org.hibernate.exception.SQLGrammarException: could not execute query
at org.springframework.orm.hibernate3.SessionFactoryUtils.convertHibernateAccessException(SessionFactoryUtils.java:629)
at org.springframework.orm.hibernate3.HibernateAccessor.convertHibernateAccessException(HibernateAccessor.java:412)
at org.springframework.orm.hibernate3.HibernateTemplate.doExecute(HibernateTemplate.java:411)
at org.springframework.orm.hibernate3.HibernateTemplate.executeWithNativeSession(HibernateTemplate.java:374)
at org.springframework.orm.hibernate3.HibernateTemplate.loadAll(HibernateTemplate.java:584)
at org.cinemotion.dao.GenericDAO.list(GenericDAO.java:53)
at org.cinemotion.service.impl.GenericServiceImpl.list(GenericServiceImpl.java:39)
at sun.reflect.GeneratedMethodAccessor186.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:309)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:196)
at $Proxy291.list(Unknown Source)
at org.cinemotion.controller.ConfiguracaoFuncController.grid(ConfiguracaoFuncController.java:31)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at br.com.caelum.vraptor.interceptor.ExecuteMethodInterceptor.intercept(ExecuteMethodInterceptor.java:61)
… 65 more
Caused by: org.hibernate.exception.SQLGrammarException: could not execute query
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:90)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
at org.hibernate.loader.Loader.doList(Loader.java:2235)
at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2129)
at org.hibernate.loader.Loader.list(Loader.java:2124)
at org.hibernate.loader.criteria.CriteriaLoader.list(CriteriaLoader.java:118)
at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1597)
at org.hibernate.impl.CriteriaImpl.list(CriteriaImpl.java:306)
at org.springframework.orm.hibernate3.HibernateTemplate$5.doInHibernate(HibernateTemplate.java:590)
at org.springframework.orm.hibernate3.HibernateTemplate$5.doInHibernate(HibernateTemplate.java:1)
at org.springframework.orm.hibernate3.HibernateTemplate.doExecute(HibernateTemplate.java:406)
… 81 more
Caused by: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Table ‘cinemotionds.config_hr_funcionamento’ doesn’t exist
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2985)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1631)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1723)
at com.mysql.jdbc.Connection.execSQL(Connection.java:3256)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1313)
at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1448)
at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:208)
at org.hibernate.loader.Loader.getResultSet(Loader.java:1812)
at org.hibernate.loader.Loader.doQuery(Loader.java:697)
at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:259)
at org.hibernate.loader.Loader.doList(Loader.java:2232)
… 89 more

Lucas_Cavalcanti · Maio 14, 2012, 12:56pm

leia a exception até o final, principalmente os caused by’s:

Table ‘cinemotionds.config_hr_funcionamento’ doesn’t exist

rubens_inf · Maio 14, 2012, 12:58pm

Muito bem, fiz isso aqui o banco de dados eh o mesmo que eu e mais 2 usamos, um deles pode ter deletado por algum motivo, vou tentar de noivo qquer coisa aviso aqui, obrigado e desculpa.

rubens_inf · Maio 14, 2012, 1:37pm

Com string não dava esse erro abaixo, quando mudei pra Date começou a dar…

15:46:18,085 DEBUG [DefaultExceptionMapper] find for exception class java.lang.NullPointerException
Mai 14, 2012 3:46:18 PM org.apache.catalina.core.StandardWrapperValve invoke
Grave: Servlet.service() for servlet default threw exception
br.com.caelum.vraptor.InterceptionException: exception raised, check root cause for details: java.lang.NullPointerException
at br.com.caelum.vraptor.interceptor.ExecuteMethodInterceptor.intercept(ExecuteMethodInterceptor.java:96)
at br.com.caelum.vraptor.core.ToInstantiateInterceptorHandler.execute(ToInstantiateInterceptorHandler.java:54)
at br.com.caelum.vraptor.core.DefaultInterceptorStack.next(DefaultInterceptorStack.java:54)
at br.com.caelum.vraptor.core.LazyInterceptorHandler.execute(LazyInterceptorHandler.java:61)
at br.com.caelum.vraptor.core.DefaultInterceptorStack.next(DefaultInterceptorStack.java:54)
at br.com.caelum.vraptor.core.LazyInterceptorHandler.execute(LazyInterceptorHandler.java:61)
at br.com.caelum.vraptor.core.DefaultInterceptorStack.next(DefaultInterceptorStack.java:54)
at br.com.caelum.vraptor.interceptor.ExceptionHandlerInterceptor.intercept(ExceptionHandlerInterceptor.java:71)
at br.com.caelum.vraptor.core.ToInstantiateInterceptorHandler.execute(ToInstantiateInterceptorHandler.java:54)
at br.com.caelum.vraptor.core.DefaultInterceptorStack.next(DefaultInterceptorStack.java:54)
at br.com.caelum.vraptor.interceptor.InstantiateInterceptor.intercept(InstantiateInterceptor.java:48)
at br.com.caelum.vraptor.core.ToInstantiateInterceptorHandler.execute(ToInstantiateInterceptorHandler.java:54)
at br.com.caelum.vraptor.core.DefaultInterceptorStack.next(DefaultInterceptorStack.java:54)
at br.com.caelum.vraptor.interceptor.FlashInterceptor.intercept(FlashInterceptor.java:83)
at br.com.caelum.vraptor.core.ToInstantiateInterceptorHandler.execute(ToInstantiateInterceptorHandler.java:54)
at br.com.caelum.vraptor.core.DefaultInterceptorStack.next(DefaultInterceptorStack.java:54)
at br.com.caelum.vraptor.interceptor.ParametersInstantiatorInterceptor.intercept(ParametersInstantiatorInterceptor.java:93)
at br.com.caelum.vraptor.core.LazyInterceptorHandler.execute(LazyInterceptorHandler.java:59)
at br.com.caelum.vraptor.core.DefaultInterceptorStack.next(DefaultInterceptorStack.java:54)
at br.com.caelum.vraptor.interceptor.ResourceLookupInterceptor.intercept(ResourceLookupInterceptor.java:69)
at br.com.caelum.vraptor.core.ToInstantiateInterceptorHandler.execute(ToInstantiateInterceptorHandler.java:54)
at br.com.caelum.vraptor.core.DefaultInterceptorStack.next(DefaultInterceptorStack.java:54)
at br.com.caelum.vraptor.core.ToInstantiateInterceptorHandler.execute(ToInstantiateInterceptorHandler.java:56)
at br.com.caelum.vraptor.core.DefaultInterceptorStack.next(DefaultInterceptorStack.java:54)
at br.com.caelum.vraptor.core.EnhancedRequestExecution.execute(EnhancedRequestExecution.java:44)
at br.com.caelum.vraptor.VRaptor$1.insideRequest(VRaptor.java:91)
at br.com.caelum.vraptor.ioc.spring.SpringProvider.provideForRequest(SpringProvider.java:58)
at br.com.caelum.vraptor.VRaptor.doFilter(VRaptor.java:88)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:378)
at org.springframework.security.intercept.web.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:109)
at org.springframework.security.intercept.web.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:83)
at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
at org.springframework.security.ui.SessionFixationProtectionFilter.doFilterHttp(SessionFixationProtectionFilter.java:67)
at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
at org.springframework.security.ui.ExceptionTranslationFilter.doFilterHttp(ExceptionTranslationFilter.java:101)
at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
at org.springframework.security.wrapper.SecurityContextHolderAwareRequestFilter.doFilterHttp(SecurityContextHolderAwareRequestFilter.java:91)
at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
at org.springframework.security.ui.AbstractProcessingFilter.doFilterHttp(AbstractProcessingFilter.java:277)
at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
at org.springframework.security.ui.logout.LogoutFilter.doFilterHttp(LogoutFilter.java:89)
at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
at org.springframework.security.context.HttpSessionContextIntegrationFilter.doFilterHttp(HttpSessionContextIntegrationFilter.java:235)
at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
at org.springframework.security.util.FilterChainProxy.doFilter(FilterChainProxy.java:175)
at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:237)
at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:167)
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.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:293)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:859)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:602)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
at java.lang.Thread.run(Unknown Source)
Caused by: java.lang.NullPointerException
at org.cinemotion.controller.ConfiguracaoFuncController.salvar(ConfiguracaoFuncController.java:46)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at br.com.caelum.vraptor.interceptor.ExecuteMethodInterceptor.intercept(ExecuteMethodInterceptor.java:61)
… 66 more

meu método de salvar é esse…

[code] @Post
@Path("/configuracaofunc/salvar")
public void salvar(ConfiguracaoFuncionamento configuracaoFunc, List horarioInicial, List horarioFinal) throws Exception {

	//DateFormat formatter = new SimpleDateFormat("dd/MM/yyyy"); 
	//date = new java.sql.Date( ((java.util.Date)formatter.parse(configuracaoFunc.getHrFim())).getTime());
	/*Calendar c = Calendar.getInstance();
	Date hora = c.getTime();
	String date = hora.toString();
	System.out.println("dcddddddddddddd" + date);*/
 
	configuracaoFuncService.truncate();
	for (int i = 1; i <= 7; i++) {
		configuracaoFunc.setDiaSemana(i);
		configuracaoFunc.setHrInicio(horarioInicial.get(i));
		configuracaoFunc.setHrFim(horarioFinal.get(i));
		configuracaoFuncService.insert(configuracaoFunc);
		
	}
}
[/code]

Lucas_Cavalcanti · Maio 14, 2012, 1:58pm

de novo, leia o erro:

Caused by: java.lang.NullPointerException
at org.cinemotion.controller.ConfiguracaoFuncController.salvar(ConfiguracaoFuncController.java:46)

tem algo null nessa linha

rubens_inf · Maio 14, 2012, 2:44pm

Eu li isso, soh nao entendo pq com string funcionava corretamente…e mudando pra Date da tudo isso

Lucas_Cavalcanti · Maio 14, 2012, 2:50pm

possivelmente ele devia usar string vazia antes e agora que é Date vem null

rubens_inf · Maio 15, 2012, 8:59am

Desculpa a ignorância! já tentei aqui, chamei colega de serviço aqui, vi uns exemplos da net e não mudei isso, no forum do extJs ninguem me responde!
esse é meu método, como eu fugiria desse nullpointer…tem uma classe identica em outro sistema nosso…e nao dá isso…obrigado…

[code]@Path("/configuracaofunc/grid/dados.json")
public void grid() throws Exception {

	System.out.println("TEALA: "+configuracaoFuncService.list().size());
	result.use(ExtJSJson.class).from(configuracaoFuncService.list()).include("hrInicio").include("hrFim").serialize();
}


@Post
@Path("/configuracaofunc/salvar")
public void salvar(ConfiguracaoFuncionamento configuracaoFunc, List<Date> horarioInicial, List<Date> horarioFinal) throws Exception {
	
	//DateFormat formatter = new SimpleDateFormat("dd/MM/yyyy"); 
	//date = new java.sql.Date( ((java.util.Date)formatter.parse(configuracaoFunc.getHrFim())).getTime());
	/*Calendar c = Calendar.getInstance();
	Date hora = c.getTime();
	String date = hora.toString();
	System.out.println("dcddddddddddddd" + date);*/
 
	
	   
	
	
	configuracaoFuncService.truncate();
	
	for (int i = 1; i <= 7; i++) {
		
		configuracaoFunc.setDiaSemana(i);			
		configuracaoFunc.setHrInicio(horarioInicial.get(i));
		configuracaoFunc.setHrFim(horarioFinal.get(i));
		
		configuracaoFuncService.insert(configuracaoFunc);
		
	}
}
[/code]

Lucas_Cavalcanti · Maio 15, 2012, 9:32am

repito:

qual é essa linha? org.cinemotion.controller.ConfiguracaoFuncController.salvar(ConfiguracaoFuncController.java:46)

o que está null nela?

rubens_inf · Maio 15, 2012, 11:34am

configuracaoFuncService.truncate(); for (int i = 1; i <= 7; i++) { configuracaoFunc.setDiaSemana(i); configuracaoFunc.setHrInicio(horarioInicial.get(i)); configuracaoFunc.setHrFim(horarioFinal.get(i)); configuracaoFuncService.insert(configuracaoFunc);

É essa linha:

tem vez que da no truncate e as vezes eh nessa linha.

Lucas_Cavalcanti · Maio 15, 2012, 3:15pm

horarioInicial deve estar nulo, então provavelmente vc não está passando ele corretamente como parâmetro na requsição…

existe algum parametro horarioInicial, ou horarioInicial[] ou ainda horarioInicial[0]?

rubens_inf · Maio 15, 2012, 3:17pm

Opa Lucas consegui o timefield no extJs ele envia os dados como String comente, nao imprime Date!
converti o Date pra String e deu certo!

Obrigado.

preciso postar aqui o codigo? acho que dificilmente alguem passa por isso rs…soh noob como eu rs…

system · Janeiro 5, 2016, 4:56pm

[RESOLVIDO] Dúvida sobre Validator (ExtJS 4 + Json + VRaptor 3.4.0)

Cursos de Mobile

Cursos de Programação

Cursos de Front-end

Cursos de DevOps

Cursos de Design & UX

Cursos de Business

Cursos de Data & BI