PostgreSQLUtilities.java

  1. /*
  2.  * GovWay - A customizable API Gateway
  3.  * https://govway.org
  4.  *
  5.  * Copyright (c) 2005-2025 Link.it srl (https://link.it).
  6.  *
  7.  * This program is free software: you can redistribute it and/or modify
  8.  * it under the terms of the GNU General Public License version 3, as published by
  9.  * the Free Software Foundation.
  10.  *
  11.  * This program is distributed in the hope that it will be useful,
  12.  * but WITHOUT ANY WARRANTY; without even the implied warranty of
  13.  * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
  14.  * GNU General Public License for more details.
  15.  *
  16.  * You should have received a copy of the GNU General Public License
  17.  * along with this program.  If not, see <http://www.gnu.org/licenses/>.
  18.  *
  19.  */
  20. package org.openspcoop2.utils.jdbc;

  21. /**
  22.  * PostgreSQLUtilities
  23.  *
  24.  * @author Andrea Poli (poli@link.it)
  25.  * @author $Author$
  26.  * @version $Rev$, $Date$
  27.  *
  28.  */
  29. public class PostgreSQLUtilities {

  30.     public static String NULL_BYTE_SEQUENCE = "\u0000";
  31.    
  32.     public static boolean isInvalid0x00error(Throwable t) {
  33.         return t.getMessage()!=null && t.getMessage().contains("invalid byte sequence for encoding \"UTF8\": 0x00");
  34.     }
  35.    
  36.     public static boolean containsNullByteSequence(String s) {
  37.         return s!=null && s.contains(NULL_BYTE_SEQUENCE);
  38.     }
  39.    
  40.     public static String normalizeString(String s) {
  41.        
  42.         // invalid byte sequence for encoding "UTF8": 0x00
  43.         // PostgreSQL non supporta il salvataggio di NULL (\0x00) caratteri nei campi text.
  44.         return s.replaceAll(NULL_BYTE_SEQUENCE, "");

  45.     }
  46.    
  47. }