java.sql.SQLException: Unknown initial character set index '45' received from server.

最新推荐文章于 2024-07-10 21:58:42 发布
最新推荐文章于 2024-07-10 21:58:42 发布
阅读量2.4k 收藏 1
点赞数
分类专栏： mysql
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/sunyuhua_keyboard/article/details/95193209
版权

启动tomcat，链接mysql出现如下的错误，查询日志因为mysql大小写问题，程序里组装的mysql都是大写的sql，执行到mysql，mysql找不到对应的大写的mysql的表。

java.sql.SQLException: Unknown initial character set index '45' received from server. Initial client character set can be forced via the 'characterEncoding' property.
	com.mysql.jdbc.SQLError.createSQLException(SQLError.java:910)
	com.mysql.jdbc.Connection.configureClientCharacterSet(Connection.java:2345)
	com.mysql.jdbc.Connection.initializePropsFromServer(Connection.java:3913)
	com.mysql.jdbc.Connection.createNewIO(Connection.java:2683)
	com.mysql.jdbc.Connection.<init>(Connection.java:1531)
	com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:266)
	org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:37)
	org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:290)
	org.apache.commons.dbcp.BasicDataSource.validateConnectionFactory(BasicDataSource.java:877)
	org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:851)
	org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:540)
	org.springframework.jdbc.datasource.DataSourceTransactionManager.doBegin(DataSourceTransactionManager.java:202)
	org.springframework.transaction.support.AbstractPlatformTransactionManager.getTransaction(AbstractPlatformTransactionManager.java:371)
	org.springframework.transaction.interceptor.TransactionAspectSupport.createTransactionIfNecessary(TransactionAspectSupport.java:335)
	org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:105)
	org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
	org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:90)
	org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
	org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)
	com.sun.proxy.$Proxy21.queryForList(Unknown Source)
	com.fanya.daos.operator.impl.OperatorDaoImpl.qryOperator(OperatorDaoImpl.java:72)
	sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
	sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	java.lang.reflect.Method.invoke(Method.java:606)
	org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:318)
	org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
	org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
	org.springframework.aop.aspectj.MethodInvocationProceedingJoinPoint.proceed(MethodInvocationProceedingJoinPoint.java:80)
	com.fanya.interceptors.AuthorizationAspect.doDaoOperation(AuthorizationAspect.java:105)
	sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
	sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	java.lang.reflect.Method.invoke(Method.java:606)
	org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethodWithGivenArgs(AbstractAspectJAdvice.java:621)
	org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethod(AbstractAspectJAdvice.java:610)
	org.springframework.aop.aspectj.AspectJAroundAdvice.invoke(AspectJAroundAdvice.java:65)
	org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
	org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:90)
	org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
	org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)
	com.sun.proxy.$Proxy54.qryOperator(Unknown Source)
	com.fanya.services.operator.impl.OperatorServiceImpl.qryOperatorByName(OperatorServiceImpl.java:47)
	sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
	sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	java.lang.reflect.Method.invoke(Method.java:606)
	org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:318)
	org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
	org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
	org.springframework.aop.aspectj.MethodInvocationProceedingJoinPoint.proceed(MethodInvocationProceedingJoinPoint.java:80)
	com.fanya.interceptors.AuthorizationAspect.doServiceOperation(AuthorizationAspect.java:93)
	sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
	sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	java.lang.reflect.Method.invoke(Method.java:606)
	org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethodWithGivenArgs(AbstractAspectJAdvice.java:621)
	org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethod(AbstractAspectJAdvice.java:610)
	org.springframework.aop.aspectj.AspectJAroundAdvice.invoke(AspectJAroundAdvice.java:65)
	org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
	org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:90)
	org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
	org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)
	com.sun.proxy.$Proxy55.qryOperatorByName(Unknown Source)
	com.fanya.controllers.manage.permission.PermissionController.login(PermissionController.java:55)
	com.fanya.controllers.manage.permission.PermissionController$$FastClassByCGLIB$$56b4b9d8.invoke(<generated>)
	net.sf.cglib.proxy.MethodProxy.invoke(MethodProxy.java:149)
	org.springframework.aop.framework.Cglib2AopProxy$CglibMethodInvocation.invokeJoinpoint(Cglib2AopProxy.java:689)
	org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
	org.springframework.aop.aspectj.MethodInvocationProceedingJoinPoint.proceed(MethodInvocationProceedingJoinPoint.java:91)
	com.fanya.interceptors.AuthorizationAspect.doActionOperation(AuthorizationAspect.java:80)
	sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
	sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	java.lang.reflect.Method.invoke(Method.java:606)
	org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethodWithGivenArgs(AbstractAspectJAdvice.java:621)
	org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethod(AbstractAspectJAdvice.java:610)
	org.springframework.aop.aspectj.AspectJAroundAdvice.invoke(AspectJAroundAdvice.java:65)
	org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
	org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:90)
	org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
	org.springframework.aop.framework.Cglib2AopProxy$DynamicAdvisedInterceptor.intercept(Cglib2AopProxy.java:622)
	com.fanya.controllers.manage.permission.PermissionController$$EnhancerByCGLIB$$297512a8.login(<generated>)
	sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
	sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	java.lang.reflect.Method.invoke(Method.java:606)
	org.springframework.web.bind.annotation.support.HandlerMethodInvoker.invokeHandlerMethod(HandlerMethodInvoker.java:176)
	org.springframework.web.servlet.mvc.annotation.AnnotationMethodHandlerAdapter.invokeHandlerMethod(AnnotationMethodHandlerAdapter.java:436)
	org.springframework.web.servlet.mvc.annotation.AnnotationMethodHandlerAdapter.handle(AnnotationMethodHandlerAdapter.java:424)
	org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:900)
	org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:827)
	org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:882)
	org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:789)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:650)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:731)
	org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
	com.fanya.filter.PermissionFilter.doFilterInternal(PermissionFilter.java:33)
	org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76)
	org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:88)
	org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76)

