99 comentários

• Luciano Dias(usuário não autenticado)

  25 de Janeiro de 2010, 16:10

   

  Oi Mateus,

  O erro que você está tendo é "Connection refused", ou seja, a aplicação não está conseguindo se conectar ao banco de dados MySQL .

  Verifique as configurações para conexão ao banco de dados que estão no arquivo hibernate-config.xml. Você pode executar o seguinte comando no prompt do Windows para testar a conexão:

  mysql --user={usuario} --password={senha} --host=localhost --database=bancotalentos

  Substituindo {usuario} e {senha} pelas configurações existentes no hibernate-config.xml. Se você conseguir se conectar, então os parâmetros estão corretos e o problema deve ser outro.

  Talvez este tópico lhe ajude a resolver o problema de conexão com o banco MySQL.

  Um abraço,

  Luciano.

  
  

  • Mateus Belluzzo(usuário não autenticado)

    25 de Janeiro de 2010, 17:26

     

    Salve Luciano!!!

    Primeiramente muito obrigado pela pronta disposição.

    Não sei se para minha alegria ou tristeza, mas conectou certinho...rs...e agora...qual o próximo passo para verificar? Para ajudar segue algumas informações:

    Uso Mandriva 2007, Tomcat6, JRE1.6, MySQL 5.

    Ah e instalei dentro de /usr/local/apache-tomcat-6.0.20/lib o conector mysql-connector-java-5.1.11-bin.jar

     

    /etc/profile:

    # Inicio da Configuracao do Tomcat6
    JAVA_HOME=/usr/lib/jvm/java-1.6.0-sun-1.6.0.15/jre
    CATALINA_HOME=/usr/local/apache-tomcat-6.0.20
    TOMCAT_HOME=/usr/local/apache-tomcat-6.0.20
    CLASSPATH=$CATALINA_HOME/lib/mysql-connector-java-5.1.11-bin.jar:$CLASSPATH
    CLASSPATH=$CATALINA_HOME/lib/servlet-api.jar:$CLASSPATH
    CLASSPATH=$CATALINA_HOME/lib/jsp-api.jar:$CLASSPATH
    PATH=$PATH:$JAVA_HOME/bin
    export JAVA_HOME CATALINA_HOME TOMCAT_HOME CLASSPATH PATH
    # Fim da Configuracao do Tomcat6

     

    Variável PATH:

    /usr/local/bin:/bin:/usr/bin:/usr/lib/jvm/java-1.6.0-sun-1.6.0.15/jre/bin:/usr/games:/usr/lib/qt4/bin:/home/mateus/bin:/usr/lib/qt4/bin

     

    Se precisar de alguma informação adicional me avise, qualquer ajuda é bem vinda!

    
    

    • Luciano Dias(usuário não autenticado)

      26 de Janeiro de 2010, 15:44

       

      Mateus,

      Peço que você poste as seguintes informações:

      1) arquivo hibernate-config.xml localizado em TOMCAT_HOME/webapps/bancotalentos/WEB-INF/classes/;

      2) usuário e senha para conexão ao banco de dados e COM PERMISSÃO de acesso ao esquema bancotalentos e todas suas tabelas;

      3) arquivo de log completo do Tomcat (em TOMCAT_HOME/logs) com uma tentativa de logon na aplicação;

      Obs: suponho que seu banco de dados é o MySQL e está na mesma máquina que o servidor Tomcat, ou seja, você consegue acessar especificando a máquina "localhost".

      Um abraço,

      Luciano.

      
      
• Mateus Belluzzo(usuário não autenticado)

  26 de Janeiro de 2010, 15:32

   

  Só para atualizar o tópico, vou baixar o JDK 6u18 e tentar com ele ao invés do JRE.

  Mateus.

  
  
• Mateus Belluzzo(usuário não autenticado)

  26 de Janeiro de 2010, 17:29

   

  JDK instalado mas sem sucesso ainda...continua com o mesmo erro.

  Outrossim, passei a tarde vasculhando fórums de Java/MySQL e todas as alternativas NÃO resolveram o problema, dentre elas:

  1) Remover do arquivo /etc/my.cnf o parâmetro --skip-networking
  2) Alterar no hibernate-config.xml a URL de conexão tentando com o hostname ao invés de localhost
  3) Setar a variável do kernel para uma versão mais antiga: export LD_ASSUME_KERNEL=2.4.1 (essa foi a pior, desconfigurou todos os meus comandos e quase tive um treco, mas graças ao oráculo descobri que era só dar unset nela...rs)

  Bom, é isso...continuo na labuta e aguardando ajuda dos senhores...

   

  Mateus Belluzzo
  Prefeitura de Telêmaco Borba/PR

  
  
• Mateus Belluzzo(usuário não autenticado)

  26 de Janeiro de 2010, 17:30

   

  OPS...

  não tinha visto o seu post Luciano...vou pegar as informações e daí posto aqui...grato novamente.

  
  
