apch连接mysql数据库连接_连接mysql报错

2010-9-17 14:41:17 org.apache.catalina.core.AprLifecycleListener init

信息: The APR based Apache Tomcat Native library which allows optimal performanc

e in production environments was not found on the java.library.path: D:\tomcat6j

dk6mysql51\tomcat6jdk6mysql5\tomcat-6.0.16-asso\jdk1.6\jre\bin;.;C:\WINDOWS\Sun\

Java\bin;C:\WINDOWS\system32;C:\WINDOWS;D:\tomcat6jdk6mysql51\tomcat6jdk6mysql5\

tomcat-6.0.16-asso\jdk1.6\bin;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32

\Wbem

2010-9-17 14:41:17 org.apache.coyote.http11.Http11Protocol init

信息: Initializing Coyote HTTP/1.1 on http-8081

2010-9-17 14:41:17 org.apache.catalina.startup.Catalina load

信息: Initialization processed in 715 ms

2010-9-17 14:41:18 org.apache.catalina.core.StandardService start

信息: Starting service Catalina

2010-9-17 14:41:18 org.apache.catalina.core.StandardEngine start

信息: Starting Servlet Engine: Apache Tomcat/6.0.16

log4j:WARN No appenders could be found for logger (consult.util.HibernateThreadF

ilter).

log4j:WARN Please initialize the log4j system properly.

log4j:WARN No appenders could be found for logger (consult.util.HibernateThreadF

ilter).

log4j:WARN Please initialize the log4j system properly.

null邮件服务启动失败.

2010-9-17 14:41:34 org.apache.catalina.core.StandardContext addApplicationListen

er

信息: The listener "org.springframework.web.context.ContextLoaderListener" is al

ready configured for this context. The duplicate definition has been ignored.

2010-9-17 14:41:41 org.apache.coyote.http11.Http11Protocol start

信息: Starting Coyote HTTP/1.1 on http-8081

2010-9-17 14:41:41 org.apache.jk.common.ChannelSocket init

信息: JK: ajp13 listening on /0.0.0.0:8018

2010-9-17 14:41:41 org.apache.jk.server.JkMain start

信息: Jk running ID=0 time=0/31 config=null

2010-9-17 14:41:41 org.apache.catalina.startup.Catalina start

信息: Server startup in 23163 ms

select distinct(a.userid),a.userno,username,a.pwd from sys_users a where usern

o='admin'

com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown character set

: 'macce'

at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)

at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstruct

orAccessorImpl.java:39)

at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingC

onstructorAccessorImpl.java:27)

at java.lang.reflect.Constructor.newInstance(Constructor.java:513)

at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)

at com.mysql.jdbc.Util.getInstance(Util.java:381)

at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1030)

at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)

at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3491)

at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3423)

at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1936)

at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2060)

at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2536)

at com.mysql.jdbc.ConnectionImpl.configureClientCharacterSet(ConnectionI

mpl.java:1751)

at com.mysql.jdbc.ConnectionImpl.initializePropsFromServer(ConnectionImp

l.java:3425)

at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2045)

at com.mysql.jdbc.ConnectionImpl.(ConnectionImpl.java:718)

at com.mysql.jdbc.JDBC4Connection.(JDBC4Connection.java:46)

at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)

at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstruct

orAccessorImpl.java:39)

at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingC

onstructorAccessorImpl.java:27)

at java.lang.reflect.Constructor.newInstance(Constructor.java:513)

at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)

at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:302)

at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java

:282)

at java.sql.DriverManager.getConnection(DriverManager.java:582)

at java.sql.DriverManager.getConnection(DriverManager.java:185)

at com.Hwsoft.oa.util.DbUtil.openConnection(DbUtil.java:19)

at com.Hwsoft.oa.util.BaseDao.queryOne(BaseDao.java:116)

at com.Hwsoft.oa.dao.impl.sys.UserDaoImpl.checkLogin(UserDaoImpl.java:10

1)

at com.Hwsoft.oa.servlet.Login.doPost(Login.java:75)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:710)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl

icationFilterChain.java:290)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF

ilterChain.java:206)

at com.Hwsoft.oa.filter.EncodingFilter.doFilter(EncodingFilter.java:25)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl

icationFilterChain.java:235)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF

ilterChain.java:206)

at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperV

alve.java:233)

at org.apache.catalina.core.StandardContextValve.invoke(StandardContextV

alve.java:175)

at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.j

ava:128)

at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.j

ava:102)

at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:

568)

at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineVal

ve.java:109)

at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.jav

a:286)

at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java

:844)

at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.proce

ss(Http11Protocol.java:583)

at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:44

7)

at java.lang.Thread.run(Thread.java:619)

这是我连接mysql数据库用户名密码登陆时报的错，请问是什么原因我是用ssh做的

作者: dxb828

发布时间: 2010-09-17