困扰好几天了，求解决

[qq_32596027]

org.springframework.beans.TypeMismatchException: Failed to convert property value of type 'null' to required type 'byte' for property 'gender'; nested exception is java.lang.IllegalArgumentException: Cannot convert value of type [null] to required type [byte] for property 'gender': PropertyEditor [org.springframework.beans.propertyeditors.CustomNumberEditor] returned inappropriate value
at org.springframework.beans.BeanWrapperImpl.convertIfNecessary(BeanWrapperImpl.java:467)
at org.springframework.beans.BeanWrapperImpl.convertForProperty(BeanWrapperImpl.java:499)
at org.springframework.beans.BeanWrapperImpl.setPropertyValue(BeanWrapperImpl.java:1079)
at org.springframework.beans.BeanWrapperImpl.setPropertyValue(BeanWrapperImpl.java:880)
at org.springframework.jdbc.core.BeanPropertyRowMapper.mapRow(BeanPropertyRowMapper.java:252)
at org.springframework.jdbc.core.RowMapperResultSetExtractor.extractData(RowMapperResultSetExtractor.java:92)
at org.springframework.jdbc.core.RowMapperResultSetExtractor.extractData(RowMapperResultSetExtractor.java:1)
at org.springframework.jdbc.core.JdbcTemplate$1QueryStatementCallback.doInStatement(JdbcTemplate.java:445)
at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:395)
at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:455)
at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:463)
at com.cjkj.hwj.common.BaseDao.queryForList(BaseDao.java:87)
at com.cjkj.hwj.common.BaseDao.queryForObject(BaseDao.java:164)
at com.cjkj.hwj.common.BaseDao$$FastClassByCGLIB$$ff49786c.invoke(<generated>)
at net.sf.cglib.proxy.MethodProxy.invoke(MethodProxy.java:149)
at org.springframework.aop.framework.Cglib2AopProxy$DynamicAdvisedInterceptor.intercept(Cglib2AopProxy.java:617)
at com.cjkj.hwj.common.CommonDao$$EnhancerByCGLIB$$4b23946a.queryForObject(<generated>)
at com.cjkj.hwj.user.UserService.queryMembersByRoomId(UserService.java:448)
at com.cjkj.hwj.user.UserService$$FastClassByCGLIB$$1a91a9b5.invoke(<generated>)
at net.sf.cglib.proxy.MethodProxy.invoke(MethodProxy.java:149)
at org.springframework.aop.framework.Cglib2AopProxy$CglibMethodInvocation.invokeJoinpoint(Cglib2AopProxy.java:688)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:110)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:89)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
at org.springframework.aop.framework.Cglib2AopProxy$DynamicAdvisedInterceptor.intercept(Cglib2AopProxy.java:621)
at com.cjkj.hwj.user.UserService$$EnhancerByCGLIB$$d552fc23.queryMembersByRoomId(<generated>)
at com.cjkj.hwj.user.UserAction.queryMembersByRoomId(UserAction.java:436)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606)
at org.springframework.web.bind.annotation.support.HandlerMethodInvoker.invokeHandlerMethod(HandlerMethodInvoker.java:176)
at org.springframework.web.servlet.mvc.annotation.AnnotationMethodHandlerAdapter.invokeHandlerMethod(AnnotationMethodHandlerAdapter.java:426)
at org.springframework.web.servlet.mvc.annotation.AnnotationMethodHandlerAdapter.handle(AnnotationMethodHandlerAdapter.java:414)
at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:790)
at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:719)
at com.cjkj.hwj.common.EnCodingUtil.doService(EnCodingUtil.java:29)
at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:644)
at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:549)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:624)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:731)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)

at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:220)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:505)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:169)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)
at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:956)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:423)
at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1079)
at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:625)
at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:316)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
at java.lang.Thread.run(Thread.java:744)
Caused by: java.lang.IllegalArgumentException: Cannot convert value of type [null] to required type [byte] for property 'gender': PropertyEditor [org.springframework.beans.propertyeditors.CustomNumberEditor] returned inappropriate value
at org.springframework.beans.TypeConverterDelegate.convertIfNecessary(TypeConverterDelegate.java:227)
at org.springframework.beans.BeanWrapperImpl.convertIfNecessary(BeanWrapperImpl.java:447)
... 62 more

是因为数据库的值是空值吗，但是有的字段为空也能取出来啊(数据库里这些值可以为null啊)
而且 我带代码做了限定字段 给页面传的json字符串还是有那些没用的字段 而且值为0

[晓风吹雾]

Cannot convert value of type [null] to required type [byte] for property 'gender': gender 数据库的类型和mapping对象的类型 是什么？

[qq_32596027]

数据库是number(2) mapping对象是byte 逆向生成的

[晓风吹雾]

引用 2 楼 qq_32596027 的回复:

数据库是number(2) mapping对象是byte 逆向生成的

1 byte 和number(2) 能映射？ 2 byte不能为null

[qq_32596027]

对啊 我上网查说 oracle字段 Hibernate映射类型 java类型 number big_decimal java.math.BigDecimal number(1) boolean Boolean number(2)2至4之间 byte Byte number(8)4至8之间 integer Integer numbernumber(10)8以上 long Long 拿着怎么改

[What__If]

引用 4 楼 qq_32596027 的回复:

对啊 我上网查说 oracle字段 Hibernate映射类型 java类型 number big_decimal java.math.BigDecimal number(1) boolean Boolean number(2)2至4之间 byte Byte number(8)4至8之间 integer Integer numbernumber(10)8以上 long Long 拿着怎么改

byte改成Byte