当前位置:编程学习 > JAVA >>

出错了

at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1515)
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(SQLServerPreparedStatement.java:404)
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(SQLServerPreparedStatement.java:350)
at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:5696)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1715)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:180)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:155)
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.executeUpdate(SQLServerPreparedStatement.java:314)
at jp.co.nec.ome.connection.database.OmPreparedQuery.executeUpdate(OmPreparedQuery.java:229)
at jp.co.kintetsu_is.batch.ps.psm.common.dao.PsTPsTaskaToriatsukaiDao.delete(PsTPsTaskaToriatsukaiDao.java:144)
at jp.co.kintetsu_is.batch.ps.psmc.PPSMC0100.init(PPSMC0100.java:555)
at jp.co.nec.ome.application.console.OmBreakBatchApplication.execute(OmBreakBatchApplication.java:103)
at jp.co.kintetsu_is.batch.ps.psmc.PPSMC0100.main(PPSMC0100.java:474)
Statement  = [ DELETE FROM   T_PS_TASKA_TORIATSUKAI T01 WHERE   T01.HOKOKU_YMD = :HOKOKU_YMD AND   T01.HOKOKU_YMD = DATEADD(DAY,1,:GYOMU_DATE)]
Parameters = [{HOKOKU_YMD=20130328, GYOMU_DATE=20130328}]
--------------------编程问答-------------------- 做数据删除时不能用别名,
DELETE FROM  T_PS_TASKA_TORIATSUKAI WHERE HOKOKU_YMD = :HOKOKU_YMD AND   HOKOKU_YMD = DATEADD(DAY,1,:GYOMU_DATE)
补充:Java ,  Java SE
CopyRight © 2022 站长资源库 编程知识问答 zzzyk.com All Rights Reserved
部分文章来自网络,