ORA-00911: invalid character Eclipse

446 Views Asked by At

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();

    } 
1

There are 1 best solutions below

1
On BEST ANSWER

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