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 dogum
column is date so you cant set it as string
. 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