Works beautiful. Thank you so much for answer quickly.
Thank you for replay. The example: CREATE TABLE MYTABLE ( MAT CHAR(5) NOT NULL ); INSERT INTO MYTABLE (MAT) VALUES('12345'); INSERT INTO MYTABLE (MAT) VALUES('12346'); String selectSQL = "SELECT * FROM MYTABLE WHERE MAT = ?"; pstmt.setString(1, "123456789"); //conn.prepareStatement(selectSQL); // EXECUTE QUERY 12345 ps: the equal was working as like clause, apparently is truncated the parameter value
Thank you for replay. The example: CREATE TABLE MYTABLE ( MAT CHAR(5) NOT NULL ); INSERT INTO MYTABLE (MAT) VALUES('12345'); INSERT INTO MYTABLE (MAT) VALUES('12346'); String selectSQL = "SELECT * FROM MYTABLE WHERE MAT = ?"; pstmt.setString(1, "123456789"); //conn.prepareStatement(selectSQL); // EXECUTE QUERY 12345
Thank you for replay. The example: CREATE TABLE MYTABLE ( MAT CHAR(5) NOT NULL ); INSERT INTO MYTABLE (MAT) VALUES('12345'); INSERT INTO MYTABLE (MAT) VALUES('12346'); String selectSQL = "SELECT * FROM MYTABLE WHERE MAT = ?"; pstmt.setString(1, "123456789"); //conn.prepareStatement(selectSQL); // EXECUTE QUERY 12345
I have this issue when use SELECT with a PreparedStatement. Version 6.7, 9.3, 9.4 and 9.7 tested.
tweaks
REFACTORING design
REFACTORING design