All about Cezar Apulchro

Special characters in MySQL DataBase.

I find out that the problem is not in mysql but in windows after an maintenance made by Samsung S Service. My mysql is fine.

1 week ago

JDBC and Relational Databases

Special characters in MySQL DataBase.

After to do the alter I executed in MySQL Workbench a Table inspect and DDL tab show me that character set still latin1 and collate latin1_swedish_ci.

1 week ago

Java in General

Special characters in MySQL DataBase.

After to make the alter the problem still the same.

1 week ago

Java in General

Special characters in MySQL DataBase.

Sorry but my problem is in MySQL and I don't saw an forum to open this topic.
I've a table defined with charset latin1 and collate latin1_swedish_ci but this table don't accepted character special.
The MySQL Workbench table inspector show in ddl tab this definition ie charset latin1 and collate latin1_swedish_ci. How to solve this problem?

Thanks and best regards.

1 week ago

Java in General

javax.persistence.TransactionRequiredException: no transaction is in progress

Realy I don't know, after delete the line of flush the problem was solved.

Thanks and best regards.

2 weeks ago

Java in General

javax.persistence.TransactionRequiredException: no transaction is in progress

I'm development a servlet class that get parameters from JSP and write in mysql table, to do this I'm using Hibernate 5.4, the problem is that after update my mysql table I receive this error.
Error generated:

HTTP Status 500 – Internal Server Error
Type Exception Report
Message no transaction is in progress
Description The server encountered an unexpected condition that prevented it from fulfilling the request.
Exception
javax.persistence.TransactionRequiredException: no transaction is in progress
org.hibernate.internal.AbstractSharedSessionContract.checkTransactionNeededForUpdateOperation(AbstractSharedSessionContract.java:422)
org.hibernate.internal.SessionImpl.checkTransactionNeededForUpdateOperation(SessionImpl.java:3397)
org.hibernate.internal.SessionImpl.doFlush(SessionImpl.java:1354)
org.hibernate.internal.SessionImpl.flush(SessionImpl.java:1349)
itc.systems.beans.SavUpdt.sveInsert(SavUpdt.java:30)
itc.systems.itcmedbr.Pre_Natal_S003.doPost(Pre_Natal_S003.java:230)
javax.servlet.http.HttpServlet.service(HttpServlet.java:660)
javax.servlet.http.HttpServlet.service(HttpServlet.java:741)
org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)
Note A pilha de erros completa da causa principal está disponível nos logs do servidor.
Apache Tomcat/9.0.33

HibernateUtil

package itc.systems.beans;
import org.hibernate.SessionFactory;
import org.hibernate.cfg.Configuration;
/**
*
* @author Cezar Apulchro
*/
public class HibernateUtil {
   
   //XML based configuration
   private static SessionFactory sessionFactory;
   
   private static SessionFactory buildSessionFactory() {
       
       try {
           
           // Create the SessionFactory from hibernate.cfg.xml
           Configuration configuration = new Configuration();
           
           configuration.configure("hibernate.cfg.xml");
           System.out.println("Hibernate Configuration Carregado...");
           
           SessionFactory sessionFactory = configuration.buildSessionFactory();
           
           return sessionFactory;
       }
       catch (Throwable ex)
       {
           // Make sure you log the exception, as it might be swallowed
           System.err.println("Initial SessionFactory - falhou a criação..." + ex);
           throw new ExceptionInInitializerError(ex);
       }
   }
   
   public static SessionFactory getSessionFactory() {
       
       if (sessionFactory == null) sessionFactory = buildSessionFactory();
       System.out.println("Vai retornar o getSessionFactory....");
       return sessionFactory;
   }
 
}

Class to save:

Once again, all the parameters geted in my servlet is recorded in my mysql table.

Thanks in advanced.

2 weeks ago

Java in General

SQLSyntaxErrorException: You have an error in your SQL syntax;

I don't believe, only a comma.
Thanks guys.

4 weeks ago

JDBC and Relational Databases

SQLSyntaxErrorException: You have an error in your SQL syntax;

I've others methods that do the same thing in other tables and other columns, in all the tables i've an common column called "CNPJ" and I insert when necessary without problem but in this servlet my method to insert in the mysql table I'm receiving this error.
Method to save:

