java.sql.SQLSyntaxErrorException: ORA-00911: invalid character. I cant see any problem but eclipse get error ora-911
public void create(String NAME, String DOGUM, String ADRES, String EMAIL, String PASSWORD) throws SQLException {
String sql = "INSERT INTO UYELER (UYE_ID, UYE_ADSOYAD, UYE_DOGUM, UYE_ADRES, UYE_EMAIL, UYE_PASSWORD) VALUES (UYELER_SEQ.NEXTVAL,?,?,?,?,?)";
PreparedStatement stmt = conn.prepareStatement(sql);
stmt.setString(1, NAME);
stmt.setString(2, DOGUM);
stmt.setString(3, ADRES);
stmt.setString(4, EMAIL);
stmt.setString(5, PASSWORD);
stmt.executeUpdate();
stmt.close();
}
The problem seems about date format. If your
dogumcolumn is date so you cant set it asstring. If it is string so check your data. You can set it manually for test like "20180328". If it dont give any error the problem is on your data