Problem: Unknown initial character set index '192' received from server

[Jesus Rafael Lopez Ibarra]

Hi everyone!

does anyone have had this error?

           Unknown initial character set index '192' received from server. Initial client character set can be forced via the 'characterEncoding' property.

i want to try appfog database cocnection, i don't have any database now, y use the credential given by the VCAP_SERVICES variable.

I try to connect in this way:

            db ="";

           Class.forName("com.mysql.jdbc.Driver");

           Connection conexion = DriverManager.getConnection("jdbc:mysql://xxxx/"+db, "xxx", "xxx");

In the end this error appers:

Message:
           Unknown initial character set index '192' received from server. Initial client character set can be forced via the 'characterEncoding' property.

            (Stack trace at the end)

i've search a bit and i found out that  that the problem is solved by commenting out two lines of the my.ini file of mysql,  this two lines:

      #collation_server=utf8_unicode_ci
      #character_set_server=utf8

      from : http://gonithethinker.blogspot.mx/2012/07/unknown-initial-character-set-index-192.html

but, i don't know how to comment them out, or disable them via java

can anyone help me?

thanks in advance =D

.

.

.

.

StackTrace:
java.sql.SQLException: Unknown initial character set index '192' received from server. Initial client character set can be forced via the 'characterEncoding' property. at com.mysql.jdbc.Connection.configureClientCharacterSet(Connection.java:2268) at com.mysql.jdbc.Connection.initializePropsFromServer(Connection.java:3748) at com.mysql.jdbc.Connection.createNewIO(Connection.java:2585) at com.mysql.jdbc.Connection.(Connection.java:1485) at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:266) at java.sql.DriverManager.getConnection(Unknown Source) at java.sql.DriverManager.getConnection(Unknown Source) at com.mintakastar.test.DataBaseTest.connectTest(DataBaseTest.java:62) at com.mintakastar.test.DataBaseTest.test(DataBaseTest.java:25) at com.mintakastar.goodlife.rafa.RafaController.testDatabase(RafaController.java:91) at com.mintakastar.goodlife.rafa.RafaController.rafa(RafaController.java:76) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at org.springframework.web.method.support.InvocableHandlerMethod.invoke(InvocableHandlerMethod.java:213) at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:126) at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:96) at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:617) at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:578) at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:80) at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:923) at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:852) at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:882) at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:778) at javax.servlet.http.HttpServlet.service(HttpServlet.java:617) at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:859) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:602) at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489) at java.lang.Thread.run(Unknown Source) 

[Jesus Rafael Lopez Ibarra]

Hi it is SOLVED now..

If any one has the same problem , this is what was happening

     i was using mysql-connector-java-3.x-bin.jar, then after changing it  to mysql-connector-java-5.x-bin.jar and it worked well. 

Thanks any way!

Found from :

           https://stackoverflow.com/questions/11539757/cloudfoundry-spring-mysql-unknown-initial-character-set-index-192-received

[Jorge Portocarrero]

Hi Jesus, I'm having the same problem as you 

Unknown initial character set index '192' received from server. Initial client character set can be forced via the 'characterEncoding' property.

please can you explain me how did you solved it.

thanks a lot

[Jesus Rafael Lopez Ibarra]

Hi Jorge Portocarrero

    I don't remember well now, but, seeing my own reply that was the solution.

   You should be using  a connector (a driver, a jar , a library)  to connect to MySql,  look in your loaded  libraries that one called, "mysql-connector*.jar".

    see the version you have, it might be an old version, try to update it.

 

   In my case that time (2014), i was using 3.x version.. then i updated it to 5.x version. I didn't use maven that time, now using maven it is easier, i dunno if you are using it.

   here you can download the java connector : https://dev.mysql.com/downloads/connector/j/

   here is the list: https://dev.mysql.com/downloads/connector/

   It appears that , with maven , there is a 6.x version of the connector:

   The link:

        https://mvnrepository.com/artifact/mysql/mysql-connector-java/6.0.5

   The Maven tag to the pom file:

     <!-- https://mvnrepository.com/artifact/mysql/mysql-connector-java -->

     <dependency>

         <groupId>mysql</groupId>

         <artifactId>mysql-connector-java</artifactId>

         <version>6.0.5</version>

     </dependency>

I hope this help you!

Greetings