jsp连接sybase数据库时,出现一条关于distinct的问题,请各位大虾帮助解决,一百分 是不是 select binary distinct name1 from table1 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 是呀,name1是文本型,是关键字还有一个文本型,也是关键字,name2吧,还有个id,数字型关键字,只有,id可以读,binary什么意思呀 binary什么意思呀 二进制吧 你看看数据库的书,distinct有要求列是什么类型的吗?我现在在家没条件看 我用Oracle9i没有问题!不如你到sybase区去搜索一下 String sql2="SELECT DISTINCT totalunitname FROM d_oncemoney ";执行就报错,String sql2="SELECT totalunitname FROM d_oncemoney ";就没有问题,String sql2="SELECT DISTINCT totalunitname,id1 FROM d_oncemoney ";也没有问题,id1也为关键字,单独的执行String sql2="SELECT DISTINCT id1 FROM d_oncemoney ";也可以错误提示:javax.servlet.ServletException: [Microsoft][ODBC ???????] ??????? org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:867) org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:800) org.apache.jsp.police.project.gs_005fonce_jsp._jspService(gs_005fonce_jsp.java:653) org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:133) javax.servlet.http.HttpServlet.service(HttpServlet.java:856) org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:311) org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:301) org.apache.jasper.servlet.JspServlet.service(JspServlet.java:248) javax.servlet.http.HttpServlet.service(HttpServlet.java:856)java.sql.SQLException: [Microsoft][ODBC ???????] ??????? sun.jdbc.odbc.JdbcOdbc.createSQLException(JdbcOdbc.java:6958) sun.jdbc.odbc.JdbcOdbc.standardError(JdbcOdbc.java:7115) sun.jdbc.odbc.JdbcOdbc.SQLGetDataString(JdbcOdbc.java:3908) sun.jdbc.odbc.JdbcOdbcResultSet.getDataString(JdbcOdbcResultSet.java:5699) sun.jdbc.odbc.JdbcOdbcResultSet.getString(JdbcOdbcResultSet.java:353) sun.jdbc.odbc.JdbcOdbcResultSet.getString(JdbcOdbcResultSet.java:410) org.apache.jsp.police.project.gs_005fonce_jsp._jspService(gs_005fonce_jsp.java:323) org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:133) javax.servlet.http.HttpServlet.service(HttpServlet.java:856) org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:311) org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:301) org.apache.jasper.servlet.JspServlet.service(JspServlet.java:248) javax.servlet.http.HttpServlet.service(HttpServlet.java:856) 我记得以前SYBASE数据库区分大小写的。你可以把字段值,及关键字等等都改成大写! String sql2="SELECT DISTINCT totalunitname FROM d_oncemoney ";执行就报错,字段名改成大写:String sql2="SELECT DISTINCT TOTALUNITNAME FROM D_ONCEMONEY";执行就报错, jsp实现多个条件查询功能 JAVA虚拟机JVM 和 SDK 如何安装? 表单接收数据的问题 struts2问题 求助毕业设计 jsp连接不上sql server session问题 请指点一下,如何把多个页面里form的数据一并提交? Tomcat启动后没有jdk sql加判断报错????????????????????????? 如何写一个JSP读目录的语句 请教javascript高手 对ACCESS2000数据库操作的问题.[更新数据]
还有一个文本型,也是关键字,name2吧,还有个id,数字型关键字,
只有,id可以读,binary什么意思呀
我现在在家没条件看
String sql2="SELECT totalunitname FROM d_oncemoney ";就没有问题,
String sql2="SELECT DISTINCT totalunitname,id1 FROM d_oncemoney ";也没有问题,id1也为关键字,
单独的执行String sql2="SELECT DISTINCT id1 FROM d_oncemoney ";也可以
错误提示:
javax.servlet.ServletException: [Microsoft][ODBC ???????] ???????
org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:867)
org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:800)
org.apache.jsp.police.project.gs_005fonce_jsp._jspService(gs_005fonce_jsp.java:653)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:133)
javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:311)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:301)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:248)
javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
java.sql.SQLException: [Microsoft][ODBC ???????] ???????
sun.jdbc.odbc.JdbcOdbc.createSQLException(JdbcOdbc.java:6958)
sun.jdbc.odbc.JdbcOdbc.standardError(JdbcOdbc.java:7115)
sun.jdbc.odbc.JdbcOdbc.SQLGetDataString(JdbcOdbc.java:3908)
sun.jdbc.odbc.JdbcOdbcResultSet.getDataString(JdbcOdbcResultSet.java:5699)
sun.jdbc.odbc.JdbcOdbcResultSet.getString(JdbcOdbcResultSet.java:353)
sun.jdbc.odbc.JdbcOdbcResultSet.getString(JdbcOdbcResultSet.java:410)
org.apache.jsp.police.project.gs_005fonce_jsp._jspService(gs_005fonce_jsp.java:323)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:133)
javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:311)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:301)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:248)
javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
字段名改成大写:
String sql2="SELECT DISTINCT TOTALUNITNAME FROM D_ONCEMONEY";执行就报错,