• Mateus Belluzzo(usuário não autenticado)

  27 de Janeiro de 2010, 10:55

   

  Bom dia Luciano,

  Abaixo segue o que solicitou...resolvi postar também o log quando dei RELOAD na aplicação pelo Tomcat Manager, apareceu uma coisa estranha e destaquei em vermelho.

   

   TOMCAT_HOME/webapps/bancotalentos/WEB-INF/classes/hibernate-config.xml

  <persistencia-configuracao>

          <configuracao>
                  <propriedade caminhoModulosMapeamento="../config/" />
          </configuracao>

      <!-- Parametros de 'formatoConsultaDataBD':
          {0}: posição onde ficará a coluna do banco que contém a data, ex.: talento.datLancamento
               Se a coluna armazena também a hora, deve ser especificada uma função (de banco)
               que desconsidera a hora.
          {1}: posição onde ficará o sinal da operação, ex.: >=
          {2}: posição onde ficará a string que representa a data informada pelo usuário, ex.: 23/12/2004
               Deve ser especificada uma função de banco que converte essa string (no formato DD/MM/YYYY) em data.
      -->
      <!-- Propriedade 'queryConsultaTimeStampBD':
          A query especificada nessa propriedade deve retornar uma única coluna
          denominada 'timestamp' contendo a data e hora do banco de dados.
      -->

      <conexao nome="conexaoPadrao, conexaoDataHoraBD, conexaoSeguranca, conexaoAutenticacao">
          <property name="hibernate.show_sql">false</property>

          <!--
          <property name="hibernate.connection.datasource">java:comp/env/jdbc/TalentosDS</property>
          -->
          <property name="hibernate.dialect">org.hibernate.dialect.MySQLDialect</property>

          <property name="hibernate.connection.username">root</property>
          <property name="hibernate.connection.password">asd123</property>
          <property name="hibernate.connection.url">jdbc:mysql://localhost/bancotalentos?autoReconnect=true&amp;relaxAutoCommit=true</property>
          <property name="hibernate.connection.driver_class">com.mysql.jdbc.Driver</property>

          <substituicao chave="funcaoBDConverterStringEmData">STR_TO_DATE({0}, '%d/%m/%Y')</substituicao>
          <substituicao chave="funcaoBDRemoverHorasDeData">STR_TO_DATE(DATE_FORMAT({0}, '%d/%m/%Y'), '%d/%m/%Y')</substituicao>

          <substituicao chave="queryConsultaTimeStampBD">SELECT NOW() as timestamp</substituicao>

          <moduloMapeamento nomeArquivo="BancoTalentosApoio-hibernate.xml" caminhoRelativo="BancoTalentosApoio/hibernate-config/"/>
          <moduloMapeamento nomeArquivo="BancoTalentosGestao-hibernate.xml" caminhoRelativo="BancoTalentosGestao/hibernate-config/"/>

          <moduloMapeamento nomeArquivo="Seguranca-hibernate.xml" caminhoRelativo="Autenticacao/hibernate-config/"/>
      </conexao>

  </persistencia-configuracao>

   

   

  Log ao dar reload na aplicação pelo Tomcat Manager

  27/01/2010 10:49:33 org.apache.catalina.core.StandardContext reload
  INFO: Reloading this Context has started
  27/01/2010 10:49:33,714 |  | INFO | HibernatePlugIn (destroy:66) | Finalizando o HibernatePlugIn...
  27/01/2010 10:49:33,714 |  | INFO | HibernateUtilCD (finalizar:132) | Finalizando o HibernatePlugIn...
  27/01/2010 10:49:33,715 |  | INFO | GerenciadorConfiguracaoHibernate (finalizar:558) | ...Fechando a SessionFactory da conexão '0'...
  27/01/2010 10:49:33,715 |  | INFO | SessionFactoryImpl (close:769) | closing
  27/01/2010 10:49:33,715 |  | INFO | DriverManagerConnectionProvider (close:147) | cleaning up connection pool: jdbc:mysql://localhost/bancotalentos?autoReconnect=true&relaxAutoCommit=true
  27/01/2010 10:49:33,716 |  | INFO | HibernatePlugIn (destroy:66) | Finalizando o HibernatePlugIn...
  27/01/2010 10:49:33,716 |  | INFO | HibernateUtilCD (finalizar:132) | Finalizando o HibernatePlugIn...
  27/01/2010 10:49:33,716 |  | INFO | HibernatePlugIn (destroy:66) | Finalizando o HibernatePlugIn...
  27/01/2010 10:49:33,716 |  | INFO | HibernateUtilCD (finalizar:132) | Finalizando o HibernatePlugIn...
  27/01/2010 10:49:33,716 |  | INFO | HibernatePlugIn (destroy:66) | Finalizando o HibernatePlugIn...
  27/01/2010 10:49:33,717 |  | INFO | HibernateUtilCD (finalizar:132) | Finalizando o HibernatePlugIn...
  27/01/2010 10:49:33 org.apache.catalina.loader.WebappClassLoader loadClass
  INFO: Illegal access: this web application instance has been stopped already.  Could not load org.apache.log4j.spi.NOPLoggerRepository.  The eventual following stack trace is caused by an error thrown for debugging purposes as well as to attempt to terminate the thread which caused the illegal access, and has no functional impact.
  java.lang.IllegalStateException
          at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1273)
          at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1233)
          at org.apache.log4j.LogManager.getLoggerRepository(LogManager.java:175)
          at org.apache.log4j.LogManager.getLogger(LogManager.java:199)
          at org.apache.log4j.Logger.getLogger(Logger.java:105)
          at org.apache.commons.logging.impl.Log4JLogger.getLogger(Log4JLogger.java:289)
          at org.apache.commons.logging.impl.Log4JLogger.info(Log4JLogger.java:199)
          at org.hibernate.connection.DriverManagerConnectionProvider.close(DriverManagerConnectionProvider.java:147)
          at org.hibernate.connection.DriverManagerConnectionProvider.finalize(DriverManagerConnectionProvider.java:142)
          at java.lang.ref.Finalizer.invokeFinalizeMethod(Native Method)
          at java.lang.ref.Finalizer.runFinalizer(Finalizer.java:83)
          at java.lang.ref.Finalizer.access$100(Finalizer.java:14)
          at java.lang.ref.Finalizer$FinalizerThread.run(Finalizer.java:160)
  27/01/2010 10:49:34,118 |  | INFO | ResponseOverrideFilter (init:108) | Filter initialized. Response buffering is enabled
  27/01/2010 10:49:34,461 |  | INFO | TilesPlugin (initDefinitionsFactory:238) | Tiles definition factory loaded for module ''.
  27/01/2010 10:49:34,598 |  | INFO | GerenciadorConfiguracaoHibernate (iniciar:81) | Inicializando o gerenciador de configurações do Hibernate...
  27/01/2010 10:49:34,598 |  | INFO | GerenciadorConfiguracaoHibernate (iniciar:96) | Inicializando a conexão '0'
  27/01/2010 10:49:34,611 |  | INFO | Environment (<clinit>:514) | Hibernate 3.2.6
  27/01/2010 10:49:34,614 |  | INFO | Environment (<clinit>:547) | hibernate.properties not found
  27/01/2010 10:49:34,616 |  | INFO | Environment (buildBytecodeProvider:681) | Bytecode provider name : cglib
  27/01/2010 10:49:34,618 |  | INFO | Environment (<clinit>:598) | using JDK 1.4 java.sql.Timestamp handling
  27/01/2010 10:49:34,658 |  | INFO | Configuration (addResource:559) | Reading mappings from resource : br/gov/camara/negocio/autenticacaoperfil/hbm/UsuarioSistema.hbm.xml
  27/01/2010 10:49:34,721 |  | INFO | HbmBinder (bindRootPersistentClassCommonValues:300) | Mapping class: br.gov.camara.negocio.autenticacaoperfil.pojo.UsuarioSistema -> UsuarioSistema
  27/01/2010 10:49:34,772 |  | INFO | Configuration (addResource:559) | Reading mappings from resource : br/gov/camara/negocio/autenticacaoperfil/hbm/Sistema.hbm.xml
  27/01/2010 10:49:34,789 |  | INFO | HbmBinder (bindRootPersistentClassCommonValues:300) | Mapping class: br.gov.camara.negocio.autenticacaoperfil.pojo.Sistema -> Sistema
  27/01/2010 10:49:34,790 |  | INFO | Configuration (addResource:559) | Reading mappings from resource : br/gov/camara/negocio/autenticacaoperfil/hbm/PerfilSistema.hbm.xml
  27/01/2010 10:49:34,807 |  | INFO | HbmBinder (bindRootPersistentClassCommonValues:300) | Mapping class: br.gov.camara.negocio.autenticacaoperfil.pojo.PerfilSistema -> PerfilSistema
  27/01/2010 10:49:34,810 |  | INFO | HbmBinder (bindCollection:1419) | Mapping collection: br.gov.camara.negocio.autenticacaoperfil.pojo.PerfilSistema.grupos -> PerfilSistemaGrupo
  27/01/2010 10:49:34,812 |  | INFO | HbmBinder (bindCollection:1419) | Mapping collection: br.gov.camara.negocio.autenticacaoperfil.pojo.PerfilSistema.funcionalidades -> PerfilFuncionalidadeSistema
  27/01/2010 10:49:34,812 |  | INFO | Configuration (addResource:559) | Reading mappings from resource : br/gov/camara/negocio/autenticacaoperfil/hbm/FuncionalidadeSistema.hbm.xml
  27/01/2010 10:49:34,828 |  | INFO | HbmBinder (bindRootPersistentClassCommonValues:300) | Mapping class: br.gov.camara.negocio.autenticacaoperfil.pojo.FuncionalidadeSistema -> FuncionalidadeSistema
  27/01/2010 10:49:34,829 |  | INFO | Configuration (addResource:559) | Reading mappings from resource : br/gov/camara/negocio/autenticacaoperfil/hbm/GestorSistema.hbm.xml
  27/01/2010 10:49:34,844 |  | INFO | HbmBinder (bindRootPersistentClassCommonValues:300) | Mapping class: br.gov.camara.negocio.autenticacaoperfil.pojo.GestorSistema -> GestorSistema
  27/01/2010 10:49:34,845 |  | INFO | Configuration (addResource:559) | Reading mappings from resource : br/gov/camara/negocio/autenticacaoperfil/hbm/UsuarioPerfilSistema.hbm.xml
  27/01/2010 10:49:34,859 |  | INFO | HbmBinder (bindRootPersistentClassCommonValues:300) | Mapping class: br.gov.camara.negocio.autenticacaoperfil.pojo.UsuarioPerfilSistema -> UsuarioPerfilSistema
  27/01/2010 10:49:34,860 |  | INFO | Configuration (addResource:559) | Reading mappings from resource : br/gov/camara/negocio/autenticacaoperfil/hbm/Grupo.hbm.xml
  27/01/2010 10:49:34,874 |  | INFO | HbmBinder (bindRootPersistentClassCommonValues:300) | Mapping class: br.gov.camara.negocio.autenticacaoperfil.pojo.Grupo -> Grupo
  27/01/2010 10:49:34,875 |  | INFO | Configuration (addResource:559) | Reading mappings from resource : br/gov/camara/negocio/bancotalentos/hbm/AtributoTalento.hbm.xml
  27/01/2010 10:49:34,890 |  | INFO | HbmBinder (bindRootPersistentClassCommonValues:300) | Mapping class: br.gov.camara.negocio.bancotalentos.pojo.AtributoTalento -> AtributoTalento
  27/01/2010 10:49:34,892 |  | INFO | Configuration (addResource:559) | Reading mappings from resource : br/gov/camara/negocio/bancotalentos/hbm/AtributoTalentoOpcao.hbm.xml
  27/01/2010 10:49:34,906 |  | INFO | HbmBinder (bindRootPersistentClassCommonValues:300) | Mapping class: br.gov.camara.negocio.bancotalentos.pojo.AtributoTalentoOpcao -> AtributoTalentoOpcao
  27/01/2010 10:49:34,907 |  | INFO | Configuration (addResource:559) | Reading mappings from resource : br/gov/camara/negocio/bancotalentos/hbm/AtributoTalentoValorado.hbm.xml
  27/01/2010 10:49:34,925 |  | INFO | HbmBinder (bindRootPersistentClassCommonValues:300) | Mapping class: br.gov.camara.negocio.bancotalentos.pojo.AtributoTalentoValorado -> AtributoTalentoValorado
  27/01/2010 10:49:34,926 |  | INFO | Configuration (addResource:559) | Reading mappings from resource : br/gov/camara/negocio/bancotalentos/hbm/CategoriaAtributoTalento.hbm.xml
  27/01/2010 10:49:34,945 |  | INFO | HbmBinder (bindRootPersistentClassCommonValues:300) | Mapping class: br.gov.camara.negocio.bancotalentos.pojo.CategoriaAtributoTalento -> CategoriaAtributoTalento
  27/01/2010 10:49:34,947 |  | INFO | Configuration (addResource:559) | Reading mappings from resource : br/gov/camara/negocio/bancotalentos/hbm/CategoriaTalento.hbm.xml
  27/01/2010 10:49:34,968 |  | INFO | HbmBinder (bindRootPersistentClassCommonValues:300) | Mapping class: br.gov.camara.negocio.bancotalentos.pojo.CategoriaTalento -> CategoriaTalento
  27/01/2010 10:49:34,969 |  | INFO | HbmBinder (bindCollection:1419) | Mapping collection: br.gov.camara.negocio.bancotalentos.pojo.CategoriaTalento.gruposCategoriaTalento -> GrupoCategoriaTalento
  27/01/2010 10:49:34,969 |  | INFO | Configuration (addResource:559) | Reading mappings from resource : br/gov/camara/negocio/bancotalentos/hbm/Pessoa.hbm.xml
  27/01/2010 10:49:34,984 |  | INFO | HbmBinder (bindRootPersistentClassCommonValues:300) | Mapping class: br.gov.camara.negocio.bancotalentos.pojo.Pessoa -> SigespPessoal
  27/01/2010 10:49:34,985 |  | INFO | Configuration (addResource:559) | Reading mappings from resource : br/gov/camara/negocio/bancotalentos/hbm/Lotacao.hbm.xml
  27/01/2010 10:49:35,002 |  | INFO | HbmBinder (bindRootPersistentClassCommonValues:300) | Mapping class: br.gov.camara.negocio.bancotalentos.pojo.Lotacao -> SigespPessoalLotacao
  27/01/2010 10:49:35,003 |  | INFO | Configuration (addResource:559) | Reading mappings from resource : br/gov/camara/negocio/bancotalentos/hbm/TabelaApoioMM.hbm.xml
  27/01/2010 10:49:35,019 |  | INFO | HbmBinder (bindRootPersistentClassCommonValues:300) | Mapping class: br.gov.camara.negocio.bancotalentos.pojo.TabelaApoioMM -> TabelaApoioMM
  27/01/2010 10:49:35,019 |  | INFO | Configuration (addResource:559) | Reading mappings from resource : br/gov/camara/negocio/bancotalentos/hbm/Talento.hbm.xml
  27/01/2010 10:49:35,035 |  | INFO | HbmBinder (bindRootPersistentClassCommonValues:300) | Mapping class: br.gov.camara.negocio.bancotalentos.pojo.Talento -> Talento
  27/01/2010 10:49:35,036 |  | INFO | Configuration (addResource:559) | Reading mappings from resource : br/gov/camara/negocio/comum/hbm/TipoHTML.hbm.xml
  27/01/2010 10:49:35,047 |  | INFO | HbmBinder (bindRootPersistentClassCommonValues:300) | Mapping class: br.gov.camara.negocio.comum.pojo.TipoHTML -> TipoHTML
  27/01/2010 10:49:35,048 |  | INFO | Configuration (addResource:559) | Reading mappings from resource : br/gov/camara/negocio/bancotalentos/hbm/TipoFiltroConsulta.hbm.xml
  27/01/2010 10:49:35,058 |  | INFO | HbmBinder (bindRootPersistentClassCommonValues:300) | Mapping class: br.gov.camara.negocio.bancotalentos.pojo.TipoFiltroConsulta -> TipoFiltroConsulta
  27/01/2010 10:49:35,059 |  | INFO | Configuration (addResource:559) | Reading mappings from resource : br/gov/camara/negocio/bancotalentos/hbm/FiltroConsulta.hbm.xml
  27/01/2010 10:49:35,070 |  | INFO | HbmBinder (bindRootPersistentClassCommonValues:300) | Mapping class: br.gov.camara.negocio.bancotalentos.pojo.FiltroConsulta -> FiltroConsulta
  27/01/2010 10:49:35,071 |  | INFO | HbmBinder (bindCollection:1419) | Mapping collection: br.gov.camara.negocio.bancotalentos.pojo.FiltroConsulta.grupoCriterioConsulta -> GrupoCriterioConsulta
  27/01/2010 10:49:35,072 |  | INFO | HbmBinder (bindCollection:1419) | Mapping collection: br.gov.camara.negocio.bancotalentos.pojo.FiltroConsulta.filtroConsultaUsuario -> FiltroConsultaUsuario
  27/01/2010 10:49:35,072 |  | INFO | HbmBinder (bindCollection:1419) | Mapping collection: br.gov.camara.negocio.bancotalentos.pojo.FiltroConsulta.filtroConsultaGrupo -> FiltroConsultaGrupo
  27/01/2010 10:49:35,076 |  | INFO | HbmBinder (bindCollectionSecondPass:2382) | Mapping collection: br.gov.camara.negocio.bancotalentos.pojo.AtributoTalento.atributoTalentoOpcoes -> AtributoTalentoOpcao
  27/01/2010 10:49:35,076 |  | INFO | HbmBinder (bindCollectionSecondPass:2382) | Mapping collection: br.gov.camara.negocio.bancotalentos.pojo.CategoriaAtributoTalento.atributosTalentoValorados -> AtributoTalentoValorado
  27/01/2010 10:49:35,076 |  | INFO | HbmBinder (bindCollectionSecondPass:2382) | Mapping collection: br.gov.camara.negocio.bancotalentos.pojo.Pessoa.lotacoes -> SigespPessoalLotacao
  27/01/2010 10:49:35,117 |  | INFO | DriverManagerConnectionProvider (configure:41) | Using Hibernate built-in connection pool (not for production use!)
  27/01/2010 10:49:35,117 |  | INFO | DriverManagerConnectionProvider (configure:42) | Hibernate connection pool size: 20
  27/01/2010 10:49:35,117 |  | INFO | DriverManagerConnectionProvider (configure:45) | autocommit mode: false
  27/01/2010 10:49:35,120 |  | INFO | DriverManagerConnectionProvider (configure:80) | using driver: com.mysql.jdbc.Driver at URL: jdbc:mysql://localhost/bancotalentos?autoReconnect=true&relaxAutoCommit=true
  27/01/2010 10:49:35,120 |  | INFO | DriverManagerConnectionProvider (configure:86) | connection properties: {user=root, password=****, release_mode=on_close}
  27/01/2010 10:49:49,192 |  | WARN | SettingsFactory (buildSettings:117) | Could not obtain connection metadata
  java.sql.SQLException: Server connection failure during transaction. Due to underlying exception: 'java.sql.SQLException: Unknown initial character set index '192' received from server. Initial client character set can be forced via the 'characterEncoding' property.'.

  ** BEGIN NESTED EXCEPTION **

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

  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:2969)
          at com.mysql.jdbc.Connection.initializePropsFromServer(Connection.java:3215)
          at com.mysql.jdbc.Connection.createNewIO(Connection.java:1904)
          at com.mysql.jdbc.Connection.<init>(Connection.java:430)
          at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:268)
          at java.sql.DriverManager.getConnection(DriverManager.java:582)
          at java.sql.DriverManager.getConnection(DriverManager.java:154)
          at org.hibernate.connection.DriverManagerConnectionProvider.getConnection(DriverManagerConnectionProvider.java:110)
          at org.hibernate.cfg.SettingsFactory.buildSettings(SettingsFactory.java:84)
          at org.hibernate.cfg.Configuration.buildSettings(Configuration.java:2073)
          at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1298)
          at br.gov.camara.hibernate.GerenciadorConfiguracaoHibernate.iniciar(GerenciadorConfiguracaoHibernate.java:115)
          at br.gov.camara.hibernate.HibernateUtilCD.inicializar(HibernateUtilCD.java:102)
          at br.gov.camara.hibernate.HibernateUtilCD.inicializar(HibernateUtilCD.java:122)
          at sigesp.comum.util.hibernate.HibernatePlugIn.init(HibernatePlugIn.java:50)
          at org.apache.struts.action.ActionServlet.initModulePlugIns(ActionServlet.java:839)
          at org.apache.struts.action.ActionServlet.init(ActionServlet.java:332)
          at javax.servlet.GenericServlet.init(GenericServlet.java:212)
          at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1173)
          at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:993)
          at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:4149)
          at org.apache.catalina.core.StandardContext.start(StandardContext.java:4458)
          at org.apache.catalina.core.StandardContext.reload(StandardContext.java:3190)
          at org.apache.catalina.manager.ManagerServlet.reload(ManagerServlet.java:918)
          at org.apache.catalina.manager.HTMLManagerServlet.reload(HTMLManagerServlet.java:544)
          at org.apache.catalina.manager.HTMLManagerServlet.doGet(HTMLManagerServlet.java:121)
          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.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:525)
          at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
          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:849)
          at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)
          at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:454)
          at java.lang.Thread.run(Thread.java:619)

  ** END NESTED EXCEPTION **

  Attempted reconnect 3 times. Giving up.
          at com.mysql.jdbc.Connection.createNewIO(Connection.java:1954)
          at com.mysql.jdbc.Connection.<init>(Connection.java:430)
          at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:268)
          at java.sql.DriverManager.getConnection(DriverManager.java:582)
          at java.sql.DriverManager.getConnection(DriverManager.java:154)
          at org.hibernate.connection.DriverManagerConnectionProvider.getConnection(DriverManagerConnectionProvider.java:110)
          at org.hibernate.cfg.SettingsFactory.buildSettings(SettingsFactory.java:84)
          at org.hibernate.cfg.Configuration.buildSettings(Configuration.java:2073)
          at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1298)
          at br.gov.camara.hibernate.GerenciadorConfiguracaoHibernate.iniciar(GerenciadorConfiguracaoHibernate.java:115)
          at br.gov.camara.hibernate.HibernateUtilCD.inicializar(HibernateUtilCD.java:102)
          at br.gov.camara.hibernate.HibernateUtilCD.inicializar(HibernateUtilCD.java:122)
          at sigesp.comum.util.hibernate.HibernatePlugIn.init(HibernatePlugIn.java:50)
          at org.apache.struts.action.ActionServlet.initModulePlugIns(ActionServlet.java:839)
          at org.apache.struts.action.ActionServlet.init(ActionServlet.java:332)
          at javax.servlet.GenericServlet.init(GenericServlet.java:212)
          at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1173)
          at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:993)
          at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:4149)
          at org.apache.catalina.core.StandardContext.start(StandardContext.java:4458)
          at org.apache.catalina.core.StandardContext.reload(StandardContext.java:3190)
          at org.apache.catalina.manager.ManagerServlet.reload(ManagerServlet.java:918)
          at org.apache.catalina.manager.HTMLManagerServlet.reload(HTMLManagerServlet.java:544)
          at org.apache.catalina.manager.HTMLManagerServlet.doGet(HTMLManagerServlet.java:121)
          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.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:525)
          at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
          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:849)
          at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)
          at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:454)
          at java.lang.Thread.run(Thread.java:619)
  27/01/2010 10:49:49,203 |  | INFO | Dialect (<init>:152) | Using dialect: org.hibernate.dialect.MySQLDialect
  27/01/2010 10:49:49,206 |  | INFO | TransactionFactoryFactory (buildTransactionFactory:31) | Using default transaction strategy (direct JDBC transactions)
  27/01/2010 10:49:49,207 |  | INFO | TransactionManagerLookupFactory (getTransactionManagerLookup:33) | No TransactionManagerLookup configured (in JTA environment, use of read-write or transactional second-level cache is not recommended)
  27/01/2010 10:49:49,208 |  | INFO | SettingsFactory (buildSettings:143) | Automatic flush during beforeCompletion(): disabled
  27/01/2010 10:49:49,208 |  | INFO | SettingsFactory (buildSettings:147) | Automatic session close at end of transaction: disabled
  27/01/2010 10:49:49,209 |  | INFO | SettingsFactory (buildSettings:162) | Scrollable result sets: disabled
  27/01/2010 10:49:49,209 |  | INFO | SettingsFactory (buildSettings:170) | JDBC3 getGeneratedKeys(): disabled
  27/01/2010 10:49:49,209 |  | INFO | SettingsFactory (buildSettings:178) | Connection release mode: on_close
  27/01/2010 10:49:49,210 |  | INFO | SettingsFactory (buildSettings:202) | Maximum outer join fetch depth: 2
  27/01/2010 10:49:49,210 |  | INFO | SettingsFactory (buildSettings:205) | Default batch fetch size: 1
  27/01/2010 10:49:49,210 |  | INFO | SettingsFactory (buildSettings:209) | Generate SQL with comments: disabled
  27/01/2010 10:49:49,210 |  | INFO | SettingsFactory (buildSettings:213) | Order SQL updates by primary key: disabled
  27/01/2010 10:49:49,211 |  | INFO | SettingsFactory (buildSettings:217) | Order SQL inserts for batching: disabled
  27/01/2010 10:49:49,211 |  | INFO | SettingsFactory (createQueryTranslatorFactory:386) | Query translator: org.hibernate.hql.ast.ASTQueryTranslatorFactory
  27/01/2010 10:49:49,213 |  | INFO | ASTQueryTranslatorFactory (<init>:24) | Using ASTQueryTranslatorFactory
  27/01/2010 10:49:49,213 |  | INFO | SettingsFactory (buildSettings:225) | Query language substitutions: {}
  27/01/2010 10:49:49,213 |  | INFO | SettingsFactory (buildSettings:230) | JPA-QL strict compliance: disabled
  27/01/2010 10:49:49,213 |  | INFO | SettingsFactory (buildSettings:235) | Second-level cache: enabled
  27/01/2010 10:49:49,214 |  | INFO | SettingsFactory (buildSettings:239) | Query cache: disabled
  27/01/2010 10:49:49,214 |  | INFO | SettingsFactory (createCacheProvider:373) | Cache provider: org.hibernate.cache.NoCacheProvider
  27/01/2010 10:49:49,214 |  | INFO | SettingsFactory (buildSettings:254) | Optimize cache for minimal puts: disabled
  27/01/2010 10:49:49,214 |  | INFO | SettingsFactory (buildSettings:263) | Structured second-level cache entries: disabled
  27/01/2010 10:49:49,218 |  | INFO | SettingsFactory (buildSettings:290) | Statistics: disabled
  27/01/2010 10:49:49,218 |  | INFO | SettingsFactory (buildSettings:294) | Deleted entity synthetic identifier rollback: disabled
  27/01/2010 10:49:49,218 |  | INFO | SettingsFactory (buildSettings:309) | Default entity-mode: pojo
  27/01/2010 10:49:49,219 |  | INFO | SettingsFactory (buildSettings:313) | Named query checking : enabled
  27/01/2010 10:49:49,238 |  | INFO | SessionFactoryImpl (<init>:161) | building session factory
  27/01/2010 10:49:49,535 |  | INFO | SessionFactoryObjectFactory (addInstance:82) | Not binding factory to JNDI, no JNDI name configured
  27/01/2010 10:49:49,539 |  | INFO | GerenciadorConfiguracaoHibernate (iniciar:177) | ... fim da inicialização do gerenciador de configurações do Hibernate...
  27/01/2010 10:49:49,621 |  | INFO | TilesPlugin (initDefinitionsFactory:238) | Tiles definition factory loaded for module '/BancoTalentosApoio'.
  27/01/2010 10:49:49,631 |  | INFO | GerenciadorConfiguracaoHibernate (iniciar:74) | Gerenciador de configurações do Hibernate já inicializado
  27/01/2010 10:49:49,687 |  | INFO | TilesPlugin (initDefinitionsFactory:238) | Tiles definition factory loaded for module '/BancoTalentosGestao'.
  27/01/2010 10:49:49,701 |  | INFO | GerenciadorConfiguracaoHibernate (iniciar:74) | Gerenciador de configurações do Hibernate já inicializado
  27/01/2010 10:49:49,729 |  | INFO | TilesPlugin (initDefinitionsFactory:238) | Tiles definition factory loaded for module '/Autenticacao'.
  27/01/2010 10:49:49,739 |  | INFO | GerenciadorConfiguracaoHibernate (iniciar:74) | Gerenciador de configurações do Hibernate já inicializado

   

   

   Log ao tentar logar no BT

  27/01/2010 10:52:02,920 |  | INFO | TilesRequestProcessor (initDefinitionsMapping:105) | Tiles definition factory found for request processor ''.
  27/01/2010 10:52:02,971 |  | INFO | TilesRequestProcessor (initDefinitionsMapping:105) | Tiles definition factory found for request processor '/Autenticacao'.
  27/01/2010 10:52:42,740 |  | WARN | JDBCExceptionReporter (logExceptions:77) | SQL Error: 0, SQLState: 08001
  27/01/2010 10:52:42,741 |  | ERROR | JDBCExceptionReporter (logExceptions:78) | Server connection failure during transaction. Due to underlying exception: 'java.sql.SQLException: Unknown initial character set index '192' received from server. Initial client character set can be forced via the 'characterEncoding' property.'.

  ** BEGIN NESTED EXCEPTION **

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

  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:2969)
          at com.mysql.jdbc.Connection.initializePropsFromServer(Connection.java:3215)
          at com.mysql.jdbc.Connection.createNewIO(Connection.java:1904)
          at com.mysql.jdbc.Connection.<init>(Connection.java:430)
          at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:268)
          at java.sql.DriverManager.getConnection(DriverManager.java:582)
          at java.sql.DriverManager.getConnection(DriverManager.java:154)
          at org.hibernate.connection.DriverManagerConnectionProvider.getConnection(DriverManagerConnectionProvider.java:110)
          at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:423)
          at org.hibernate.jdbc.ConnectionManager.getConnection(ConnectionManager.java:144)
          at org.hibernate.jdbc.AbstractBatcher.prepareQueryStatement(AbstractBatcher.java:139)
          at org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:1547)
          at org.hibernate.loader.Loader.doQuery(Loader.java:673)
          at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:236)
          at org.hibernate.loader.Loader.doList(Loader.java:2213)
          at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2104)
          at org.hibernate.loader.Loader.list(Loader.java:2099)
          at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:378)
          at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:338)
          at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:172)
          at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1121)
          at org.hibernate.impl.QueryImpl.list(QueryImpl.java:79)
          at br.gov.camara.negocio.DAO.obter(DAO.java:254)
          at br.gov.camara.negocio.autenticacaoperfil.dao.UsuarioSistemaDAO.obterPeloLogin(UsuarioSistemaDAO.java:304)
          at br.gov.camara.negocio.autenticacaoperfil.facade.UsuarioSistemaFacade.obterPeloLogin(UsuarioSistemaFacade.java:119)
          at br.gov.camara.seguranca.implementacaobt.UnidadeAutenticadoraBT.autenticarUsuario(UnidadeAutenticadoraBT.java:63)
          at br.gov.camara.visao.autenticacao.sequencia.AutenticacaoSequencia.validarLogonEfetuarLogon(AutenticacaoSequencia.java:241)
          at br.gov.camara.visao.autenticacao.action.AutenticacaoAction.execute(AutenticacaoAction.java:122)
          at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:421)
          at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:226)
          at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1164)
          at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:415)
          at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
          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 sigesp.comum.util.hibernate.HibernateServletFilter.doFilter(HibernateServletFilter.java:59)
          at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
          at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
          at br.gov.camara.util.log4j.RequestInfoMDCFilter.doFilter(RequestInfoMDCFilter.java:83)
          at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
          at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
          at org.displaytag.filter.ResponseOverrideFilter.doFilter(ResponseOverrideFilter.java:125)
          at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
          at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
          at org.ajaxanywhere.AAFilter.doFilter(AAFilter.java:46)
          at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
          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:128)
          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:849)
          at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)
          at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:454)
          at java.lang.Thread.run(Thread.java:619)

  ** END NESTED EXCEPTION **

  Attempted reconnect 3 times. Giving up.
  27/01/2010 10:52:42,742 |  | ERROR | CDException (gerarLog:182) | 094848 | ST: br.gov.camara.negocio.DAO.obter(DAO.java:258)
  27/01/2010 10:52:42,743 |  | ERROR | CDException (gerarLog:182) | 094848 | ST: br.gov.camara.negocio.autenticacaoperfil.dao.UsuarioSistemaDAO.obterPeloLogin(UsuarioSistemaDAO.java:304)
  27/01/2010 10:52:42,743 |  | ERROR | CDException (gerarLog:182) | 094848 | ST: br.gov.camara.negocio.autenticacaoperfil.facade.UsuarioSistemaFacade.obterPeloLogin(UsuarioSistemaFacade.java:119)
  27/01/2010 10:52:42,743 |  | ERROR | CDException (gerarLog:182) | 094848 | ST: br.gov.camara.seguranca.implementacaobt.UnidadeAutenticadoraBT.autenticarUsuario(UnidadeAutenticadoraBT.java:63)
  27/01/2010 10:52:42,743 |  | ERROR | CDException (gerarLog:182) | 094848 | ST: br.gov.camara.visao.autenticacao.sequencia.AutenticacaoSequencia.validarLogonEfetuarLogon(AutenticacaoSequencia.java:241)
  27/01/2010 10:52:42,743 |  | ERROR | CDException (gerarLog:182) | 094848 | ST: br.gov.camara.visao.autenticacao.action.AutenticacaoAction.execute(AutenticacaoAction.java:122)
  27/01/2010 10:52:42,744 |  | ERROR | CDException (gerarLog:186) | 094848 | GM: (...) Cannot open connection | class br.gov.camara.negocio.exception.DAOException
  27/01/2010 10:52:42,745 |  | INFO | Mensagem (obterMensagem:67) | Erro desconhecido -> Server connection failure during transaction. Due to underlying exception: 'java.sql.SQLException: Unknown initial character set index '192' received from server. Initial client character set can be forced via the 'characterEncoding' property.'.

  ** BEGIN NESTED EXCEPTION **

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

  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:2969)
          at com.mysql.jdbc.Connection.initializePropsFromServer(Connection.java:3215)
          at com.mysql.jdbc.Connection.createNewIO(Connection.java:1904)
          at com.mysql.jdbc.Connection.<init>(Connection.java:430)
          at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:268)
          at java.sql.DriverManager.getConnection(DriverManager.java:582)
          at java.sql.DriverManager.getConnection(DriverManager.java:154)
          at org.hibernate.connection.DriverManagerConnectionProvider.getConnection(DriverManagerConnectionProvider.java:110)
          at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:423)
          at org.hibernate.jdbc.ConnectionManager.getConnection(ConnectionManager.java:144)
          at org.hibernate.jdbc.AbstractBatcher.prepareQueryStatement(AbstractBatcher.java:139)
          at org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:1547)
          at org.hibernate.loader.Loader.doQuery(Loader.java:673)
          at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:236)
          at org.hibernate.loader.Loader.doList(Loader.java:2213)
          at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2104)
          at org.hibernate.loader.Loader.list(Loader.java:2099)
          at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:378)
          at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:338)
          at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:172)
          at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1121)
          at org.hibernate.impl.QueryImpl.list(QueryImpl.java:79)
          at br.gov.camara.negocio.DAO.obter(DAO.java:254)
          at br.gov.camara.negocio.autenticacaoperfil.dao.UsuarioSistemaDAO.obterPeloLogin(UsuarioSistemaDAO.java:304)
          at br.gov.camara.negocio.autenticacaoperfil.facade.UsuarioSistemaFacade.obterPeloLogin(UsuarioSistemaFacade.java:119)
          at br.gov.camara.seguranca.implementacaobt.UnidadeAutenticadoraBT.autenticarUsuario(UnidadeAutenticadoraBT.java:63)
          at br.gov.camara.visao.autenticacao.sequencia.AutenticacaoSequencia.validarLogonEfetuarLogon(AutenticacaoSequencia.java:241)
          at br.gov.camara.visao.autenticacao.action.AutenticacaoAction.execute(AutenticacaoAction.java:122)
          at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:421)
          at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:226)
          at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1164)
          at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:415)
          at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
          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 sigesp.comum.util.hibernate.HibernateServletFilter.doFilter(HibernateServletFilter.java:59)
          at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
          at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
          at br.gov.camara.util.log4j.RequestInfoMDCFilter.doFilter(RequestInfoMDCFilter.java:83)
          at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
          at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
          at org.displaytag.filter.ResponseOverrideFilter.doFilter(ResponseOverrideFilter.java:125)
          at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
          at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
          at org.ajaxanywhere.AAFilter.doFilter(AAFilter.java:46)
          at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
          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:128)
          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:849)
          at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)
          at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:454)
          at java.lang.Thread.run(Thread.java:619)

  ** END NESTED EXCEPTION **

  Attempted reconnect 3 times. Giving up.
  27/01/2010 10:52:56,762 |  | WARN | JDBCExceptionReporter (logExceptions:77) | SQL Error: 0, SQLState: 08001
  27/01/2010 10:52:56,762 |  | ERROR | JDBCExceptionReporter (logExceptions:78) | Server connection failure during transaction. Due to underlying exception: 'java.sql.SQLException: Unknown initial character set index '192' received from server. Initial client character set can be forced via the 'characterEncoding' property.'.

  ** BEGIN NESTED EXCEPTION **

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

  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:2969)
          at com.mysql.jdbc.Connection.initializePropsFromServer(Connection.java:3215)
          at com.mysql.jdbc.Connection.createNewIO(Connection.java:1904)
          at com.mysql.jdbc.Connection.<init>(Connection.java:430)
          at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:268)
          at java.sql.DriverManager.getConnection(DriverManager.java:582)
          at java.sql.DriverManager.getConnection(DriverManager.java:154)
          at org.hibernate.connection.DriverManagerConnectionProvider.getConnection(DriverManagerConnectionProvider.java:110)
          at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:423)
          at org.hibernate.jdbc.ConnectionManager.getConnection(ConnectionManager.java:144)
          at org.hibernate.jdbc.BorrowedConnectionProxy.invoke(BorrowedConnectionProxy.java:57)
          at $Proxy1.commit(Unknown Source)
          at br.gov.camara.hibernate.ConexaoJDBC.realizarTransacao(ConexaoJDBC.java:58)
          at br.gov.camara.hibernate.FabricaSessaoHibernate.fecharSessao(FabricaSessaoHibernate.java:255)
          at br.gov.camara.hibernate.HibernateUtilCD.fecharSessao(HibernateUtilCD.java:254)
          at br.gov.camara.negocio.DAO.desconectar(DAO.java:111)
          at br.gov.camara.negocio.autenticacaoperfil.facade.UsuarioSistemaFacade.obterPeloLogin(UsuarioSistemaFacade.java:127)
          at br.gov.camara.seguranca.implementacaobt.UnidadeAutenticadoraBT.autenticarUsuario(UnidadeAutenticadoraBT.java:63)
          at br.gov.camara.visao.autenticacao.sequencia.AutenticacaoSequencia.validarLogonEfetuarLogon(AutenticacaoSequencia.java:241)
          at br.gov.camara.visao.autenticacao.action.AutenticacaoAction.execute(AutenticacaoAction.java:122)
          at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:421)
          at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:226)
          at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1164)
          at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:415)
          at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
          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 sigesp.comum.util.hibernate.HibernateServletFilter.doFilter(HibernateServletFilter.java:59)
          at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
          at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
          at br.gov.camara.util.log4j.RequestInfoMDCFilter.doFilter(RequestInfoMDCFilter.java:83)
          at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
          at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
          at org.displaytag.filter.ResponseOverrideFilter.doFilter(ResponseOverrideFilter.java:125)
          at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
          at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
          at org.ajaxanywhere.AAFilter.doFilter(AAFilter.java:46)
          at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
          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:128)
          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:849)
          at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)
          at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:454)
          at java.lang.Thread.run(Thread.java:619)

  ** END NESTED EXCEPTION **

  Attempted reconnect 3 times. Giving up.
  27/01/2010 10:52:56,765 |  | ERROR | UnidadeAutenticadoraBT (autenticarUsuario:102) | autenticarUsuario(String strLoginUsuario = M10001, String strSenhaUsuario = Senha) - catch
  br.gov.camara.negocio.exception.DAOException: Cannot open connection
          at br.gov.camara.negocio.DAO.obter(DAO.java:258)
          at br.gov.camara.negocio.autenticacaoperfil.dao.UsuarioSistemaDAO.obterPeloLogin(UsuarioSistemaDAO.java:304)
          at br.gov.camara.negocio.autenticacaoperfil.facade.UsuarioSistemaFacade.obterPeloLogin(UsuarioSistemaFacade.java:119)
          at br.gov.camara.seguranca.implementacaobt.UnidadeAutenticadoraBT.autenticarUsuario(UnidadeAutenticadoraBT.java:63)
          at br.gov.camara.visao.autenticacao.sequencia.AutenticacaoSequencia.validarLogonEfetuarLogon(AutenticacaoSequencia.java:241)
          at br.gov.camara.visao.autenticacao.action.AutenticacaoAction.execute(AutenticacaoAction.java:122)
          at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:421)
          at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:226)
          at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1164)
          at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:415)
          at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
          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 sigesp.comum.util.hibernate.HibernateServletFilter.doFilter(HibernateServletFilter.java:59)
          at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
          at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
          at br.gov.camara.util.log4j.RequestInfoMDCFilter.doFilter(RequestInfoMDCFilter.java:83)
          at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
          at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
          at org.displaytag.filter.ResponseOverrideFilter.doFilter(ResponseOverrideFilter.java:125)
          at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
          at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
          at org.ajaxanywhere.AAFilter.doFilter(AAFilter.java:46)
          at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
          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:128)
          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:849)
          at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)
          at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:454)
          at java.lang.Thread.run(Thread.java:619)
  Caused by: org.hibernate.exception.JDBCConnectionException: Cannot open connection
          at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:74)
          at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
          at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:29)
          at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:426)
          at org.hibernate.jdbc.ConnectionManager.getConnection(ConnectionManager.java:144)
          at org.hibernate.jdbc.AbstractBatcher.prepareQueryStatement(AbstractBatcher.java:139)
          at org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:1547)
          at org.hibernate.loader.Loader.doQuery(Loader.java:673)
          at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:236)
          at org.hibernate.loader.Loader.doList(Loader.java:2213)
          at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2104)
          at org.hibernate.loader.Loader.list(Loader.java:2099)
          at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:378)
          at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:338)
          at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:172)
          at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1121)
          at org.hibernate.impl.QueryImpl.list(QueryImpl.java:79)
          at br.gov.camara.negocio.DAO.obter(DAO.java:254)
          ... 35 more
  Caused by: java.sql.SQLException: Server connection failure during transaction. Due to underlying exception: 'java.sql.SQLException: Unknown initial character set index '192' received from server. Initial client character set can be forced via the 'characterEncoding' property.'.

  ** BEGIN NESTED EXCEPTION **

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

  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:2969)
          at com.mysql.jdbc.Connection.initializePropsFromServer(Connection.java:3215)
          at com.mysql.jdbc.Connection.createNewIO(Connection.java:1904)
          at com.mysql.jdbc.Connection.<init>(Connection.java:430)
          at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:268)
          at java.sql.DriverManager.getConnection(DriverManager.java:582)
          at java.sql.DriverManager.getConnection(DriverManager.java:154)
          at org.hibernate.connection.DriverManagerConnectionProvider.getConnection(DriverManagerConnectionProvider.java:110)
          at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:423)
          at org.hibernate.jdbc.ConnectionManager.getConnection(ConnectionManager.java:144)
          at org.hibernate.jdbc.AbstractBatcher.prepareQueryStatement(AbstractBatcher.java:139)
          at org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:1547)
          at org.hibernate.loader.Loader.doQuery(Loader.java:673)
          at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:236)
          at org.hibernate.loader.Loader.doList(Loader.java:2213)
          at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2104)
          at org.hibernate.loader.Loader.list(Loader.java:2099)
          at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:378)
          at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:338)
          at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:172)
          at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1121)
          at org.hibernate.impl.QueryImpl.list(QueryImpl.java:79)
          at br.gov.camara.negocio.DAO.obter(DAO.java:254)
          at br.gov.camara.negocio.autenticacaoperfil.dao.UsuarioSistemaDAO.obterPeloLogin(UsuarioSistemaDAO.java:304)
          at br.gov.camara.negocio.autenticacaoperfil.facade.UsuarioSistemaFacade.obterPeloLogin(UsuarioSistemaFacade.java:119)
          at br.gov.camara.seguranca.implementacaobt.UnidadeAutenticadoraBT.autenticarUsuario(UnidadeAutenticadoraBT.java:63)
          at br.gov.camara.visao.autenticacao.sequencia.AutenticacaoSequencia.validarLogonEfetuarLogon(AutenticacaoSequencia.java:241)
          at br.gov.camara.visao.autenticacao.action.AutenticacaoAction.execute(AutenticacaoAction.java:122)
          at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:421)
          at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:226)
          at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1164)
          at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:415)
          at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
          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 sigesp.comum.util.hibernate.HibernateServletFilter.doFilter(HibernateServletFilter.java:59)
          at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
          at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
          at br.gov.camara.util.log4j.RequestInfoMDCFilter.doFilter(RequestInfoMDCFilter.java:83)
          at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
          at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
          at org.displaytag.filter.ResponseOverrideFilter.doFilter(ResponseOverrideFilter.java:125)
          at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
          at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
          at org.ajaxanywhere.AAFilter.doFilter(AAFilter.java:46)
          at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
          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:128)
          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:849)
          at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)
          at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:454)
          at java.lang.Thread.run(Thread.java:619)

  ** END NESTED EXCEPTION **

  Attempted reconnect 3 times. Giving up.
          at com.mysql.jdbc.Connection.createNewIO(Connection.java:1954)
          at com.mysql.jdbc.Connection.<init>(Connection.java:430)
          at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:268)
          at java.sql.DriverManager.getConnection(DriverManager.java:582)
          at java.sql.DriverManager.getConnection(DriverManager.java:154)
          at org.hibernate.connection.DriverManagerConnectionProvider.getConnection(DriverManagerConnectionProvider.java:110)
          at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:423)
          ... 49 more
  27/01/2010 10:52:56,767 |  | INFO | AutenticacaoSequencia (validarLogonEfetuarLogon:271) | Logon inválido | M10001

  
  

  • Luciano Dias(usuário não autenticado)

    27 de Janeiro de 2010, 11:22

     

    Mateus,

    Eu procurei por "Unknown initial character set index '192' received from server" na internet e encontrei vários relatos relacionando essa mensagem com um "bug" do MySQL (http://bugs.mysql.com/bug.php?id=22456) ou um problema na distribuição do xampp (http://bugs.mysql.com/bug.php?id=26178).

    Existem várias sugestões de solução, mas não testei nenhuma visto que não tenho esse problema:

    - best​desi​gns.​co.i​n/bl​og/u​nkno​wn-i​niti​al-c​hara​cter​-set​-ind​ex-1​92-r​ecei​ved-​serv​er

    - bugs​.mys​ql.c​om/b​ug.p​hp?i​d=22​456&​nbsp​; (última mensagem)

    Tente uma delas e avise. De qualquer maneira, pelo arquivo de log, temos certeza que seu problema é de conexão com o banco de dados.

    Um abraço,

    Luciano.

    
    
• Mateus Belluzzo(usuário não autenticado)

  27 de Janeiro de 2010, 14:18

   

  E U R E K A !!!

   Não acredito que deu certo...!!!!...Que colírio: "Bem vindo ao Banco de Talentos" ...rsrsrs

  Muito obrigado Luciano...após 10 dias de labuta o sistema está no ar...agora não quero ouvir falar de Java pelo menos nos próximos 10 dias...rs

  A solução para o erro "Unknow initial character set index 192 received from server" foi essa:

  best​desi​gns.​co.i​n/bl​og/u​nkno​wn-i​niti​al-c​hara​cter​-set​-ind​ex-1​92-r​ecei​ved-​serv​er

  Simplesmente comentar duas linhas no /etc/my.cnf

  collation_server = utf8_unicode_ci
  character_set_server = utf8

   

  Fico te devendo uma gelada...forte abraço e vida longa!

   

  Mateus Belluzzo
  Prefeitura de Telêmaco Borba/PR