if ("Salvar".equals(botaoacao))
       {
           prontuario = request.getParameter("prontuario");
           historico = request.getParameter("consulta").trim();
           peso = request.getParameter("peso");
           prsmax = request.getParameter("pmax");
           prsmin = request.getParameter("pmin");
           
           SimpleDateFormat dataF = new SimpleDateFormat("dd/MM/yyyy");
           Date dataconsulta = new Date();
           String dataFC = dataF.format(dataconsulta);            
           String historicoF = "\r\n" + "Data: " + dataFC + "--------" + historico + "\r\n";
           
           dpaciente.setCPF(prontuario);
           dpaciente.setHistory_Paciente(historicoF);
           dpaciente.setPeso(peso);
           dpaciente.setPressao_Max(prsmax);
           dpaciente.setPressao_Min(prsmin);
           dpaciente.setDataConsulta(dataFC);
           dpaciente.setCnpj(cnpj);
           System.out.println("CNPJ: " + cnpj);
           System.out.println("Data Consulta: " + dataFC);
           pcdao.updateHistory(dpaciente, cnpj);
           
           RequestDispatcher retorna = request.getRequestDispatcher("Consulta_Pacientes_W001.jsp");
                   retorna.forward(request, response);
       }

Method called to save:

public void updateHistory (DadosPaciente Tabela_Historico_Medico, String CNPJ)
   {
       String sqlUpdateHistory = "INSERT INTO Tabela_Historico_Medico" +
               "(Prontuario, Historico, Peso, Pressao_Max, Pressao_Min " +
               "Data_Consulta, CNPJ)" +
               "values(?,?,?,?,?,?,?)";
       
       try
       {            
           PreparedStatement pstmInput;
           pstmInput = conectar.prepareStatement(sqlUpdateHistory);
           
           pstmInput.setString(1, Tabela_Historico_Medico.getCPF());
           pstmInput.setString(2, Tabela_Historico_Medico.getHistory_Paciente());
           pstmInput.setString(3, Tabela_Historico_Medico.getPeso());
           pstmInput.setString(4, Tabela_Historico_Medico.getPressao_Max());
           pstmInput.setString(5, Tabela_Historico_Medico.getPressao_Min());
           pstmInput.setString(6, Tabela_Historico_Medico.getDataConsulta());
           pstmInput.setString(7, Tabela_Historico_Medico.getCnpj());
           
           pstmInput.executeUpdate();
           pstmInput.close();
       }
       catch (SQLException e)
       {
           e.printStackTrace();
           System.out.println("Problemas na gravação: " + e);
       }
   }

Error generated:

CNPJ: 04.377.802/0001-76
Data Consulta: 05/01/2023
Problemas na gravação: java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Data_Consulta, CNPJ)values('203.203.203-20','\r\nData: 05/01/2023--------fadjdad' at line 1
Send Pront.: 203.203.203-20
Conectando DB...
Conectando DB...
java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Data_Consulta, CNPJ)values('203.203.203-20','\r\nData: 05/01/2023--------fadjdad' at line 1
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:120)
at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)
at com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:953)
at com.mysql.cj.jdbc.ClientPreparedStatement.executeUpdateInternal(ClientPreparedStatement.java:1092)
at com.mysql.cj.jdbc.ClientPreparedStatement.executeUpdateInternal(ClientPreparedStatement.java:1040)
at com.mysql.cj.jdbc.ClientPreparedStatement.executeLargeUpdate(ClientPreparedStatement.java:1348)
at com.mysql.cj.jdbc.ClientPreparedStatement.executeUpdate(ClientPreparedStatement.java:1025)
at itc.systems.beans.PacientesDAO_W01.updateHistory(PacientesDAO_W01.java:1054)
at itc.systems.itcmedbr.Agenda_Consulta_Pacientes_S001.doPost(Agenda_Consulta_Pacientes_S001.java:224)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:660)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:741)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:202)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:541)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:139)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92)
at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:688)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343)
at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:373)
at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65)
at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:868)
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1594)
at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1136)
at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:635)
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
at java.base/java.lang.Thread.run(Thread.java:833)

Thanks in advanced.

4 weeks ago

JDBC and Relational Databases

Fiddler result:

3 months ago

After increase connectionTimeout and set disableUploadTimeout="true" I am receiving 404 not found in my page.

3 months ago

3 months ago

The fiddler that I downloaded is a free trial in this copy I don't have how to configure other options.

3 months ago

Java in General

400 Bad Request

Result of Access-Control-Request-Headers Fiddler composer:
Raw field:

