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语句的问题,建议你好好检查一下
