{"action":"created","issue":{"url":"https://api.github.com/repos/p6spy/p6spy/issues/282","labels_url":"https://api.github.com/repos/p6spy/p6spy/issues/282/labels{/name}","comments_url":"https://api.github.com/repos/p6spy/p6spy/issues/282/comments","events_url":"https://api.github.com/repos/p6spy/p6spy/issues/282/events","html_url":"https://github.com/p6spy/p6spy/issues/282","id":64154423,"number":282,"title":"No resultset logged when executing a stored procedure","user":{"login":"PierreC2","id":11640698,"avatar_url":"https://avatars.githubusercontent.com/u/11640698?v=3","gravatar_id":"","url":"https://api.github.com/users/PierreC2","html_url":"https://github.com/PierreC2","followers_url":"https://api.github.com/users/PierreC2/followers","following_url":"https://api.github.com/users/PierreC2/following{/other_user}","gists_url":"https://api.github.com/users/PierreC2/gists{/gist_id}","starred_url":"https://api.github.com/users/PierreC2/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/PierreC2/subscriptions","organizations_url":"https://api.github.com/users/PierreC2/orgs","repos_url":"https://api.github.com/users/PierreC2/repos","events_url":"https://api.github.com/users/PierreC2/events{/privacy}","received_events_url":"https://api.github.com/users/PierreC2/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/p6spy/p6spy/labels/Defect","name":"Defect","color":"fbca04"}],"state":"closed","locked":false,"assignee":{"login":"quintonm","id":991413,"avatar_url":"https://avatars.githubusercontent.com/u/991413?v=3","gravatar_id":"","url":"https://api.github.com/users/quintonm","html_url":"https://github.com/quintonm","followers_url":"https://api.github.com/users/quintonm/followers","following_url":"https://api.github.com/users/quintonm/following{/other_user}","gists_url":"https://api.github.com/users/quintonm/gists{/gist_id}","starred_url":"https://api.github.com/users/quintonm/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/quintonm/subscriptions","organizations_url":"https://api.github.com/users/quintonm/orgs","repos_url":"https://api.github.com/users/quintonm/repos","events_url":"https://api.github.com/users/quintonm/events{/privacy}","received_events_url":"https://api.github.com/users/quintonm/received_events","type":"User","site_admin":false},"milestone":{"url":"https://api.github.com/repos/p6spy/p6spy/milestones/9","html_url":"https://github.com/p6spy/p6spy/milestones/2.1.4","labels_url":"https://api.github.com/repos/p6spy/p6spy/milestones/9/labels","id":949997,"number":9,"title":"2.1.4","description":"","creator":{"login":"quintonm","id":991413,"avatar_url":"https://avatars.githubusercontent.com/u/991413?v=3","gravatar_id":"","url":"https://api.github.com/users/quintonm","html_url":"https://github.com/quintonm","followers_url":"https://api.github.com/users/quintonm/followers","following_url":"https://api.github.com/users/quintonm/following{/other_user}","gists_url":"https://api.github.com/users/quintonm/gists{/gist_id}","starred_url":"https://api.github.com/users/quintonm/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/quintonm/subscriptions","organizations_url":"https://api.github.com/users/quintonm/orgs","repos_url":"https://api.github.com/users/quintonm/repos","events_url":"https://api.github.com/users/quintonm/events{/privacy}","received_events_url":"https://api.github.com/users/quintonm/received_events","type":"User","site_admin":false},"open_issues":0,"closed_issues":1,"state":"open","created_at":"2015-01-25T00:17:54Z","updated_at":"2015-04-12T06:26:50Z","due_on":null,"closed_at":null},"comments":5,"created_at":"2015-03-25T02:36:54Z","updated_at":"2015-04-13T03:29:50Z","closed_at":"2015-04-12T06:26:50Z","body":"I am trying to log the resultset from a stored procedure but nothing is logged after the procedure call.\r\n\r\nThe log file only registered the call to the DB :\r\n\r\n    2015-03-24 22:15:37:321|11|statement|connection 0|{ CALL envoi_courriel() }|{ CALL envoi_courriel() }\r\n    2015-03-24 22:15:37:339|0|commit|connection 0||\r\n    2015-03-24 22:19:48:227|-1|debug|connection -1||this is com.p6spy.engine.spy.P6SpyDriver@5db99810 and passthru is com.mysql.jdbc.Driver@7f2e7127\r\n\r\nNothing is excluded from the logging in the spy.proerties.  That is :\r\n\r\n    excludecategories=\r\n\r\nAm I missing something or is this feature not supported? Thanks in advance."},"comment":{"url":"https://api.github.com/repos/p6spy/p6spy/issues/comments/92185321","html_url":"https://github.com/p6spy/p6spy/issues/282#issuecomment-92185321","issue_url":"https://api.github.com/repos/p6spy/p6spy/issues/282","id":92185321,"user":{"login":"PierreC2","id":11640698,"avatar_url":"https://avatars.githubusercontent.com/u/11640698?v=3","gravatar_id":"","url":"https://api.github.com/users/PierreC2","html_url":"https://github.com/PierreC2","followers_url":"https://api.github.com/users/PierreC2/followers","following_url":"https://api.github.com/users/PierreC2/following{/other_user}","gists_url":"https://api.github.com/users/PierreC2/gists{/gist_id}","starred_url":"https://api.github.com/users/PierreC2/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/PierreC2/subscriptions","organizations_url":"https://api.github.com/users/PierreC2/orgs","repos_url":"https://api.github.com/users/PierreC2/repos","events_url":"https://api.github.com/users/PierreC2/events{/privacy}","received_events_url":"https://api.github.com/users/PierreC2/received_events","type":"User","site_admin":false},"created_at":"2015-04-13T03:29:50Z","updated_at":"2015-04-13T03:29:50Z","body":"Hello quintonm,\r\n\r\nUnfortunately, the problem is not solved for me with the latest snapshot version.\r\n\r\nI copied the new p6spy-2.1.4-SNAPSHOT.jar into  :\r\nC:\\Users\\utilisateur\\GlassFish_Server\\glassfish\\domains\\domain1\\lib\\ext\r\n\r\nand I still don't have any resultset log for a call to a db procedure.  Here is the pertinent excerpt from my log : \r\n\r\n    2015-04-12 22:59:58:485|10|statement|connection 0|{ CALL envoi_courriel() }|{ CALL envoi_courriel() }\r\n    2015-04-12 22:59:58:500|1|commit|connection 0||\r\n\r\n(I do have resultset logs for regular SELECT instructions), e.g. : \r\n\r\n    2015-04-12 22:59:26:372|0|result|connection 0|SELECT id_comite, codes_comites, date_debut, date_fin, pointage FROM comites WHERE (id_comite = ?)|\r\n    2015-04-12 22:59:26:373|-1|resultset|connection -1|SELECT id_comite, codes_comites, date_debut, date_fin, pointage FROM comites WHERE (id_comite = ?)|1 = 1, 2 = CA, 3 = 1976-11-15, 4 = null, 5 = 100\r\n\r\nAs requested, here is the simple java code that calls the procedure :\r\n     \r\n\r\n    public List<NomsEtCourriels> faireEnvoiCourriel () {   \r\n            //http://en.wikibooks.org/wiki/Java_Persistence/Advanced_Topics#Stored_Procedureshttp://en.wikibooks.org/wiki/Java_Persistence/Advanced_Topics#Stored_Procedures\r\n            List<NomsEtCourriels> courriels;\r\n            StoredProcedureQuery envoiCourriel = getEntityManager().createNamedStoredProcedureQuery(\"envoi_courriel\");\r\n            logger.info(\"[ejbMembresFacade]faireEnvoiCourriel envoiCourriel =\" + envoiCourriel);\r\n            courriels = envoiCourriel.getResultList();\r\n            logger.info(\"[ejbMembresFacade]faireEnvoiCourriel  Nbre d'enregistrements retournés : \" + courriels.size());\r\n            if (courriels != null) {\r\n                for (NomsEtCourriels courriel : courriels) {\r\n                    logger.info(\"[ejbMembresFacade]faireEnvoiCourriel  courriel : \" + courriel);\r\n                }\r\n           }\r\n            return courriels;\r\n        }\r\n\r\nAnd, the entity class which is basic and only contains 3 fields :\r\n\r\n    @Entity\r\n    public class NomsEtCourriels implements Serializable {\r\n    \r\n    private Integer noLigne;\r\n    private String noms;\r\n    @Id\r\n    private String courriels;\r\n    \r\n    \r\n    public NomsEtCourriels() {\r\n        System.err.println(\"[NomsEtCouriels]no argument constructor\");\r\n    }\r\n    \r\n    public NomsEtCourriels(Integer noLigne, String noms, String courriels) {\r\n        System.err.println(\"[NomsEtCouriels]3 field constructor : \" + noLigne + \", noms=\" + noms + \", courriels=\" + courriels);\r\n        this.noLigne = noLigne;\r\n        this.noms = noms;\r\n        this.courriels = courriels;\r\n    }\r\n\r\n    + getters & setters\r\n\r\nI want to use p6spy to diagnose why when I iterate over my resultset, only the \"courriel\" field is not null while, when executing the procedure call from MySql Workbench, all three fields are OK and not null.\r\n\r\nThank you."}}