https://tracker.silverpeas.org/https://tracker.silverpeas.org/favicon.ico?17095821032018-04-26T09:42:26ZSilverpeas Issues TrackerSilverpeas Core - Bug #9745: Erreur SQL sur l'interrogation de statisiques publicationshttps://tracker.silverpeas.org/issues/9745?journal_id=512342018-04-26T09:42:26ZDavid Lesimpledavid.lesimple@silverpeas.com
<ul><li><strong>Fichier</strong> <a href="/attachments/7352">erreur_stat</a> <a class="icon-only icon-download" title="Télécharger" href="/attachments/download/7352/erreur_stat">erreur_stat</a> ajouté</li></ul> Silverpeas Core - Bug #9745: Erreur SQL sur l'interrogation de statisiques publicationshttps://tracker.silverpeas.org/issues/9745?journal_id=512352018-04-26T09:45:05ZDavid Lesimpledavid.lesimple@silverpeas.com
<ul></ul><pre><code class="java syntaxhl" data-language="java"><span class="nc">Caused</span> <span class="nl">by:</span> <span class="n">org</span><span class="o">.</span><span class="na">silverpeas</span><span class="o">.</span><span class="na">core</span><span class="o">.</span><span class="na">silverstatistics</span><span class="o">.</span><span class="na">access</span><span class="o">.</span><span class="na">model</span><span class="o">.</span><span class="na">StatisticRuntimeException</span><span class="o">:</span> <span class="n">java</span><span class="o">.</span><span class="na">sql</span><span class="o">.</span><span class="na">SQLException</span><span class="o">:</span> <span class="nc">Echec</span> <span class="n">de</span> <span class="n">conversion</span> <span class="n">dans</span> <span class="n">la</span> <span class="n">représentation</span> <span class="n">interne</span>
<span class="n">at</span> <span class="n">org</span><span class="o">.</span><span class="na">silverpeas</span><span class="o">.</span><span class="na">core</span><span class="o">.</span><span class="na">silverstatistics</span><span class="o">.</span><span class="na">access</span><span class="o">.</span><span class="na">service</span><span class="o">.</span><span class="na">DefaultStatisticService</span><span class="o">.</span><span class="na">getHistoryByObjectAndUser</span><span class="o">(</span><span class="nc">DefaultStatisticService</span><span class="o">.</span><span class="na">java</span><span class="o">:</span><span class="mi">145</span><span class="o">)</span>
</code></pre>
<p>Appel par :</p>
<pre><code class="java syntaxhl" data-language="java"> <span class="nc">Collection</span><span class="o"><</span><span class="nc">HistoryObjectDetail</span><span class="o">></span> <span class="n">history</span> <span class="o">=</span> <span class="n">statisticService</span><span class="o">.</span><span class="na">getHistoryByObjectAndUser</span><span class="o">(</span><span class="n">resourceReference</span><span class="o">,</span> <span class="nc">DefaultStatisticService</span><span class="o">.</span><span class="na">ACTION_ACCESS</span><span class="o">,</span> <span class="nc">PublicationDetail</span><span class="o">.</span><span class="na">TYPE</span><span class="o">,</span> <span class="n">getUserId</span><span class="o">());</span>
</code></pre> Silverpeas Core - Bug #9745: Erreur SQL sur l'interrogation de statisiques publicationshttps://tracker.silverpeas.org/issues/9745?journal_id=512702018-04-26T15:29:24ZNicolas Eysseric
<ul><li><strong>Statut</strong> changé de <i>New</i> à <i>In progress...</i></li><li><strong>Assigné à</strong> mis à <i>Nicolas Eysseric</i></li><li><strong>Version cible</strong> mis à <i>Version 6.1</i></li></ul><p>Le problème ne vient pas de la requête elle-même mais de la récupération des résultats...</p> Silverpeas Core - Bug #9745: Erreur SQL sur l'interrogation de statisiques publicationshttps://tracker.silverpeas.org/issues/9745?journal_id=512732018-04-26T16:00:04ZNicolas Eysseric
<ul><li><strong>Statut</strong> changé de <i>In progress...</i> à <i>Resolved</i></li><li><strong>% réalisé</strong> changé de <i>0</i> à <i>100</i></li></ul><p>Traité par PR : <a class="external" href="https://github.com/Silverpeas/Silverpeas-Core/pull/900">https://github.com/Silverpeas/Silverpeas-Core/pull/900</a></p> Silverpeas Core - Bug #9745: Erreur SQL sur l'interrogation de statisiques publicationshttps://tracker.silverpeas.org/issues/9745?journal_id=512752018-04-27T06:42:19ZYohann Chastagnieryohann.chastagnier@silverpeas.com
<ul><li><strong>Statut</strong> changé de <i>Resolved</i> à <i>Integration in progress...</i></li></ul> Silverpeas Core - Bug #9745: Erreur SQL sur l'interrogation de statisiques publicationshttps://tracker.silverpeas.org/issues/9745?journal_id=513132018-04-27T16:11:26ZYohann Chastagnieryohann.chastagnier@silverpeas.com
<ul><li><strong>Statut</strong> changé de <i>Integration in progress...</i> à <i>Closed</i></li></ul><p>Intégré en 6.0.x et en 6.x<br />Je n'ai jamais pu reproduire le problème, malgré la mise en place d'un environnement dédié lié à une base de données Oracle.<br />Le driver JDBC que j'ai utilisé est : ojdbc6-12.1.0.2.jar<br />En espérant que le problème rencontré venait bien du driver JDBC utilisé chez le client...</p> Silverpeas Core - Bug #9745: Erreur SQL sur l'interrogation de statisiques publicationshttps://tracker.silverpeas.org/issues/9745?journal_id=513142018-04-27T16:21:36ZDavid Lesimpledavid.lesimple@silverpeas.com
<ul></ul><p>j'utilise ojdbc7.jar qui fait 3397734 octets.<br /><a class="external" href="http://www.oracle.com/technetwork/database/features/jdbc/default-2280470.html">http://www.oracle.com/technetwork/database/features/jdbc/default-2280470.html</a></p>