Menu ▾ ▴

#2 测试查询卡报错

1.0
open
hjbflzu
None
2016-03-24
2016-03-15
Chiva.Zhao
No

{"errmsg":"系统错误: 程序内部错误","errcode":20000}

请求参数如下：
cardno:A2021060100325
cardpwd:99187
isQuery:findCard

Discussion

  • Chiva.Zhao

    Chiva.Zhao - 2016-03-15

    测试URL：http://182.92.197.56:8090/login

     

  • Chiva.Zhao

    Chiva.Zhao - 2016-03-15
    • assigned_to: hjbflzu
     

  • hjbflzu

    hjbflzu - 2016-03-15
    • status: open --> accepted
     

  • hjbflzu

    hjbflzu - 2016-03-15

    这个还是去年说的那个数据的问题actbill 中 certType 是 int 型的，结果这个值是null，这种王雄修一下数据，使用默认值0吧，java是强类型的，null转int就会抛异常。建议数据库所有字段除了varchar之外都是not null的。

     

  • Benny Wang

    Benny Wang - 2016-03-15

    修改为0之后还是有下面的错误。
    [INFO 2016-03-15 22:06:00.459] [resin-port-8090-41] [0994187fb4bb4e6d9372d4a44650ab3a] net.paoding.rose.jade.context.JadeInvocationHandler.invoke(JadeInvocationHandler.java:131) [cost 3ms: com.ruibao.dao.RuiBaoDAO#getJob3
    sql: select job1_no, job2_no, no, name FROM ##(:1) WHERE job1_no = :2 AND job2_no = :3 AND no = :4
    parameters: :1='job3' :2='null' :3='null' :4='null' ]
    [INFO 2016-03-15 22:06:00.459] [resin-port-8090-41] [0994187fb4bb4e6d9372d4a44650ab3a] com.ruibao.dbmanager.Job3Manager.getJob3(Job3Manager.java:25) [finish getJob3, result= null]
    [DEBUG 2016-03-15 22:06:00.460] [resin-port-8090-41] [0994187fb4bb4e6d9372d4a44650ab3a] net.paoding.rose.web.impl.thread.ModuleEngine.execute(ModuleEngine.java:149) [exception happendedï¼› net.paoing.rose.web.impl.module.ErrorHandlerDispatcher will handle the exception: java.lang.NullPointerException:null]
    [ERROR 2016-03-15 22:06:00.460] [resin-port-8090-41] [0994187fb4bb4e6d9372d4a44650ab3a] com.ruibao.controllers.ErrorHandler.onError(ErrorHandler.java:18) [ruibao error]
    java.lang.NullPointerException
    at com.ruibao.controllers.IndexController.login(IndexController.java:73)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.

     

  • hjbflzu

    hjbflzu - 2016-03-16
    • status: accepted --> closed
     

  • Benny Wang

    Benny Wang - 2016-03-17
    • status: closed --> open
     

  • Benny Wang

    Benny Wang - 2016-03-17

    错误依旧！

     

  • hjbflzu

    hjbflzu - 2016-03-24
     

  • hjbflzu

    hjbflzu - 2016-03-24

    这个还是数据错误啊
    result= [com.ruibao.model.ActBill@133601d1[id=43,billNo=E01A2021060100325,cardNo=A2021060100325,passwd=99187,state=0,code=20,actMode=0,actPhone=13910007347,contractor=<null>,contraPhone=<null>,name=杨彦,certType=0,certNo=420101700214101,phone=<null>,sex=2,age=0,blood=N/A,anamnesis=<null>,avoidDrug=<null>,benefit1Name=法定,benefit1Share=100,benefit1Rel=4,benefit2Name=<null>,benefit2Share=0,benefit2Rel=4,contact1Name=<null>,contact1Phone=<null>,contact1Mobile=<null>,contact2Name=<null>,contact2Phone=<null>,contact2Mobile=<null>,validDate=2006-12-29 17:48:43.0,startDate=2007-01-01 00:00:00.0,endDate=2007-01-01 23:59:59.0,inDays=1,fee=5.0,disRate=100,operator=spihbm04,organ=OPICCH-1,insurNo=A,modiDate=<null>,payMark=0,cardnoPurity=A201060100325,email=<null>,addrPost=<null>,postcode=<null>,otherPhone=<null>,occupation=<null>,occupationText=<null>,serialNo=<null>,birthday=<null>,address=<null>,job1No=<null>,job2No=<null>,job3No=<null>,smsInfo=您的滑雪卡已被激活，人保健康祝您健康!,dateOffset=-1,appNo=<null>]]</null></null></null></null></null></null></null></null></null></null></null></null></null></null></null></null></null></null></null></null></null></null></null></null></null></null>

    actbill中查出来 job1No job2No job3No都为null啊。这几个字段有了就没问题

     

Log in to post a comment.

MongoDB Logo MongoDB