com.common.exception.DaoException: org.springframework.jdbc.BadSqlGrammarException: PreparedStatementCallback; bad SQL grammar [SELECT M.PK_ID AS ID,M.F_USER_NAME AS USERNAME,M.F_PASSWORD AS PASSWORD,M.F_REAL_NAME AS REALNAME,M.F_POSITION AS POSITION,M.F_TYPE AS TYPE,R.FK_COMP_ID AS COMP_ID FROM T_MANAGER M LEFT JOIN T_COMP_MEMBER_REL R ON M.PK_ID=R.FK_MANAGER_ID WHERE (ISNULL(?) || LENGTH(TRIM(?)) < 1 || M.PK_ID=?) AND  (ISNULL(?) || LENGTH(TRIM(?)) < 1 || F_USER_NAME=?) AND (ISNULL(?) || LENGTH(TRIM(?)) < 1 || F_TYPE=?)]; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'mls.T_MANAGER' doesn't exist
	com.fanya.interceptors.AuthorizationAspect.doDaoOperation(AuthorizationAspect.java:108)
	sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
	sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	java.lang.reflect.Method.invoke(Method.java:606)
	org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethodWithGivenArgs(AbstractAspectJAdvice.java:621)
	org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethod(AbstractAspectJAdvice.java:610)
	org.springframework.aop.aspectj.AspectJAroundAdvice.invoke(AspectJAroundAdvice.java:65)
	org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
	org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:90)
	org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
	org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)
	com.sun.proxy.$Proxy54.qryOperator(Unknown Source)
	com.fanya.services.operator.impl.OperatorServiceImpl.qryOperatorByName(OperatorServiceImpl.java:47)
	sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
	sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	java.lang.reflect.Method.invoke(Method.java:606)
	org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:318)
	org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
	org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
	org.springframework.aop.aspectj.MethodInvocationProceedingJoinPoint.proceed(MethodInvocationProceedingJoinPoint.java:80)
	com.fanya.interceptors.AuthorizationAspect.doServiceOperation(AuthorizationAspect.java:93)
	sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
	sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	java.lang.reflect.Method.invoke(Method.java:606)
	org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethodWithGivenArgs(AbstractAspectJAdvice.java:621)
	org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethod(AbstractAspectJAdvice.java:610)
	org.springframework.aop.aspectj.AspectJAroundAdvice.invoke(AspectJAroundAdvice.java:65)
	org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
	org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:90)
	org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
	org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)
	com.sun.proxy.$Proxy55.qryOperatorByName(Unknown Source)
	com.fanya.controllers.manage.permission.PermissionController.login(PermissionController.java:55)
	com.fanya.controllers.manage.permission.PermissionController$$FastClassByCGLIB$$56b4b9d8.invoke(<generated>)
	net.sf.cglib.proxy.MethodProxy.invoke(MethodProxy.java:149)
	org.springframework.aop.framework.Cglib2AopProxy$CglibMethodInvocation.invokeJoinpoint(Cglib2AopProxy.java:689)
	org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
	org.springframework.aop.aspectj.MethodInvocationProceedingJoinPoint.proceed(MethodInvocationProceedingJoinPoint.java:91)
	com.fanya.interceptors.AuthorizationAspect.doActionOperation(AuthorizationAspect.java:80)
	sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
	sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	java.lang.reflect.Method.invoke(Method.java:606)
	org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethodWithGivenArgs(AbstractAspectJAdvice.java:621)
	org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethod(AbstractAspectJAdvice.java:610)
	org.springframework.aop.aspectj.AspectJAroundAdvice.invoke(AspectJAroundAdvice.java:65)
	org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
	org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:90)
	org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
	org.springframework.aop.framework.Cglib2AopProxy$DynamicAdvisedInterceptor.intercept(Cglib2AopProxy.java:622)
	com.fanya.controllers.manage.permission.PermissionController$$EnhancerByCGLIB$$a89c8d75.login(<generated>)
	sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
	sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	java.lang.reflect.Method.invoke(Method.java:606)
	org.springframework.web.bind.annotation.support.HandlerMethodInvoker.invokeHandlerMethod(HandlerMethodInvoker.java:176)
	org.springframework.web.servlet.mvc.annotation.AnnotationMethodHandlerAdapter.invokeHandlerMethod(AnnotationMethodHandlerAdapter.java:436)
	org.springframework.web.servlet.mvc.annotation.AnnotationMethodHandlerAdapter.handle(AnnotationMethodHandlerAdapter.java:424)
	org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:900)
	org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:827)
	org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:882)
	org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:789)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:650)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:731)
	org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
	com.fanya.filter.PermissionFilter.doFilterInternal(PermissionFilter.java:33)
	org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76)
	org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:88)
	org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76)