HTTP/1.1 200 OK
Date: Sat, 29 Oct 2022 11:03:20 GMT
Server: Apache/2.4.52 (Ubuntu)
Last-Modified: Mon, 24 Oct 2022 14:24:47 GMT
ETag: "29af-5ebc88dc287a0"
Accept-Ranges: bytes
Content-Length: 10671
Vary: Accept-Encoding
Content-Type: text/html
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
 
 <head>
   <meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
   <title>Apache2 Ubuntu Default Page: It works</title>
   <style type="text/css" media="screen">
 * {
   margin: 0px 0px 0px 0px;
   padding: 0px 0px 0px 0px;
 }
 body, html {
   padding: 3px 3px 3px 3px;
   background-color: #D8DBE2;
   font-family: Ubuntu, Verdana, sans-serif;
   font-size: 11pt;
   text-align: center;
 }
 div.main_page {
   position: relative;
   display: table;
   width: 800px;
   margin-bottom: 3px;
   margin-left: auto;
   margin-right: auto;
   padding: 0px 0px 0px 0px;
   border-width: 2px;
   border-color: #212738;
   border-style: solid;
   background-color: #FFFFFF;
   text-align: center;
 }
 div.page_header {
   height: 180px;
   width: 100%;
   background-color: #F5F6F7;
 }
 div.page_header span {
   margin: 15px 0px 0px 50px;
   font-size: 180%;
   font-weight: bold;
 }
 div.page_header img {
   margin: 3px 0px 0px 40px;
   border: 0px 0px 0px;
 }
 div.banner {
   padding: 9px 6px 9px 6px;
   background-color: #E9510E;
   color: #FFFFFF;
   font-weight: bold;
   font-size: 112%;
   text-align: center;
   position: absolute;
   left: 40%;
   bottom: 30px;
   width: 20%;
 }
 div.table_of_contents {
   clear: left;
   min-width: 200px;
   margin: 3px 3px 3px 3px;
   background-color: #FFFFFF;
   text-align: left;
 }
 div.table_of_contents_item {
   clear: left;
   width: 100%;
   margin: 4px 0px 0px 0px;
   background-color: #FFFFFF;
   color: #000000;
   text-align: left;
 }
 div.table_of_contents_item a {
   margin: 6px 0px 0px 6px;
 }
 div.content_section {
   margin: 3px 3px 3px 3px;
   background-color: #FFFFFF;
   text-align: left;
 }
 div.content_section_text {
   padding: 4px 8px 4px 8px;
   color: #000000;
   font-size: 100%;
 }
 div.content_section_text pre {
   margin: 8px 0px 8px 0px;
   padding: 8px 8px 8px 8px;
   border-width: 1px;
   border-style: dotted;
   border-color: #000000;
   background-color: #F5F6F7;
   font-style: italic;
 }
 div.content_section_text p {
   margin-bottom: 6px;
 }
 div.content_section_text ul, div.content_section_text li {
   padding: 4px 8px 4px 16px;
 }
 div.section_header {
   padding: 3px 6px 3px 6px;
   background-color: #8E9CB2;
   color: #FFFFFF;
   font-weight: bold;
   font-size: 112%;
   text-align: center;
 }
 div.section_header_grey {
   background-color: #9F9386;
 }
 .floating_element {
   position: relative;
   float: left;
 }
 div.table_of_contents_item a,
 div.content_section_text a {
   text-decoration: none;
   font-weight: bold;
 }
 div.table_of_contents_item a:link,
 div.table_of_contents_item a:visited,
 div.table_of_contents_item a:active {
   color: #000000;
 }
 div.table_of_contents_item a:hover {
   background-color: #000000;
   color: #FFFFFF;
 }
 div.content_section_text a:link,
 div.content_section_text a:visited,
  div.content_section_text a:active {
   background-color: #DCDFE6;
   color: #000000;
 }
 div.content_section_text a:hover {
   background-color: #000000;
   color: #DCDFE6;
 }
 div.validator {
 }
   </style>
 </head>
 <body>
   <div class="main_page">
     <div class="page_header floating_element">
       <img src="icons/ubuntu-logo.png" alt="Ubuntu Logo"
            style="width:184px;height:146px;" class="floating_element" />
       <div>
         <span style="margin-top: 1.5em;" class="floating_element">
           Apache2 Default Page
         </span>
       </div>
       <div class="banner">
         <div id="about"></div>
         It works!
       </div>
     </div>
     <div class="content_section floating_element">
       <div class="content_section_text">
         <p>
               This is the default welcome page used to test the correct
               operation of the Apache2 server after installation on Ubuntu systems.
               It is based on the equivalent page on Debian, from which the Ubuntu Apache
               packaging is derived.
               If you can read this page, it means that the Apache HTTP server installed at
               this site is working properly. You should <b>replace this file</b> (located at
               <tt>/var/www/html/index.html</tt>) before continuing to operate your HTTP server.
         </p>
         <p>
               If you are a normal user of this web site and don't know what this page is
               about, this probably means that the site is currently unavailable due to
               maintenance.
               If the problem persists, please contact the site's administrator.
         </p>
       </div>
       <div class="section_header">
         <div id="changes"></div>
               Configuration Overview
       </div>
       <div class="content_section_text">
         <p>
               Ubuntu's Apache2 default configuration is different from the
               upstream default configuration, and split into several files optimized for
               interaction with Ubuntu tools. The configuration system is
               <b>fully documented in
               /usr/share/doc/apache2/README.Debian.gz</b>. Refer to this for the full
               documentation. Documentation for the web server itself can be
               found by accessing the <a href="/manual">manual</a> if the <tt>apache2-doc</tt>
               package was installed on this server.
         </p>
         <p>
               The configuration layout for an Apache2 web server installation on Ubuntu systems is as follows:
         </p>
         <pre>
