Project

General

Profile

Actions

Bug #646

closed

Cast implicite dans les requêtes SQL

Added by Emmanuel Hugonnet over 11 years ago. Updated over 11 years ago.

Status:
Closed
Priority:
Normal
Start date:
06/17/2010
Due date:
% Done:

100%

Estimated time:
4.00 h
Spent time:
Navigateur:
Votre version de Silverpeas:
5.1.2
Système d'exploitation:
Votre base de données:
PostgreSQL
Livraison en TEST:
Livraison en PROD:

Description

Impossible d'accéder au composant sur Posqtgresql 8.4 : cast implicite dans les requêtes

org.postgresql.util.PSQLException: ERREUR: l'opérateur n'existe pas : integer = character varying
    at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1592)
    at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1327)
    at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:192)
    at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:451)
    at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:350)
    at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:254)
    at org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.executeQuery(WrappedPreparedStatement.java:211)
    at com.silverpeas.projectManager.model.ProjectManagerDAO.getOccupationByUser(ProjectManagerDAO.java:665)
    at com.silverpeas.projectManager.model.ProjectManagerDAO.getOccupationByUser(ProjectManagerDAO.java:626)


Files

bug_project_manager.png (39.8 KB) bug_project_manager.png Emmanuel Hugonnet, 06/17/2010 10:21 AM

Related issues

Has duplicate Project Manager - Bug #877: Plantage de Project-Manager après avoir affecter des ressources à une tâcheClosed07/29/2010

Actions
Has duplicate Project Manager - Bug #1038: Impossible d'obtenir l'objet distantClosed09/21/2010

Actions
Actions #1

Updated by Emmanuel Hugonnet over 11 years ago

  • Status changed from New to In progress...
Actions #2

Updated by Emmanuel Hugonnet over 11 years ago

  • Status changed from In progress... to Closed

Ajout de tests supplémentaires sur la DAO : à enrichir

Actions #3

Updated by Emmanuel Hugonnet over 11 years ago

  • % Done changed from 0 to 100
Actions

Also available in: Atom PDF