用户信息保存时错误，，Http status 500

yuichao

在进行用户信息保存时，出现了Http satus 500-执行Action失败之类的

yuichao

yuichao

图..

liangyongfei

yuichao 发表于 2016-6-28 12:12
图..

看看后台的报错信息是什么？？请问你是baasServer 吗？？使用的公共action吗？？

其他案例可以正常新增数据吗？？

yuichao

这是我自己新建的Action，其它的案例都可以正常保存

jishuang

tomcat控制台的错误信息发一下

yuichao

六月 29, 2016 3:33:25 下午 org.apache.catalina.core.AprLifecycleListener init
信息: The APR based Apache Tomcat Native library which allows optimal performance in production environments was not found on the java.library.path: D:\WeX5_V3.4\java\jre1.8\bin;C:\Windows\Sun\Java\bin;C:\Windows\system32;C:\Windows;C:\Windows;C:\Windows\System32;C:\ProgramData\Oracle\Java\javapath;C:\Program Files (x86)\Intel\iCLS Client\;C:\Program Files\Intel\iCLS Client\;C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\System32\WindowsPowerShell\v1.0\;C:\Program Files\Intel\Intel(R) Management Engine Components\DAL;C:\Program Files (x86)\Intel\Intel(R) Management Engine Components\DAL;C:\Program Files\Intel\Intel(R) Management Engine Components\IPT;C:\Program Files (x86)\Intel\Intel(R) Management Engine Components\IPT;C:\Program Files (x86)\NVIDIA Corporation\PhysX\CommonC:\Program Files\Java\jdk1.8.0_91\bin;C:\Program Files\Java\jdk1.8.0_91\jre\bin;;.
六月 29, 2016 3:33:26 下午 org.apache.coyote.http11.Http11Protocol init
信息: Initializing Coyote HTTP/1.1 on http-8080
六月 29, 2016 3:33:26 下午 org.apache.catalina.startup.Catalina load
信息: Initialization processed in 490 ms
六月 29, 2016 3:33:26 下午 org.apache.catalina.core.StandardService start
信息: Starting service Catalina
六月 29, 2016 3:33:26 下午 org.apache.catalina.core.StandardEngine start
信息: Starting Servlet Engine: Apache Tomcat/6.0.41
六月 29, 2016 3:33:26 下午 org.apache.catalina.startup.HostConfig deployDescriptor
信息: Deploying configuration descriptor baas.xml
六月 29, 2016 3:33:26 下午 org.apache.catalina.loader.WebappClassLoader validateJarFile
信息: validateJarFile(D:\WeX5_V3.4\apache-tomcat\webapps\..\..\runtime\BaasServer\WEB-INF\lib\servlet-api.jar) - jar not loaded. See Servlet Spec 2.3, section 9.7.2. Offending class: javax/servlet/Servlet.class
六月 29, 2016 3:33:26 下午 org.apache.catalina.startup.HostConfig deployDescriptor
信息: Deploying configuration descriptor host-manager.xml
六月 29, 2016 3:33:26 下午 org.apache.catalina.startup.HostConfig deployDescriptor
信息: Deploying configuration descriptor manager.xml
六月 29, 2016 3:33:26 下午 org.apache.catalina.startup.HostConfig deployDescriptor
信息: Deploying configuration descriptor x5.xml
[JUSTEP_HOME in UIServer]: D:\WeX5_V3.4
六月 29, 2016 3:33:28 下午 org.apache.catalina.startup.HostConfig deployDirectory
信息: Deploying web application directory app-builder
六月 29, 2016 3:33:28 下午 org.apache.catalina.startup.HostConfig deployDirectory
信息: Deploying web application directory app-template
D:\WeX5_V3.4\apache-tomcat\webapps\app-template\ not found appMetadata_in_server.json
六月 29, 2016 3:33:28 下午 org.apache.catalina.startup.HostConfig deployDirectory
信息: Deploying web application directory docs
六月 29, 2016 3:33:28 下午 org.apache.catalina.startup.HostConfig deployDirectory
信息: Deploying web application directory examples
六月 29, 2016 3:33:28 下午 org.apache.catalina.core.ApplicationContext log
信息: ContextListener: contextInitialized()
六月 29, 2016 3:33:28 下午 org.apache.catalina.core.ApplicationContext log
信息: SessionListener: contextInitialized()
六月 29, 2016 3:33:28 下午 org.apache.catalina.startup.HostConfig deployDirectory
信息: Deploying web application directory ROOT
六月 29, 2016 3:33:28 下午 org.apache.coyote.http11.Http11Protocol start
信息: Starting Coyote HTTP/1.1 on http-8080
六月 29, 2016 3:33:28 下午 org.apache.jk.common.ChannelSocket init
信息: JK: ajp13 listening on /0.0.0.0:8009
六月 29, 2016 3:33:28 下午 org.apache.jk.server.JkMain start
信息: Jk running ID=0 time=0/17  config=null
六月 29, 2016 3:33:28 下午 org.apache.catalina.startup.Catalina start
信息: Server startup in 2452 ms
com.justep.baas.action.ActionException: Action[zhaowoya/zhaowoya/saveYonghuxinxi]执行失败，SQL执行失败，SQL:INSERT INTO yonghuxinxi (fID,fName,faddress,flianxidianhua,fshenfen)  VALUES (?,?,?,?,?)