myql区分大小写，而之前的系统中的查询全部是大写。

在这里插入图片描述
取消mysql的大小写的方法

lower_case_table_names
表示表名是否大小写敏感，可以修改。

lower_case_table_names = 0时，mysql会根据表名直接操作，大小写敏感。
lower_case_table_names = 1时，mysql会先把表名转为小写，再执行操作。

修改完毕后，需要重启mysql。

重启完成后再次执行，错误消失。

MonkeyKing.sun
关注
  • 0
    点赞
  • 踩
  • 1
    收藏
    觉得还不错? 一键收藏
  • 打赏
    打赏
  • 3
    评论
专栏目录
java.sql.SQLException: Unknown initial character set index '255' received from server. Initial clien
inexaustible的博客
11-27 868
java.sql.SQLException: Unknown initial character set index '255' received from server. Initial client character set can be forced via the 'characterEncoding' property. at com.mysql.jdbc.SQLError.c...
Unknown initial character set index ‘45‘ received from server.java.sql.SQLException: Unknown initial
此时彼刻的蜗牛
10-22 598
Unknown initial character set index ‘45’ received from server.java.sql.SQLException: Unknown initial character set index ‘45’ received from server. Initial client character set can be forced via the ‘characterEncoding’ property. 解决方案： 1.MySQL版本低，需要升级 如果安装的
Java & SQL 连接（初级）
最新发布
2301_79600015的博客
07-10 1664
解析PreparedStatement ps = conn.prepareStatement( "UPDATE students1 SET NAME =?, gender =?◎- private：将类的属性声明为私有，只能在本类中访问，外部无法直接访问。注册驱动 + 加载驱动（DriverManager）原生的JDBC（数据库连接）
Unknown initial character set index '45' received from server. Initial client ch
tengxg的专栏
10-16 677
Unknown initial character set index '45' received from server. Initial client character set can be forced via the 'characterEncoding' property. 最初遇到这个问题，到网上查了一下，很多人都说是编码问题，并且好像符合错误的描述，但是经过我的不断判断与实验...
java.sql.SQLException Unknown initial character set index 45 received from server. Initial client
EraWalker的博客
06-04 736
java.sql.SQLException: Unknown initial character set index ‘45’ received from server. Initial client character set can be forced via the ‘characterEncoding’ property. 问题出现原因大多数使用了MySQL5.5的其他一些版本，java项目的部分jar包连接就会出现问题。比如今天看到出问题的就是 MySQL5.5 MariaDB 解决办法： 官方下
Unknown initial character set index '45' received from server
e891377的专栏
10-08 1562
出现这个数据库连接异常，可能是你们数据库太新，所以更新一下JDBC连接驱动，原来的是5.0.4 ，现在换成5.1.47.连接成功。 Unknown initial character set index '45' received from server. Initial client character set can be forced via the 'chara ...
java.sql.SQLException: null,  message from server: “Host ‘%’ is not allowed to connect to
12-14
java.sql.SQLException: null, message from server: “Host ‘223.72.41.7’ is not allowed to connect to this MySQL server” 客户端访问时报错： 解决方法： 1，登陆服务器 mysql> use mysql; //用mysql ...
java.sql.SQLException: 内部错误: Unable to construct a Datum from the specified input
01-21
Q: I am working with ... I am using updateBinaryStream method of resultset to update the BLOB field but it is failing after giving following exception java.sql.SQLException: Internal Error: Unable to
java.sql.SQLException: 结果集已耗尽
08-02
在Java编程中，`java.sql.SQLException: 结果集已耗尽` 是一个常见的错误提示，通常出现在处理数据库查询结果集时。这个异常表明程序试图访问已经没有数据的结果集中下一行，即所有行已经被遍历完，尝试访问超出范围...
java.sql.SQLException: 不支持的字符集 (在类路径中添加 orai18n.jar): ZHS16GBK
09-29
java.sql.SQLException: 不支持的字符集 (在类路径中添加 orai18n.jar): ZHS16GBK ……
Unknown initial character set index '45'问题
geqian0的博客
05-13 7909
前两天把在学校机房上的写好的一个小项目拷到自己电脑上，运行时就报了： Unknown initial character set index '45' received from server.java.sql.SQLException: Unknown initial character set index '45' received from server. Initial client c
Unknown initial character set index ‘45’ received
allgame029的博客
05-10 265
Unknown initial character set index ‘45’ received from server. Initial client character set can be forced via the ‘characterEncoding’ property. mysql jar 的版本问题, 同时lib下不能有多个jar。 mysql-connector-java-5.1.30
mysql问题，Unknown initial character set index '45' received from server
YueQingFeng445的博客
06-07 1871
mySQL安装后出现问题，eclipse编写插入汉字代码，出现标题错误和数据库中两个问号的问题。1.文件修改    复制my-default.ini文件，重命名为my.ini；这样根目录下就有两个.ini文件了，一个是my-default.ini，一个是my.ini。接下来我们只需修改my.ini里面的内容就行了；2.修改my.ini添加两行：default-character-set=utf8 ...
达梦数据库：迁移工具DMDTS报：unknown initial character set index 45
qq_37358909的博客
11-06 717
达梦数据库：迁移工具DMDTS报：unknown initial character set index 45 使用达梦数据库工具DMDTS ，数据源是mysql-5.7.24 在新建迁移时，创建数据源报 unknown initial character set index 45 详细的如图： 原因为DMDTS自带的驱动对应的mysql的版本为mysql-5.0.* 所以需要指定驱动 mysql-5.7.*对应的驱动下载链接为： 链接： https://pan.baidu.com/s/1zmYg-r
【已解决】Unknown initial character set index ‘45‘ received from server
yeliner的博客
09-07 321
出现这个数据库连接异常，可能是数据库太新，所以更新一下JDBC连接驱动，原来的是5.0.4 ，现在换成5.1.47.连接成功。
mysql 连接报错 java.sql.SQLException: Unknown initial character set index ‘45‘ received from server.
hehong4698的博客
03-23 149
原本使用的驱动版本为:mysql-connector-java-5.0.4-bin.jar。升级成:mysql-connector-java-5.1.46.jar 解决问题。
mysql java.sql.SQLException: Unknown initial character set index ‘255‘ received from server
qq 117791303
01-11 801
java.sql.SQLException: Unknown initial character set index '255' received from server. Initial client character set can be forced via the 'characterEncoding' property. Class.forName("com.mysql.jdbc.Driver"); private static String url = "jdbc:mysq...
Caused by: java.sql.SQLException: Unknown initial character set index '255'...
baiHoo.chen
08-15 5781
一些进一步的调查表明，这个问题完全是在MySQL V.8.0中进行的更改： 关于字符集支持 重要更改：        默认字符集已从latin1变成utf8mb4。 因而系统变量受到影响：     字符集的默认值 character_set_database ，其系统变量由 latin1 变成 utf8mb4 。而这个这个系统默认 collation_server 和 collocati...
Exception in thread "main" java.lang.RuntimeException: java.sql.SQLException: Unknown initial character set index '255'
06-01
这个错误通常是由于 JDBC 驱动程序无法识别数据库字符集引起的。这可能是由于以下原因之一导致的： 1. JDBC 驱动程序版本过旧，无法识别数据库字符集。 2. 数据库字符集设置不正确或不兼容 JDBC 驱动程序。...
评论 3
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包

打赏作者

MonkeyKing.sun

对你有帮助的话，可以打赏

¥1 ¥2 ¥4 ¥6 ¥10 ¥20
扫码支付：¥1
获取中
扫码支付

您的余额不足，请更换扫码支付或充值

打赏作者

实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值