数据库使用 Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");错误说明: [Microsoft][ODBC SQL Server Driver]无效的描述符索引
错误地点:urldomain = rs.getString("urldomain");发送错误时候的sql(只是吧tblsearchurl.urldomain 放到最前面):sql = "select top 1 tblsearchurl.urldomain , tblsearchurl.id_pk, tblurlext.urlid_pk,tblurlext.id_fk, tblurlext.url as urlext, tblsearchurl.url as url1 from tblurlext ,tblsearchurl where tblurlext.isread=0 and tblurlext.id_fk=tblsearchurl.id_pk ";正确的时候的sql:
sql = "select top 1 tblsearchurl.id_pk, tblurlext.urlid_pk,tblurlext.id_fk, tblurlext.url as urlext, tblsearchurl.url as url1,tblsearchurl.urldomain from tblurlext ,tblsearchurl where tblurlext.isread=0 and tblurlext.id_fk=tblsearchurl.id_pk ";把sql放到查询分析器里运行没有问题。
不知道为什么,实在想不通。
错误地点:urldomain = rs.getString("urldomain");发送错误时候的sql(只是吧tblsearchurl.urldomain 放到最前面):sql = "select top 1 tblsearchurl.urldomain , tblsearchurl.id_pk, tblurlext.urlid_pk,tblurlext.id_fk, tblurlext.url as urlext, tblsearchurl.url as url1 from tblurlext ,tblsearchurl where tblurlext.isread=0 and tblurlext.id_fk=tblsearchurl.id_pk ";正确的时候的sql:
sql = "select top 1 tblsearchurl.id_pk, tblurlext.urlid_pk,tblurlext.id_fk, tblurlext.url as urlext, tblsearchurl.url as url1,tblsearchurl.urldomain from tblurlext ,tblsearchurl where tblurlext.isread=0 and tblurlext.id_fk=tblsearchurl.id_pk ";把sql放到查询分析器里运行没有问题。
不知道为什么,实在想不通。
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货