/etc/apache2/
|-- apache2.conf
|       `--  ports.conf
|-- mods-enabled
|       |-- *.load
|       `-- *.conf
|-- conf-enabled
|       `-- *.conf
|-- sites-enabled
|       `-- *.conf
         </pre>
         <ul>
                       <li>
                          <tt>apache2.conf</tt> is the main configuration
                          file. It puts the pieces together by including all remaining configuration
                          files when starting up the web server.
                       </li>
                       <li>
                          <tt>ports.conf</tt> is always included from the
                          main configuration file. It is used to determine the listening ports for
                          incoming connections, and this file can be customized anytime.
                       </li>
                       <li>
                          Configuration files in the <tt>mods-enabled/</tt>,
                          <tt>conf-enabled/</tt> and <tt>sites-enabled/</tt> directories contain
                          particular configuration snippets which manage modules, global configuration
                          fragments, or virtual host configurations, respectively.
                       </li>
                       <li>
                          They are activated by symlinking available
                          configuration files from their respective
                          *-available/ counterparts. These should be managed
                          by using our helpers
                          <tt>
                               a2enmod,
                               a2dismod,
                          </tt>
                          <tt>
                               a2ensite,
                               a2dissite,
                           </tt>
                               and
                          <tt>
                               a2enconf,
                               a2disconf
                          </tt>. See their respective man pages for detailed information.
                       </li>
                       <li>
                          The binary is called apache2 and is managed using systemd, so to
                          start/stop the service use <tt>systemctl start apache2</tt> and
                          <tt>systemctl stop apache2</tt>, and use <tt>systemctl status apache2</tt>
                          and <tt>journalctl -u apache2</tt> to check status.  <tt>system</tt>
                          and <tt>apache2ctl</tt> can also be used for service management if
                          desired.
                          <b>Calling <tt>/usr/bin/apache2</tt> directly will not work</b> with the
                          default configuration.
                       </li>
         </ul>
       </div>
       <div class="section_header">
           <div id="docroot"></div>
               Document Roots
       </div>
       <div class="content_section_text">
           <p>
               By default, Ubuntu does not allow access through the web browser to
               <em>any</em> file outside of those located in <tt>/var/www</tt>,
               <a href="http://httpd.apache.org/docs/2.4/mod/mod_userdir.html" rel="nofollow">public_html</a>
               directories (when enabled) and <tt>/usr/share</tt> (for web
               applications). If your site is using a web document root
               located elsewhere (such as in <tt>/srv</tt>) you may need to whitelist your
               document root directory in <tt>/etc/apache2/apache2.conf</tt>.
           </p>
           <p>
               The default Ubuntu document root is <tt>/var/www/html</tt>. You
               can make your own virtual hosts under /var/www.
           </p>
       </div>
       <div class="section_header">
         <div id="bugs"></div>
               Reporting Problems
       </div>
       <div class="content_section_text">
         <p>
               Please use the <tt>ubuntu-bug</tt> tool to report bugs in the
               Apache2 package with Ubuntu. However, check <a
               href="https://bugs.launchpad.net/ubuntu/+source/apache2"
               rel="nofollow">existing bug reports</a> before reporting a new bug.
         </p>
         <p>
               Please report bugs specific to modules (such as PHP and others)
               to their respective packages, not to the web server itself.
         </p>
       </div>
     </div>
   </div>
   <div class="validator">
   </div>
 </body>
</html>

3 months ago

Java in General

400 Bad Request

I don't know how to get request headers because I am receiving 502 bad gateway.

3 months ago

Another test:

3 months ago

Cezar Apulchro

Recent posts by Cezar Apulchro