PostgreSQLUtilities.java

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

/**
 * PostgreSQLUtilities
 * 
 * @author Andrea Poli (poli@link.it)
 * @author $Author$
 * @version $Rev$, $Date$
 *
 */
public class PostgreSQLUtilities {

	public static String NULL_BYTE_SEQUENCE = "\u0000";
	
	public static boolean isInvalid0x00error(Throwable t) {
		return t.getMessage()!=null && t.getMessage().contains("invalid byte sequence for encoding \"UTF8\": 0x00");
	}
	
	public static boolean containsNullByteSequence(String s) {
		return s!=null && s.contains(NULL_BYTE_SEQUENCE);
	}
	
	public static String normalizeString(String s) {
		
		// invalid byte sequence for encoding "UTF8": 0x00
		// PostgreSQL non supporta il salvataggio di NULL (\0x00) caratteri nei campi text. 
		return s.replaceAll(NULL_BYTE_SEQUENCE, "");

	}
	
}