1
I’m making the following mistake:
java.sql.Sqlsyntaxerrorexception: ORA-00933: SQL command not properly ended
This happens after I run the following line from SQL
:
/* Listar todas as reuniões do utilizador onde esteja convidado*/
String sql = "SELECT M.ID, M.TITLE, M.DIA, M.HORA FROM MEETING AS M, MEETING_LIST AS ML WHERE (M.ID=ML.ID_MEETING AND ML.ID_UTILIZADOR=( SELECT ID FROM UTILIZADOR WHERE NOMEUTILIZADOR='"+ parcel.getUsername()+"' ) AND ML.STATUS=1 AND ML.INVITE=1)";
toClient = new AbstractMessage(database.submitQuery(sql));
The table MEETING
has the following attributes:
- ID, TITLE, OUTCOME, DAY, TIME, LOCATION
The table MEETING_LIST
has the following attributes:
- ID, ID_MEETING, ID_UTILIZADOR, INVITE, STATUS
The table UTILIZADOR
has the following attributes:
- ID, username, PALAVRACHAVE
The table MEETING_LIST
is a table that crosses users and meetings (Many to Many).
Use four spaces to form codes or select the text and click the button
{ }
– rray