日期:2014-05-17  浏览次数:21064 次

java.sql.SQLException: ORA-00933: SQL command not properly ended
java.sql.SQLException: ORA-00933: SQL command not properly ended,又没有遇到过,程序以前是正确的,后来我改了sql语句,sql单独运行也是正确的,但是放在java里就不行了。
sql:
sql = "select ORI_URL, count(*) as counter, count(*)/"+total+" as ratio "+
  "from KFWEB_VISIT"+
  "where ORI_URL not like '%192.168.0.200%' and ORI_URL not like '%192.168.0.100%' "+
  " group by ORI_URL"+
  " order by counter desc";

------解决方案--------------------
还是sql语句的问题,建议你好好检查一下