|
版本: |
BeX5V3.5 |
小版本号: |
|
|
|
数据库: |
MySQL |
服务器操作系统: |
Windows |
应用服务器: |
Tomcat |
客户端操作系统: |
Windows 其它 |
浏览器: |
Chrome |
|
|
在做excel导入功能时,提示:编码: JUSTEP150039; 提示: 执行sql:
已经参照了帖子:
http://bbs.wex5.com/forum.php?mod=viewthread&tid=206581&highlight=JUSTEP150210
http://bbs.wex5.com/thread-58270-1-1.html
但还是无法解决:
控制台报错如下:
Caused by: com.justep.exception.BusinessException: 编码: JUSTEP150210; 提示: 执行KSQL出错, KSQL: INSERT INTO VA_500ZCLZXB VA_500ZCLZXB(VA_500ZCLZXB, VA_500ZCLZXB.version, VA_500ZCLZXB.fMassDen, VA_500ZCLZXB.fMaterialName, VA_500ZCLZXB.fPSRatio, VA_500ZCLZXB.fShearModulus, VA_500ZCLZXB.fTXML, VA_500ZCLZXB.fTensileStrength, VA_500ZCLZXB.fThermalConductivity, VA_500ZCLZXB.fThermalExpansionCoefficient, VA_500ZCLZXB.fYieldStrength, VA_500ZCLZXB.fspecificHeat) VALUES (:VA_500ZCLZXB, :version, :fMassDen, :fMaterialName, :fPSRatio, :fShearModulus, :fTXML, :fTensileStrength, :fThermalConductivity, :fThermalExpansionCoefficient, :fYieldStrength, :fspecificHeat)
at com.justep.exception.BusinessException.create(Unknown Source)
at com.justep.system.data.impl.TableUtilsImplement.ksqlInsert(Unknown Source)
at com.justep.system.data.impl.TableUtilsImplement.ksqlExecuteUpdate(Unknown Source)
at com.justep.system.data.KSQL.executeUpdate(Unknown Source)
at com.justep.system.data.KSQL.executeUpdate(Unknown Source)
at com.justep.system.data.impl.TableImpl.insert(Unknown Source)
at com.justep.system.data.impl.TableImpl.save(Unknown Source)
at com.justep.system.data.impl.TableImpl.save(Unknown Source)
at com.justep.system.data.BizData.save(Unknown Source)
at BizProcedure.save(BizProcedure.java:18)
... 41 more
Caused by: com.justep.exception.BusinessException: 编码: JUSTEP150039; 提示: 执行sql: INSERT INTO VA_500ZCLZXB (VA_500ZCLZXB.fID, VA_500ZCLZXB.VERSION, VA_500ZCLZXB.FMASSDEN, VA_500ZCLZXB.FMATERIALNAME, VA_500ZCLZXB.FPSRATIO, VA_500ZCLZXB.FSHEARMODULUS, VA_500ZCLZXB.FTXML, VA_500ZCLZXB.FTENSILESTRENGTH, VA_500ZCLZXB.FTHERMALCONDUCTIVITY, VA_500ZCLZXB.FTHERMALEXPANSIONCOEFFICIENT, VA_500ZCLZXB.FYIELDSTRENGTH, VA_500ZCLZXB.FSPECIFICHEAT) VALUES ( ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ), binds: [2981027064E64B289D1D121F97CF3985, 0, 7900.0, Ductile Iron (SN) , 0.31, 7.7E+10, 1.2E+11, 8.61695E+8, 75.0, 0.000011, 5.51485E+8, 450.0]出错
at com.justep.exception.BusinessException.create(Unknown Source)
at com.justep.system.ksql.KSQLUtils.execSqlUpdate(Unknown Source)
... 50 more
Caused by: com.mysql.jdbc.MysqlDataTruncation: Data truncation: Out of range value for column 'fShearModulus' at row 1
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3845)
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.executeUpdate(PreparedStatement.java:2113)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2049)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2034)
at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
... 51 more
|
|