一条select语句(包含like),直接在mysql里运行是好的,在jsp里运行出错?
语句:
SELECT infoname,infovalues FROM truransysinfo WHERE infoname LIKE 'ANONYMITY_%'
错误提示(tomcat):
java.sql.SQLException: Illegal mix of collations (latin1_swedis
d (gb2312_chinese_ci,COERCIBLE) for operation 'like'
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1518
at com.mysql.jdbc.ServerPreparedStatement.serverPrepare
atement.java:1439)
at com.mysql.jdbc.ServerPreparedStatement.<init>(Server
.java:150)
at com.mysql.jdbc.Connection.prepareStatement(Connectio
at com.mysql.jdbc.Connection.prepareStatement(Connectio
at bf_com.utils.DBConnect.common(DBConnect.java:63)
at org.apache.jsp.usrlogin_jsp._jspService(usrlogin_jsp
at org.apache.jasper.runtime.HttpJspBase.service(HttpJs
at javax.servlet.http.HttpServlet.service(HttpServlet.j
at org.apache.jasper.servlet.JspServletWrapper.service(
.java:210)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(
95)
at org.apache.jasper.servlet.JspServlet.service(JspServ
at javax.servlet.http.HttpServlet.service(HttpServlet.j
at org.apache.catalina.core.ApplicationFilterChain.inte
icationFilterChain.java:247)
at org.apache.catalina.core.ApplicationFilterChain.doFi
ilterChain.java:193)
at org.apache.catalina.core.StandardWrapperValve.invoke
alve.java:256)
at org.apache.catalina.core.StandardPipeline$StandardPi
t.invokeNext(StandardPipeline.java:643)
at org.apache.catalina.core.StandardPipeline.invoke(Sta
a:480)
at org.apache.catalina.core.ContainerBase.invoke(Contai
at org.apache.catalina.core.StandardContextValve.invoke
alve.java:191)
at org.apache.catalina.core.StandardPipeline$StandardPi
t.invokeNext(StandardPipeline.java:643)
at org.apache.catalina.core.StandardPipeline.invoke(Sta
a:480)
at org.apache.catalina.core.ContainerBase.invoke(Contai
at org.apache.catalina.core.StandardContext.invoke(Stan
2422)
at org.apache.catalina.core.StandardHostValve.invoke(St
ava:180)
at org.apache.catalina.core.StandardPipeline$StandardPi
t.invokeNext(StandardPipeline.java:643)
at org.apache.catalina.valves.ErrorDispatcherValve.invo
rValve.java:171)
at org.apache.catalina.core.StandardPipeline$StandardPi
t.invokeNext(StandardPipeline.java:641)
at org.apache.catalina.valves.ErrorReportValve.invoke(E
ava:163)
at org.apache.catalina.core.StandardPipeline$StandardPi
t.invokeNext(StandardPipeline.java:641)
at org.apache.catalina.core.StandardPipeline.invoke(Sta
a:480)
at org.apache.catalina.core.ContainerBase.invoke(Contai
at org.apache.catalina.core.StandardEngineValve.invoke(
ve.java:174)
at org.apache.catalina.core.StandardPipeline$StandardPi
t.invokeNext(StandardPipeline.java:643)
at org.apache.catalina.core.StandardPipeline.invoke(Sta
a:480)
at org.apache.catalina.core.ContainerBase.invoke(Contai
at org.apache.coyote.tomcat4.CoyoteAdapter.service(Coyo
9)
at org.apache.coyote.http11.Http11Processor.process(Htt
:828)
at org.apache.coyote.http11.Http11Protocol$Http11Connec
ssConnection(Http11Protocol.java:700)
at org.apache.tomcat.util.net.TcpWorkerThread.runIt(Poo
:584)
at org.apache.tomcat.util.threads.ThreadPool$ControlRun
ool.java:683)
at java.lang.Thread.run(Thread.java:534)