帮忙给看一下，这是那个表里少了列名 'LASTOVERDUEREMINDER'

青岛融贯汇众 · 发表于 2014-12-5 14:46:18

本帖最后由 karrman 于 2016-2-29 21:32 编辑

java.sql.SQLException: 列名 'LASTOVERDUEREMINDER' 无效。
at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:368)
at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2816)
at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2254)
at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:631)
at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQLQuery(JtdsStatement.java:477)
at net.sourceforge.jtds.jdbc.JtdsPreparedStatement.executeQuery(JtdsPreparedStatement.java:777)
at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:93)
at cn.myapps.core.workflow.notification.dao.AbstractNotificationDAO.queryOverDuePending(AbstractNotificationDAO.java:92)
at cn.myapps.core.workflow.notification.ejb.NotificationProcessBean.getOverDueNotifications(NotificationProcessBean.java:278)
at cn.myapps.core.workflow.notification.ejb.NotificationProcessBean.notifyOverDueAuditors(NotificationProcessBean.java:222)
at cn.myapps.core.workflow.notification.ejb.NotificationJob.run(NotificationJob.java:36)
at java.util.TimerThread.mainLoop(Timer.java:512)
at java.util.TimerThread.run(Timer.java:462)
java.sql.SQLException: 列名 'LASTOVERDUEREMINDER' 无效。
at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:368)
at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2816)
at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2254)
at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:631)
at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQLQuery(JtdsStatement.java:477)
at net.sourceforge.jtds.jdbc.JtdsPreparedStatement.executeQuery(JtdsPreparedStatement.java:777)
at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:93)
at cn.myapps.core.workflow.notification.dao.AbstractNotificationDAO.queryOverDuePending(AbstractNotificationDAO.java:92)
at cn.myapps.core.workflow.notification.ejb.NotificationProcessBean.getOverDueNotifications(NotificationProcessBean.java:278)
at cn.myapps.core.workflow.notification.ejb.NotificationProcessBean.notifyOverDueAuditors(NotificationProcessBean.java:222)
at cn.myapps.core.workflow.notification.ejb.NotificationJob.run(NotificationJob.java:36)
at java.util.TimerThread.mainLoop(Timer.java:512)
at java.util.TimerThread.run(Timer.java:462)
java.sql.SQLException: 列名 'LASTOVERDUEREMINDER' 无效。
at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:368)
at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2816)
at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2254)
at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:631)
at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQLQuery(JtdsStatement.java:477)
at net.sourceforge.jtds.jdbc.JtdsPreparedStatement.executeQuery(JtdsPreparedStatement.java:777)
at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:93)
at cn.myapps.core.workflow.notification.dao.AbstractNotificationDAO.queryOverDuePending(AbstractNotificationDAO.java:92)
at cn.myapps.core.workflow.notification.ejb.NotificationProcessBean.getOverDueNotifications(NotificationProcessBean.java:278)
at cn.myapps.core.workflow.notification.ejb.NotificationProcessBean.notifyOverDueAuditors(NotificationProcessBean.java:222)
at cn.myapps.core.workflow.notification.ejb.NotificationJob.run(NotificationJob.java:36)
at java.util.TimerThread.mainLoop(Timer.java:512)
at java.util.TimerThread.run(Timer.java:462)

复制代码

lumi · 发表于 2014-12-5 15:35:41

去后台保存一下软件，就可以自动创建这个字段了

lumi · 发表于 2014-12-15 17:11:35

你好，帖子已经回复你，是否解决？

		自动登录	找回密码
密码			注册成为天翎用户

[其他] 帮忙给看一下，这是那个表里少了列名 'LASTOVERDUEREMINDER'

相关帖子