please can someone help me to fix this error,
this is my method that have an sql query,i dont know why i have an error:java.sql.sqlsyntaxerrorexception ora-00933 sql command not properly ended
method:
public String privilegeCurrentAclUser() {
String userPrivileges =null;
ResultSet resultSet = null;
PreparedStatement createPreparedStatement =
getDBTransaction().createPreparedStatement("" +
" select a.privilege from ACL__USER a where a.TUSER_ID="+CurrentUser().longValue()+"and a.DOCUMENT_ID="+getDocumentId()+")", 0);
try {
resultSet = createPreparedStatement.executeQuery();
if (resultSet.next()) {
userPrivileges = (String)resultSet.getObject(1);
}
} catch (SQLException e) {
throw new JboException(e);
}
return userPrivileges;
}