yuichao

        at com.justep.baas.action.Engine.execAction(Unknown Source)
        at com.justep.baas.action.Engine.execAction(Unknown Source)
        at com.justep.baas.servlet.BaasServlet.execService(Unknown Source)
        at com.justep.baas.servlet.BaasServlet.service(Unknown Source)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
        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:103)
        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:861)
        at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:606)
        at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
        at java.lang.Thread.run(Thread.java:745)
Caused by: java.lang.reflect.InvocationTargetException
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.lang.reflect.Method.invoke(Method.java:497)
        ... 16 more
Caused by: com.justep.baas.data.sql.SQLException: SQL执行失败，SQL:INSERT INTO yonghuxinxi (fID,fName,faddress,flianxidianhua,fshenfen)  VALUES (?,?,?,?,?)
        at com.justep.baas.data.DataUtils.saveData(Unknown Source)
        at com.justep.baas.data.DataUtils.saveData(Unknown Source)
        at com.justep.baas.action.CRUD.save(Unknown Source)
        at zhaowoya.Zhaowoya__do.saveYonghuxinxi(Zhaowoya__do.java:75)
        ... 20 more
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Column 'fID' cannot be null
        at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
        at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
        at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
        at java.lang.reflect.Constructor.newInstance(Constructor.java:422)
        at com.mysql.jdbc.Util.handleNewInstance(Util.java:400)
        at com.mysql.jdbc.Util.getInstance(Util.java:383)
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:973)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3847)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3783)
        at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2447)
        at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2594)
        at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2545)
        at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1901)
        at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:1193)
        at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:172)
        at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:172)
        ... 24 more
六月 29, 2016 3:33:39 下午 org.apache.catalina.core.StandardWrapperValve invoke
严重: Servlet.service() for servlet WeX5_Baas_Servlet threw exception
com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Column 'fID' cannot be null
        at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
        at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
        at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
        at java.lang.reflect.Constructor.newInstance(Constructor.java:422)
        at com.mysql.jdbc.Util.handleNewInstance(Util.java:400)
        at com.mysql.jdbc.Util.getInstance(Util.java:383)
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:973)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3847)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3783)
        at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2447)
        at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2594)
        at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2545)
        at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1901)
        at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:1193)
        at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:172)
        at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:172)
        at com.justep.baas.data.DataUtils.saveData(Unknown Source)
        at com.justep.baas.data.DataUtils.saveData(Unknown Source)
        at com.justep.baas.action.CRUD.save(Unknown Source)
        at zhaowoya.Zhaowoya__do.saveYonghuxinxi(Zhaowoya__do.java:75)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.lang.reflect.Method.invoke(Method.java:497)
        at com.justep.baas.action.Engine.execAction(Unknown Source)
        at com.justep.baas.action.Engine.execAction(Unknown Source)
        at com.justep.baas.servlet.BaasServlet.execService(Unknown Source)
        at com.justep.baas.servlet.BaasServlet.service(Unknown Source)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
        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:103)
        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:861)
        at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:606)
        at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
        at java.lang.Thread.run(Thread.java:745)
我分开发的，，一个发不了

liangyongfei

yuichao 发表于 2016-6-29 15:36
at com.justep.baas.action.Engine.execAction(Unknown Source)
        at com.justep.baas.action.Engine.execA ...

Column 'fID' cannot be null


你的fID 这个字段是空的！主键不能为空！要么你设置数据库自动生成！要么就要使用个uuid 赋值这字段，再保存！

yuichao

liangyongfei 发表于 2016-6-30 10:46
Column 'fID' cannot be null

1. define(function(require){
   
2.         var $ = require("jquery");
   
3.         var justep = require("$UI/system/lib/justep");
   
4. 
   
5.         var Model = function(){
   
6.                 this.callParent();
   
7.                 this.userID;
   
8.                 this.loadUser = true;
   
9.         };
   
10. 
    
11.         Model.prototype.modelLoad = function(event){
    
12.             this.userID ="user";
    
13.             this.comp("userData1").setFilter("filterl","fID = '"+this.userID+"'");
    
14.         };
    
15. 
    
16.         Model.prototype.content4Active = function(event){
    
17.        if(this.loadUser)  {
    
18.        var userData1 = this.comp("userData1");
    
19.        userData1.refreshData();
    
20.        if(userData1.getCount() == 0) {
    
21.        userData1.newData({
    
22.            defaultValues:[{
    
23.                "fID":this.userID,
    
24.                "fName":"新用户",
    
25.                "fshenfen": "请填写商户、社团或个人"            
    
26.                   }]
    
27.               })
    
28.             }
    
29.              this.loadUser = false;
    
30.              }
    
31.         };
    
32.         Model.prototype.saveUserBtnClick = function(event){
    
33.         this.comp("userData1").saveData({
    
34.             "onSuccess":function(){
    
35.                 justep.Util.hint("用户信息保存成功")
    
36.             }
    
37.         })
    
38.         };
    
39.         return Model;
    
40. });

复制代码