2

here is the sql query and it does not accept the sum on dataservice wso2

SELECT nom, SUM(note) as totalnote from etudiant where nom =?;

when i test i get this error :

  <axis2ns4:ds_code>DATABASE_ERROR</axis2ns4:ds_code>
  <axis2ns4:nested_exception>java.sql.SQLException: Can not issue executeUpdate() or executeLargeUpdate() for SELECTs</axis2ns4:nested_exception>
rania ben salem
  • 151
  • 6
  • Hi Rania, can you show how you call the dataservice? Also, I do not think the SUM is actually summing anything without any grouping or subquery. But I do not think that causes the problem – ophychius Nov 28 '22 at 10:25
  • Could you add the solution/share what the problem was? That way the question/answer remain valuable for other SO users. – ophychius Nov 28 '22 at 11:50
  • Yes just i added in outputmapping ``` ``` – rania ben salem Nov 28 '22 at 13:34

0 Answers0